| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TOTAL | |||||||||||||||
2 | ||||||||||||||||
3 | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL | % of Total | ||
4 | Electronic | |||||||||||||||
5 | Group TV | $84,000.00 | $84,000.00 | $84,000.00 | $112,853.00 | $130,243.11 | $140,000.00 | $95,000.00 | $95,000.00 | $120,000.00 | $120,000.00 | $140,000.00 | $140,000.00 | $1,345,096.11 | ||
6 | Television | $30,757.00 | $30,757.00 | $37,818.00 | $37,818.00 | $48,174.00 | $48,174.00 | $30,757.00 | $30,757.00 | $37,818.00 | $37,818.00 | $37,818.00 | $48,174.00 | $456,640.00 | ||
7 | Cable | $68,943.00 | $68,943.00 | $86,268.00 | $107,418.00 | $137,776.00 | $137,776.00 | $95,543.00 | $91,410.00 | $101,463.00 | $108,963.00 | $122,929.00 | $137,776.00 | $1,265,208.00 | ||
8 | Radio | $0.00 | $0.00 | $0.00 | $0.00 | $1,000.00 | $1,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,000.00 | $1,000.00 | $4,000.00 | ||
9 | Prerolll/PVOD/ACR | $41,400.00 | $51,900.00 | $66,800.00 | $103,940.00 | $153,820.00 | $153,820.00 | $85,540.00 | $85,540.00 | $122,540.00 | $120,040.00 | $144,640.00 | $153,820.00 | $1,283,800.00 | ||
10 | Group Sponsorship | $32,225.00 | $23,613.00 | $34,176.00 | $30,750.00 | $0.00 | $0.00 | $0.00 | $0.00 | $605.00 | $28,000.00 | $28,000.00 | $28,000.00 | $205,369.00 | ||
11 | Agency Fee | $7,372.00 | $8,848.72 | $7,760.00 | $7,760.00 | $7,760.00 | $7,760.00 | $7,760.00 | $7,760.00 | $7,760.00 | $7,760.00 | $7,760.00 | $7,760.00 | $93,820.72 | ||
12 | Production | $12,400.00 | $29,890.30 | $29,890.30 | $29,890.30 | $29,890.30 | $29,890.30 | $29,890.30 | $29,890.30 | $29,890.30 | $29,890.30 | $29,890.30 | $29,890.30 | $341,193.30 | ||
13 | Total | $277,097.00 | $297,952.02 | $346,712.30 | $430,429.30 | $508,663.41 | $518,420.30 | $344,490.30 | $340,357.30 | $420,076.30 | $452,471.30 | $512,037.30 | $546,420.30 | $4,995,127.13 | #REF! | |
14 | ||||||||||||||||
15 | Richmond Times/Freelance Star | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
16 | Store Specific Publications | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $5,100.00 | ||
17 | Lake Anna Community | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
18 | Prensa Libre | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
19 | Washington Auto Show Program | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
20 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
21 | Total | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $425.00 | $5,100.00 | #REF! | |
22 | Direct Mail/Email | |||||||||||||||
23 | Database Mail | $8,250.00 | $16,500.00 | $111,444.25 | $8,250.00 | $51,750.00 | $8,250.00 | $8,250.00 | $39,750.00 | $8,250.00 | $25,250.00 | $18,250.00 | $8,250.00 | $312,444.25 | ||
24 | Database Calls | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
25 | Harley Mail | $225.42 | $225.42 | $225.42 | $225.42 | $225.42 | $225.42 | $225.42 | $225.42 | $225.42 | $225.42 | $225.42 | $225.42 | $2,705.04 | ||
26 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
27 | Conquest email/CBS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
28 | Cap One Sale | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
29 | Benchmark | $725.00 | $725.00 | $725.00 | $725.00 | $725.00 | $725.00 | $725.00 | $725.00 | $725.00 | $725.00 | $725.00 | $725.00 | $8,700.00 | ||
30 | Special event or other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
31 | $0.00 | |||||||||||||||
32 | Total | $9,200.42 | $17,450.42 | $112,394.67 | $9,200.42 | $52,700.42 | $9,200.42 | $9,200.42 | $40,700.42 | $9,200.42 | $26,200.42 | $19,200.42 | $9,200.42 | $323,849.29 | #REF! | |
33 | Fixed Internet | |||||||||||||||
34 | Website | $72,416.38 | $72,416.38 | $71,616.38 | $71,076.38 | $71,915.63 | $71,915.63 | $71,915.63 | $71,915.63 | $71,915.63 | $71,915.63 | $71,915.63 | $71,915.63 | $862,850.56 | ||
35 | eLead Mobile Desking | $395.00 | $395.00 | $395.00 | $395.00 | $395.00 | $395.00 | $395.00 | $395.00 | $395.00 | $395.00 | $395.00 | $395.00 | $4,740.00 | ||
36 | eLead Text | $7,449.00 | $7,449.00 | $7,449.00 | $7,449.00 | $7,449.00 | $7,449.00 | $7,449.00 | $7,449.00 | $7,449.00 | $7,449.00 | $7,449.00 | $7,449.00 | $89,388.00 | ||
37 | eLead RCI Data Feed | $11,784.00 | $11,784.00 | $11,784.00 | $11,784.00 | $11,784.00 | $11,784.00 | $11,784.00 | $11,784.00 | $11,784.00 | $11,784.00 | $11,784.00 | $11,784.00 | $141,408.00 | ||
38 | eLead BDC | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
39 | eLead Rebate Integration | $1,780.00 | $1,780.00 | $1,780.00 | $1,780.00 | $1,780.00 | $1,780.00 | $1,780.00 | $1,780.00 | $1,780.00 | $1,780.00 | $1,780.00 | $1,780.00 | $21,360.00 | ||
40 | eLead GoldDigger | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
41 | Equity Mining Tool | $69,485.00 | $69,485.00 | $78,340.00 | $78,340.00 | $78,340.00 | $78,340.00 | $78,340.00 | $78,340.00 | $78,340.00 | $78,340.00 | $78,340.00 | $78,340.00 | $922,370.00 | ||
42 | Chat | $9,680.00 | $10,045.00 | $10,045.00 | $10,045.00 | $10,045.00 | $10,045.00 | $10,045.00 | $10,045.00 | $10,045.00 | $10,045.00 | $10,045.00 | $10,045.00 | $120,175.00 | ||
43 | CallRevu | $32,883.39 | $32,883.39 | $32,883.39 | $32,883.39 | $32,883.39 | $32,883.39 | $32,883.39 | $33,462.56 | $33,462.56 | $33,462.56 | $33,462.56 | $33,462.56 | $397,496.53 | ||
44 | Finance Tools | $7,234.00 | $7,234.00 | $7,234.00 | $7,234.00 | $7,234.00 | $7,234.00 | $7,234.00 | $7,234.00 | $7,234.00 | $7,234.00 | $7,234.00 | $7,234.00 | $86,808.00 | ||
45 | Rep Management | $7,098.62 | $7,369.85 | $7,369.85 | $7,143.62 | $7,143.62 | $7,143.62 | $7,143.62 | $7,143.62 | $7,143.62 | $7,143.62 | $7,143.62 | $7,143.62 | $86,130.90 | ||
46 | DealerRater | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
47 | Social Media | $98,800.00 | $102,350.00 | $101,350.00 | $101,350.00 | $101,350.00 | $101,350.00 | $101,350.00 | $101,350.00 | $101,450.00 | $101,450.00 | $101,450.00 | $101,450.00 | $1,215,050.00 | ||
48 | Trade-in Tool | $12,403.52 | $12,782.52 | $12,782.52 | $12,782.52 | $12,782.52 | $12,782.52 | $12,782.52 | $12,782.52 | $12,782.52 | $12,782.52 | $12,782.52 | $12,782.52 | $153,011.24 | ||
49 | eLead - ACE | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
50 | LX CDK/eLead Deal Builder/Roadster | $43,705.00 | $39,725.00 | $39,725.00 | $39,725.00 | $39,725.00 | $39,725.00 | $39,725.00 | $39,725.00 | $39,725.00 | $39,725.00 | $39,725.00 | $39,725.00 | $480,680.00 | ||
51 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
52 | Total | $375,113.91 | $375,699.14 | $382,754.14 | $381,987.91 | $382,827.16 | $382,827.16 | $382,827.16 | $383,406.33 | $383,506.33 | $383,506.33 | $383,506.33 | $383,506.33 | $4,581,468.23 | #REF! | |
53 | New Vehicles | |||||||||||||||
54 | OEM | $48,326.00 | $45,615.34 | $40,375.00 | $43,198.00 | $39,198.00 | $41,460.60 | $43,198.00 | $41,460.60 | $35,466.00 | $50,199.60 | $46,906.00 | $46,906.00 | $522,309.14 | ||
55 | True Car | $71,600.00 | $81,398.00 | $83,388.00 | $82,888.00 | $82,888.00 | $81,888.00 | $79,940.00 | $79,865.00 | $80,940.00 | $80,940.00 | $80,940.00 | $80,940.00 | $967,615.00 | ||
56 | Pure Cars - VYT | $22,789.00 | $23,396.00 | $23,396.00 | $23,396.00 | $23,396.00 | $23,396.00 | $22,589.00 | $23,396.00 | $23,396.00 | $23,396.00 | $23,396.00 | $23,396.00 | $279,338.00 | ||
57 | AutoTrader - New | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
58 | $0.00 | $713.50 | $713.50 | $713.50 | $713.50 | $713.50 | $713.50 | $713.50 | $713.50 | $713.50 | $713.50 | $713.50 | $7,848.50 | |||
59 | Cars.com | $22,215.50 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | $244,848.50 | ||
60 | Carsforsale.com | $99.00 | $99.00 | $99.00 | $99.00 | $99.00 | $99.00 | $99.00 | $99.00 | $99.00 | $99.00 | $99.00 | $99.00 | $1,188.00 | ||
61 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
62 | Edmunds.com | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
63 | PureCars - SEM | $247,870.30 | $250,220.30 | $251,520.30 | $252,820.30 | $252,820.30 | $252,820.30 | $252,820.30 | $252,220.30 | $251,220.30 | $250,220.30 | $250,220.30 | $250,220.30 | $3,014,993.60 | ||
64 | TruckTrader | $10,910.00 | $10,910.00 | $10,910.00 | $10,910.00 | $10,910.00 | $10,910.00 | $10,910.00 | $10,910.00 | $10,910.00 | $10,910.00 | $10,910.00 | $10,910.00 | $130,920.00 | ||
65 | Special Finance leads | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
66 | WP+/Wash Post Digital/Boston specials | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
67 | Mobile Campaign/Lotlinx | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
68 | Dealix/KBB - New | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
69 | AutoTrader/KBB - TIM | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
70 | Total | $423,809.80 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | $5,169,060.74 | #REF! | |
71 | Used Vehicles | |||||||||||||||
72 | AutoTrader (incl. AT Moto) | $199.00 | $199.00 | $199.00 | $199.00 | $199.00 | $199.00 | $199.00 | $199.00 | $199.00 | $199.00 | $199.00 | $199.00 | $2,388.00 | ||
73 | CarFax UCL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
74 | Cars.com (incl. HD: motomate) | $22,713.50 | $23,427.00 | $23,427.00 | $23,427.00 | $23,427.00 | $23,427.00 | $23,427.00 | $23,427.00 | $23,427.00 | $23,427.00 | $23,427.00 | $23,427.00 | $280,410.50 | ||
75 | Cycle Trader | $725.00 | $725.00 | $725.00 | $797.50 | $797.50 | $797.50 | $797.50 | $797.50 | $797.50 | $797.50 | $797.50 | $797.50 | $9,352.50 | ||
76 | AutoiPacket | $4,343.00 | $4,343.00 | $4,343.00 | $4,343.00 | $4,343.00 | $4,343.00 | $4,343.00 | $4,343.00 | $4,343.00 | $4,343.00 | $4,343.00 | $4,343.00 | $52,116.00 | ||
77 | Edmunds.com | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $600.00 | ||
78 | Autotrader Spotlights / Accelerate DR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
79 | KBB Used | $76,209.09 | $84,070.40 | $84,070.40 | $84,070.40 | $84,070.40 | $84,070.40 | $84,070.40 | $84,070.40 | $84,070.40 | $84,070.40 | $84,070.40 | $84,070.40 | $1,000,983.49 | ||
80 | Cargurus | $41,650.00 | $44,000.00 | $45,000.00 | $45,000.00 | $45,000.00 | $44,597.50 | $44,597.50 | $45,000.00 | $45,000.00 | $45,000.00 | $45,000.00 | $45,000.00 | $534,845.00 | ||
81 | SEM | $2,125.00 | $2,125.00 | $2,125.00 | $2,125.00 | $2,125.00 | $2,125.00 | $2,125.00 | $2,125.00 | $2,125.00 | $2,125.00 | $2,125.00 | $4,125.00 | $27,500.00 | ||
82 | Total | $148,014.59 | $158,939.40 | $159,939.40 | $160,011.90 | $160,011.90 | $159,609.40 | $159,609.40 | $160,011.90 | $160,011.90 | $160,011.90 | $160,011.90 | $162,011.90 | $1,908,195.49 | #REF! | |
83 | Used Vehicles - non Internet | |||||||||||||||
84 | Carfax | $19,143.79 | $19,963.79 | $19,963.79 | $19,963.79 | $19,963.79 | $19,963.79 | $19,963.79 | $19,963.79 | $19,963.79 | $20,397.58 | $20,397.58 | $20,397.58 | $240,046.85 | ||
85 | Special Event | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
86 | J&L Event | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
87 | Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
88 | Total | $19,143.79 | $19,963.79 | $19,963.79 | $19,963.79 | $19,963.79 | $19,963.79 | $19,963.79 | $19,963.79 | $19,963.79 | $20,397.58 | $20,397.58 | $20,397.58 | $240,046.85 | #REF! | |
89 | Store Specific Other | |||||||||||||||
90 | Graphic Design - Web and Print | $19,100.00 | $19,750.00 | $19,750.00 | $19,750.00 | $19,100.00 | $19,750.00 | $19,750.00 | $19,650.00 | $19,650.00 | $19,650.00 | $19,650.00 | $19,650.00 | $235,200.00 | ||
91 | Printing Costs | $10,050.00 | $15,600.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $612.26 | $450.00 | $250.00 | $250.00 | $250.00 | $28,712.26 | ||
92 | Polin PR | $4,680.00 | $4,860.00 | $4,860.00 | $4,860.00 | $4,860.00 | $4,860.00 | $4,860.00 | $4,860.00 | $4,860.00 | $10,060.00 | $4,860.00 | $4,860.00 | $63,340.00 | ||
93 | POP Instore | $10,500.00 | $10,743.00 | $700.00 | $1,000.00 | $4,945.00 | $11,107.00 | $1,723.00 | $6,686.58 | $11,000.00 | $10,441.84 | $11,300.00 | $11,000.00 | $91,146.42 | ||
94 | COSTCO/Navy Fed | $1,400.00 | $1,400.00 | $1,400.00 | $1,400.00 | $1,400.00 | $1,400.00 | $1,400.00 | $1,400.00 | $1,400.00 | $1,400.00 | $1,400.00 | $1,900.00 | $17,300.00 | ||
95 | Military - Ft. Belvoir | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
96 | BJs Wholesale Club | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $6,250.00 | $6,250.00 | $12,500.00 | ||
97 | Community Events/Sponsorships | $4,500.00 | $8,000.00 | $8,000.00 | $9,000.00 | $10,000.00 | $8,500.00 | $9,000.00 | $9,600.00 | $9,699.00 | $8,500.00 | $9,000.00 | $9,000.00 | $102,799.00 | ||
98 | Charitable Donations | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $18,000.00 | ||
99 | Automotive - New car clinics | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
100 | Outdoor/billboards/etc. | $470.00 | $470.00 | $5,470.00 | $5,470.00 | $5,470.00 | $5,470.00 | $5,470.00 | $5,470.00 | $5,470.00 | $5,470.00 | $5,470.00 | $470.00 | $50,640.00 | ||