Omnisend Data Connector User Guide

Omnisend Data Connector User Guide

Info
Get valuable insights into your e-commerce and marketing automation performance by connecting your Omnisend account to Power My Analytics. This guide will walk you through setup, reporting capabilities, and important considerations.

Prerequisites

Before connecting Omnisend to Power My Analytics, ensure you have:

  • An Omnisend account with a connected website or store
  • Your Omnisend API key

Creating an API Key in Omnisend

  1. Log in to your Omnisend account.
  2. Click on Store Settings in the left menu, then select the API keys tab.
  3. Click the Create API key button in the upper right corner.
  4. Enter a name for this API key, such as “Power My Analytics”.
  5. Enable the following API key permissions under Select API key permissions:
    • Campaigns
    • Contacts
    • Orders
    • Products
    • Carts
    • Events
    • Brands
  6. Click the Create API key button, then copy your API key.

For help with creating a API key, please see Omnisend’s documentation on how to Generate an API key in Omnisend.

Adding Omnisend as a Data Source

  1. In the Power My Analytics hub, navigate to Sources.
  2. Click + Add new source and select Omnisend.
  3. Enter your Omnisend API key.
  4. Click Connect to authenticate.

Creating a Looker Studio Report

Follow these steps to create a Looker Studio report using your Omnisend data:

  1. In the PMA hub, navigate to Reports > Looker Studio
  2. Select Omnisend under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
    • Step 1:
      • Name your data source (e.g., rename “Untitled Data Source” to "Omnisend - Organization Name")
      • Power My Analytics Hub: Choose your PMA hub from the dropdown
      • Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      • Click Next
    • Step 2:
      • User Account: Select your Omnisend account (for real data) or "Sample Account" (for sample data)
      • Click Next
    • Step 3:
      • Select a Currency for use in reporting
      • Click Connect (top right) to complete the data source configuration
    • Step 4:
      • Click Create Report (top right)

For a quick start, use our pre-built Omnisend demo template.

Key Reports and Fields

The Omnisend connector provides access to a variety of data, including:

  • Campaign Metrics: All Devices Clicked By, All Devices Opened By, By Devices Clicked Desktop, By Devices Opened Mobile, By Devices Opened Tablet, Opened by Desktop, Opened by Mobile, Opened by Tablet, Sent, Opened, Clicked

For a full list of available Omnisend fields in Power My Analytics, visit the Schema Explorer.

Limitations and Important Considerations

  • Backfilling: Up to 2 years of historical data is available through the Omnisend connector.
    • Initial backfill: 13 months of historical data will be backfilled when you first connect your Omnisend account as a data source.

Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the Omnisend connector.

If you need further assistance, please submit a ticket.


    • Related Articles

    • AdRoll Data Connector User Guide

      This guide provides comprehensive instructions for setting up and utilizing the AdRoll data source in Power My Analytics. AdRoll is a powerful advertising platform specializing in retargeting, cross-channel advertising, dynamic ads, email marketing, ...
    • Amazon Ads Data Connector User Guide

      Amazon Ads is a powerful advertising platform that allows sellers and brands to promote their products on Amazon. This guide will walk you through how to connect Amazon Ads to Power My Analytics, create reports in Looker Studio, and understand key ...
    • eBay Seller Center Data Connector User Guide

      As an eBay seller, you need quick access to your sales data and performance metrics to make informed decisions. This guide will walk you through connecting your eBay Seller Center account to Power My Analytics, enabling you to automate data ...
    • Mailchimp Data Connector User Guide

      Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...
    • Power My Analytics Data Connector User Guide

      The Power My Analytics (PMA) Data Connector is your gateway from Data Builder datasets to your reporting destinations. Design your datasets in Data Builder, then report your data in Looker Studio or Sheets or export to destinations like BigQuery and ...