Follow these steps to connect your Celtra data to Supermetrics.
If you need to connect this data source to one of our data warehouse or cloud storage destinations, explore our data warehouse and cloud storage setup guides.
Before you begin
To connect Supermetrics to your Celtra account, you need to get your Celtra Account ID and to create an API application inside Celtra.
- Log in to Celtra, and open your dashboard.
- Go to the Reporting Center.
- Click the green + button on the right to open the report builder.
- In “Search dimensions”, enter “Account ID”.
- In “Search metrics”, select any metric from the list.
- Click Generate report.
- Copy your Account ID from the report to use later.
- Log in to Celtra, and open your dashboard.
- Click your name in the top right of the navigation bar and select Settings.
- Select the API Apps tab.
- Click Add API App.
- Enter a name for the app, for example, “Supermetrics”.
- Click Save to create the API app.
- Copy the App ID from the list and copy it for later.
- Under Secret Key, click Show Key.
- Copy this key and store it in a secure place for later.
Query type
- Campaign performance: Measure the performance of your creatives on different platforms.
Instructions
Make sure you've installed the Supermetrics add-on before you connect.
- Open a new Google Sheets file.
- Navigate to Extensions → Supermetrics → Launch sidebar to open Supermetrics.
- Click Create new query.
- Under Data source, select Celtra.
- Enter your Account ID, App ID, and Secret Key.
- Enter a name for your account for you to identify it later.
- Click Start.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.
Make sure you've connected Supermetrics to Looker Studio before following the steps below.
- Open the Supermetrics Looker Studio data source gallery.
- Navigate to Celtra and click Start free trial.
- You'll see two buttons that read Authorize. If you're using Supermetrics for the first time, click the left-hand one and log in with the Google Account you use with Supermetrics.
- Once that's done, or if you've done it before, click the right-hand Authorize button (under "Celtra requires authorization to connect to data").
- Select a team that has access to the account you want to connect.
- Choose to make this connection shared or private.
- Enter your Account ID, App ID, and Secret Key.
- Enter a name for the account for you to identify it later.
- Click Start.
- Select the type of query you would like to fetch data for.
- In the pane's top right, click Connect.
- Click Create report.
- Click Add to report.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Looker Studio.
Make sure you've installed the Supermetrics add-on before you connect.
- Open an Excel file.
- Click Data → Show Supermetrics.
- Under Data source, select Celtra.
- Choose to make this connection shared or private.
- Enter your Account ID, App ID, and Secret Key.
- Enter a name for the account for you to identify it later.
- Click Start.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Excel.