Supermetrics Support Forum
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"