Email campaign data – OWOX Help Center

Build Smart Data reports using email campaign data from your mailing service collected to Google BigQuery manually.

Learn more about importing email campaign data to Google BigQuery from this article.

To add email data to your reports, you need to connect to your Smart Data source set a table with the following 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).