Google Data Studio is a great way to share reports with your local SEO clients. They don't need an account in a separate tool, and sharing a report can be as easy as sending them a link. In this post I'll share a few tips on getting started, and show you how to integrate data from Persuaded.io into your reports.
All of the steps outlined in this post are included in the video below, if you'd prefer to follow along that way.
Reports, Data Sources, and Connectors
Data Studio consists of three basic building blocks: Reports, data sources, and connectors.
Reports allow you to slice and dice data from a variety of sources and present it in almost any fashion. Connectors act as the data transport between Data Studio and silos like Google Analytics, Sheets, or any number of third party providers. Data Sources are the bridge between your report and a connector – connectors can be quite powerful, and Data Sources allow you to configure exactly how your report consumes the data.
Persuaded.io Studio Connector
Pulling data from your Persuaded.io account into Google Data Studio is easy. Use this link to get started:
Google will present you with a quick sign-up process if you've never used Data Studio before. Once you have an account, the following page will appear and ask you for a few setup details.
Your API Key can be found on the Account page. Copy and paste this number into the API Key field in order to sync up Data Studio with your Persuaded.io account.
The Data Type field allows you to choose what kind of data you want to bring in from Persuaded.io. As of this writing, you can choose from Ranking or Spam reporting data. Data sources can only pull in one kind of data at a time, so while you can use both Ranking and Spam data in a single report, you'll need to create a data source for each.
After pressing connect, Data Studio will ask you to configure the fields belonging to the data source. If you chose Ranking data, you'll want to make sure the fields are configured exactly as below. Text and Number should be the only data types that appear (including Capture Date, which Studio may try to convert to their own Date and Time format – if that is the case, change it back to Text).
Before pressing Create Report, click the "Community visualizations access" button on the top bar. This is an important step that will allow you to pull in custom visualizations, in addition to the standard charts and graphs that Google provides. Persuaded.io has its own ranking visualization that you can add as a custom visualization.
Once you've clicked Create Report, you should have access to your ranking data from Persuaded.io. If you want to pull in the spam reporting data, you can repeat the process, and simply select Spam instead of Rankings from the Data Type dropdown.
To use the custom ranking visualization, locate the "Community visualizations" button and click Explore more at the bottom.
This will show a list of third party visualizations, as well as a "Build your own" button. Clicking the "Build your own" button will allow you to import the ranking visualization by adding the manifest path, as seen below.
You should be able to add the ranking visualization now. If you add all of the required dimensions, it should appear something like below.
Data Studio is an incredibly powerful reporting tool, and I hope this walkthrough will help you add even more depth to your reports!