Supermetrics Support Forum
System Status Updates
Supermetrics
Data Sources
- Issue with Facebook Ads - Unsupported Get Request/Query failed due to a known issue - 13/03/2020
- Issue with Facebook Ads - queries failing - 01/04/2020
- Issue with Facebook Insights - "FB error: (#190) This method must be called with a Page Access Token" - 02/042020
- Google Reducing Some Functionality of Google My Business
- Known Issue With Facebook Insights - Unknown Get Request
Impactful Data Source API Changes
- Facebook Ads Field Deprecations - March 25th, 2020
- SEMrush Analytics Field Deprecations - March 31st, 2020
- Microsoft Advertising Field Deprecation "Average Position" - April 1st, 2020
- Google Ad Manager Revenue Behavior Change - April 1st 2020
- HubSpot Field Changes for Analytics - April 7th 2020
Authentication Guides
Getting started
Common Errors
- Authentication-, HTTP- or Script errors
- This Was a Reauthorization Request for User X But You Logged in as User Y
- This Action is Not Supported When You Are Logged in to Multiple Accounts
- Data Studio User Restrictions / "You're Not Allowed to Run Queries With This License"
- Not All Accounts/Segments/Custom Fields/Labels Are Showing in the Product
Troubleshooting
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)
- 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?
- How do I Refresh Fields/Update a Connector?
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
- 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
- Viewing Your Account Usage
- Merging Teams in Team Management
- Granting Permission for Data Access to Support
General Issues and Instructions Per Data Source
General Issues
Ad Data + Google Analytics
Adobe Analytics
Adform
AdRoll
Bing Webmaster Tools
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
- How to Authenticate/Re-authenticate Facebook Ads in Google Sheets, Google Data Studio & Microsoft Excel
- Getting "null" or "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)
Facebook Audience Network
Facebook Insights
- How to Authenticate/Re-authenticate Facebook Insights in Google Sheets, Google Data Studio & Microsoft Excel
- 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?
Facebook Public Data
Google Ads
- How to Authenticate/Re-authenticate Google Ads in Google Sheets, Google Data Studio & Microsoft Excel
- Google Ads Error: AuthorizationError.CUSTOMER_NOT_ACTIVE
- Google Ads Error: USER_PERMISSION_DENIED: User xxx Doesn't Have Permissions for Account
- Google Ads Discrepancies with Top Impression Share Metrics
- Enabling User Location for Geo Performance Reporting
Google Ad Manager
Google Analytics
- How to Authenticate/Re-authenticate Google Analytics in Google Sheets, Google Data Studio & Excel
- Discrepancies in Google Analytics Results
- Does Supermetrics Support Custom Metrics/Dimensions in Google Analytics?
- Google Analytics Error: USER_PERMISSION_DENIED
- Google Analytics User and Event Data Missing After X Months
Google BigQuery
Google Campaign Manager
- Query Getting Stuck/Time Outs When Using Floodlight Variables
- How to Authenticate/Re-authenticate Google Campaign Manager in Google Sheets, Google Data Studio & Microsoft Excel
- It seems you tried to log in with a user that does not have Google Campaign Manager enabled
- Date Range Limitations on Floodlight Data (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
- How to Authenticate/Re-authenticate Instagram Insights in Google Sheets, Google Data Studio & Microsoft Excel
- 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)
LinkedIn Ads
- How to Authenticate/Re-authenticate LinkedIn Ads in Google Sheets, Google Data Studio & Microsoft Excel
- 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
LinkedIn Company Pages
MailChimp
- How to Authenticate/Re-authenticate Mailchimp in Google Sheets, Google Data Studio & Microsoft Excel
- Incompatible fields: IllegalDimensionMetricCombinationException (MailChimp)
- MailChimp Known Issue: List Growth History Returns 0 For Some Months
- Discrepancies in MailChimp's Own Reporting UI
- Unable to Fetch Data From Multiple Accounts with Mailchimp
Microsoft Advertising
Moz
Outbrain Amplify
Optimizely
Pinterest Ads
Pinterest Public Data
Quora Ads
Salesforce
Searchmetrics
SEMrush Analytics
SEMrush Projects
Snapchat Marketing
Taboola
Twitter Ads
- How to Authenticate/Re-authenticate Twitter Ads in Google Sheets, Google Data Studio & Microsoft Excel
- Twitter data discrepancy
- This User Does Not Have Permission to Read Campaign Data
- Twitter Ads Error: Expect Time to Be Midnight in the Account's Local Timezone
- Twitter Ads Account Fetch Error: User xxxx is Not Authorized to Make This Request
Twitter Premium
Twitter Public Data
- How to Authenticate/Re-authenticate Twitter Public Data in Google Sheets, Google Data Studio & Microsoft Excel
- Getting Started - Twitter Public Data Connector
- Twitter Public Data Limitation for Country
- Discrepancies with Fetching User Tweets (Twitter Public Data)
- Twitter Public Data Error - "Profile(s) not found"
Verizon Media Native Ads
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
Adobe Analytics v1
AdRoll
Ad Data + Google Analytics (DS ONLY)
Criteo
Facebook Ads
- Facebook Ads Updates March 2020
- Facebook Ads Updates Nov. 2019
- Facebook Ads Updates Oct. 2019
- Facebook Ads Updates Aug. 2019
- Facebook Ads Updates July 2019
Facebook Insights
- Facebook Insights Updates Feb. 2020
- Facebook Insights Updates Jan. 2020
- Facebook Insights Updates July 2019
- Facebook Insights Updates Feb. 2019
- Facebook Insights Updates Jan. 2019
Facebook Public Data
Google Ads
- Google Ads Updates March 2020
- Google Ads Updates Feb. 2020
- Google Ads Updates Jan. 2020
- Google Ads Updates Aug. 2019
- Google Ads Updates June 2019
Google AdSense
Google Ad Manager
- Google Ad Manager Updates March 2020
- Google Ad Manager Updates Jan. 2020
- Google Ad Manager Updates Nov. 2019
- Google Ad Manager Updates July 2019
- Google Ad Manager Updates May 2019
Google Analytics
Google Campaign Manager
- Google Campaign Manager Updates Feb. 2020
- 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 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
- Microsoft Advertising Updates March 2020
- Microsoft Advertising Updates June 2019
- Microsoft Advertising Updates May 2019
- Microsoft Advertising Updates Dec. 2018
- Microsoft Advertising Updates May 2018
Moz
Pinterest Ads
Public Data / Simple Connectors
Quora Ads
Salesforce
Seachmetrics
SEMrush Analytics
Snapchat Marketing
Taboola
Twitter Ads
- Twitter Ads Updates March 2020
- Twitter Ads Updates Feb. 2020
- Twitter Ads Updates Jan. 2020
- Twitter Ads Updates July 2019
- Twitter Ads Updates June 2019
Verizon Media Native Ads
Yandex Direct
Yandex Metrica
YouTube
Recent articles
- Issue with Facebook Ads - queries failing - 01/04/2020
- Issue with Facebook Insights - "FB error: (#190) This method must be called with a Page Access Token" - 02/042020
- Issue with Facebook Ads - Unsupported Get Request/Query failed due to a known issue - 13/03/2020
- How to Authenticate/Re-authenticate YouTube in Google Sheets, Google Data Studio & Microsoft Excel
- General Data Source Access Requirements
- Discrepancies with Snapchat Marketing Results