Our Google Sheets widgets have full date range functionality. This means that when you change the date range in our platform, the data in those widgets will also change.
Setting up the Google Sheet with data and a date column
First, you'll need to get your data into a Google Sheet.
The Sheet should be set up so that:
- One column has dates in chronological order, following one of our required date formats like dd-mm-yyyy (e.g. "26-12-2019"). This will be the x-axis (horizontal axis) of your line or sparkline widget.
- Another column has the numerical data you'd like to be shown for each date. This will be the y-axis (vertical axis) of your widget.
Here's an example, where column A has our dates, and column B contains our data.
Setting up Google Sheets widgets in AgencyAnalytics
To plug your Google Sheets data into an AgencyAnalytics widget, first ensure you've integrated Google Sheets in your campaign.
Once you've added the widget, open the widget's settings via the ellipsis ("...") at the top right corner of the widget.
In the widget settings, do the following:
- Select the Google Sheet you'd like to use for this widget (the "Spreadsheet" option)
- Select the tab that contains the data you want to use ("Spreadsheet Tab")
- Specify the date column in the "Dimension Column" in your pie chart or bar chart widget or in the "Date Column" in your table, line chart or sparkline widget.
- Specify the column containing data in the "Metric Column"
Once you're done, click "Save Settings", and you'll be all set.
The widget settings also allow you to configure other aspects of the widget, such as the custom date range, title, and theme color.
The end result
Recall our example where column A contained our Dimension (the dates), and column B contained our Metric (the data):
The data would be shown like this in a line chart:
like this in a sparkline widget:
like this in a bar chart widget:
like this in a pie chart widget:
...and like this in a table widget: