I spent years manually copying data from GA4, GSC, and Ahrefs into spreadsheets...
https://speedy-wiki.win/index.php/What_is_the_Best_Way_to_Report_SEO_and_PPC_Together_in_One_View%3F
I spent years manually copying data from GA4, GSC, and Ahrefs into spreadsheets before realizing there had to be a better way