2016 Facebook Advertising Dashboard Template

1. Social + Search Advertising Dashboard Template - Facebook 2016 Paid Media ROI Dashboard All data below is example data only! Month January Days in Month 31 Edit These Columns Only Yesterday 9 DO NOT EDIT THESE COLUMNS % of Month 29% Ad Spend Revenue Leading Indicators & Metrics 2015 Actual 3,500 3,500 1,000 Goal % of Goal 100% 67% Actual 2,900 4,000 900 Goal % of Goal 73% 60% Imp 105,000 3,000 40,000 1,000 Clicks Leads Sales CPC 500 200 CPM 33.33 25.00 CPL 7.00 140.0 5.00 100.0 CPA Click to Lead Click to Cust RPL 5.80 116.0 4.50 90.00 AOV IROAS Totals September 25 10 1.17 1.00 16.7% 20.0% 0.8% 1.0% 0.83 0.90 1,500 1,500 October 2,500 2,000 125% 2,000 2,500 80% 65,000 2,000 300 15 1.25 38.46 8.33 166.6 15.0% 0.8% 6.67 133.33 0.80 November 3,500 3,000 117% 3,700 3,500 106% 75,000 3,000 400 20 1.17 46.67 8.75 175.0 13.3% 0.7% 9.25 185.0 1.06 December 2016 4,500 5,000 90% 9,000 7,000 129% 100,000 4,000 600 30 1.13 45.00 7.50 150.0 15.0% 0.8% 15.00 300.0 2.00 Ad Spend Revenue Leading Indicators & Metrics Actual 142,300 138,00 2,000 6,000 4,000 7,000 8,300 8,000 9,500 9,000 11,000 10,000 12,000 11,000 12,500 12,000 14,000 13,000 15,000 14,000 17,000 15,000 18,000 16,000 19,000 17,000 Goal % of Goal 103% 33% 57% 104% 106% 110% 109% 104% 108% 107% 113% 113% 112% Actual 293,00 228,0 3,000 8,000 5,000 10,000 14,000 12,000 18,000 14,000 20,000 16,000 24,000 18,000 22,000 20,00 30,000 22,000 32,000 24,00 35,000 26,00 40,000 28,00 50,000 30,00 Goal % of Goal 129% 38% 50% 117% 129% 125% 133% 110% 136% 133% 135% 143% 167% Clicks Leads Sales CPC 1,750,88 79,58 11,142 110,000 5,000 115,500 5,250 121,275 5,513 127,339 5,788 133,706 6,078 140,391 6,381 147,411 6,700 154,781 7,036 162,520 7,387 1,034 170,646 7,757 1,086 179,178 8,144 1,140 188,137 8,552 1,197 Imp CPM 81.27 12.77 223.5 18.18 2.86 50.00 34.63 5.44 95.24 68.44 10.75 188.21 74.60 11.72 205.1 82.27 12.93 226.2 85.48 13.43 235.0 84.80 13.33 233.19 90.45 14.21 248.7 92.30 14.50 253.81 99.62 15.65 273.9 100.46 15.79 276.2 100.99 15.87 277.72 CPL CPA Click to Lead Click to Cust RPL AOV IROAS Totals January February March April May June July August September October November December 637 40 42 44 46 49 51 54 56 59 62 65 68 1.79 0.40 0.76 1.51 1.64 1.81 1.88 1.87 1.99 2.03 2.19 2.21 2.22 14.0% 14.0% 14.0% 14.0% 14.0% 14.0% 14.0% 14.0% 14.0% 14.0% 14.0% 14.0% 14.0% 0.8% 26.30 460.2 0.8% 4.29 75.00 0.8% 6.80 119.05 0.8% 18.14 317.46 0.8% 22.21 388.7 0.8% 23.51 411.35 0.8% 26.86 470.12 0.8% 23.45 410.42 0.8% 30.46 533.01 0.8% 30.94 541.47 0.8% 32.23 564.0 0.8% 35.08 613.91 0.8% 41.76 730.8 2.06 1.50 1.25 1.69 1.89 1.82 2.00 1.76 2.14 2.13 2.06 2.22 2.63 700 735 772 810 851 893 938 985 1

2. Social + Search Advertising Dashboard Template - Definitions Definitions CPC Cost per click CPM Cost per 1000 impressions CPL Cost per lead CPA Cost per acquisition/sale Click to Lead Opt-in conversion Click to Customer Purchase conversion RPL Revenue per Lead AOV Average Order Value IROAS Initial Return on Ad Spend 2