Supermetrics is a 3rd party app that picks up all the marketing data you need and brings it to your go-to reporting, analytics, or storage platform — whether that’s a BI tool, a spreadsheet, a data visualization tool, a data lake, or a data warehouse.
Integrate Supermetrics with Omnisend and build custom reports based on your Omnisend email campaigns data in any data tool from the Supermetrics directory.
Firstly, create an API key. To do this click on your brand name in the top right corner -> Store settings:
Click on the 'API keys' section:
Then click the 'Create API Key' button:
Enter the name of your API key, keep default settings and click 'Save':
Copy the API key that you've just created. Go to your Supermetrics account and open the 'Query manager (API)' tab. Then search for Omnisend integration:
Then paste the API key and enter your Store name:
That's it! Campaign data will be synced from Omnisend and you can proceed with creating your own custom reports.
What data is synced
Supermetrics app syncs any Omnisend Campaign data that you'll set up to be synced in the Query settings:
All the available data points are listed here: Integration Omnisend Fields.
There is a lot of data tools you can use to work with the data synced from Omnisend. Google Sheets is one of them. We'll explain below how to sync data from Omnisend to Google Sheets using Supermetrics.
Firstly, install Supermetrics extension in the Google Workspace Marketplace. Click 'Install' and give all the necessary permissions:
Then create a new Google Sheet file that you'll be using to display the Omnisend data. Once created, navigate to Extensions -> Add-on -> Manage add-ons:
Then click on the 3 vertical dots button in the top right corner of the Supermetrics widget and enable 'Use in this document':
Supermetrics will appear as an option under the Extensions tab. Select it and click 'Launch':
The Supermetrics menu will be launched on the right side of the screen -> click 'Create new query':
Search for Omnisend among other data sources:
Proceed with connecting Omnisend to Supermetrics as described in the Setup Process. Once it's done, you'll be allowed to pick what data you want to import into your Google Sheet file and how you want it to be organized: