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 / By Multiple Users
- 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
- This Action is Not Supported When You Are Logged in to Multiple Accounts
- Not All Accounts/Segments/Custom Fields/Labels Are Showing in the Product
- Daily query quotas
- Can't Be Calculated, Would Require Summing Deduplicated Values
- These Metrics and Dimensions Can't Be Fetched Together / Incompatible Fields
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
- How to Get Cost Per Conversion for Facebook Custom Conversions (Data Studio)
- 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 Insights
- Facebook Page is Missing From List
- Discrepancies with Facebook Insights Results
- [FIXED] Facebook - Post level discrepancies
- How Do I Get the Count of Posts in Data Studio?
- Insights Restrictions for Pages With Under 100 Likes
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 Insights Updates Jan. 2019
- Facebook Insights Updates Nov. 2018
- Facebook Insights Updates Oct. 2018
- Facebook Insights Updates July 2018
- Facebook Insights Updates June 2018
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
Public Data / Simple Connectors
Seachmetrics
SEMRush
Twitter Ads
Yahoo Gemini
Yandex Direct
YouTube
Recent articles
- Do I need to pay to use Supermetrics for Google Drive?
- It seems you tried to log in with a Google Account that does not have DoubleClick enabled
- Facebook Ad Account Missing From the List
- Twitter Ads Account Fetch Error: User xxxx is Not Authorized to Make This Request
- Moz Error: Data Fetch Failed: 403 Permission Denied
- Twitter Public Data Limitation for Country