Monthly Paid Media Report.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2	Monthly Paid Media Report
3	Creative	Markets	Impressions	Reach	Post Shares	Unique Clicks	Click Through Rate	Cost	Cost/ Click	CPM Impressions	Unique Users to Landing Page	Foot Traffic Visits	Full Video Views	View Through Rate
4			14,705,539	1,710,731	498	228,173	1.55%	$59,454.58	$0.26	$4.04	260,583	0	0	0.00%
5		Facebook Tile Ad		June 23 - July 3			Hootenany
6		Hi-Line	299,659	23,785	45	2,176	0.73%	$1,200.12	$0.55	$4.00
7		Kalispell	255,011	56,374	39	2,771	1.09%	$1,195.87	$0.43	$4.69
8		Missoula	276,091	51,738	33	2,680	0.97%	$1,195.05	$0.45	$4.33
9		Lethbridge	604,568	72,968	33	3,785	0.63%	$1,195.56	$0.32	$1.98
10
11		Totals	1,435,329	204,865	150	11,412	0.80%	$4,786.60	$0.42	$3.33	10,202
12		Facebook Tile Ad		June 23 -July 16			Cottonwood Festival
13		Billings	253,807	24,739	3	1,493	0.59%	$432.25	$0.29	$1.70
14		Hi-Line	228,634	11,120	7	1,242	0.54%	$406.48	$0.33	$1.78
15		Kalispell	213,645	22,597	4	1,365	0.64%	$432.04	$0.32	$2.02
16		Missoula	203,002	22,737	10	1,296	0.64%	$431.98	$0.33	$2.13
17		Lethbridge	427,775	29,445	1	1,836	0.43%	$406.81	$0.22	$0.95
18		Calgary	186,424	68,645	7	1,892	1.01%	$432.37	$0.23	$2.32
19
20		Totals	1,513,287	179,283	32	9,124	0.60%	$2,541.93	$0.28	$1.68	3,963
21		Snapchat Ad		July 1 - September 30			Kayaking
22		Calgary, AB	1,056,119	111,988		19,128	1.81%	$5,172.65	$0.27	$4.90
23		Lethbridge, AB	68,653	14,697		1,279	1.86%	$344.82	$0.27	$5.02
24
25
26
27		Totals	1,124,772	126,685	0	20,407	1.81%	$5,517.47	$0.27	$4.91	26,615
28		Snapchat Event Ad		July 1 - 24			Third Eye Blind
29		Billings	17,851	3,500		303	1.70%	$238.26	$0.79	$13.35
30		Hi-Line	4,992	876		81	1.62%	$58.72	$0.72	$11.76
31		Eastern MT	2,906	626		53	1.82%	$39.50	$0.75	$13.59
32		Missoula/Kalispell	11,031	2,968		222	2.01%	$163.52	$0.74	$14.82
33
34		Totals	36,780	7,970	0	659	1.79%	$500.00	$0.76	$13.59	2,452
35		Snapchat Event Ad		July 2 - 25			Ian Munsick
36		Billings	17,858	3,930		325	1.82%	$250.77	$0.77	$14.04
37		Hi-Line	4,876	970		65	1.33%	$57.37	$0.88	$11.77
38		Eastern MT	2,931	703		46	1.57%	$43.07	$0.94	$14.69
39		Missoula/Kalispell	9,503	2,925		186	1.96%	$148.79	$0.80	$15.66
40
41		Totals	35,168	8,528	0	622	1.77%	$500.00	$0.80	$14.22	1,640
42		Snapchat Event Ad		July 8 - August 30			Great Falls Voyagers
43		Billings	23,110	4,632		518	2.24%	$371.79	$0.72	$16.09
44		Hi-Line	6,479	1,158		121	1.87%	$92.94	$0.77	$14.34
45		Eastern MT	4,778	951		100	2.09%	$79.81	$0.80	$16.70
46		Missoula/Kalispell	14,021	3,708		379	2.70%	$255.13	$0.67	$18.20
47
48		Totals	48,388	10,449	0	1,118	2.31%	$799.67	$0.72	$16.53	2,408
49		Snapchat Event Ad		July 8 - 26			John Crist
50		Billings	16,623	5,013		266	1.60%	$239.50	$0.90	$14.41
51		Hi-Line	4,446	1,189		74	1.66%	$56.08	$0.76	$12.61
52		Eastern MT	3,136	895		69	2.20%	$52.49	$0.76	$16.74
53		Missoula/Kalispell	9,185	3,538		193	2.10%	$151.87	$0.79	$16.53
54
55		Totals	33,390	10,635	0	602	1.80%	$499.94	$0.83	$14.97	2,140
56		Snapchat Event Ad		July 8 - 28			Big Sky Pro Rodeo
57		Billings	10,614	3,960		273	2.57%	$233.37	$0.85	$21.99
58		Hi-Line	3,077	932		49	1.59%	$54.24	$1.11	$17.63
59		Eastern MT	2,662	799		59	2.22%	$55.66	$0.94	$20.91
60		Missoula/Kalispell	6,986	2,970		187	2.68%	$156.73	$0.84	$22.43
61
62		Totals	23,339	8,661	0	568	2.43%	$500.00	$0.88	$21.42	1,947
63		Facebook Tile Ad		July 9 - 22			Kentucky Headhunters
64		Billings	135,087	29,710	16	1,366	1.01%	$340.19	$0.25	$2.52
65		Hi-Line	117,546	12,330	21	975	0.83%	$274.70	$0.28	$2.34
66		Kalispell	140,395	27,056	12	1,244	0.89%	$366.45	$0.29	$2.61
67		Missoula	172,508	26,583	14	1,154	0.67%	$365.30	$0.32	$2.12
68		Calgary/Lethbridge, AB	268,930	98,446	26	2,793	1.04%	$458.22	$0.16	$1.70
69
70		Totals	834,466	194,125	89	7,532	0.90%	$1,804.86	$0.24	$2.16	5,604
71		Snapchat		July 9 - 22			Kentucky Headhunters
72		Billings	13,479	4,310		283	2.10%	$281.20	$0.99	$20.86
73		Hi-Line	4,270	1,136		83	1.94%	$79.35	$0.96	$18.58
74		Missoula/Kalispell	8,694	3,327		236	2.71%	$199.43	$0.85	$22.94
75		Calgary, AB	36,814	17,460		1,376	3.74%	$349.54	$0.25	$9.49
76		Lethbridge, AB	2,138	123		83	3.88%	$23.58	$0.28	$11.03
77
78		Totals	65,395	26,356	0	2,061	3.15%	$933.10	$0.45	$14.27	5,604
79		Facebook Tile Ad		July 10 - 26			John Crist
80		Billings	22,333	9,450	10	515	2.31%	$97.93	$0.19	$4.38
81		Hi-Line	26,190	6,819	5	329	1.26%	$98.25	$0.30	$3.75
82		Eastern MT	28,610	6,796	1	362	1.27%	$97.90	$0.27	$3.42
83		Kalispell	31,114	9,219	9	504	1.62%	$97.92	$0.19	$3.15
84		Missoula	22,828	9,276	7	490	2.15%	$97.87	$0.20	$4.29
85		Calgary/Lethbridge, AB	22,942	13,125	3	1,202	5.24%	$97.78	$0.08	$4.26
86
87		Totals	154,017	54,685	35	3,402	2.21%	$587.65	$0.17	$3.82	2,140
88		Facebook Tile Ad		July 10 - 25			Ian Munsick
89		Billings	22,140	9,720	2	379	1.71%	$97.13	$0.26	$4.39
90		Hi-Line	30,228	5,924	1	290	0.96%	$97.09	$0.33	$3.21
91		Eastern MT	42,636	5,330	1	324	0.76%	$97.06	$0.30	$2.28
92		Kalispell	19,393	8,706		338	1.74%	$97.08	$0.29	$5.01
93		Missoula	19,688	8,462	1	320	1.63%	$97.07	$0.30	$4.93
94		Calgary/Lethbridge, AB	24,187	13,541	2	874	3.61%	$97.01	$0.11	$4.01
95
96		Totals	158,272	51,683	7	2,525	1.60%	$485.43	$0.19	$3.07	1,640
97		Facebook Tile Ad		July 10 - 28			Big Sky Pro Rodeo
98		Billings	37,293	13,190	2	379	1.02%	$97.96	$0.26	$2.63
99		Hi-Line	46,391	7,062	2	316	0.68%	$97.96	$0.31	$2.11
100		Eastern MT	47,508	7,500	2	333	0.70%	$97.96	$0.29	$2.06