Tracking

Tracking & Analyzing: Interactive

E-Mail

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