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.
Metrics:
- 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
Dimensions:
- 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).
0 Comments