Tracking

Tracking & Analyzing: Interactive

E-Mail

1. Create creatives
2. Create URL with Google Campaign URL Builder
3. Create mail
4. Send our mail
5. Put the data into the Google Spreadsheet

When we send out e-mails, like every other channel, we want to track the performance of that e-mail:

• How many recipients were there?
• How many did received the e-mail?
• How many did open the e-mail?
• How many hard bounces did we have?
• How many soft bounces did we have?

This results in a Table with following attributes:

• Date
• Year
• HOTY
• Month
• Day
• Content Group
• Content Source
• Campaign Medium
• Campaign Name
• Campaign Content
• Subject
• Sent
• Delivered
• Delivered Rate (calc)
• Failure Rate (calc)
• Bounce (Hard)
• Blocked Rate
• Bounce (Soft)
• Bounced Rate
• Openers (Total)
• Total Open Rate (calc)
• Openers (Unique)
• * Clicked
• Click Rate (calc)
• Unique Clicked
• Unique Click Rate (calc)
• Click-to-Open-Rate (calc)
• Unsubscribed
• Unsubscribed Rate (calc)
• Spam (Beschwerden)
• Spam Rate

There is a Google Sheet Template to use to report:

1. Go to https://drive.google.com/
2. Click on the [List-Item] "Shared drives"
3. Click on the [Folder] "/-Shared {Client-name}" of the relevant client
4. Click on the [Folder] "_DataReports"
5. Click on the [CTA] "New"
6. Hoover over the [Icon] "Arrow_right" on the [List-Item] "Google Sheets"
7. Click on the [List-Item] "From a template"
8. Scroll down until the [Anchor-Point] "Interactive"
9. Click on the [Template] "PSL_Data_Mailings"
10. Rename the template from "PSL_Data_Mailings" to "{Client-name}_Data_Mailings"

Every URL inserted into an e-mail needs to be build with the https://ga-dev-tools.appspot.com/campaign-url-builder/

How is responsible for what?

Task	Role
URL-Builder	PM
Data maintenance	PM

What mailing tools are we using?

Name	Link
sendinblue	https://app.sendinblue.com/account/login
Mailjet	https://app.mailjet.com/
Hybris	Depends on client