Supermetrics Support Forum
System Status Updates
Supermetrics for Google Sheets
Getting Started
- First steps (getting Supermetrics Sidebar in to your Google Sheets)
- How to login to data sources? (step-by-step)
- How to create a reporting dashboard
- Do you have any templates for easy setup?
- Upgrade trial/free license to paid subscription
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?
- How does the tool determine where to place the data on query refresh? How can I move queries?
- What does the "Filter referral spam" setting do?
- What does the "Show all time values" setting do?
Troubleshooting
- I get "Authentication expired: Refreshing token failed" or "Query failed: Trial expired" -messages. What to do?
- Your License is Being Used Simultaneously in X Browsers
- Reporting Templates' Updates and Troubleshooting Tips (From Google Sheets to Data Studio)
- Why Are My Comparison Period Values Blank?
- Queries are Returning Dates With Apostrophe Characters (')
Tips & Tricks
Missing metrics or dimension
- Google Analytics metrics missing from Supermetrics
- Google Ads metrics missing from Supermetrics
- Facebook Ads metrics missing from Supermetrics
- Facebook Insights metrics missing from Supermetrics
- Twitter Ads metrics missing from Supermetrics
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
Supermetrics for Data Studio
Getting Started
- Adding and authorizing Supermetrics connectors in Google Data Studio
- Editing data source fields
- Edit data source field descriptions
- How to create a time series chart
- How to create a pie chart
Frequently Asked Questions (FAQ)
- Can I Use Multiple Accounts in the Same Data Source?
- How can I remove my account from the Data Studio connectors?
- Can I purchase more accounts for my license?
- How Do I Access Team Management for Data Studio?
- What Does "Number of Ad Accounts Per Ad Network" Mean?
Troubleshooting
- Community connector error: You are using the free version of Supermetrics for Data Studio
- Troubleshooting for Paid Channel Mix Template
- Scorecard showing error
- Troubleshooting No Data Found Errors
- Summary Row Shows Wrong Values When Using a Filter
Tips & Tricks
Supermetrics for Excel
Supermetrics API
Supermetrics Data Grabber
Getting Started
Troubleshooting
- I've purchased a license, but when logging in, I get an error saying my trial period has expired.
- Why doesn't anything happen when I press the "Log into Google Analytics" button?
- Why do I see discrepancies between Supermetrics Data Grabber and the Google Analytics web interface?
- 60k Row limit in old Data Grabber versions
- I get an error when trying to log in to the Google Webmaster Tools Module, even though I'm sure my credentials are correct.
Frequently Asked Questions
- When I open the file, Excel shows an error message describing unreadable content, and notifies that is has removed Visual Basic for Applications (VBA). None of the buttons work.
- Can I change the user ID associated with my license?
- How do I refresh a report to cover a new date range?
- What are the definitions of the metrics and dimensions that Supermetrics Data Grabber makes available?
- How can I get separate metrics for paid and organic search traffic?
Supermetrics Uploader
Getting Started
Troubleshooting
- I can't schedule an upload, because whichever Google Analytics webproperty I select, the tool returns an "No custom data sources found" error.
- I've had an upload running successfully for some time, but now I get an "invalid credentials" error. What's wrong?
- Error: Unable to refresh your token. It may not be valid anymore.
Frequently asked question (FAQ)
- I've already uploaded data into Google Analytics using another upload tool. Will Supermetrics Uploader overwrite this data?
- What does Supermetrics Uploader do with my data?
- Do I need to provide my Google Account login credentials to the tool?
- Will you be adding automatic daily uploads for other data sources?
Supermetrics Functions
Getting Started
Troubleshooting
Frequently asked questions
- How do I make the results span several cells? When I enter a function, I get a value to just one cell.
- How can I add a button that updates all the functions I've placed?
- How do I get the function to return more rows/columns?
- How do I use the functions when connecting via a proxy server?
- How can I use the functions in an existing workbook I have?
Account management & Payments
Account Management
Payments / Invoices
- How can I cancel my Supermetrics subscription?
- Payment options
- Where Can I Find and Modify My Invoices?
- How Do I Enable/Disable Auto-Renewal?
- What to Do if My Credit Card Was Declined?
Team Management Tool
- Team Management for Data Studio
- License Management
- Forcing a Refresh for Account Data
- Viewing Your Account Usage
- Merging Teams in Team Management
General Issues and Instructions Per Data Source
General Issues
Adobe Analytics
AdRoll
Amazon Ads
Bing Ads
Custom JSON/CSV
Databases
DoubleClick
Google Ads
Google Analytics
Google Display & Video 360 (Campaign Manager)
Google My Business
Google Search Console
Facebook Ads
- Can I set a custom conversion window for Facebook Ads metrics?
- How to Query for Facebook Ads Custom Conversions
- I am getting error message : Error validating access token: The user is enrolled in a blocking, logged-in checkpoint
- Discrepancies in Data Studio When Using a Filter
- Facebook Ads Error: Unsupported Get Request. Object With ID 'act_XXXX' Does Not Exist
Facebook Insights
- The XXX metric is only available on daily, weekly or monthly level
- Facebook Insights Error: (#283) Requires manage_pages permission to manage the object
- Insights Restrictions for Pages With Under 100 Likes
- [FIXED] Facebook - Post level discrepancies
- Discrepancies with Facebook Insights Results
Facebook Public Data
Instagram Insights
LinkedIn Ads
MailChimp
Moz
SEMRush
Twitter Ads
Twitter Public Data
YouTube
Data Source Update Logs
Adform
AdRoll
Ad Data + Google Analytics (DS ONLY)
Amazon Ads
Bing Ads
Facebook Ads
- Facebook Ads Updates Sept. 2018
- Facebook Ads Updates Aug. 2018
- Facebook Ads Updates July 2018
- Facebook Ads Updates June 2018
- Facebook Ads Updates May 2018
Facebook Insights
Facebook Public Data
Google Ads
Google Ad Manager
Google Display & Video 360 (Bid Manager)
Google Display & Video 360 (Campaign Manager)
Google My Business
Google Search Console
LinkedIn Ads
LinkedIn Pages
Moz
SEMRush
Twitter Ads
Yahoo Gemini
YouTube
Seachmetrics
Recent articles
- Unable to See Instagram Account After Logging In
- How do I Re-Authenticate an Excel Connector?
- Can I Schedule Queries to Refresh Automatically (Excel)?
- Google My Business Updates Dec. 2018
- Instagram Insights Failure (Error Validating Access token: Session Has Expired)
- Issue with Adform Connector Dec 3rd 2018 **UPDATE**