User Acquisition Heatmap Dashboard - workshopdigital.com

	B	C	D	E	F	G	H	I	J	L	M	N	O	P	Q	R	S	T	U
1	Blog post with instructions and more details
2	User Acquisition Heatmap Dashboard							@kellyjw514
3	User Acquisition Heatmap Dashboard							@WorkshopMktg		Avg. Monthly Select a Metric		Month with the Most Select a Metric		Day of Week with the Most Select a Metric		Time of Day with the Most Select a Metric
4	ga:XXXXXXXX			Select a Segment		Select a Metric				Avg. Monthly Select a Metric		Month with the Most Select a Metric		Day of Week with the Most Select a Metric		Time of Day with the Most Select a Metric
5	ga:XXXXXXXX			Select a Segment		Select a Metric				2,741.7		May		Monday		10 AM
6										2,741.7		May		Monday		10 AM
7	Month by Month Analysis									Avg. Daily Select a Metric		Month with the Least Select a Metric		Day of Week with the Least Select a Metric		Time of Day with the least Select a Metric
8	Month by Month Analysis									Avg. Daily Select a Metric		Month with the Least Select a Metric		Day of Week with the Least Select a Metric		Time of Day with the least Select a Metric
9	Month		2013	2014	2015	2016	2017	2018	Average	90.2		December		Saturday		2 AM
10	January	Q1	2,427	2,632	2,565	2,456	3,093	3,437	2,768.3	90.2		December		Saturday		2 AM
11	February		2,285	2,543	2,206	2,627	3,163	3,485	2,718.2
12	March		2,599	2,852	2,729	2,827	3,746	3,908	3,110.2
13	April	Q2	2,679	2,897	2,777	2,937	3,618	1,399	2,717.8	Select a Metric by Time and Day of Week
14	May		3,429	3,262	3,000	3,336	4,008	N/A	3,407.0	Select a Metric by Time and Day of Week
15	June		3,258	2,862	3,024	3,149	3,942	N/A	3,247.0	Time of Day	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Total	% of Total
16	July	Q3	3,377	3,086	2,950	3,030	3,014	N/A	3,091.4	12 AM	256	253	269	296	238	182	169	1,663	0.95%
17	August		3,048	2,457	2,860	2,827	2,793	N/A	2,797.0	1 AM	148	207	186	196	194	164	110	1,205	0.69%
18	September		2,360	2,400	2,452	2,662	2,023	N/A	2,379.4	2 AM	138	173	179	171	142	91	79	973	0.55%
19	October	Q4	2,177	2,238	2,316	2,485	2,693	N/A	2,381.8	3 AM	146	149	179	193	180	76	86	1,009	0.57%
20	November		2,035	1,720	2,183	2,408	2,518	N/A	2,172.8	4 AM	197	232	251	302	250	107	91	1,430	0.81%
21	December		2,072	1,739	2,003	2,365	2,367	N/A	2,109.2	5 AM	383	392	405	530	389	184	106	2,389	1.36%
22	Yearly Avg.		2,645.5	2,557.3	2,588.8	2,759.1	3,081.5	3,057.3	2,741.7	6 AM	783	783	759	890	736	307	205	4,463	2.54%
23	Yearly Total		31,746	30,688	31,065	33,109	36,978	12,229	175,815	7 AM	1,508	1,444	1,474	1,446	1,334	535	376	8,117	4.62%
24										8 AM	2,172	2,154	2,083	2,208	1,924	739	521	11,801	6.72%
25	Avgerage Daily Select a Metric									9 AM	2,778	2,625	2,528	2,522	2,253	754	612	14,072	8.01%
26	Avgerage Daily Select a Metric									10 AM	2,802	2,754	2,707	2,484	2,328	820	704	14,599	8.31%
27	Month		2013	2014	2015	2016	2017	2018	Average	11 AM	2,608	2,444	2,392	2,238	2,020	798	627	13,127	7.47%
28	January	Q1	78.29	84.90	82.74	79.23	99.77	110.87	89.3	12 PM	2,606	2,572	2,465	2,346	2,092	764	701	13,546	7.71%
29	February		81.61	90.82	78.79	93.82	112.96	124.46	97.1	1 PM	2,829	2,724	2,550	2,392	2,142	749	669	14,055	8.00%
30	March		83.84	92.00	88.03	91.19	120.84	126.06	100.3	2 PM	2,722	2,682	2,514	2,385	2,142	740	703	13,888	7.91%
31	April	Q2	89.30	96.57	92.57	97.90	120.60	46.63	90.6	3 PM	2,455	2,440	2,321	2,229	1,750	677	712	12,584	7.16%
32	May		110.61	105.23	96.77	107.61	129.29	N/A	109.9	4 PM	1,803	1,753	1,671	1,587	1,165	622	763	9,364	5.33%
33	June		108.60	95.40	100.80	104.97	131.40	N/A	108.2	5 PM	1,335	1,281	1,225	1,204	862	547	718	7,172	4.08%
34	July	Q3	108.94	99.55	95.16	97.74	97.23	N/A	99.7	6 PM	1,130	1,151	1,152	1,090	736	557	832	6,648	3.78%
35	August		98.32	79.26	92.26	91.19	90.10	N/A	90.2	7 PM	1,120	1,088	1,102	1,076	682	534	812	6,414	3.65%
36	September		78.67	80.00	81.73	88.73	67.43	N/A	79.3	8 PM	1,030	1,046	1,075	1,003	667	526	795	6,142	3.50%
37	October	Q4	70.23	72.19	74.71	80.16	86.87	N/A	76.8	9 PM	829	810	915	811	535	446	690	5,036	2.87%
38	November		67.83	57.33	72.77	80.27	83.93	N/A	72.4	10 PM	622	597	632	567	405	336	483	3,642	2.07%
39	December		66.84	56.10	64.61	76.29	76.35	N/A	68.0	11 PM	344	350	398	364	307	245	320	2,328	1.33%
40	Yearly Avg.		87.0	84.1	85.1	90.7	101.3	33.5	90.2	Total	32,744	32,104	31,432	30,530	25,473	11,500	11,884	175,667
41
42	Select a Metric by the Day of Week
43	Select a Metric by the Day of Week
44	Day of Week		2013	2014	2015	2016	2017	2018	Average
45	Monday		6,026	5,883	5,879	6,094	6,620	2,293	5,465.8
46	Tuesday		5,896	5,653	5,631	5,982	6,699	2,266	5,354.5
47	Wednesday		5,575	5,337	5,547	6,014	6,804	2,176	5,242.2
48	Thursday		5,305	5,295	5,466	5,933	6,527	2,021	5,091.2
49	Friday		4,685	4,447	4,513	4,742	5,429	1,679	4,249.2
50	Saturday		2,095	1,959	1,936	2,212	2,404	894	1,916.7
51	Sunday		2,164	2,114	2,093	2,132	2,495	900	1,983.0
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100