Jump to content

Tracking: Difference between revisions

From Parasol
No edit summary
Tag: visualeditor
No edit summary
Line 2: Line 2:


==E-Mail==
==E-Mail==
When we send out e-mails, like every other channel, we want to track the performance of that 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 recipients were there?
Line 10: Line 10:
*How many soft bounces did we have?
*How many soft bounces did we have?


This results in a Table with following attributes:
====This results in a Table with following attributes:====


*Date
*Date
Line 44: Line 44:
*Spam Rate
*Spam Rate


====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"
# 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 [http://Google%20Campaign%20URL%20Builder https://ga-dev-tools.appspot.com/campaign-url-builder/]
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/]


==How is responsible for what?==
===How is responsible for what?===
{| class="wikitable"
{| class="wikitable"
!Task
!Task
Line 64: Line 76:
|}
|}


==What mailing tools are we using?==
===What mailing tools are we using?===


{| class="wikitable"
{| class="wikitable"

Revision as of 17:33, 27 February 2020

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