Revision as of 10:39, 11 March 2020

Tracking & Analyzing: Interactive

E-Mail

Create creatives
Create URL with Google Campaign URL Builder
Create mail
Send our mail
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:

Go to https://drive.google.com/
Click on the [List-Item] "Shared drives"
Click on the [Folder] "/-Shared {Client-name}" of the relevant client
Click on the [Folder] "_DataReports"
Click on the [CTA] "New"
Hoover over the [Icon] "Arrow_right" on the [List-Item] "Google Sheets"
Click on the [List-Item] "From a template"
Scroll down until the [Anchor-Point] "Interactive"
Click on the [Template] "PSL_Data_Mailings"
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

@@ Line 2: / Line 2: @@
 ==E-Mail==
+<br />
+# Create creatives
+# Create URL with Google Campaign URL Builder
+# Create mail
+# Send our mail
+# 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:===
@@ Line 45: / Line 53: @@
 ====There is a Google Sheet Template to use to report:====
-# Go to [http://Google%20Drive https://drive.google.com/]
-# Click on the [List-Item] "Shared drives"
+#Go to [http://Google%20Drive https://drive.google.com/]
-# Click on the [Folder] "/-Shared {Client-name}" of the relevant client
+#Click on the [List-Item] "Shared drives"
-# Click on the [Folder] "_DataReports"
+#Click on the [Folder] "/-Shared {Client-name}" of the relevant client
-# Click on the [CTA] "New"
+#Click on the [Folder] "_DataReports"
-# Hoover over the [Icon] "Arrow_right" on the [List-Item] "Google Sheets"
+#Click on the [CTA] "New"
-# Click on the [List-Item] "From a template"
+#Hoover over the [Icon] "Arrow_right" on the [List-Item] "Google Sheets"
-# Scroll down until the [Anchor-Point] "Interactive"
+#Click on the [List-Item] "From a template"
-# Click on the [Template] "PSL_Data_Mailings"
+#Scroll down until the [Anchor-Point] "Interactive"
-# Rename the template from "PSL_Data_Mailings" to "{Client-name}_Data_Mailings"
+#Click on the [Template] "PSL_Data_Mailings"
+#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 [http://Google%20Campaign%20URL%20Builder https://ga-dev-tools.appspot.com/campaign-url-builder/]