Search our Knowledge Base
Search

Google Drive



Connecting a rank tracking campaign to Google Drive allows you to use external data in the Insight Graph, export rank reports directly to a Rank Ranger campaign folder in your Drive, and store documents relating to specific Links in Link Manager.

File size and type are based on Google Drive restrictions.

For more information regarding adding, managing and deleting 3rd party integrations, please refer to our Authorize Connections documentation.

Add Google Drive integration
 

Authorize Connection to a Google Drive

 
Integrate Google Drive with Rank Ranger
  • Log into a Google account (e.g., Gmail, Google Plus, etc.) for the Drive account you want to integrate with Rank Ranger.
  • Open the Account Settings > Authorized Connections screen.
  • Click the Add Connection button to expand the option list.
  • Click the Google Drive button.

Add Google Drive connection

Select the Account


If more than one Google account is accessed with the computer or device you're using, then Google will ask you to choose an account.

Select the Google Account


Permissions

Rank Ranger requires access to view and manage files in your Google Drive in order to complete this integration. This involves creation of folders that contain Rank data files and any files you upload to Link Manager (more information about this use can be found in the Rank Data and Link Manager sections in this document).

Review the permissions that need to be granted and click the Allow button if you agree.


Review the authorization message

More info

Click the i icon to review the more information regarding the account permissions.  Click the OK button to close the window. 

Google Drive Permissions


Name the Connection

Rank Ranger default is to name the connection based on the type (e.g., Google Drive) followed by the account name. You have the option to change that connection name during creation by entering the desired name in the Connection Name field and clicking the Update button. The name can also be edited later (refer to instructions in Authorize Connections).

Edit connection name



Connect a Campaign to Google Drive

 
Integrate Campaign with Google Drive

Connecting a rank tracking campaign to Google Drive will allow you to export Rank Tracker Dashboard reports directly to a Rank Ranger campaign folder in your Drive, and use data that you have in a Google Sheet in our Insight Graphs and Metric Widgets.
  • After connecting a Google Drive account to your Rank Ranger account, open the Campaign Settings > Other Integrations screen
  • Scroll down the Google Drive section and select a connection from the list of Google Drive accounts authorized for use in your Rank Ranger account.
  • Click the Connect button.

select Google Drive

Campaign Connected to Google Drive


It is important to click the Connect button after selecting the Drive account. When the Drive is correctly connected, Rank Ranger displays the Drive account name and usage.   To disconnect a Drive account from a campaign, simply click the Disconnect link below the Drive account information on the Campaign Settings > General Settings screen.

correct Google Drive connection


Google Sheets Data in Insight Graph

Integrate Google Sheets data with marketing metrics in an Insight Graph

Google Sheets integration makes it possible for you to produce a graph with internal company data (e.g., sales, offline advertising, net profit, etc.)  that is not available via third-party integration. That data can easily be blended in a graph with our search engine rank and backlink data, search traffic, social media and email campaign performance, and more.

In this example, we've used Google Sheet data for the Total Sales and Offline Advertising expense, and added Website Sales (from Google Analytics tracking) and AdWords Spend per month (AdWords must be linked to your Google Analytics profile - refer to Link Google Analytics and AdWords).

Insight Graph displaying data from Google Sheets, Analytics and AdWords

Insight Graph with data from Google Sheets, Analytics and AdWords



The first step to graphing data from Google Sheets is to authorize a Google Drive account and connect it to a campaign.

Add Google Sheets Metric
Open an Insight Graph or Metric Widget and select:
  • Data Source: Other Integrations
  • Type: Google Sheets
In the Spreadsheet field, copy and paste the URL of the Google Sheet containing the data
 
Add data from Google Sheets to an Insight Graph



Define the Metric Data

Select the Sheet name from the menu (each tab in Google Sheets has a label name, e.g., Sheet1, Sheet 2, or user assigned custom names)

Google Sheets Insight Graph settings


Date and Value Ranges

Viewing the Google Sheet in another window, determine the data ranges and:
  • Enter the start cell and end cell that contain the dates
  • Enter the start cell and end cell that contain the values
Using the following Google Sheet example, the Insight Graph settings in the previous image correspond to a Date Range from cells A2 - A7; October 2016 - March 2017, and Regional Sales Percentage for the USA from cells F2 - F7.

Google Sheet Example


Y Axis Settings

By default each metric has its own separate Y Axis with a label matching the Metric Name field.
  • If you want the Y Axis name to be different than the metric name, you can enter the label in the Y Axis name field.
  • If you want a group of metrics all plotted on the same Y axis, then enter the same Y Axis name when adding each metric.

Y Axis Name field


Insight Graph with Shared Y-Axis

In this example, "Percent" was entered in the Y Axis name field of all 4 metrics to cause them all to be graphed on the same scale. 
shared Y axis

Refer to Metric Display Settings to learn more about colors, chart types, markers, labels and date options.

Google Sheets Data in Metric Widgets


Integrate Google Sheets data with marketing metrics in single or multiple Metric Widgets

