A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 Year | Organic Traffic Year Over Year (Linear) with Target | Organic Traffic Penetration | Geo Penetration | |||||||||||||||||||||||||||||
3 | Month | Year 2017 | Year 2018 | Year 2019 | Year 2020 | Month | Organic sessions | % growth (MoM) | Target | % on target | Month | Organic Traffic | All Traffic | Non Organic Traffic | % organic | % non organic | Country or Area | Internet Users | Qualified Organic Traffic | Penetration | |||||||||||||
4 | January | 10,234 | 12,178 | 12,281 | 14,273 | Jan-2017 | 10,234 | 10,234 | 100.00% | Jan-2017 | 10,234 | 35,254 | 25,020 | 29.03% | 70.97% | Jamaica | 1,409,888 | 3,423 | 2.43 | ||||||||||||||
5 | February | 10,950 | 12,593 | 14,016 | 16,728 | Feb-2017 | 10,950 | 7.00% | 9,527 | 114.94% | Feb-2017 | 10,950 | 25,179 | 14,229 | 43.49% | 56.51% | Bahrain | 1,431,090 | 2,365 | 1.65 | |||||||||||||
6 | March | 11,826 | 13,955 | 15,256 | 23,426 | Mar-2017 | 11,826 | 8.00% | 11,471 | 103.09% | Mar-2017 | 11,826 | 27,579 | 15,753 | 42.88% | 57.12% | Japan | 115,845,120 | 100,456 | 0.87 | |||||||||||||
7 | April | 12,181 | 14,617 | 14,739 | 24,342 | Apr-2017 | 12,181 | 3.00% | 12,668 | 96.16% | Apr-2017 | 12,181 | 26,214 | 14,033 | 46.47% | 53.53% | Germany | 69,304,405 | 35,928 | 0.52 | |||||||||||||
8 | May | 13,277 | 13,543 | 16,463 | 26,762 | May-2017 | 13,277 | 9.00% | 14,472 | 91.74% | May-2017 | 13,277 | 29,766 | 16,489 | 44.60% | 55.40% | Poland | 29,005,924 | 10,452 | 0.36 | |||||||||||||
9 | June | 13,675 | 16,137 | 16,820 | 25,453 | Jun-2017 | 13,675 | 3.00% | 14,769 | 92.59% | Jun-2017 | 13,675 | 33,028 | 19,353 | 41.40% | 58.60% | United Kingdom | 62,621,016 | 20,345 | 0.32 | |||||||||||||
10 | July | 13,949 | 15,065 | 17,018 | 27,893 | Organic Traffic Year Over Year (Yearly) | Jul-2017 | 13,949 | 2.00% | 13,252 | 105.26% | Jul-2017 | 13,949 | 30,211 | 16,262 | 46.17% | 53.83% | United States | 244,090,854 | 50,234 | 0.21 | ||||||||||||
11 | August | 14,088 | 15,919 | 17,469 | 29,893 | Year | Organic Traffic | % Growth | Target | % on target | Aug-2017 | 14,088 | 1.00% | 16,201 | 86.96% | Aug-2017 | 14,088 | 26,749 | 12,661 | 52.67% | 47.33% | Russia | 109,446,612 | 20,374 | 0.19 | ||||||||
12 | September | 15,497 | 18,441 | 19,836 | 31,823 | Year 2017 | 167,135 | 150,000 | 111.42% | Sep-2017 | 15,497 | 10.00% | 17,047 | 90.91% | Sep-2017 | 15,497 | 38,740 | 23,243 | 40.00% | 60.00% | Brazil | 141,206,801 | 20,045 | 0.14 | |||||||||
13 | October | 16,272 | 17,736 | 19,689 | 30,292 | Year 2018 | 189,116 | 13.15% | 190,000 | 99.53% | Oct-2017 | 16,272 | 5.00% | 15,133 | 107.53% | Oct-2017 | 16,272 | 35,040 | 18,768 | 46.44% | 53.56% | India | 706,620,000 | 70,346 | 0.10 | ||||||||
14 | November | 17,248 | 17,765 | 21,043 | 32,837 | Year 2019 | 207,053 | 9.48% | 210,000 | 98.60% | Nov-2017 | 17,248 | 6.00% | 16,731 | 103.09% | Nov-2017 | 17,248 | 39,868 | 22,620 | 43.26% | 56.74% | Pakistan | 76,381,089 | 5,673 | 0.07 | ||||||||
15 | December | 17,938 | 21,167 | 22,423 | 29,873 | Year 2020 | 940,785 | 354.37% | 240,000 | 391.99% | Dec-2017 | 17,938 | 4.00% | 20,091 | 89.28% | Dec-2017 | 17,938 | 36,067 | 18,129 | 49.74% | 50.26% | China | 840,080,566 | 50,029 | 0.06 | ||||||||
16 | Jan-2018 | 12,178 | -32.11% | 13,883 | 87.72% | Jan-2018 | 12,178 | 19,638 | 7,460 | 62.01% | 37.99% | ||||||||||||||||||||||
17 | Feb-2018 | 12,593 | 3.41% | 11,082 | 113.63% | Feb-2018 | 12,593 | 21,734 | 9,141 | 57.94% | 42.06% | ||||||||||||||||||||||
18 | Mar-2018 | 13,955 | 10.82% | 12,839 | 108.69% | Mar-2018 | 13,955 | 32,315 | 18,360 | 43.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-2018 | 14,617 | 4.74% | 13,155 | 111.11% | Apr-2018 | 14,617 | 27,143 | 12,526 | 53.85% | 46.15% | Qualified traffic means traffic only from specific country. | |||||||||||||||||||||
20 | May-2018 | 13,543 | -7.35% | 13,949 | 97.09% | May-2018 | 13,543 | 22,292 | 8,749 | 60.75% | 39.25% | In Example: For China 50,029 sessions in GA must be marked as traffic from China | |||||||||||||||||||||
21 | Jun-2018 | 16,137 | 19.15% | 18,558 | 86.95% | Jun-2018 | 16,137 | 34,339 | 18,202 | 46.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-2018 | 15,065 | -6.64% | 16,120 | 93.46% | Jul-2018 | 15,065 | 24,695 | 9,630 | 61.01% | 38.99% | Highest traffic doesn't mean its the best result | |||||||||||||||||||||
23 | Aug-2018 | 15,919 | 5.67% | 14,964 | 106.38% | Aug-2018 | 15,919 | 32,048 | 16,129 | 49.67% | 50.33% | ||||||||||||||||||||||
24 | Sep-2018 | 18,441 | 15.84% | 18,441 | 100.00% | Sep-2018 | 18,441 | 38,775 | 20,334 | 47.56% | 52.44% | ||||||||||||||||||||||
25 | Oct-2018 | 17,736 | -3.82% | 18,445 | 96.16% | Oct-2018 | 17,736 | 31,523 | 13,787 | 56.26% | 43.74% | ||||||||||||||||||||||
26 | Nov-2018 | 17,765 | 0.16% | 17,054 | 104.17% | Nov-2018 | 17,765 | 34,425 | 16,660 | 51.61% | 48.39% | ||||||||||||||||||||||
27 | Dec-2018 | 21,167 | 19.15% | 19,262 | 109.89% | Dec-2018 | 21,167 | 39,951 | 18,784 | 52.98% | 47.02% | ||||||||||||||||||||||
28 | Jan-2019 | 12,281 | -41.98% | 12,895 | 95.24% | Jan-2019 | 12,281 | 15,723 | 3,442 | 78.11% | 21.89% | ||||||||||||||||||||||
29 | Feb-2019 | 14,016 | 14.13% | 14,156 | 99.01% | Feb-2019 | 14,016 | 20,219 | 6,203 | 69.32% | 30.68% | ||||||||||||||||||||||
30 | Mar-2019 | 15,256 | 8.85% | 13,730 | 111.11% | Mar-2019 | 15,256 | 29,026 | 13,770 | 52.56% | 47.44% | ||||||||||||||||||||||
31 | Apr-2019 | 14,739 | -3.39% | 16,508 | 89.28% | Apr-2019 | 14,739 | 20,826 | 6,087 | 70.77% | 29.23% | ||||||||||||||||||||||
32 | May-2019 | 16,463 | 11.70% | 14,158 | 116.28% | May-2019 | 16,463 | 27,716 | 11,253 | 59.40% | 40.60% | ||||||||||||||||||||||
33 | Jun-2019 | 16,820 | 2.17% | 15,474 | 108.70% | Jun-2019 | 16,820 | 27,033 | 10,213 | 62.22% | 37.78% | ||||||||||||||||||||||
34 | GSC vs Analytics Data Check (Example 1) | CONCLUSION: Data is correct because of strong correlation | Jul-2019 | 17,018 | 1.18% | 19,060 | 89.29% | Jul-2019 | 17,018 | 29,071 | 12,053 | 58.54% | 41.46% | ||||||||||||||||||||
35 | Month | Organic sessions (GA) | Clicks (GSC) | difference | % difference | CORREL= | Aug-2019 | 17,469 | 2.65% | 16,945 | 103.09% | Aug-2019 | 17,469 | 25,933 | 8,464 | 67.36% | 32.64% | ||||||||||||||||
36 | Jan-2017 | 10,234 | 7,781 | -2,453 | 27.23% | 0.9990686127 | Sep-2019 | 19,836 | 13.55% | 19,241 | 103.09% | Sep-2019 | 19,836 | 29,927 | 10,091 | 66.28% | 33.72% | ||||||||||||||||
37 | Feb-2017 | 10,950 | 8,541 | -2,409 | 24.72% | If correlation is close to 1 then GA gather data correctly | Oct-2019 | 19,689 | -0.74% | 20,280 | 97.09% | Oct-2019 | 19,689 | 34,011 | 14,322 | 57.89% | 42.11% | ||||||||||||||||
38 | Mar-2017 | 11,826 | 9,198 | -2,628 | 25.00% | STANDARD DEVIATION= | Nov-2019 | 21,043 | 6.88% | 17,887 | 117.64% | Nov-2019 | 21,043 | 31,032 | 9,989 | 67.81% | 32.19% | ||||||||||||||||
39 | Apr-2017 | 12,181 | 9,261 | -2,920 | 27.24% | 0.01109230116 | Dec-2019 | 22,423 | 6.56% | 21,526 | 104.17% | Dec-2019 | 22,423 | 33,913 | 11,490 | 66.12% | 33.88% | ||||||||||||||||
40 | May-2017 | 13,277 | 10,453 | -2,824 | 23.80% | Standard deviation of % difference is very low so expected growth is very predictable | Jan-2020 | 14,273 | -36.35% | 12,132 | 117.65% | Jan-2020 | 14,273 | 13,212 | 5,432 | 108.03% | 41.11% | ||||||||||||||||
41 | Jun-2017 | 13,675 | 10,440 | -3,235 | 26.83% | Feb-2020 | 16,728 | 17.20% | 15,557 | 107.53% | Feb-2020 | 16,728 | 24,687 | 7,959 | 67.76% | 32.24% | |||||||||||||||||
42 | Jul-2017 | 13,949 | 10,856 | -3,093 | 24.94% | Mar-2020 | 23,426 | 40.04% | 20,146 | 116.28% | Mar-2020 | 23,426 | 42,308 | 18,882 | 55.37% | 44.63% | |||||||||||||||||
43 | Aug-2017 | 14,088 | 11,164 | -2,924 | 23.16% | Apr-2020 | 24,342 | 3.91% | 29,002 | 83.93% | Apr-2020 | 24,342 | 43,239 | 18,897 | 56.30% | 43.70% | |||||||||||||||||
44 | Sep-2017 | 15,497 | 12,123 | -3,374 | 24.43% | May-2020 | 26,762 | 9.94% | 25,000 | 107.05% | |||||||||||||||||||||||
45 | Oct-2017 | 16,272 | 12,640 | -3,632 | 25.12% | Jun-2020 | 25,453 | -4.89% | 26,000 | 97.90% | |||||||||||||||||||||||
46 | Nov-2017 | 17,248 | 13,558 | -3,690 | 23.96% | Jul-2020 | 27,893 | 9.59% | 27,000 | 103.31% | |||||||||||||||||||||||
47 | Dec-2017 | 17,938 | 13,962 | -3,976 | 24.93% | Aug-2020 | 29,893 | 7.17% | 28,000 | 106.76% | |||||||||||||||||||||||
48 | Jan-2018 | 12,178 | 9,319 | -2,859 | 26.60% | Sep-2020 | 31,823 | 6.46% | 29,000 | 109.73% | |||||||||||||||||||||||
49 | Feb-2018 | 12,593 | 9,691 | -2,902 | 26.05% | Oct-2020 | 30,292 | -4.81% | 30,000 | 100.97% | |||||||||||||||||||||||
50 | Mar-2018 | 13,955 | 11,025 | -2,930 | 23.46% | Nov-2020 | 32,837 | 8.40% | 31,000 | 105.93% | |||||||||||||||||||||||
51 | Apr-2018 | 14,617 | 11,397 | -3,220 | 24.76% | Dec-2020 | 29,873 | -9.03% | 30,000 | 99.58% | |||||||||||||||||||||||
52 | May-2018 | 13,543 | 10,731 | -2,812 | 23.17% | ||||||||||||||||||||||||||||
53 | Jun-2018 | 16,137 | 12,501 | -3,636 | 25.39% | ||||||||||||||||||||||||||||
54 | Jul-2018 | 15,065 | 11,859 | -3,206 | 23.82% | ||||||||||||||||||||||||||||
55 | Aug-2018 | 15,919 | 12,448 | -3,471 | 24.47% | ||||||||||||||||||||||||||||
56 | Sep-2018 | 18,441 | 14,364 | -4,077 | 24.86% | ||||||||||||||||||||||||||||
57 | Oct-2018 | 17,736 | 13,980 | -3,756 | 23.69% | ||||||||||||||||||||||||||||
58 | Nov-2018 | 17,765 | 14,102 | -3,663 | 22.99% | ||||||||||||||||||||||||||||
59 | Dec-2018 | 21,167 | 16,640 | -4,527 | 23.95% | ||||||||||||||||||||||||||||
60 | Jan-2019 | 12,281 | 9,662 | -2,619 | 23.87% | ||||||||||||||||||||||||||||
61 | Feb-2019 | 14,016 | 10,884 | -3,132 | 25.16% | ||||||||||||||||||||||||||||
62 | Mar-2019 | 15,256 | 12,065 | -3,191 | 23.36% | ||||||||||||||||||||||||||||
63 | Apr-2019 | 14,739 | 11,360 | -3,379 | 25.89% | ||||||||||||||||||||||||||||
64 | May-2019 | 16,463 | 12,946 | -3,517 | 23.92% | ||||||||||||||||||||||||||||
65 | Jun-2019 | 16,820 | 13,008 | -3,812 | 25.56% | ||||||||||||||||||||||||||||
66 | Jul-2019 | 17,018 | 13,222 | -3,796 | 25.11% | ||||||||||||||||||||||||||||
67 | Aug-2019 | 17,469 | 13,482 | -3,987 | 25.76% | ||||||||||||||||||||||||||||
68 | Sep-2019 | 19,836 | 15,585 | -4,251 | 24.00% | ||||||||||||||||||||||||||||
69 | Oct-2019 | 19,689 | 15,320 | -4,369 | 24.96% | ||||||||||||||||||||||||||||
70 | Nov-2019 | 21,043 | 16,444 | -4,599 | 24.54% | ||||||||||||||||||||||||||||
71 | Dec-2019 | 22,423 | 17,548 | -4,875 | 24.39% | ||||||||||||||||||||||||||||
72 | Jan-2020 | 14,273 | 11,129 | -3,144 | 24.75% | ||||||||||||||||||||||||||||
73 | Feb-2020 | 16,728 | 13,039 | -3,689 | 24.79% | ||||||||||||||||||||||||||||
74 | Mar-2020 | 23,426 | 18,314 | -5,112 | 24.49% | ||||||||||||||||||||||||||||
75 | Apr-2020 | 25,440 | 20,241 | -5,199 | 22.76% | ||||||||||||||||||||||||||||
76 | |||||||||||||||||||||||||||||||||
77 | GSC vs Analytics Data Check (Example 2) | CONCLUSION: Strong Correlation | |||||||||||||||||||||||||||||||
78 | Month | Organic sessions (GA) | Clicks (GSC) | difference | % difference | CORREL= | |||||||||||||||||||||||||||
79 | Jan-2017 | 10,234 | 7,781 | -2,453 | 27.23% | 0.5497219829 | |||||||||||||||||||||||||||
80 | Feb-2017 | 10,950 | 8,541 | -2,409 | 24.72% | Correlation nowhere close to 1 | |||||||||||||||||||||||||||
81 | Mar-2017 | 11,826 | 9,198 | -2,628 | 25.00% | STANDARD DEVIATION= | |||||||||||||||||||||||||||
82 | Apr-2017 | 12,181 | 9,261 | -2,920 | 27.24% | 0.1560020166 | |||||||||||||||||||||||||||
83 | May-2017 | 13,277 | 10,453 | -2,824 | 23.80% | Standard deviation is higher than in example 1 | |||||||||||||||||||||||||||
84 | Jun-2017 | 13,675 | 10,440 | -3,235 | 26.83% | ||||||||||||||||||||||||||||
85 | Jul-2017 | 13,949 | 10,856 | -3,093 | 24.94% | ||||||||||||||||||||||||||||
86 | Aug-2017 | 14,088 | 11,164 | -2,924 | 23.16% | ||||||||||||||||||||||||||||
87 | Sep-2017 | 15,497 | 12,123 | -3,374 | 24.43% | ||||||||||||||||||||||||||||
88 | Oct-2017 | 16,272 | 12,640 | -3,632 | 25.12% | 0.9964643419 | |||||||||||||||||||||||||||
89 | Nov-2017 | 17,248 | 13,558 | -3,690 | 23.96% | ||||||||||||||||||||||||||||
90 | Dec-2017 | 17,938 | 13,962 | -3,976 | 24.93% | ||||||||||||||||||||||||||||
91 | Jan-2018 | 12,178 | 9,319 | -2,859 | 26.60% | ||||||||||||||||||||||||||||
92 | Feb-2018 | 12,593 | 9,691 | -2,902 | 26.05% | ||||||||||||||||||||||||||||
93 | Mar-2018 | 13,955 | 11,025 | -2,930 | 23.46% | ||||||||||||||||||||||||||||
94 | Apr-2018 | 14,617 | 11,397 | -3,220 | 24.76% | ||||||||||||||||||||||||||||
95 | May-2018 | 13,543 | 10,731 | -2,812 | 23.17% | ||||||||||||||||||||||||||||
96 | Jun-2018 | 16,137 | 12,501 | -3,636 | 25.39% | ||||||||||||||||||||||||||||
97 | Jul-2018 | 15,065 | 11,859 | -3,206 | 23.82% | ||||||||||||||||||||||||||||
98 | Aug-2018 | 6,043 | 12,448 | 6,405 | 69.28% | SOMETHING WRONG IS HERE. PROBABLY GA DIDN'T GATHER DATA CORRECTLY (CHECK COOKIES CONSENT, ETC)..... | |||||||||||||||||||||||||||
99 | Sep-2018 | 8,495 | 14,364 | 5,869 | 51.35% | ||||||||||||||||||||||||||||
100 | Oct-2018 | 7,564 | 13,980 | 6,416 | 59.56% |