The WTF is Happening to My Traffic Dashboard - Updated for 2021 - josephwkelly.com

	B	C	D	E	F	G	H	I	J	L	M	N	O	P	Q	AB	AC	AD
1																	MoM	YoY
2						SEO Analytics Dashboard							Blog post with instructions and more details			Cities	1	1
3						WTF is Happening to My Traffic?							@kellyjw514			Landing Pages	1	1
4	GA VIEW ID:								ga:XXXXXXXXX							Conversions	1	1
5	GA VIEW ID:								ga:XXXXXXXXX							Channels	1	1
6																Devices	1	1
7		% Change - Top Cities								% Change - Goal Completions						New vs. Ret.	1	1
8		City		Last 30 Days	Previous Period	% Change	Last Year		YoY % Change	Channel	Last 30 Days	Previous Period	% Change	Last Year	YoY % Change
9		Beijing		1	1	0.00	#N/A		#N/A	Organic Search	0	0	#DIV/0!	0	#DIV/0!
10		Detroit		1	#N/A	#N/A	#N/A		#N/A	Paid Search	#N/A	#N/A	#N/A	#N/A	#N/A
11		Liverpool		1	#N/A	#N/A	#N/A		#N/A	Direct	0	0	#DIV/0!	0	#DIV/0!
12		Logan		1	#N/A	#N/A	#N/A		#N/A	Referral	#N/A	0	#N/A	0	#N/A
13		Portsmouth		1	#N/A	#N/A	#N/A		#N/A	Social	0	0	#DIV/0!	0	#DIV/0!
14
15		% Change - Top Landing Pages								% Change - Channel
16		Landing Page		Last 30 Days	Previous Period	% Change	Last Year		YoY % Change	Channel	Last 30 Days	Previous Period	% Change	Last Year	YoY % Change
17		/blog/example-post/		4	#N/A	#N/A	#N/A		#N/A	Organic Search	8	14	-42.86	2	300.00
18		/		3	14	-78.57	1		200.00	Paid Search	#N/A	#N/A	#N/A	#N/A	#N/A
19		/blog/google-analytics-heatmap/		1	#N/A	#N/A	1		0.00	Direct	101	112	-9.82	120	-15.83
20					#N/A	#N/A	#N/A		#N/A	Display	#N/A	#N/A	#N/A	#N/A	#N/A
21					#N/A	#N/A	#N/A		#N/A	Referral	#N/A	3	#N/A	2	#N/A
22					#N/A	#N/A	#N/A		#N/A	Social	2	4	-50.00	3	-33.33
23					#N/A	#N/A	#N/A		#N/A
24					#N/A	#N/A	#N/A		#N/A	% Change - Device Type
25					#N/A	#N/A	#N/A		#N/A	Device	Last 30 Days	Previous Period	% Change	Last Year	YoY % Change
26					#N/A	#N/A	#N/A		#N/A	Desktop	6	14	-57.14	2	200.00
27										Mobile	2		#DIV/0!		#DIV/0!
28		Organic Sessions by Month								Tablet			#DIV/0!		#DIV/0!
29		Organic Sessions by Month
30		Month	2016	2017	2018	2019	2020	2021	Average	% Change - New vs. Returning Visitors
31		January	N/A	N/A	5	N/A	N/A	7	6	User Type	Last 30 Days	Previous Period	% Change	Last Year	YoY % Change
32		February	N/A	N/A	3	6	3	N/A	4	New Visitors	4	14	-71.43	1	300.00
33		March	N/A	12	5	1	12	N/A	8	Returning Visitors	4		#DIV/0!	1	300.00
34		April	N/A	8	9	4	12	N/A	8
35		May	N/A	11	8	4	7	N/A	8	Here's WTF Happened to Your Traffic
36		June	N/A	6	8	N/A	21	N/A	12	WTF Happened?			In the Past Month	Compared to Last Year
37		July	N/A	4	1	1	15	N/A	5	You lost visibilty in your top cities.			Not Likely	Not Likely
38		August	N/A	N/A	2	3	8	N/A	4	Your top landing pages have lost valuable positioning.			Not Likely	Not Likely
39		September	N/A	N/A	4	9	4	N/A	6	The drop in traffic is impacting your converions.			Not Likely	Not Likely
40		October	N/A	N/A	4	11	27	N/A	14	Traffic sources besides organic are also down, so other marketing channels could be impacting this decline.			Not Likely	Not Likely
41		November	N/A	N/A	N/A	18	16	N/A	17	A drop in organic traffic from a specific types of device.			Likely	Likely
42		December	N/A	N/A	N/A	13	7	N/A	10	You're not retaining your loyal customers.			Likely	Likely
43
44
45
46
47
48
49
50
51
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