ABCDEFGHIJKLMNOPQRST
1
2
CURRENT CAMPAIGN YOYCAMPAIGN WEB PROMOTIONSMONTHLY BUDGET
3
YEAR ENDTotals do not include Evergreen web sourcesREVENUE# OF GIFTS
4
Homepage Hero$335,556199Monthly budget numbers and NOTE are taken from current campaign strategy
5
EMAILS DELIVEREDOPEN RATECLICK THROUGH RATERESPONSE RATELightbox$50,07934PROJECTEDACTUALLAST YEAR
6
2018 Average Emails Delivered2018 Average Open Rate2018 Average Click Through Rate2018 Average Response RateBanner$10,55120Check that formulas are connecting to the correct chart in the TABLES tabEmail $20,000$18,470$15,000
7
20,24012.54%2.52%0.06%Landing Page/Webform$64,77838Online (Web)$500,000$497,879$400,000
8
2019 Average Emails Delivered2019 Average Open Rate2019 Average Click Through Rate2019 Average Response RateSponsorship Enrollment$5,000$0$0
9
14,26911.29%1.82%0.030%CAMPAIGN SOCIAL PROMOTIONS
10
Facebook includes "organic" and promoted postsREVENUE# OF GIFTS
11
Twitter$00
12
Facebook$3,50810
13
14
CAMPAIGN AD PROMOTIONS
15
REVENUE# OF GIFTS
16
Google- SEM$10,57824
17
Google- Grant$25,91438
18
Google- Display$5,84315
19
Google- Remarketing$7703
20
Facebook- ads$00NOTE:
21
22
CAMPAIGN PROMOTIONS BY CHANNEL
23
REVENUE# OF GIFTSAVERAGE GIFT
24
EMAIL - ONE TIME GIFTSEMAIL - MONTHLY GIFTSTOTAL EMAIL AVERAGE GIFTWeb$460,964291$1,584ANNUAL BUDGET
25
2018 One time gifts2018 Monthly gifts2018 Campaign Email Average GiftSocial$3,50810$351
26
3793$432Ads$43,10580$539Projected budget numbers are taken from Annual Budget plan.
27
2019 One time gifts2019 Monthly gifts2019 Campaign Email Average GiftEmail $18,47056$330PROJECTEDACTUAL% TO BUDGET
28
560$330Email $10,000$18,470185%
29
ONE TIME GIFT REVENUEMONTHLY GIFT REVENUETOTAL EMAIL REVENUEOnline (Web)$350,000$497,879142%
30
Sponsorship Enrollment$5,480$00%
31
32
33
34
35
36
37
38
39
40
41
To change the campaign, click into the table below and under Filters > Email Campaign, select the campaign in the drop down menu to view it's metrics. To update the overall totals, add email sends to the Email Metrics tab. Use the "Paint Format" tool, to copy the formatting for new Email Efforts that are added to the table. To hide rows, select the rows you would like to hide, right click and select "Hide Rows". Columns U-Z contain the Pivot table for the open, clicks, and unsubscribes. Unhide these rows to update the pivot table for the correct campaign. For columns Q-S, drag the formula down from the cell above.
42
YearLaunch DateEmail EffortSUM of Total RevenueSUM of Total # of GiftsSUM of Revenue Per 1k RecipientsSUM of One-Time GiftsSUM of One-Time RevenueAVERAGE of One-Time Avg GiftSUM of Monthly GiftsSUM of Monthly RevenueAVERAGE of Monthly Avg GiftSUM of Sponsorship GiftsSUM of Sponsorship RevenueSUM of Emails DeliveredOpen RateClick Through RateUnsubscribe Rate
43
20181/4/2018Cultivation #2$00$00$0$00$0$00$0149,8315.07%0.89%0.10%
44
1/10/2018Campaign Thank You$00$00$0$00$0$00$0146,4274.48%0.89%0.06%
45
11/14/2018DM Integrated $6003$4133$600$1200$0$00$013,8799.21%2.09%0.04%
46
12/4/2018Appeal #1$8139$408$613$511$200$670$048,39514.30%2.40%0.25%
47
12/6/2018Appeal #2$2755$135$275$480$0$00$048,34114.84%2.26%0.19%
48
12/11/2018Appeal #2 - Resend$2,5003$1183$2,500$5830$0$00$049,26213.82%2.25%0.23%
49
12/13/2018Appeal #3$00$00$0$00$0$00$056,39715.90%3.36%0.17%
50
12/17/2018Appeal #3 - Resend$00$00$0$00$0$00$048,7828.24%2.64%0.15%
51
12/19/2018Appeal #4$3,88523$4,31421$3,845$4062$40$50$056,46818.43%2.90%0.23%
52
12/22/2018Appeal - Additional $93513$1913$935$720$0$00$049,02815.53%3.22%0.16%
53
12/24/2018
Appeal - Additional Resend
$12,15014$25014$12,150$8680$0$00$048,53314.70%2.75%0.12%
54
12/26/2018Appeal #5$10,40016$21416$10,400$6500$0$00$048,48514.53%3.06%0.25%
55
12/27/2018Appeal #5 - Resend$1,12513$2313$1,125$870$0$00$048,21615.36%3.26%0.34%
56
12/28/2018Appeal #6$20,71534$43034$20,715$6090$0$00$048,20016.01%3.18%0.27%
57
12/29/2018Appeal #7$10,28516$21416$10,285$6430$0$00$047,98215.53%3.22%0.33%
58
12/30/2018Appeal #8$6,59020$1,33020$6,590$1600$0$00$050,19514.81%3.05%0.31%
59
Appeal #8 - 11pm$58514$1214$585$420$0$00$047,34414.65%3.47%0.34%
60
Appeal #8 - Liftnote$92015$10615$920$390$0$00$050,02315.09%3.33%0.33%
61
Appeal #8 - Liftnote Resend
$76618$4318$766$190$0$00$049,75914.31%3.41%0.35%
62
Appeal #8 - Resend$20,14024$44524$20,140$2310$0$00$050,12314.43%3.37%0.32%
63
12/31/2018Appeal #9$14,04022$59322$14,040$2730$0$00$054,79914.17%2.55%0.26%
64
Appeal #9 - 11pm$90516$1616$905$570$0$00$057,73010.88%2.01%0.23%
65
Appeal #9 - Liftnote$27,45345$2,57545$27,453$5110$0$00$054,02914.09%3.00%0.25%
66
Appeal #9 - Liftnote Resend
$12,55831$2,37731$12,558$3190$0$00$053,95514.10%2.95%0.26%
67
Appeal #9 - Resend$17,30528$44828$17,305$2020$0$00$054,35914.03%2.93%0.31%
68
1/2/2019Campaign Thank You$00$00$0$00$0$00$046,95416.89%3.08%0.35%
69
201912/7/2019Cultivation #1$3685$115$368$370$0$00$037,02016.09%3.37%0.09%
70
12/9/2019Appeal #1$58511$23411$585$410$0$00$083,46612.59%1.73%0.15%
71
12/11/2019Appeal #1 Resend$1,20011$1,03711$1,200$1080$0$00$067,2125.59%1.67%0.12%
72
12/13/2019GTGB$00$00$0$00$0$00$083,20512.27%1.97%0.13%
73
12/16/2019eNews$7,27815$17415$7,278$2190$0$00$084,01212.32%1.70%0.12%
74
12/19/2019Appeal #2$9,04014$49914$9,040$2660$0$00$075,33510.71%1.47%0.15%
75
12/22/2019GTGB$00$00$0$00$0$00$083,43810.95%1.64%0.15%
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100