Many of you track important client KPIs in Google Sheets, whether that's offline conversions, sales numbers, call data, or custom-calculated metrics.
You can now use your Google Sheets data to build Custom Metrics and Goals directly in AgencyAnalytics.
Google Sheets in Custom Metrics and Goals
When you create a Custom Metric or Goal, start by selecting Google Sheets as your metric source. From there:
  • Identify the column in your spreadsheet you'd like to pull data from
  • Select your spreadsheet
  • Set your correct spreadsheet tab, date column, and aggregator type
Finally, finish building your Custom Metric or Goal as you normally would.
Learn more about using Google Sheets data in
Custom Metrics
and
Goals
.