Automated SEO Reporting (The Easy Way)

If you’ve dabbled in SEO reporting, you’ll know that manual reporting becomes more painful the more you have to do. So, how can you take the weight off your shoulders? By automating the repetitive bits. In this article, I’ll share how you can automate your SEO reporting easily using just two tools: Ahrefs and Google Looker Studio (GLS). Automating SEO reporting: theory vs. reality In theory, automating SEO reporting should help: Free up time Improve efficiency Improve consistency Reduce costs But, in reality, these types of projects can get complicated quickly—often taking longer than expected—if finished at all. Source: XKCD (crude adaptations by me) So, rather than trying to automate all the things, let’s keep it simple and focus on what we can automate easily: Organic traffic reporting Keyword rank tracking Website auditing Competitor analysis Website changes Brand mentions 1. Automate organic traffic reporting The two most popular data sources for SEO reporting are Google Search Console (GSC) and Google Analytics (GA). So, how can we automate these two reports? Here’s what we’ll do: Connect data sources to Google Looker Studio – GSC and GA Design a report – we’ll cheat using a template Schedule it to be delivered in our email box Plot spoiler: We’ll use these two Google Looker Studio templates: Automating Google Search Console reporting To start, make sure you’re logged into Google Search Console. Then, head to Looker Studio and click on the Search Console Report. Then click on Use my own data and Replace data. Then, select your site from the list. Then select either Site Impression and web or URL Impression and web, depending on your preference. I am using URL Impression and web in this example. Sidenote. Site Impression and URL impression support different search types. For full details and differences, check Google’s documentation here. Click Add at the bottom…

Source: lbm demo