Google Sheets integration makes it possible for you to produce widgets that can include numbers, trend chart and comparison to previous period KPIs that are not available via third-party integration such as internal company data (e.g., sales, offline advertising, net profit, etc.). .

In this example, we've used Google Sheet data for the total sales vs. sales per region compared to previous period.

Series of Metric Widgets

metric widgets displaying data from a Google Sheet


The first step to creating widgets using data from a Google Sheet is to authorize a Google Drive account and connect it to a campaign.

Add Google Sheets Metric

Open Graphs > Single Metric Widget, click the Add New Metric button and select:
  • Data Source: Other Integrations
  • Type: Google Sheets
In the Spreadsheet field, copy and paste the URL of the Google Sheet containing the data
 
Add data from Google Sheets to Metric Widgets


Define the Metric Data

Select the Sheet name from the menu (each tab in Google Sheets has a label name, e.g., Sheet1, Sheet 2, or user assigned custom names).

Viewing the Google Sheet in another window, determine the data ranges and:
  • Enter the start cell and end cell that contain the dates
  • Enter the start cell and end cell that contain the values
Using the following Google Sheet example, the Metric settings in the previous image correspond to a Date Range from cells A2 - A3; February - March 2017, and Regional Sales for Australia from cells C2 - C3.   The latest date in the series entered determines the current data, and the oldest date in the range is the data used for the previous period.

Google Sheet Example

Refer to Metric Display Settings to learn more about color and theme options.

Rank Data Export to Google Drive


Export Rank Tracking Report to Google Drive

To utilize the export to Google Drive feature, you must be logged into the Google account for the Drive that is connected to the campaign (learn how to authorize connection to Google Drive and connect Google Drive to a campaign).

In the Rank Tracker Dashboard report, hover over the download icon and select CSV to Drive.
 
Export Report to Google Drive


Rank Report Export Successful

The exported file displays in the browser and can be opened with a variety of tools or closed and viewed later. 

rank report exported to Google Drive


View Rank Report in Google Sheets

In the above example, I chose to open the rank report data in Google Sheets and am now able to work with that data as needed.
 
Rank Report view in Google Sheets



View Rank Ranger Campaign Data in Google Drive

After exporting a report from Rank Ranger to Google Drive, you will see a folder for each campaign in that Drive.  You can rename those folders and move them to other locations within that same Drive and Rank Ranger will continue to write to that folder when you export additional reports for that same campaign as long as authorized access exists in your Account & Campaign Settings for that Drive. These folders can be shared with others in the same manner you share any folder in Google Drive.

Rank Ranger campaign folders in Google Drive



Rank Data Files in Google Drive for 1 Campaign

In this example you see the Jeni's Splendid Ice Creams campaign with 3 files; 2 CSV files of the Dashboard report for each reflecting a different date, and 1 Google Sheet file for the date that I opened and edited the CSV file data using Google Sheets. Like all Google Drive files, these files can be shared with others and downloaded to a local computer drive.

Google Drive Files


Google Drive Error


If after clicking the CSV to Drive option, you recieve an error message from Google indicating that you need permission, that indicates that you are not logged into the Google Drive account that is connected to the campaign. You may choose one of two methods to resolve this error:
  • Click the Switch accounts button and select and log into the Google account that is connected to the campaign
  • Change the Google Drive account that is connected to the campaign in the Campaign Settings > Other Integrations screen, to the Google account that you are logged into while working in Rank Ranger.
             
Google Drive Error

Link Manager File Storage in Google Drive


Connect Google Drive with Link Manager for Link-related Documents

Connecting a Google Drive to your Link Manager will allow you to attach files (e.g., invoices, link exchange agreements, etc.) to individual Link records.
  • After connecting a Google Drive account to your Rank Ranger account, open the Account Settings > Default Tool Settings screen
  • Expand the Link Manager section
  • Select a Drive Connection and click the Save button.  When successfully connected, the Google Drive user's name and usage statistics display.

connect Link Manager to Google Drive


Add Files to Link Details


After connecting a Google Drive to Link Manager, open the Campaigns > Link Manager screen and click the Edit (pencil) icon for an individual link.
 
Link details


  • Scroll down the screen to the Files & Documents section.
  • Click the Choose File button, navigate to and select the file on your computer.
  • Click the Upload button
 
Upload link related files


Successful File Upload to Google Drive

When files display in the Files & Documents section of a Link Details screen, they have been successfully uploaded to the Google Drive account connected in the Localization & Settings screen. From here authorized users of the Rank Ranger account can download or delete the files.

Successful Link related file upload to Drive


Google Drive Link Manager Folders

Each individual Link is assigned an ID in the Link Manager and those IDs become the folder names in the Google Drive connected to the Rank Ranger account.  Folders can be shared, renamed and moved to other locations in Google Drive as needed.  Files can be deleted from the Link Details screen by an authorized user* or from Google Drive.

Google Drive Link Folders

*By default, a user can only manage the links s/he created unless "Manage Account Links" permission is granted by the account administrator (refer to Manage Users permissions).


Available Third Party Integrations


Get the ultimate SEO tools with the Rank Ranger Software
Learn More About Rank Ranger