Should you’ve dabbled in website positioning reporting, you’ll know that handbook reporting turns into extra painful the extra it’s important to do. So, how will you take the load off your shoulders? By automating the repetitive bits.
On this article, I’ll share how one can automate your website positioning reporting simply utilizing simply two instruments: Ahrefs and Google Looker Studio (GLS).
In idea, automating website positioning reporting ought to assist:
- Unencumber time
- Enhance effectivity
- Enhance consistency
- Scale back prices
However, in actuality, these kinds of tasks can get sophisticated rapidly—typically taking longer than anticipated—if completed at all.
So, moderately than making an attempt to automate all the issues, let’s maintain it easy and deal with what we will automate simply:
- Natural site visitors reporting
- Key phrase rank monitoring
- Web site auditing
- Competitor evaluation
- Web site modifications
- Model mentions
The 2 hottest knowledge sources for website positioning reporting are Google Search Console (GSC) and Google Analytics (GA). So, how can we automate these two reviews?
Right here’s what we’ll do:
- Join knowledge sources to Google Looker Studio – GSC and GA
- Design a report – we’ll cheat utilizing a template
- Schedule it to be delivered in our e-mail field
Plot spoiler: We’ll use these two Google Looker Studio templates:
Automating Google Search Console reporting
To start out, ensure you’re logged into Google Search Console. Then, head to Looker Studio and click on on the Search Console Report.
Then click on on Use my very own knowledge and Substitute knowledge.
Then, choose your web site from the listing.
Then choose both Website Impression and internet or URL Impression and internet, relying in your desire. I’m utilizing URL Impression and internet on this instance.
Sidenote.
Website Impression and URL impression help totally different search sorts. For full particulars and variations, verify Google’s documentation right here.
Click on Add on the backside right-hand nook. You’ll then most likely get a pop-up—click on Add to report.
As soon as that’s added, you must get one thing that appears like this however together with your web site’s knowledge exhibiting.
Now you’ve bought your report, let’s schedule it. To take action, click on on the downward-facing caret within the prime proper and click on Schedule supply.
Add the folks you need to obtain the report and choose a begin time and time for the report back to be despatched. Then click on Save.
When you’ve accomplished these steps, you’ll get a PDF report robotically despatched to these e-mail inboxes on the date you specified.
Automating Google Analytics 4 (GA4) reporting
Automating GA4 reporting makes use of an identical course of. To start out, head again to the primary Looker Studio dashboard and arrange a brand new GA4 report by clicking on the GA4 Report icon.
Then, click on on Use my very own knowledge and choose your GA4 account.
Then choose your web site from the drop-down listing and click on Add.
Your web site’s info will then be populated within the copy of the GA4 template.
When you’ve executed that, you’ll be able to automate the sending like we did with the GSC report.
- Go to Share and click on the downward going through caret
- Click on Schedule supply
- Add the folks you need to ship the report back to and choose a frequency to ship the report.
Now, we’ve seen how straightforward it’s to schedule reviews for GSC and GA4. We will do the identical utilizing the Ahrefs Google Looker Studio Connectors.
Ahrefs has three connectors for Looker Studio that aid you create GLS dashboards in a few clicks. Yow will discover them within the Associate Connectors listing inside GLS.
Right here’s what they appear like:
Let’s get began with key phrase rank monitoring.
One of many points with sharing conventional rank monitoring knowledge with purchasers is the reviews could be too overwhelming at a look, making it onerous for them to see what’s going on.
Our Rank Tracker connector creates a shareable, easy-to-understand scheduled report in just a few clicks.
Right here’s the way you set it up.
Go to Ahrefs’ Rank Tracker
Click on on the venture that you just need to create a dashboard for, then click on on Looker Studio.
Then click on on Ahrefs’ Rank Tracker connector.
Authorize the connector
When you’ve executed that, you’ll be taken to Google Looker Studio to authorize the connector.
Click on on Authorize and check in utilizing your Google account. You’ll must click on Permit for Ahrefs Rank Tracker to entry your Google Account.
When you’ve executed that, enter the venture you need to add after which hit Join within the prime right-hand nook. If you’re pleased with the whole lot, click on Create Report.
Then, you must get a dashboard that appears one thing like this.
Schedule it
To make it automated, comply with the identical steps we used for our GSC and GA4 reviews by clicking the downwards going through caret subsequent to Share and click on Schedule supply.
Add the recipients to the report and choose how repeatedly you need it despatched.
Now you’ve arrange the Rank Tracker report, you’ll have the ability to verify these particulars in each e-mail:
- Positions
- SERP options
- Opponents
- Tags
- Visitors share
- Key phrases metrics
Should you’re specializing in technical website positioning in your web site then it’s a good suggestion to get an automatic Website Audit dashboard arrange. It allows you to maintain monitor of your web site’s technical well being simply.
Go to Ahrefs’ Website Audit
Go to Ahrefs’ Website Audit and choose a venture from the dashboard to click on on it.
Then click on on the Looker Studio button within the prime right-hand nook.
On the dropdown, click on Ahrefs Website Audit connector.
Authorize the connector
Like different connectors, you could be prompted to Authorize and check in utilizing your Google account. You’ll must click on Permit for Ahrefs Rank Tracker to entry your Google Account.
Afterward, set your parameters. I usually set it up like this.
If prompted, click on on enable parameter sharing after which Create Report.
Then click on Create Report once more when prompted.
GLS then begins to construct your report within the background.
Schedule it
You’ll be able to schedule the reviews in precisely the identical approach as you probably did with the opposite connectors. Click on on Share and Schedule supply to share with the folks you need to obtain the report.
You should use the Website Explorer report for monitoring your personal web site, however you may also use it to watch your opponents’ websites.
Sidenote.
You need to have your competitor’s web site arrange as a venture to be able to create a dashboard for it.
This dashboard report makes it attainable to maintain tabs in your opponents, and have it despatched to your or your consumer’s inbox regularly.
Go to Ahrefs’ Website Explorer
As soon as on the Overview web page, click on the Looker Studio button within the prime right-hand nook.
Then click on on Ahrefs’ Website Explorer Connector.
Authorize the connector
When you’ve executed that, hit Authorize.
And check in with Google.
Then, choose a venture and verify all of the packing containers to make sure compatibility with the template.
When you’ve executed that, hit Join, and if prompted, choose Permit. Then click on Create Report on the next display.
When you’ve created your report, it should seem on the next display, and all the information needs to be populated.
Schedule it
Scheduling supply is identical as now we have seen for the opposite reviews.
When you’ve shared it together with your colleagues or purchasers, it should robotically be delivered to your inboxes in your chosen schedule.
In case your web site is vulnerable to occasional downtime, a software like Uptime Robotic is a straightforward and free technique to automate monitoring of your web site’s standing.
When you’ve set it up, you’ll be able to obtain notifications via e-mail, slack messages, SMS, or perhaps a voice name—that approach, you’ll be the primary to know when your web site goes down.
If you wish to monitor sure pages in your web site for modifications, you should utilize a software like Little Warden. The software can monitor many alternative issues, however I like to make use of it to watch the robots.txt file for modifications.
The sort of monitoring is helpful in enterprise website positioning, the place a number of groups have entry to the web site and may change issues typically with out notifying the website positioning group beforehand.
If monitoring internet mentions of your model or a selected key phrase is vital, you are able to do this utilizing Ahrefs Alerts.
To take action, head to Alerts on the primary web site navigation and click on the Mentions tab.
Then click on + Add alert and enter the main points within the pop-up field of the point out you need to monitor.
Point out alerts are a helpful technique to report unbranded mentions of your model or web site. As soon as you might be alerted of the point out you’ll be able to contact the web site to request a hyperlink.
Last ideas
Automating your website positioning reporting course of isn’t at all times straightforward to do. However by utilizing Ahrefs’ Google Looker Studio connectors, you may make it simpler to automate your website positioning reporting course of—with out sacrificing high quality.
Even when you’ve got no coding data or expertise in constructing website positioning dashboards, you’ll be able to have a plug-and-play set of automated website positioning reviews able to go in just some clicks.
Bought extra questions? Ping me on X