How do I set up Supermetrics in Google Sheets?
Table of Contents
How do I set up Supermetrics in Google Sheets?
How to Access the SuperMetrics Add-on
- Open a spreadsheet.
- Click the add-ons button in the navigation menu.
- Click the Get add-ons button.
- A window will pop up for you to browse.
- Type “Supermetrics” in the search box.
- Click the Free button to get the add-on.
Is Supermetrics for Google sheets free?
Try Supermetrics for free Get full access to Supermetrics for Google Sheets with a 14-day free trial. No credit card required.
Is Supermetrics an ETL?
Supermetrics is an ETL (Extract-Transform-Load) tool that pulls data from your marketing sources into one of the destinations like Google Data Studio. They don’t offer many data source integrations but do have a stack of the most popular marketing tools.
What is Supermetrics for Google Data Studio?
And Supermetrics for Data Studio is a data pipeline that allows you to bring both Google (think Google Analytics, Google Search Console, Google Ads etc.) and non-Google data (think Facebook, HubSpot, Salesforce etc.) directly into your Data Studio dashboard.
What is Supermetrics for Google Sheets?
With Supermetrics, you can automatically pull and blend data from 90+ different marketing and sales tools directly in Google Sheets. So you can make smarter business decisions, faster.
How do you add a Supermetrics query?
Open a Google Sheets file. Navigate to Extensions → Supermetrics → Launch to open the Supermetrics sidebar. Click Create new query. Under Data source, choose which data source your query should pull data from.
What Supermetrics queries?
Every time you pull data from a data source (like Google Search Console), the Supermetrics Google Sheets Add-on creates and runs a query in the background. Supermetrics run queries at a specific location in Google Sheets. This location is specified by you when you click on a particular cell.
Is there a free version of Supermetrics?
Unfortunately, a completely free add-on that works like Supermetrics — doesn’t exist yet. If you want one that’s free, you’ll have to DIY it via Google Apps Script.
How much does Supermetrics API cost?
Supermetrics Functions : Starting at $29.99 per Month Disclaimer: The pricing details were last updated on 23/01/2019 from the vendor website and may be different from actual. Please confirm with the vendor website before purchasing. Learn more about Supermetrics pricing.
How do I connect my Supermetrics to Facebook ads?
After you’ve opened a new document in Data Studio, head over to the bottom right corner and click “Create new data source” to feed your Facebook Ads data into the report. From the connector gallery, select “Facebook Ads by Supermetrics”. Next, authorize the connector by clicking the “Authorize” button.
How do I link data studios to Supermetrics?
Instructions
- Open the Supermetrics data source gallery.
- Navigate to Facebook Ads and click Try.
- If you’re authenticating the data source for the first time, log in with the Google Account you use with Supermetrics. Click Allow.
How do I edit a Supermetrics query?
Modify a query
- Click any cell in your Sheet. (When your query’s ready, your data will populate starting in this cell.)
- In the Supermetrics sidebar, click Modify.
- Make any changes you want to the query setup, and click Apply changes.
- The query will be run again with the new setup.
Can you connect Facebook Ads to Google Data Studio?
With the Facebook Ads connector for Google Data Studio you can track: standard events, performance Metrics, engagement Metrics, page Post Metrics, messaging metrics, media Metrics, click Metrics, and awareness metrics.
How do I link Google data studio to Facebook?
Connecting your Facebook Ads account to Google Data Studio. Go to the Google Data Studio connectors library and search for Facebook Ads and choose the Facebook Ads connector for Google Data Studio from Porter Metrics. You may find that other connectors have Instagram Ads and Facebook Ads separately.
How do I create a new data source in Supermetrics?
Instructions
- Open the Supermetrics data source gallery.
- Navigate to Facebook Ads and click Try.
- If you’re authenticating the data source for the first time, log in with the Google Account you use with Supermetrics.
- Under Select accounts, select at least one account.
- Scroll to the bottom of the page.
- Click Connect.
How do I connect my Facebook to Supermetrics?
From the connector gallery, select “Facebook Ads by Supermetrics”. Next, authorize the connector by clicking the “Authorize” button. After you have connected your Facebook accounts, select the ones you want to pull data from.
How do I use Supermetrics in Facebook Ads?
How do I turn my Facebook data into a Data Studio?
Go to the right-hand column and select your Facebook Ads data source. You’ll add the Google Analytics data source later. To create a chart, click Add a Chart in the navigation bar. Data Studio will provide the options for the type of chart to add to your report.