Media Insights

Automate Keyword Rank Reporting With Google Data Studio

by |

Creating reports for your clients is a vital part of SEO. It’s also one of the most daunting and time-consuming tasks. Your reports need to contain all the necessary data, while also having clear visuals, providing quick wins, and being easy to understand.

We asked SEO Analyst, Emily Christon of Ovative Group, to share how her team makes keyword rank reporting easy and digestible for all stakeholders.

Read on to see how she combines the power of STAT with Google Data Studio for streamlined reporting that never fails to impress her clients.

Why Google Data Studio 

At Ovative Group, we’re big advocates for reporting tools that save time and make data easier to understand. This is why we love Google Data Studio.

This reporting tool was created with the user in mind and allows for easy collaboration and sharing with teams. It’s also free, and its reporting dashboard is designed to take the complexity and stress out of visualizing data.

Don’t get us wrong. We still love our spreadsheets, but tools like Excel aren’t ideal for building real-time, interactive dashboards. They also don’t allow for easy data pulls — you have to manually add your data, which can eat up a lot of time and cause a lot of feelings.

Data Studio, however, pulls all your data into one place from multiple sources, like spreadsheets, Google Analytics accounts, and Adwords. You can then customize how all that data is viewed so you can surface quick insights.

How Does This Relate to Keyword Reporting? 

Creating an actionable keyword report that is beneficial for both SEO and your stakeholders can be a challenge. Data Studio makes things a bit easier for us at Ovative in a variety of ways:

Automated Data Integration

Our team uses the STAT API — which can be connected to Data Studio through a little technical magic and Google Big Query — to pull in all our raw data. You can select what data points you want to be collected from the API, including rank, base rank, competitors, search volume, local information, and more.

Once your data is collected and living in Big Query, you can access it through the Data Studio interface. If you want to learn more about STAT’s API, go here.

Customization

Do you care about current rank? Rank over time? Major movers – those that changed +20 positions week over week? Or are you just after how many keywords you have ranking number one?

All of this is doable — and easy — once you’re comfortable in Data Studio. You can easily customize your reports to match your goals.

“Our team uses the STAT API — which can be connected to Data Studio through a little technical magic and Google Big Query — to pull in all our raw data.” — Emily Christon, SEO Analyst at Ovative Group

Custom dashboards make reporting and insights efficient and client-facing, transforming all that raw data into easy-to-understand metrics, which tell a more compelling story.

How to Build Your Custom Google Data Studio 

There are a myriad of ways to leverage Google Data Studio for major insights. Here are just a few features we use to help visualize our data.

Keyword Rank

This report gives you a snapshot of how many keywords you have in each ranking group and how things are trending. You can also scroll through your list of keywords to see what the traffic-driving queries are.

One cool feature of Data Studio when it comes to rank is period over period comparisons. For example, if you set the date range to the previous week, it will automatically pull week over week rank change. If you set the date range to the previous month, it pulls a month over month rank change.

At Ovative, we do weekly, monthly, and yearly keyword rank change reporting.

Choose what time periods you want to compare — Data Studio will automatically adjust your data.

Keyword Look-Up Tool 

If you notice that traffic has declined in a specific keyword set, pop down to the keyword look-up tool to track rank trends over time. This view is extremely helpful — it shows the progress or decline of rank to help explain traffic variability.

Check rank trends over time to see how your keywords are (and have been) performing.

Campaign or Priority Tracker 

To support newly launched pages or priority keywords, create a separate section just for these keywords. This will make it easy for you to quickly check the performance and trends of chosen keyword sets.

At a glance, see how your campaigns, pages, or priority keywords sets are doing.