March 17, 2020 — OWOX BI Smart Data. New report data source: Email campaigns

Extend your Smart Data reports with email campaign data.

Get reports on your email campaigns solely or merge the email data with website user behavior and transaction data and learn how your email activities affected user acquisition and conversion.

New metrics and dimensions

Having your email campaign data connected, you can use these new metrics and dimensions in your report.


  • Click
  • Open
  • Unsubscribe
  • Spam complaint
  • Delivery
  • Send
  • Bounce
  • Hard bounce
  • Click-to-Open Rate
  • Open rate
  • Click-through rate
  • Unsubscribe rate
  • Spam complaint rate
  • Delivery rate
  • Bounce rate


  • Campaign name
  • Campaign id
  • Email source
  • Email medium
  • Email campaign
  • Email Ad content
  • Email keyword

How to connect email campaign data to Smart Data

To use email data to build your reports, you first need to collect this data to a Google BigQuery table and then connect to your Smart Data source set.

Read also: How to upload your data to Google BigQuery

Data table structure:

Field name Data type Description
click INTEGER Number of clicks on the email
open INTEGER Times the email was opened
unsubscribe INTEGER Times a user unsubscribed from this email
spam_complaint INTEGER Times a user made a spam complaint to this email
delivery INTEGER Times the email was delivered
send INTEGER Times the email was sent
bounce INTEGER Times a user bounced from this email
hard_bounce INTEGER Times a user had a hard bounce from this email
сampaign_name STRING Email campaign name
сampaign_id STRING Email campaign id
utm_source STRING Email source
utm_medium STRING Email medium
utm_campaign STRING Email campaign
utm_adcontent STRING Email Ad content
utm_keyword STRING Email keyword


All fields are required to be in the table you connect, but they can have empty values.

We recommend naming the table with your email service's name to distinguish it among other data sources in Smart Data more easily.

Note:In a Smart Data source set, you can unite the data from BigQuery datasets located in a single multi-regional location only (example: US).

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.