*Disclaimer: The add-on described here is not yet live in AgencyAnalytics. These articles are currently live as part of the add-on approval process.*
In order to pull data from AgencyAnalytics using the Google Sheets addon, you'll first need to create a query. If you haven't done so yet, login to the Addon following the steps here, to see AgencyAnalytics in the tool bar.
To get started, click AgencyAnalytics in the toolbar at the top of the Google Sheet you're working in, then click Launch Sidebar from the dropdown.
Then, click the Create New Query button at the bottom of the sidebar.
Next, you'll name the Query, and select where in the Google Sheet you'd like the data to load. You can have multiple queries within one Google Sheet, so keep this in mind when organizing where your queries load.
When choosing where to load data, you can either type your choice into the field, or click the cell you want to use, then click the grid button to the right to use the actively selected cell.
The selected cell is the first cell that data will load into; the amount of space used by the query will change dependent on how many metrics the query is set to pull in. Each Metric will have it's own column.
Next, there are a few selections you need to make to determine where we pull the data from in this Query, and a few optional choices. To learn more about these options, checkout the addon overview here.
After selecting where you want the data to come from, pick the metrics you'd like to pull. To do so, click the Metrics field, then type to search for the metric name. Check the boxes to the left of the metric name, to add them to the query.
Once all of these settings are selected, you're ready to pull data. To do so, click the Insert Data button at the bottom of the sidebar.
The data you've filtered for will load into the Google Sheet, starting with the cell you selected earlier.
Back on the query page of the sidebar, you will now see your query listed here, along with some useful information about the query.
It will display the integration icon for this query, as well as the Sheet and cells it loads into. Lastly, it will show the last date this query was run.
Edit a Query in the Google Sheets Addon
Update data pulled from a Query in the Google Sheets Addon
Google Sheets Addon Overview