ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
Dashboard by Lukasz Zelezny. Visit: https://seo.london Email: lukasz@zelezny.co.uk. Feel free to copy to your Google Drive. Enquires: https://seo.london/
2
Organic Traffic Year Over YearOrganic Traffic Year Over Year (Linear) with TargetOrganic Traffic PenetrationGeo Penetration
3
MonthYear 2017Year 2018Year 2019Year 2020Month
Organic sessions
% growth (MoM)
Target% on targetMonthOrganic TrafficAll Traffic
Non Organic Traffic
% organic% non organicCountry or AreaInternet UsersQualified Organic TrafficPenetration
4
January10,23412,17812,28114,273Jan-201710,23410,234100.00%Jan-201710,23435,25425,02029.03%70.97%Jamaica1,409,8883,4232.43
5
February10,95012,59314,01616,728Feb-201710,9507.00%9,527114.94%Feb-201710,95025,17914,22943.49%56.51%Bahrain1,431,0902,3651.65
6
March11,82613,95515,25623,426Mar-201711,8268.00%11,471103.09%Mar-201711,82627,57915,75342.88%57.12%Japan115,845,120100,4560.87
7
April12,18114,61714,73924,342Apr-201712,1813.00%12,66896.16%Apr-201712,18126,21414,03346.47%53.53%Germany69,304,40535,9280.52
8
May13,27713,54316,46326,762May-201713,2779.00%14,47291.74%May-201713,27729,76616,48944.60%55.40%Poland29,005,92410,4520.36
9
June13,67516,13716,82025,453Jun-201713,6753.00%14,76992.59%Jun-201713,67533,02819,35341.40%58.60%United Kingdom62,621,01620,3450.32
10
July13,94915,06517,01827,893Organic Traffic Year Over Year (Yearly)Jul-201713,9492.00%13,252105.26%Jul-201713,94930,21116,26246.17%53.83%United States244,090,85450,2340.21
11
August14,08815,91917,46929,893YearOrganic Traffic% GrowthTarget% on targetAug-201714,0881.00%16,20186.96%Aug-201714,08826,74912,66152.67%47.33%Russia109,446,61220,3740.19
12
September15,49718,44119,83631,823Year 2017167,135150,000111.42%Sep-201715,49710.00%17,04790.91%Sep-201715,49738,74023,24340.00%60.00%Brazil141,206,80120,0450.14
13
October16,27217,73619,68930,292Year 2018189,11613.15%190,00099.53%Oct-201716,2725.00%15,133107.53%Oct-201716,27235,04018,76846.44%53.56%India706,620,00070,3460.10
14
November17,24817,76521,04332,837Year 2019207,0539.48%210,00098.60%Nov-201717,2486.00%16,731103.09%Nov-201717,24839,86822,62043.26%56.74%Pakistan76,381,0895,6730.07
15
December17,93821,16722,42329,873Year 2020418,127101.94%240,000174.22%Dec-201717,9384.00%20,09189.28%Dec-201717,93836,06718,12949.74%50.26%China840,080,56650,0290.06
16
Jan-201812,178-32.11%13,88387.72%Jan-201812,17819,6387,46062.01%37.99%
17
Feb-201812,5933.41%11,082113.63%Feb-201812,59321,7349,14157.94%42.06%
18
Mar-201813,95510.82%12,839108.69%Mar-201813,95532,31518,36043.18%56.82%
This is how to compare strength of traffic from different countries. Penetration is considering number of users in each country.
19
Apr-201814,6174.74%13,155111.11%Apr-201814,61727,14312,52653.85%46.15%
Qualified traffic means traffic only from specific country.
20
May-201813,543-7.35%13,94997.09%May-201813,54322,2928,74960.75%39.25%
In Example: For China 50,029 sessions in GA must be marked as traffic from China
21
Jun-201816,13719.15%18,55886.95%Jun-201816,13734,33918,20246.99%53.01%
In example above Jamaica and Bahrain has the best result as for small population country these country delivered relatively high traffic
22
Jul-201815,065-6.64%16,12093.46%Jul-201815,06524,6959,63061.01%38.99%
Highest traffic doesn't mean its the best result
23
Aug-201815,9195.67%14,964106.38%Aug-201815,91932,04816,12949.67%50.33%
24
Sep-201818,44115.84%18,441100.00%Sep-201818,44138,77520,33447.56%52.44%
25
Oct-201817,736-3.82%18,44596.16%Oct-201817,73631,52313,78756.26%43.74%
26
Nov-201817,7650.16%17,054104.17%Nov-201817,76534,42516,66051.61%48.39%
27
Dec-201821,16719.15%19,262109.89%Dec-201821,16739,95118,78452.98%47.02%
28
Jan-201912,281-41.98%12,89595.24%Jan-201912,28115,7233,44278.11%21.89%
29
Feb-201914,01614.13%14,15699.01%Feb-201914,01620,2196,20369.32%30.68%
30
Mar-201915,2568.85%13,730111.11%Mar-201915,25629,02613,77052.56%47.44%
31
Apr-201914,739-3.39%16,50889.28%Apr-201914,73920,8266,08770.77%29.23%
32
May-201916,46311.70%14,158116.28%May-201916,46327,71611,25359.40%40.60%
33
Jun-201916,8202.17%15,474108.70%Jun-201916,82027,03310,21362.22%37.78%
34
GSC vs Analytics Data Check (Example 1)CONCLUSION: Data is correct because of strong correlationJul-201917,0181.18%19,06089.29%Jul-201917,01829,07112,05358.54%41.46%
35
Month
Organic sessions (GA)
Clicks (GSC)difference% differenceCORREL=Aug-201917,4692.65%16,945103.09%Aug-201917,46925,9338,46467.36%32.64%
36
Jan-201710,2347,781-2,45327.23%0.9990686127Sep-201919,83613.55%19,241103.09%Sep-201919,83629,92710,09166.28%33.72%
37
Feb-201710,9508,541-2,40924.72%If correlation is close to 1 then GA gather data correctlyOct-201919,689-0.74%20,28097.09%Oct-201919,68934,01114,32257.89%42.11%
38
Mar-201711,8269,198-2,62825.00%STANDARD DEVIATION=Nov-201921,0436.88%17,887117.64%Nov-201921,04331,0329,98967.81%32.19%
39
Apr-201712,1819,261-2,92027.24%0.01109230116Dec-201922,4236.56%21,526104.17%Dec-201922,42333,91311,49066.12%33.88%
40
May-201713,27710,453-2,82423.80%Standard deviation of % difference is very low so expected growth is very predictableJan-202014,273-36.35%12,132117.65%Jan-202014,27313,2125,432108.03%41.11%
41
Jun-201713,67510,440-3,23526.83%Feb-202016,72817.20%15,557107.53%Feb-202016,72824,6877,95967.76%32.24%
42
Jul-201713,94910,856-3,09324.94%Mar-202023,42640.04%20,146116.28%Mar-202023,42642,30818,88255.37%44.63%
43
Aug-201714,08811,164-2,92423.16%Apr-202024,3423.91%29,00283.93%Apr-202024,34243,23918,89756.30%43.70%
44
Sep-201715,49712,123-3,37424.43%May-202026,7629.94%25,000107.05%
45
Oct-201716,27212,640-3,63225.12%Jun-202025,453-4.89%26,00097.90%
46
Nov-201717,24813,558-3,69023.96%Jul-202027,8939.59%27,000103.31%
47
Dec-201717,93813,962-3,97624.93%Aug-202029,8937.17%28,000106.76%
48
Jan-201812,1789,319-2,85926.60%Sep-202031,8236.46%29,000109.73%
49
Feb-201812,5939,691-2,90226.05%Oct-202030,292-4.81%30,000100.97%
50
Mar-201813,95511,025-2,93023.46%Nov-202032,8378.40%31,000105.93%
51
Apr-201814,61711,397-3,22024.76%Dec-202029,873-9.03%30,00099.58%
52
May-201813,54310,731-2,81223.17%
53
Jun-201816,13712,501-3,63625.39%
54
Jul-201815,06511,859-3,20623.82%
55
Aug-201815,91912,448-3,47124.47%
56
Sep-201818,44114,364-4,07724.86%
57
Oct-201817,73613,980-3,75623.69%
58
Nov-201817,76514,102-3,66322.99%
59
Dec-201821,16716,640-4,52723.95%
60
Jan-201912,2819,662-2,61923.87%
61
Feb-201914,01610,884-3,13225.16%
62
Mar-201915,25612,065-3,19123.36%
63
Apr-201914,73911,360-3,37925.89%
64
May-201916,46312,946-3,51723.92%
65
Jun-201916,82013,008-3,81225.56%
66
Jul-201917,01813,222-3,79625.11%
67
Aug-201917,46913,482-3,98725.76%
68
Sep-201919,83615,585-4,25124.00%
69
Oct-201919,68915,320-4,36924.96%
70
Nov-201921,04316,444-4,59924.54%
71
Dec-201922,42317,548-4,87524.39%
72
Jan-202014,27311,129-3,14424.75%
73
Feb-202016,72813,039-3,68924.79%
74
Mar-202023,42618,314-5,11224.49%
75
Apr-202025,44020,241-5,19922.76%
76
77
GSC vs Analytics Data Check (Example 2)CONCLUSION: Strong Correlation
78
Month
Organic sessions (GA)
Clicks (GSC)difference% differenceCORREL=
79
Jan-201710,2347,781-2,45327.23%0.5497219829
80
Feb-201710,9508,541-2,40924.72%
Correlation nowhere close to 1
81
Mar-201711,8269,198-2,62825.00%
STANDARD DEVIATION=
82
Apr-201712,1819,261-2,92027.24%0.1560020166
83
May-201713,27710,453-2,82423.80%
Standard deviation is higher than in example 1
84
Jun-201713,67510,440-3,23526.83%
85
Jul-201713,94910,856-3,09324.94%
86
Aug-201714,08811,164-2,92423.16%
87
Sep-201715,49712,123-3,37424.43%
88
Oct-201716,27212,640-3,63225.12%0.9964643419
89
Nov-201717,24813,558-3,69023.96%
90
Dec-201717,93813,962-3,97624.93%
91
Jan-201812,1789,319-2,85926.60%
92
Feb-201812,5939,691-2,90226.05%
93
Mar-201813,95511,025-2,93023.46%
94
Apr-201814,61711,397-3,22024.76%
95
May-201813,54310,731-2,81223.17%
96
Jun-201816,13712,501-3,63625.39%
97
Jul-201815,06511,859-3,20623.82%
98
Aug-20186,04312,4486,40569.28%SOMETHING WRONG IS HERE. PROBABLY GA DIDN'T GATHER DATA CORRECTLY (CHECK COOKIES CONSENT, ETC).....
99
Sep-20188,49514,3645,86951.35%
100
Oct-20187,56413,9806,41659.56%