Supermetrics Support Forum
Supermetrics for Google Sheets
Getting Started
- First steps: Getting the Supermetrics sidebar into Google Sheets
- Logging in to data sources for Google Sheets
- How to run queries in Google Sheets
- Using report templates with Google Sheets
- Setting up triggers for Google Sheets
Frequently Asked Questions (FAQ)
- Which data sources can I access with Supermetrics for Google Docs/Sheets, and will you be adding more?
- I'm logged into Google Docs with one Google Account, but for Supermetrics, I want to log in to Google Analytics with a different Google Account. How do I do this?
- What does the "Show all time values" setting do?
- What does the "Combine new results with old" setting do?
- Can I See/Edit All of the Queries That I've Created?
Troubleshooting
- Your License is Being Used Simultaneously in X Browsers / By Multiple Users
- Why Are My Comparison Period Values Blank?
- Queries are Returning Dates With Apostrophe Characters (')
- Unaligned Data, Unexpected Values, Changes Not Showing, and Other Issues Due to Duplicate Queries
- Error: This action would increase the number of cells in the workbook above the limit of 5,000,000 cells
Tips & Tricks
- How to modify or edit a query
- I need to change the date formatting in my results
- I have "null" results that I would like to appear as number zeroes (0)
- Refreshing License Info
- Adding All Accounts to Your Query
Triggers/Scheduled Refresh
- Can I Schedule My Reports to be Refreshed or Emailed at Specific Intervals?
- The triggers I added don't work.
- I've added triggers to refresh my queries every hour, but they don't work.
- Sender IP address for report scheduled e-mails
- My triggers are delayed for hours or they do not fire at all