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
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
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)
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.
: select Decimal or Integer
: you may enter a symbol (e.g., currency) that you want to preceed the value
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
Insight Graph with Shared Y-Axis
Refer to Metric Display Settings to learn more about colors, chart types, markers, labels and date options.
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.