Free Digital Strategy Planner and ROI Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKL
1
Post Campaign Analysis - Quick Budget Planner
2
Monthly
3
SourceSpendLeadsAvg Profit Per SaleNo. of SalesOther Marketing CostsLeads to Sales %ROI from ChannelComments
4
Totals for All Traffic Sources (a.k.a., All Channels):$0.000#DIV/0!0$0.00$0.00These fields total the numbers below. It doesn't matter if you don't use all of the sources.
5
6
All Organic Sources#DIV/0!$0.00You can use the same process outlined below for paid sources to breakdown your various social media, organic, and traditional channels.
7
All Social Media Sources#DIV/0!$0.00
8
Traditional Advertising#DIV/0!$0.00
9
All Paid Sources#DIV/0!$0.00
10
11
Paid Source BreakdownSpendLeadsProfit Per SaleNo. of SalesOther Marketing CostsLeads to Sales %ROI from ChannelComments
12
Google AdWords - Search#DIV/0!$0.00Again, it doesn't matter if you don't use all of these sources. Feel free to delete unused rows from your local copy of this spreadsheet template.
13
Google AdWords - Display#DIV/0!$0.00
14
Google Product Feeds (i.e., Google Merchant Center)#DIV/0!$0.00
15
Bing Ads#DIV/0!$0.00
16
LinkedIn Ads#DIV/0!$0.00
17
LinkedIn Sponsored Stories#DIV/0!$0.00
18
Facebook Ads#DIV/0!$0.00
19
Facebook Sponsored Posts#DIV/0!$0.00
20
AdRoll Display#DIV/0!$0.00
21
Amazon Mobile Display#DIV/0!$0.00
22
Amazon Product Feeds#DIV/0!$0.00
23
Other Display Efforts#DIV/0!$0.00
24
Other Remarketing Efforts#DIV/0!$0.00
25
Other PPC#DIV/0!$0.00
26
Paid Totals (This should match the "All Paid Sources" totals above)$0.000#DIV/0!0$0.00#DIV/0!#DIV/0!
27
28
29
30
31
Pre-Campaign Analysis - Quick Budget Planner
32
Monthly
33
SourceBudgetExpected LeadsAvg Revenue Per SaleLeads to Sales %Other Marketing CostsExpected No. of SalesPredicted ROI from ChannelComments
34
Predicted Totals for All Traffic Sources (a.k.a., All Channels):$0.000#DIV/0!#DIV/0!$0.000$0.00
35
36
All Organic Sources0$0.00
37
All Social Media Sources0$0.00
38
Traditional Advertising0$0.00
39
All Paid Sources0$0.00
40
41
Paid BreakdownBudgetExpected LeadsAvg Revenue Per SaleLeads to Sales %Other Marketing CostsExpected No. of SalesPredicted ROI from ChannelComments
42
Google AdWords - Search0$0.00
43
Google AdWords - Display0$0.00
44
Google Product Feeds (i.e., Google Merchant Center)0$0.00
45
Bing Ads0$0.00
46
LinkedIn Ads0$0.00
47
LinkedIn Sponsored Stories0$0.00
48
Facebook Ads0$0.00
49
Facebook Sponsored Posts0$0.00
50
AdRoll Display0$0.00
51
Amazon Mobile Display0$0.00
52
Amazon Product Feeds0$0.00
53
Other Display Efforts0$0.00
54
Other Remarketing Efforts0$0.00
55
Other PPC0$0.00
56
Paid Totals (This should match the "All Paid Sources" totals above)$0.000#DIV/0!0#DIV/0!
57
58
Modify the Yellow FieldsDo Not Change the Calculations in Gray
59
60
61
62
63
64
65
66
67
68
69
70
71
Loading...
 
 
 
Quick Budget Planner
Advanced Budget Planner - Pulls Data from Tabs
Example of a Source
All Organic Sources
All Social Media Sources
Traditional Advertising
All Paid Sources
Google AdWords - Search
Google AdWords - Display
Google Product Feeds
Bing Ads
LinkedIn Ads
LinkedIn Sponsored Stories
Facebook Ads
Facebook Sponsored Posts
AdRoll Display
Amazon Mobile Display
Amazon Product Feeds
Other Display Networks
Other Remarketing Efforts
Other PPC