Supermetrics Support Forum
System Status Updates
Supermetrics
Data Sources
- Adobe Analytics Authentication Updates - March 3rd, 2021
- Changing the type of six HubSpot fields on the 10th of March, 2021
- Issue with Facebook Ads queries - December, 22nd 2020
- Issue with Facebook Insights - "FB post fetching error: An unknown error has occurred." - 29/01/2021
- What You Need to Know for the Facebook Ads iOS 14 Changes
Impactful Data Source API Changes
Authentication Guides
Getting started
- List of authentication guides per data source
- How to re-authenticate an Excel connector
- How to re-authenticate a Data Studio connector
- How to re-authenticate a Google Sheets connector
- How to re-authenticate a Supermetrics API connector
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
- Forcing a Refresh for Account Data
- How Can I Remove My Account From the Data Studio Connectors?
- How to Renew Tokens - Login Management in Team Site
- How to Completely Remove a Data Source from Microsoft Excel
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
- List of getting started guides per data source
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 Sheets with one Google Account, but for Supermetrics, I want to log in to a Data Source 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?
- Query failed: ScriptError. Try using Google Sheets logged in with just one Google account.
- Queries are Returning Dates With Apostrophe Characters (')
- Unaligned Data, Unexpected Values, Changes Not Showing, and Other Issues Due to Duplicate Queries
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 reports to be refreshed or emailed automatically?
- The triggers I added don't work.
- Get a notification if triggered queries fail during refresh
- Managing triggers for Google Sheets
- Transferring triggers from one user to another
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 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?
- Understanding Permissions for Data Studio Reporting
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
Getting Started
- First Steps: Getting Supermetrics into your BigQuery project
- How to configure a data transfer in BigQuery
- Access requirements to configure a data transfer in Big Query
- Creating a BigQuery dataset for your data transfer
- Scheduling a backfill data transfer for BigQuery
Frequently Asked Questions
Troubleshooting
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
- Changes to Supermetrics pricing on the 28th of March 2021
- 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?
Team Management Tool
- Team Management Basics
- License Management
- Viewing Your Account Usage
- Merging Teams in Team Management
- Changing User Roles in Team Management
General Issues for all Products
Instructions per Data Source
Ad Data + Google Analytics
Adform
Adobe Analytics
AdRoll
Ahrefs
Apple Search Ads
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 with Facebook Ads - Google Sheets, Google Data Studio & Microsoft Excel
- How to Authenticate/Re-authenticate Facebook Ads in Google Sheets, Google Data Studio & Microsoft Excel
- Getting Started with Facebook Ads - Data Warehouse, Cloud Storage, BigQuery & API
- Getting "null" or "No Data" With Reach and Other Unique Metrics With Filters
- Facebook Ads Adjustments to Store Traffic Ads
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 with Google Analytics - Google Sheets, Google Data Studio and Microsoft Excel
- How to Authenticate/Re-authenticate Google Analytics in Google Sheets, Google Data Studio & Excel
- Getting Started with Google Analytics - Data Warehouse, Cloud Storage, BigQuery & API
- Discrepancies in Google Analytics Results
- Does Supermetrics Support Custom Metrics/Dimensions in Google Analytics?
Google Analytics 4
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 Insights & Instagram Public Data
- Instagram Insights failure (Fetching insights caused the following error: (#10) Application does not have permission for this action)
Instagram Public Data
Klaviyo
LinkedIn Ads
- Getting Started with LinkedIn Ads - Google Sheets, Google Data Studio & Microsoft Excel
- How to Authenticate/Re-authenticate LinkedIn Ads in Google Sheets, Google Data Studio & Microsoft Excel
- Getting Started with LinkedIn Ads - Data Warehouse, Cloud Storage, BigQuery & API
- LinkedIn Ad Account/LinkedIn Company Page is missing from the list
- Expired Token and Authentication Errors for LinkedIn Ads/Pages
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
- Getting Started - Salesforce
- How to Authenticate/Re-authenticate Salesforce in Google Sheets, Google Data Studio & Microsoft Excel
- Troubleshooting Permissions Issues with Salesforce
- Salesforce Advanced Date Settings
- Salesforce: Frequently asked questions (FAQ)
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
TikTok Ads
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 Feb. 2021
- Facebook Ads Updates Jan. 2021
- Facebook Ads Updates Dec. 2020
- Facebook Ads Updates Sept. 2020
- Facebook Ads Updates July 2020
Facebook Insights
- Facebook Insights Updates Feb. 2021
- Facebook Insights Updates Jan. 2021
- Facebook Insights Updates Oct. 2020
- Facebook Insights Updates June 2020
- Facebook Insights Updates Feb. 2020
Facebook Public Data
Google Ads
- Google Ads Updates Jan. 2021
- Google Ads Updates Oct. 2020
- Google Ads Updates June 2020
- Google Ads Updates April 2020
- Google Ads Updates March 2020
Google AdSense
Google Ad Manager
- Google Ad Manager Updates Jan. 2021
- 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 Analytics
- Google Analytics Updates March 2021
- Google Analytics Updates Feb. 2021
- Google Analytics Updates Jan. 2021
- Google Analytics Updates Sept. 2020
- Google Analytics Updates April 2020
Google Analytics 4
Google Campaign Manager
- Google Campaign Manager Updates Feb. 2021
- 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 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 My Business Updates Jan. 2021
- Google My Business Updates March 2020
- Google My Business Updates Dec. 2019
- Google My Business Updates Jan. 2019
- Google My Business Updates Dec. 2018
Google Search Ads 360
Google Search Console
HubSpot
- HubSpot Updates Feb. 2021
- Hubspot Updates July 2020
- HubSpot Updates June 2020
- HubSpot Updates May 2020
- HubSpot Updates April 2020
Instagram Insights
Instagram Public Data
LinkedIn Ads
- LinkedIn Ads Updates Dec. 2020
- LinkedIn Ads Updates Nov. 2020
- LinkedIn Ads Updates Oct. 2020
- LinkedIn Ads Updates Jan. 2020
- LinkedIn Ads Updates Dec. 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 Jan. 2021
- Microsoft Advertising Updates March 2020
- Microsoft Advertising Updates June 2019
- Microsoft Advertising Updates May 2019
- Microsoft Advertising Updates Dec. 2018
Moz
Outbrain Amplify
Pinterest Ads
Pinterest Organic
Public Data / Simple Connectors
Quora Ads
Salesforce
Seachmetrics
- Searchmetrics Updates Feb. 2021
- Searchmetrics Updates Jan. 2021
- Searchmetrics Updates Dec. 2020
- Searchmetrics Updates Nov. 2019
- Searchmetrics Updates May 2019
SEMrush Analytics
Shopify
Snapchat Marketing
Stripe
Taboola
TikTok Ads
Twitter Ads
- Twitter Ads Updates Feb. 2021
- Twitter Ads Updates Jan. 2021
- Twitter Ads Updates Oct. 2020
- Twitter Ads Updates Sept. 2020
- Twitter Ads Updates May 2020
Twitter Premium
Verizon Media Native Ads
Yandex Direct
Yandex Metrica
YouTube
Legacy Products
Recent articles
- Google Analytics Updates March 2021
- How to Authenticate/Re-authenticate Shopify in Google Sheets, Google Data Studio & Microsoft Excel
- How to Authenticate/Re-authenticate Adobe Analytics & Adobe Analytics 2.0 in Google Sheets, Google Data Studio & Microsoft Excel
- Changes to Supermetrics pricing on the 28th of March 2021
- How to Connect to Adobe Analytics with Service Account
- Getting Started - SEMrush Analytics