Supermetrics Support Forum
System Status Updates
Supermetrics for Google Sheets
Getting Started
- First steps (getting Supermetrics Sidebar in to your Google Sheets)
- Logging into Data Sources for Google Sheets (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?
- 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
- 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 (')
- Unaligned Data, Unexpected Values, Changes Not Showing, and Other Issues Due to Duplicate Queries
Tips & Tricks
- 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
- Query Placement and How to Move Queries
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)
- Data Studio User Restrictions / "You're Not Allowed to Run Queries With This License"
- Can I Use Multiple Accounts in the Same Data Source?
- How Can I Remove My Account From the Data Studio Connectors?
- How Do I Access Team Management for Data Studio?
- What Does "Number of Accounts Per Data Source" 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
- This Was a Reauthorization Request for User X But You Logged in as User Y
Tips & Tricks
- Scheduled Email Delivery of Reports for Data Studio
- Converting Null Values to Zero
- Using DS Data Blending Feature With Supermetrics
- Copying Data Studio Report and Data Source Files
- How to Add Images/Creatives to Your Report from URL Fields
Supermetrics for Excel
Supermetrics for BigQuery
Supermetrics API
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?
- How Do I Upload Historical Data with Supermetrics Uploader?
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?
- 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.
- Why don't the dropdown menus work when I use Supermetrics Data Grabber on my Mac? They close so quickly I can't select anything. / I can't scroll down to select all metrics.
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.
- 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?
- Can I include several advanced segments in the same report?
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
- Where can I find my Account Management page?
- Can I Change My User ID for Supermetrics?
- How Can I Renew/Extend My License?
- How can I upgrade my license from Pro to Super Pro level?
- How to Assign Users to Your Data Studio License
Payments / Invoices
- Where Can I Find and Modify My Invoices?
- What to Do if My Credit Card Was Declined?
- How to Update Credit Card Details
- How Do I Enable/Disable Auto-Renewal?
- How can I cancel my Supermetrics subscription?
Team Management Tool
- Team Management Basics
- 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
- General Data Source Access Requirements
- Daily Query Quotas
- Can't Be Calculated, Would Require Summing Deduplicated Values
Adobe Analytics
AdRoll
Criteo
Custom JSON/CSV
- Custom JSON/CSV connector for Data Studio
- Upload CSV files from your Google Drive to Data Studio with Custom JSON/CSV
- Enabling Date Placeholders for Custom JSON/CSV in Data Studio
- Size Limitations for JSON Requests
- Sample Use Cases - How to use Custom JSON/CSV connector
Databases
Facebook Ads
- Getting "No Data" With Reach and Other Unique Metrics With Filters
- 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
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
Google Ads
Google Ad Manager
Google Analytics
Google BigQuery
Google Campaign Manager
Google Display & Video 360
Google My Business
Google Search Console
HubSpot
- How to get started with HubSpot? (Google Sheets)
- How to get started with HubSpot? (Data Studio)
- How to get started with HubSpot? (Microsoft Excel)
- How to Monitor Your HubSpot Import Status
- Can I Use HubSpot Custom Properties?
Instagram Insights
- Unable to See Instagram Account After Logging In
- Known Issues with Instagram Story Insights
- Instagram Insights Failure (Error Validating Access token: Session Has Expired)
- Instagram Public Data Errors (decreased query limit and disabled endpoints)
- Discrepancies with Instagram Insights Results
LinkedIn Ads
- Expired Token and Authentication Errors for LinkedIn Ads/Pages
- LinkedIn Ads failure "Member does not have author access to view UserGeneratedContent"
- LinkedIn Ads Failure: The Request Returns Too Much Data
- How to Query for Specific Conversions in LinkedIn Ads
- Discrepancies With LinkedIn Ads Demographic Dimensions
LinkedIn Company Pages
MailChimp
Microsoft Advertising
Moz
Outbrain Amplify
Quora Ads
Salesforce
Searchmetrics
SEMrush Analytics
SEMrush Projects
Twitter Ads
Twitter Premium
Twitter Public Data
YouTube
Data Source Update Logs
Adform
- Adform Updates Aug. 2019
- Adform Updates April 2019
- Adform Updates Jan. 2019
- Adform Updates Dec. 2018
- Adform Updates Sept. 2018
AdRoll
Ad Data + Google Analytics (DS ONLY)
Criteo
Facebook Ads
- Facebook Ads Updates Nov. 2019
- Facebook Ads Updates Oct. 2019
- Facebook Ads Updates Aug. 2019
- Facebook Ads Updates July 2019
- Facebook Ads Updates June 2019
Facebook Insights
- Facebook Insights Updates Jan. 2020
- Facebook Insights Updates July 2019
- Facebook Insights Updates Feb. 2019
- Facebook Insights Updates Jan. 2019
- Facebook Insights Updates Nov. 2018
Facebook Public Data
Google Ads
- Google Ads Updates Aug. 2019
- Google Ads Updates June 2019
- Google Ads Updates May 2019
- Google Ads Updates Feb. 2019
- Google Ads Updates Jan. 2019
Google AdSense
Google Ad Manager
- Google Ad Manager Updates Nov. 2019
- Google Ad Manager Updates July 2019
- Google Ad Manager Updates May 2019
- Google Ad Manager Updates April 2019
- Google Ad Manager Updates Mar. 2019
Google Analytics
Google Campaign Manager
- Google Campaign Manager Updates Aug. 2019
- Google Campaign Manager Updates May 2019
- Google Campaign Manager Updates Mar. 2019
- Google Campaign Manager Updates Jan. 2019
- Google Campaign Manager Updates Oct. 2018
Google Display & Video 360
- Google Display & Video 360 Updates Dec. 2019
- Google Display & Video 360 Updates Nov. 2019
- Google Display & Video 360 Updates July 2019
- Google Display & Video 360 Updates May 2019
- Google Display & Video 360 Updates Mar. 2019
Google My Business
Google Search Ads 360
Google Search Console
HubSpot
Instagram Insights
LinkedIn Ads
- LinkedIn Ads Updates Jan. 2020
- LinkedIn Ads Updates Dec. 2019
- LinkedIn Ads Updates Nov. 2019
- LinkedIn Ads Updates Oct. 2019
- LinkedIn Ads Updates May 2019
LinkedIn Pages
MailChimp
Microsoft Advertising
Moz
Public Data / Simple Connectors
Quora Ads
Seachmetrics
SEMrush Analytics
Taboola
Twitter Ads
- Twitter Ads Updates July 2019
- Twitter Ads Updates June 2019
- Twitter Ads Updates May 2019
- Twitter Ads Updates Jan. 2019
- Twitter Ads Updates Nov. 2018