| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||
2 | Week Ending (Sun - Sat) | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 |
3 | Total Weekly Spend ($) | £5,000.00 | £6,000.00 | £7,000.00 | £6,000.00 | £5,000.00 | £8,000.00 | £6,000.00 | £5,000.00 | £7,000.00 |
4 | Total # of Inbound Leads | 80 | 90 | 95 | 85 | 75 | 80 | 85 | 90 | 95 |
5 | Blended Cost Per Lead ($) | £62.50 | £66.67 | £73.68 | £70.59 | £66.67 | £100.00 | £70.59 | £55.56 | £73.68 |
6 | MQLs | 44 | 36 | 40 | 38 | 41 | 34 | 44 | 50 | 40 |
7 | Lead to MQL Conversion % | 55.00% | 40.00% | 42.11% | 44.71% | 54.67% | 42.50% | 51.76% | 55.56% | 42.11% |
8 | Blended Cost Per MQL ($) | £113.64 | £166.67 | £175.00 | £157.89 | £121.95 | £235.29 | £136.36 | £100.00 | £175.00 |
9 | Demo Requests Total | 24 | 18 | 20 | 22 | 21 | 26 | 22 | 21 | 18 |
10 | % of Leads that are Demos | 30.00% | 20.00% | 21.05% | 25.88% | 28.00% | 32.50% | 25.88% | 23.33% | 18.95% |
11 | Blended Cost Per Demo ($) | £208.33 | £333.33 | £350.00 | £272.73 | £238.10 | £307.69 | £272.73 | £238.10 | £388.89 |
12 | # of Sign-ups that are MQLs | 10 | 12 | 14 | 16 | 14 | 12 | 15 | 12 | 14 |
13 | % of Sign-ups that are MQLS | 41.67% | 66.67% | 70.00% | 72.73% | 66.67% | 46.15% | 68.18% | 57.14% | 77.78% |
14 | Cost Per MQL Demo ($) | £500.00 | £500.00 | £500.00 | £375.00 | £357.14 | £666.67 | £400.00 | £416.67 | £500.00 |
15 | Week Ending (Sun - Sat) | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 |
16 | Google Impressions | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 |
17 | Google Clicks | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 |
18 | Google CTR (%) | 1.00% | 1.00% | 1.00% | 1.00% | 1.00% | 1.00% | 1.00% | 1.00% | 1.00% |
19 | Website Sessions | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 |
20 | Paid Channels | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 |
21 | Google Ads Spend ($) | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 |
22 | Impressions | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 |
23 | Clicks | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 |
24 | CTR (%) | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% |
25 | Ave CPC (£) | £29 | £29 | £29 | £29 | £29 | £29 | £29 | £29 | £29 |
26 | # of Conversions | 2 | 3 | 2 | 1 | 2 | 1 | 3 | 2 | 2 |
27 | Cost per Conversion | £1,000 | £667 | £1,000 | £2,000 | £1,000 | £2,000 | £667 | £1,000 | £1,000 |
28 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
29 | Impressions | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 |
30 | Clicks | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 |
31 | Ave CPC | £20 | £20 | £20 | £20 | £20 | £20 | £20 | £20 | £20 |
32 | CTR (%) | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% |
33 | Conversions | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
34 | Cost Per Conversion | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 |
35 | Facebook (Meta) | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
36 | Impressions | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 |
37 | Clicks | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 |
38 | Ave CPC | £20 | £20 | £20 | £20 | £20 | £20 | £20 | £20 | £20 |
39 | CTR (%) | 2.33% | 2.33% | 2.33% | 2.33% | 2.33% | 2.33% | 2.33% | 2.33% | 2.33% |
40 | Conversions | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
41 | Cost Per Conversion | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 |