Hey guys, Has anyone created an SEO report in Looker Studio by connecting GA4 and Search Console? I could use some help or references. I’m looking to automate the reports so the team doesn’t have to manually copy-paste data into Excel sheets. If there’s any other way to automate SEO reports, I’d love to hear your suggestions! Thanks.

Hi Reema, I have been using looker studio for reporting structured GA4 and search console data. Let me know if you need help.

Hey @Rima Agarwal you can definitely use looker - but it's slightly technical. To stop this manual copy paste into excel sheet - we created superjoin which connects with both Google Analytics 4 and Google Search Console. (also HubSpot Google Ads etc) . You can automatically bring data to Google Sheets every 6 hours and set reports to your colleagues on slack.

@Vinayak Jhunjhunwala Super. I'll have a look.

Jumping into this. Connecting GSC and GA is a bit difficult but doable. I had the same problem in my previous company and so I built myself a dashboard where I can see not just the GA and GSC but also the keyword data, avg position, trends, etc., You can check out what I built and if you're interested, I can extend access to you as well: I thought of converting this as Micro Saas, but didn't have enough time to evangelise this... lol

Sure thing! @Rima Agarwal If you need any help happy to jump on a call.

@Kaavian Thank you for sharing this. Checking it out! Btw, you can convert it into something. For as long as I can remember, I have been seeing SEO teams Copy pasting data from GSC, Semrush, Analytics into excel sheets at the end of the month for reports. Automated reports can help better visualization of data and access whenever needed! and not saves time above all.

Yeah!! Thinking about for quite sometime. Let me know if you’re interested. I can add you as my beta user and your insights can help me build better as well @Rima Agarwal

We have done this for Atlan.