## Warning: package 'dplyr' was built under R version 3.4.2
## Warning: package 'tidyr' was built under R version 3.4.2
## Warning: package 'kableExtra' was built under R version 3.4.4

Note: This shows the 14,825 people that “clicked” or engaged with our newsletters across the 8 newsletters. I took the email list from each newsletter, cleaned each one for uniqueness in email ID (because for some reason when I downloaded the data as a CSV, duplicates appeared), and then combiled a large list of all eight of these cleaned lists. I then calculated how many times an email showed up within this large list (14,825) and this is what is represented in this graph. What these results suggest to me is that a vast majority of our audience has only clicked through one of our newsletters. In regards to segmentation, look at the following table.

Repeated n
1 9585
2 3102
3 1228
4 524
5 223
6 126
7 29
8 8

Note: Those that have opened more than one newsletter total at 5,240. This means that just barely over 1/3 of our audience would be target of our segmentation. Only 8 of peopleo clicked through every single newsletter. Most people only opened 2 and then 2,000 less people opened 3. For each number, there is a decrease of about 3 fold.

March 2018

## # A tibble: 8 x 2
## # Groups:   Repeated, Email.Address [8]
##                  Email.Address Repeated
##                          <chr>    <int>
## 1        acortes56@hotmail.com        8
## 2             asun57@gmail.com        8
## 3  buffalotrading1@hotmail.com        8
## 4       daniel023821@gmail.com        8
## 5         greyman.fb@gmail.com        8
## 6            hyattnk@gmail.com        8
## 7            JirkaK4@gmail.com        8
## 8 racheltdelatorre@hotmail.com        8
##           Email.Address
## 1 acortes56@hotmail.com
##      Email.Address
## 1 asun57@gmail.com
##                 Email.Address
## 1 buffalotrading1@hotmail.com
##            Email.Address
## 1 daniel023821@gmail.com
##          Email.Address
## 1 greyman.fb@gmail.com
##       Email.Address
## 1 hyattnk@gmail.com
##       Email.Address
## 1 JirkaK4@gmail.com
##                  Email.Address
## 1 racheltdelatorre@hotmail.com
## [1] "The above emails clicked on the link to open the blog."
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] "None of the eight emails clicked on the link to open the coupon."

February 2018

##           Email.Address
## 1 acortes56@hotmail.com
##      Email.Address
## 1 asun57@gmail.com
##                 Email.Address
## 1 buffalotrading1@hotmail.com
##            Email.Address
## 1 daniel023821@gmail.com
##          Email.Address
## 1 greyman.fb@gmail.com
##       Email.Address
## 1 hyattnk@gmail.com
##       Email.Address
## 1 JirkaK4@gmail.com
##                  Email.Address
## 1 racheltdelatorre@hotmail.com
## [1] "The above emails clicked on the link to open the blog."
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] "None of the eight emails clicked on the link to open the coupon."

January 2018

##           Email.Address
## 1 acortes56@hotmail.com
##      Email.Address
## 1 asun57@gmail.com
##                 Email.Address
## 1 buffalotrading1@hotmail.com
##            Email.Address
## 1 daniel023821@gmail.com
##          Email.Address
## 1 greyman.fb@gmail.com
## [1] Email.Address
## <0 rows> (or 0-length row.names)
##       Email.Address
## 1 JirkaK4@gmail.com
##                  Email.Address
## 1 racheltdelatorre@hotmail.com
## [1] "The above emails clicked on the link to open the blog."
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] "None of the eight emails clicked on the link to open the coupon."

Note: One of the emails (hyattnk@gmail.com) did not click on the blog piece and they did not click on the coupon either which means that their engagement click was somewhere else in the newsletter.

December 2017

##           Email.Address
## 1 acortes56@hotmail.com
##      Email.Address
## 1 asun57@gmail.com
##                 Email.Address
## 1 buffalotrading1@hotmail.com
##            Email.Address
## 1 daniel023821@gmail.com
##          Email.Address
## 1 greyman.fb@gmail.com
##       Email.Address
## 1 hyattnk@gmail.com
##       Email.Address
## 1 JirkaK4@gmail.com
##                  Email.Address
## 1 racheltdelatorre@hotmail.com
## [1] "The above emails clicked on the link to open the blog."
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] "None of the eight emails clicked on the link to open the coupon."

November 2017

## [1] Email.Address
## <0 rows> (or 0-length row.names)
##      Email.Address
## 1 asun57@gmail.com
##                 Email.Address
## 1 buffalotrading1@hotmail.com
##            Email.Address
## 1 daniel023821@gmail.com
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
##                  Email.Address
## 1 racheltdelatorre@hotmail.com
## [1] "The above emails clicked on the link to open the blog."
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] Email.Address
## <0 rows> (or 0-length row.names)
## [1] "None of the eight emails clicked on the link to open the coupon."

Note: 4 of the 8 emails did not click on the blog piece or the coupon of this month’s newsletter. This means that their engagement click was somewhere else in the newsletter.

Note: I performed the same series of actions for this graph as I did for the one looking at “click” data. Here you can see that the difference in engagement is much different. The total number of people that opened more than one newsletter is 30,521. With the total number of people opening a newsletter from the last eight being 45,902, a majority of people would be target of segmentation if the metric is opening a newsletter.

Repeated n
1 15381
2 8883
3 5791
4 4248
5 3262
6 2746
7 2730
8 2861

Note: It is important to note that the total number of people who clicked through a newsletter is 14,825 while the total number who opened a newsletter is 45,902. Therefore, I calculated percentages. In terms of clicks, here are the percentages from 1 newsletter to all 8: 64.7%, 20.9%, 8.3%, 3.5%, 1.5%, 0.9%, statistically irrelevant, statistically irrelevant. In terms of clicks, here are the percentages from 1 newsletter to all 8: 33.5%, 19.4%, 12.6%, 9.3%, 7.1%, 5.9%, 6.0%, 6.2%. As you can see, engagement based on the metric of newsletters opened, the trends are very different from those based on clicks. Opening 6-8 newsletters are all at about the same rate. Opening 5 newsletters isn’t that far off in percentage either. The main difference lies between 1, 2, and 3 newsletters opened. Also, the difference between 1 and 2 newsletters is far less than that seen for clicks.

## Warning in merge.data.frame(All_Reports2,
## For_Comb_Dec2017_Privacy_Invaded, : column names 'row.names.x',
## 'row.names.y' are duplicated in the result
## Warning in merge.data.frame(All_Reports3,
## For_Comb_Nov2017_Spanish_METT_Announcement, : column names 'row.names.x',
## 'row.names.y' are duplicated in the result
## Warning in merge.data.frame(All_Reports4, For_Comb_Oct2017_LV_Shooting, :
## column names 'row.names.x', 'row.names.y', 'row.names.x', 'row.names.y' are
## duplicated in the result
## Warning in merge.data.frame(All_Reports5, For_Comb_Oct2017_CEBTT, by
## = "ID"): column names 'row.names.x', 'row.names.y', 'row.names.x',
## 'row.names.y' are duplicated in the result
## Warning in merge.data.frame(All_Reports6,
## For_Comb_Sep2017_911_Special_Newsletter, : column names 'row.names.x',
## 'row.names.y', 'row.names.x', 'row.names.y', 'row.names.x', 'row.names.y'
## are duplicated in the result