Use the Omnisend data source connector to create an overview dashboard to analyze the performance of different campaigns over time. Compare your campaign performance on monthly basis and optimize your email campaigns based on your A/B test results.
For a full list of metrics and dimensions available in our Omnisend data source connector, take a look at our Omnisend documentation.
Once you’ve connected to Omnisend, you’re ready to create your first queries!
Query types for this data source
When connecting to the Omnisend data source, you need to select a query type. The query type defines what sort of metrics and dimensions are available.
- All campaigns
- A/B test campaigns
Try these queries
See the following use cases for examples on how to use the metrics and dimensions.
See email sends and clicks
Take a look at how many times a campaign email has been sent and clicked. In this example, we take a look at the data for the last 28 days.
Use the "All campaigns" query type.
The "Sends" metric shows the number of times the campaign email has been sent.
The "Clicks" metric shows the number of times the campaign email has been clicked.
For best results in Looker Studio, use the bar or table chart type.
- Select the All campaigns query type.
- Set the date range to Last 28 days.
- Select the Sends and Clicks metrics.
See email sends, clicks, and opens per campaign
Get data on how many emails you've sent per campaign, and how many of them have been opened and clicked. In this example, we pull data from the last week.
Use the "All campaigns" query type.
The "Sends" metric shows the number of times the campaign email has been sent.
The "Clicks" metric shows the number of times the campaign email has been clicked.
The "Opens" metric shows the number of times the campaign email has been opened.
For best results in Looker Studio, use the table chart type.
- Select the All campaigns query type.
- Set the date range to Last week.
- Select the Clicks, Opens, and Sends metrics.
- Select the Campaign name and Date dimensions to split the query results by campaign name and date.
See number of unsubscribes
Take a look at how many email recipients have unsubscribed from your emails. In this example, we pull data from the last week and compare the data to the previous period.
Use the "All campaigns" query type.
The "Unsubscribes" metric shows the number of contacts who have unsubscribed from the campaign.
For best results in Looker Studio, use the scorecard chart type.
- Select the All campaigns query type.
- Set the date range to Last week.
- Select the Unsubscribes metric.
- Set the Comparison date range to Previous period.
More resources
You might also be interested in: