User Acquisition Heatmap Dashboard - Updated for 2021 - josephwkelly.com

	B	C	D	E	F	G	H	I	J	K	M	N	O	P	Q	R	S	T	U	V
1	Blog post with instructions and more details					@kellyjw514
2	User Acquisition Heatmap Dashboard
3	User Acquisition Heatmap Dashboard										Avg. Monthly Sessions		Month with the Most Sessions		Day of Week with the Most Sessions		Time of Day with the Most Sessions
4	ga:XXXXXXXXX			All Users		Sessions					Avg. Monthly Sessions		Month with the Most Sessions		Day of Week with the Most Sessions		Time of Day with the Most Sessions
5	ga:XXXXXXXXX			All Users		Sessions					95.7		October		Tuesday		9 AM
6											95.7		October		Tuesday		9 AM
7	Month by Month Analysis										Avg. Daily Sessions		Month with the Least Sessions		Day of Week with the Least Sessions		Time of Day with the least Sessions
8	Month by Month Analysis										Avg. Daily Sessions		Month with the Least Sessions		Day of Week with the Least Sessions		Time of Day with the least Sessions
9	Month		2015	2016	2017	2018	2019	2020	2021	Average	3.1		February		Saturday		12 AM
10	January	Q1	N/A	N/A	N/A	48	N/A	N/A	71	60	3.1		February		Saturday		12 AM
11	February		N/A	N/A	N/A	72	15	70	N/A	52
12	March		N/A	N/A	44	26	16	220	N/A	77
13	April	Q2	N/A	N/A	38	37	25	297	N/A	99	Sessions by Time and Day of Week
14	May		N/A	N/A	35	47	223	177	N/A	121	Sessions by Time and Day of Week
15	June		N/A	N/A	24	29	14	226	N/A	73	Time of Day	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Total	% of Total
16	July	Q3	N/A	N/A	19	13	170	216	N/A	105	12 AM	14	15	13	13	24	13	14	106	2.62%
17	August		N/A	N/A	1	17	264	129	N/A	103	1 AM	5	16	31	13	17	16	44	142	3.51%
18	September		N/A	N/A	3	16	156	156	N/A	83	2 AM	11	17	33	16	25	19	15	136	3.36%
19	October	Q4	N/A	N/A	N/A	44	182	161	N/A	129	3 AM	7	21	26	21	18	18	20	131	3.24%
20	November		N/A	N/A	1	N/A	206	153	N/A	120	4 AM	14	30	35	22	28	18	11	158	3.91%
21	December		N/A	N/A	1	N/A	272	110	N/A	128	5 AM	11	36	52	26	37	41	11	214	5.29%
22	Monthly Avg.		#DIV/0!	#DIV/0!	18	35	140	174	71	96	6 AM	16	22	39	35	24	19	18	173	4.28%
23	Yearly Total		0	0	166	349	1,543	1,915	71	4,044	7 AM	15	29	34	30	30	24	13	175	4.33%
24											8 AM	9	34	50	59	23	20	7	202	5.00%
25	Average Daily										9 AM	12	48	69	85	56	36	9	315	7.79%
26	Average Daily										10 AM	10	40	38	49	37	31	9	214	5.29%
27	Month		2015	2016	2017	2018	2019	2020	2021	Average	11 AM	13	30	47	29	40	40	17	216	5.34%
28	January	Q1	N/A	N/A	N/A	1.55	N/A	N/A	2.29	2	12 PM	13	29	45	36	54	31	14	222	5.49%
29	February		N/A	N/A	N/A	2.57	0.54	2.50	N/A	2	1 PM	24	27	30	32	38	19	14	184	4.55%
30	March		N/A	N/A	1.42	0.84	0.52	7.10	N/A	2	2 PM	26	28	26	29	22	30	12	173	4.28%
31	April	Q2	N/A	N/A	1.27	1.23	0.83	9.90	N/A	3	3 PM	9	29	13	31	29	21	10	142	3.51%
32	May		N/A	N/A	1.13	1.52	7.19	5.71	N/A	4	4 PM	23	29	37	23	31	27	10	180	4.45%
33	June		N/A	N/A	0.80	0.97	0.47	7.53	N/A	2	5 PM	11	26	28	33	21	19	7	145	3.59%
34	July	Q3	N/A	N/A	0.61	0.42	5.48	6.97	N/A	3	6 PM	10	16	25	12	24	17	8	112	2.77%
35	August		N/A	N/A	0.03	0.55	8.52	4.16	N/A	3	7 PM	14	34	28	15	18	15	7	131	3.24%
36	September		N/A	N/A	0.10	0.53	5.20	5.20	N/A	3	8 PM	10	64	15	13	16	11	9	138	3.41%
37	October	Q4	N/A	N/A	N/A	1.42	5.87	5.19	N/A	4	9 PM	20	19	20	49	29	13	12	162	4.01%
38	November		N/A	N/A	0.03	N/A	6.87	5.10	N/A	4	10 PM	13	38	19	24	16	14	8	132	3.26%
39	December		N/A	N/A	0.03	N/A	8.77	3.55	N/A	4	11 PM	13	36	23	12	25	24	8	141	3.49%
40	Monthly Avg.		0.0	0	0	1	4	5	0	3	Total	323	713	776	707	682	536	307	4,044	100%
41
42	Sessions by the Day of Week
43	Sessions by the Day of Week
44	Day of Week		2015	2016	2017	2018	2019	2020	2021	Average
45	Sunday		0	0	9	9	141	152	12	46.1
46	Monday		0	0	25	49	319	308	12	101.9
47	Tuesday		0	0	39	73	287	362	15	110.9
48	Wednesday		0	0	39	99	234	324	11	101.0
49	Thursday		0	0	34	53	249	341	5	97.4
50	Friday		0	0	13	20	212	284	7	76.6
51	Saturday		0	0	7	46	101	144	9	43.9
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