Supermetrics Support Forum
System Status Updates
Supermetrics
Data Sources
- Issue with Facebook Ads - 23rd of November 2020
- Facebook Ads Changing Attribution Window Settings - Oct. 12th, 2020
- Google Ads Conversion Category Changes - October 15th, 2020
- What You Need to Know About Google Analytics 4 Properties
- Issue with Google Search Console when using the "Combine new results with old" option in Sheets - 30th of October 2020
Impactful Data Source API Changes
Authentication Guides
Getting started
Common Errors
- Error: "Authentication failed" & "You need to re-authenticate at X and then run the query again."
- Authentication-, HTTP- or Script errors
- Error: "No accounts found" & "No accounts found or the service is not enabled for this user."
- Error: "It seems you tried to log in with a user that does not have (data source) enabled. Please try again with another user account."
- Google Data Studio - This Was a Reauthorization Request for User X But You Logged in as User Y
Troubleshooting
- General Data Source Access Requirements
- How to Renew Tokens - Login Management in Team Site
- How to Completely Remove a Data Source from Microsoft Excel
- How Do I Completely Remove a Data Source from Data Studio?
- How to Completely Remove a Data Source from Google Sheets
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?
- Can I See/Edit All of the Queries That I've Created?
- How can I delete queries? I've cleared the data but it keeps reappearing when I press Refresh.
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
Supermetrics for Data Studio
Getting Started
- Adding and authorizing Supermetrics connectors in Google Data Studio
- Creating a report and charts with Google Data Studio
- List of getting started guides per data source
- Using report templates with Google Data Studio
- Editing data source fields
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 for DWH and Cloud Storage
Supermetrics API
Supermetrics Uploader
Getting Started
Troubleshooting
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 (Legacy)
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 (Legacy)
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
- 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
- How Do I Start Using the 'Free' Version of Supermetrics?
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
Adform
Adobe Analytics
AdRoll
Ahrefs
Bing Webmaster Tools
CallRail
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 Started - 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
- Facebook Ads Adjustments to Store Traffic Ads
- Can I Set a Custom Conversion Window for Facebook Ads Metrics?
Facebook Audience Network
Facebook Insights
- Getting Started - 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
Facebook Public Data
Google Ads
- Getting Started - 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
Google Ad Manager
Google Analytics
- Getting Started - 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 AdSense
Google BigQuery
Google Campaign Manager
- How to Authenticate/Re-authenticate Google Campaign Manager in Google Sheets, Google Data Studio & Microsoft Excel
- Query Getting Stuck/Time Outs When Using Floodlight Variables
- 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
- Getting Started - Google Display & Video 360
- How to Authenticate/Re-authenticate Google Display & Video 360 in Google Sheets, Google Data Studio & Microsoft Excel
- It seems you tried to log in with a Google Account that does not have Google Display & Video 360 enabled
- Backend Errors and Account List Load Timeouts for Display & Video 360
- Can I Select Specific Advertisers Under a DV360 Profile?
Google My Business
- How to Authenticate/Re-authenticate Google My Business in Google Sheets, Google Data Studio & Microsoft Excel
- Local Post API is Disabled for This Location
- Locations Are Missing From the List
- One of the Selected Locations Does Not Exist Anymore or You Do Not Have Access to It
- Google My Business Data Delays
Google Search Ads 360
Google Search Console
- How to Authenticate/Re-authenticate Google Search Console in Google Sheets, Google Data Studio & Microsoft Excel
- Using the 'Brand Keywords' Option
- Discrepancies in Google Search Console results
- Filtering issues in Google Search Console
- Discrepancy correction for Google Search Console queries
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
- Getting Started - 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
- How to Reset the Business Integration for Instagram
- Instagram Insights failure (Fetching insights caused the following error: (#10) Application does not have permission for this action)
Instagram Public Data
LinkedIn Ads
- Getting Started - LinkedIn Ads
- How to Authenticate/Re-authenticate LinkedIn Ads in Google Sheets, Google Data Studio & Microsoft Excel
- LinkedIn Ad Account/LinkedIn Company Page is missing from the list
- Expired Token and Authentication Errors for LinkedIn Ads/Pages
- LinkedIn Ads failure "Member does not have author access to view UserGeneratedContent"
LinkedIn Company Pages
MailChimp
- Getting Started - 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
Microsoft Advertising
- Getting Started - Microsoft Advertising
- How to Authenticate/Re-authenticate Microsoft Advertising in Google Sheets, Google Data Studio & Microsoft Excel
- Labels Are Missing or Outdated
- How to Query for Specific Conversions in Microsoft Advertising
- Known Issues with Top Impression Fields in Microsoft Advertising
Moz
Netvisor
Outbrain Amplify
Optimizely
PayPal
Pinterest Ads
Pinterest Organic
Pinterest Public Data
Quora Ads
Reddit Public Data
Salesforce
Searchmetrics
SEMrush Analytics
SEMrush Projects
Snapchat Marketing
Snowflake
Shopify
- Getting Started - Shopify
- How to Authenticate/Re-authenticate Shopify in Google Sheets, Google Data Studio & Microsoft Excel
- How to login to a Shopify Store as a Partner?
- I’m getting 403 Forbidden -error when authenticating to a Shopify Store
- I'm getting Authentication failed-error after re-authenticating Shopify
StackAdapt
Stripe
Taboola
Tumblr Public Data
Twitter Ads
- Getting Started - Twitter Ads
- How to Authenticate/Re-authenticate Twitter Ads in Google Sheets, Google Data Studio & Microsoft Excel
- Twitter Audience Network 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 Premium
Twitter Public Data
- Getting Started - Twitter Public Data Connector
- How to Authenticate/Re-authenticate Twitter Public Data in Google Sheets, Google Data Studio & Microsoft Excel
- Twitter Public Data Limitation for Country
- Discrepancies with Fetching User Tweets (Twitter Public Data)
- Twitter Public Data Error - "Profile(s) not found"
Verizon Media DSP
Verizon Media Native Ads
Vimeo Public Data
Yandex Direct
Yandex Metrica
YouTube
Data Source Update Logs
Adform
- Adform Updates June 2020
- Adform Updates Aug. 2019
- Adform Updates April 2019
- Adform Updates Jan. 2019
- Adform Updates Dec. 2018
Adobe Analytics v1
Adobe Analytics 2.0
AdRoll
Ad Data + Google Analytics (DS ONLY)
Criteo
Facebook Ads
- Facebook Ads Updates Sept. 2020
- Facebook Ads Updates July 2020
- Facebook Ads Updates May 2020
- Facebook Ads Updates April 2020
- Facebook Ads Updates March 2020
Facebook Insights
- Facebook Insights Updates Oct. 2020
- Facebook Insights Updates June 2020
- Facebook Insights Updates Feb. 2020
- Facebook Insights Updates Jan. 2020
- Facebook Insights Updates July 2019
Facebook Public Data
Google Ads
- Google Ads Updates Oct. 2020
- Google Ads Updates June 2020
- Google Ads Updates April 2020
- Google Ads Updates March 2020
- Google Ads Updates Feb. 2020
Google AdSense
Google Ad Manager
- Google Ad Manager Updates Oct. 2020
- Google Ad Manager Updates July 2020
- Google Ad Manager Updates June 2020
- Google Ad Manager Updates April 2020
- Google Ad Manager Updates March 2020
Google Analytics
- Google Analytics Updates Sept. 2020
- Google Analytics Updates April 2020
- Google Analytics Updates Aug. 2019
- Google Analytics Updates June 2019
- Google Analytics Updates May 2019
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 Aug 2020
- Google Display & Video 360 Updates May 2020
- Google Display & Video 360 Updates Dec. 2019
- Google Display & Video 360 Updates Nov. 2019
- Google Display & Video 360 Updates July 2019
Google My Business
Google Search Ads 360
Google Search Console
HubSpot
- Hubspot Updates July 2020
- HubSpot Updates June 2020
- HubSpot Updates May 2020
- HubSpot Updates April 2020
- HubSpot Updates Feb. 2020
Instagram Insights
LinkedIn Ads
- LinkedIn Ads Updates Nov. 2020
- LinkedIn Ads Updates Oct. 2020
- LinkedIn Ads Updates Jan. 2020
- LinkedIn Ads Updates Dec. 2019
- LinkedIn Ads Updates Nov. 2019
LinkedIn Pages
- LinkedIn Pages Updates Oct. 2020
- LinkedIn Pages Updates Feb. 2020
- LinkedIn Pages Updates Jan. 2020
- LinkedIn Pages Updates Nov. 2019
- LinkedIn Pages Updates Feb. 2019
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
Outbrain Amplify
Pinterest Ads
Public Data / Simple Connectors
Quora Ads
Salesforce
Seachmetrics
SEMrush Analytics
Shopify
Snapchat Marketing
Taboola
Twitter Ads
- Twitter Ads Updates Oct. 2020
- Twitter Ads Updates Sept. 2020
- Twitter Ads Updates May 2020
- Twitter Ads Updates March 2020
- Twitter Ads Updates Feb. 2020