Dragon Metrics has created Google Data Studio connectors to let you easily pull your data into Google Data Studio and create custom reports.
There are currently 2 connectors available (with more likely coming soon)!
Ranking 2-day comparison: Compare ranking data for two dates for each tracked keyword
Ranking history: See a historic trend of rankings for each tracked keyword over a period of time.
In this article, we'll show you how to get started pulling your data into Google Data Studio using these connectors.
Step 1: Get access to the Dragon Metrics API
All subscription plans Basic and above come with API access. There's no additional fee for using the API, but if you're currently on a Starter subscription, you'll need to upgrade your plan to gain access.
Step 2: Join the private beta
These connectors are currently in a private beta, so in order to begin using them you'll need to Contact Dragon Metrics Support to join the beta.
It's quick, easy, and free to join. The only thing we ask in return is that you provide your feedback periodically so we can continue to improve the connectors for you.
Step 3: Connect your Google account
The setup process for either connector is very similar. Once you've joined the private beta, we'll send over the URLs for each connector.
The connector needs to authorize your Google account. Click the Authorize button to get started.
Since the connectors are in beta, they have not gone through the formal approval process with Google, and you'll receive a warning letting you know they haven't verified it yet.
While the warning looks scary, no personal data will be shared with Dragon Metrics. (See below for details)
Click Advanced to unhide the link to continue.
Click the link at the bottom to proceed.
You'll now be presented with a screen explaining what this connector is requesting access to your Google account to do.
Only the minimum permissions to your Google account are requested. No personal data will be shared with this connector or Dragon Metrics. All that is required is the ability to connect to an external service, which is explained when clicking the information link for more details.
Click Allow to continue.
Step 4: Add your Dragon Metrics API Credentials
Now that your Google account is connected, you'll need to provide your Dragon Metrics API credentials.
Enter the username and password for the Dragon Metrics API into the following prompt. DO NOT ENTER YOUR GOOGLE LOGIN CREDENTIALS as this data is sent to Dragon Metrics.
Step 5: Choose your campaign and site
Next up, you'll want to select the parameters for this connector.
All active campaigns will be populated in the Campaign dropdown. Choose the one you wish to get data for.
By default, this cannot be modified by editors of the report. If you would like to allow editors to change the campaign at any time in a report, check the box to the right.
Please use caution when choosing this option: If this is enabled, editors will be able to view data for any campaign in the account. For example, agency reports shared with clients will likely not want this option selected to ensure only this client's campaign can be shown in the report.
If this optional field is left blank, ranking data for the main campaign site will be shown.
If you would like to view ranking data for a tracked competitor site instead, enter the URL of this tracked site into the form.
Just like campaign, you can choose whether this can be modified in a report.
When you are done, click CONNECT in the upper right.
Step 6: Choose your table columns
You'll then be presented with a list of all of the available columns for this report. Make any desired changes (typically you will not need to) and click CREATE REPORT when you're ready.
Step 7: Wait for data to load
All configuration options are now complete and your report has now been created.
Google Data Studio will now connect to the Dragon Metrics API to pull the requested data. You'll need to wait until your data has loaded before proceeding.
Note that this may take some time for the Ranking History connector, especially for larger campaigns, accounts with daily ranking updates, or longer date ranges. If that's your setup, go grab a cup of coffee and come back in a couple of minutes.
Step 8: Create and customize your report
When it's done, you'll see the initial data displayed in a table with only two columns.
By default, only the keyword and ranking position columns are shown, but many more can be added by dragging one of the available fields to either Dimension (usually text) or Metric (usually numbers). Learn more about dimensions and metrics
Also in the data sidebar, you can change the number of rows shown per page, change the sort order, adjust the different date range, or add a filter.
But that's just the tip of the iceberg of what's possible now that you have your ranking data in Google Data Studio. If you're unfamiliar with how to use this tool, we recommend the following tutorials:
There are 2 connectors available now. Both show ranking data at the individual keyword level.
The main difference is that the 2-Day Ranking Comparison shows ranking data only for the first date and last date in the selected range, while the Ranking History will show ranking data for all dates between the begin and end dates of the selected range.
This connector shows a simple comparison between ranking data for two dates.
Keyword: The tracked keyword
MSV: The monthly search volume for this keyword
Tags: A comma-separated list of all tags applied to this keyword (user-defined)
Preferred Landing Page: An optional URL that you'd like to rank for this keyword (user-defined)
Translation: An optional translation of the keyword (user-defined)
Search Engine: The tracked search engine, country, language, device, and location
SERP Features: A list of all rich results present on the SERP
Position Change: The difference between the highest ranking URL for this keyword between the begin date and end date. This field is not available in the Ranking History connector.
Date: The date the SERP was recorded. This field is split into two fields in the 2-Day Ranking Comparison connector, one for begin date and one for end date.
Position: The position on the SERP for the highest ranking URL of the site for this keyword. This field is split into two fields in the 2-Day Ranking Comparison connector, one for begin date and one for end date.
Position (No Universal): The position on the SERP for the highest ranking URL of the site for this keyword, excluding rich results such as local map packs, images, video, etc. This field is split into two fields in the 2-Day Ranking Comparison connector, one for begin date and one for end date.
Inline Rank: The ranking position in a rich result that displays multiple URLs. (For example, a local map pack may display up to 4 URLs. Inline rank shows which of these 4 the ranking URL was found at. This field is split into two fields in the 2-Day Ranking Comparison connector, one for begin date and one for end date.
Ranking URL: The highest ranking URL for this keyword This field is split into two fields in the 2-Day Ranking Comparison connector, one for begin date and one for end date.
Type: The rich result type of the ranking URL. This field is split into two fields in the 2-Day Ranking Comparison connector, one for begin date and one for end date.
Using the Google Data Studio connectors will likely consume more API credits than a typical client. When you join the private beta, we will increase your API credits to a higher level than they were originally set at.
As you're using the connectors, if you find you're running low on API credits, please contact Dragon Metrics Support who can top up your credits for you. There is no charge for additional credits.