Supermetrics Support Forum
Welcome to Supermetrics Support!
How can we help you today?
How can we help you today?
Recent articles
System Status Updates
Supermetrics
Data Sources
Impactful Data Source API Changes
- Google AdSense API v2 upgrade breaking changes - Sept. 15th, 2021
- Google Ads migrations for certain report types - August 24th, 2021
- Twitter Ads API v9 upgrade breaking changes - August 24th, 2021
- Google Ad Manager/DFP v202011 Deprecation
- Stripe invoice status field deprecation - August 12th, 2021
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."
- Error: "No accounts found" & "No accounts found or the service is not enabled for this user."
- This Action is Not Supported When You Are Logged in to Multiple Accounts
- 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
- 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 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
- How to add all accounts to a Google Sheets 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?
- How do I Refresh Fields/Update a Connector?
- Understanding Permissions for Data Studio Reporting
- Can I Add Multiple User Accounts to the Same Data Source?
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
Tips & Tricks
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
Purchasing, Payments & Invoices
- About Supermetrics licenses
- How can I modify an existing license? (For licenses bought after March 28th/June 15th 2021)
- Can I Migrate a License from the Old Pricing Model to the New Model?
- Where Can I Find and Modify My Invoices?
- What to Do if My Credit Card Was Declined?
Account Management
- Can I Change My User ID for Supermetrics?
- How Can I Renew/Extend My License?
- How can I upgrade my license?
- About data source accounts
- List of data sources - Account definitions
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 App Store / iTunes
Apple Search Ads
Azure Synapse
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 Ad Library
Facebook Audience Network
Facebook Insights
- Getting Started with Facebook Insights - Google Sheets, Google Data Studio and Microsoft Excel
- How to Authenticate/Re-authenticate Facebook Insights in Google Sheets, Google Data Studio & Microsoft Excel
- Getting Started with Facebook Insights - Data Warehouse, Cloud Storage, BigQuery & API
- Facebook Page is Missing From List
- Discrepancies with Facebook Insights Results
Facebook Public Data
Google Ads
- Getting Started - Google Ads
- How to Authenticate/Re-authenticate Google Ads in Google Sheets, Google Data Studio & Microsoft Excel
- How to fix customer_not_active errors in Google Ads
- Google Ads Error: USER_PERMISSION_DENIED: User xxx Doesn't Have Permissions for Account
- Google Ads "Ad Type" Field Behavior Change - May 12th, 2021
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
- Getting Started with Instagram Insights - Data Warehouse, Cloud Storage, BigQuery & API
- Unable to See Instagram Account After Logging In
- How to Reset the Business Integration for Instagram Insights & Instagram Public Data
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
- 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 with Microsoft Advertising - Google Sheets, Google Data Studio and Microsoft Excel
- How to Authenticate/Re-authenticate Microsoft Advertising in Google Sheets, Google Data Studio & Microsoft Excel
- Getting Started with Microsoft Advertising - Data Warehouse, Cloud Storage, BigQuery & API
- Labels Are Missing or Outdated
- How to Query for Specific Conversions 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)
Salesforce Marketing Cloud
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
The Trade Desk
TikTok Ads
Tumblr Public Data
Twitter Ads
- Getting Started with Twitter Ads - Google Sheets, Google Data Studio and Microsoft Excel
- How to Authenticate/Re-authenticate Twitter Ads in Google Sheets, Google Data Studio & Microsoft Excel
- Getting Started with Twitter Ads - Data Warehouse, Cloud Storage, BigQuery & API
- Twitter Audience Network data discrepancy
- This User Does Not Have Permission to Read Campaign Data
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"