Our line chart and sparkline 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. Need to set up a bar or pie chart Sheets widget? Click here.
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.
Next, add a Google Sheets line chart or sparkline widget to your report or custom dashboard. Choose Misc > Google Sheets, or simply search for "sheets" when adding widgets to see our Google Sheets options.
Once you've added the widget, open the widget's settings via the gear icon 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)
- Specify the date column in the "Dimension Column"
- 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 styles.
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:
...and like this in a sparkline widget: