Starting from tomorrow I’ll be sharing 1 SEO tip/tool/advice per day for 30 days. ✌️
None of this is scheduled, so I’ll be thinking of something daily, alongside a gif (obviously). Hope you find them useful 🙏👇
None of this is scheduled, so I’ll be thinking of something daily, alongside a gif (obviously). Hope you find them useful 🙏👇
1/30 a biggie; forecasting. Always start with your knowns.
For most of us that's historical data in GA.
You can start simple in Sheets with =forecast() and then apply a seasonality index from the average. Use that as the basis for developing ranking scenarios thereafter.
For most of us that's historical data in GA.
You can start simple in Sheets with =forecast() and then apply a seasonality index from the average. Use that as the basis for developing ranking scenarios thereafter.
I've actually started this whole thread off with an error 😂 make sure your average is an absolute cell reference. Doh!
3/30 The Xpath Helper extension in Chrome is super handy for extracting lists of data quickly, particularly if you have very little knowledge of Xpath. 🤖✨
In the GIF, I've used it to quickly get the primary category names from Amazon's full shop directory.
In the GIF, I've used it to quickly get the primary category names from Amazon's full shop directory.
4/30 Search intent isn't fixed. It varies on changes in demand. We can only speculate on how Google determines this but you should adapt your strategies for it.
eg. travel intent has shifted from booking to advice + info
Track and predict intent, then optimise accordingly. 🚀
eg. travel intent has shifted from booking to advice + info
Track and predict intent, then optimise accordingly. 🚀
5/30 a very basic way of defining which internal pages Google believes are relevant to a search query is to use the "site:" operator.
Not only can you quickly understand whether pages should *potentially* link to each other but it's also a good way of finding duplicates 💡
Not only can you quickly understand whether pages should *potentially* link to each other but it's also a good way of finding duplicates 💡
6/30 if you're looking to estimate organic traffic for a competitor, SimilarWeb has scarily accurate data 👻
Take the estimated total visits * traffic by country * traffic by channel.
All of this can be automated using the @dataforseo API.
Take the estimated total visits * traffic by country * traffic by channel.
All of this can be automated using the @dataforseo API.
7/30 I believe @dsottimano also dropped this one at #TTTlive and it can be incredibly useful.
If you add:
document.designMode="on"
to the Console in Chrome Dev Tools, you can edit your website live in Google Chrome💡
If you add:
document.designMode="on"
to the Console in Chrome Dev Tools, you can edit your website live in Google Chrome💡
8/30 Start with the conclusion in your SEO strategy presentations. 👈👈
Inductive reasoning packs a lot more punch. 👊✨
Inductive reasoning packs a lot more punch. 👊✨
9/30 you can calculate CTR outliers in Sheets using a CTR curve.
With GSC data, plot CTR/Avg. pos. in a scatter chart. Use power trendline and display R2 equation. Use equation to find residual values (check gif).
High residual values = high CTR
Low residual values = low CTR
With GSC data, plot CTR/Avg. pos. in a scatter chart. Use power trendline and display R2 equation. Use equation to find residual values (check gif).
High residual values = high CTR
Low residual values = low CTR
10/30 you can measure the statistical significance of SEO experiments using Bayesian time-series modelling.
A no-code way of doing this is using gallery.shinyapps.io/ga-effect/ by @HoloMarkeD to add your control & variant GA segments and select the date your experiment started. 🔥
A no-code way of doing this is using gallery.shinyapps.io/ga-effect/ by @HoloMarkeD to add your control & variant GA segments and select the date your experiment started. 🔥
11/30 Google autocomplete is underutilised to help understand current brand intent & sentiment.
You can use it to discover common or trending searches associated with your brand right now, to create content that protects, informs and inspires.
What should Barnard Castle do?
You can use it to discover common or trending searches associated with your brand right now, to create content that protects, informs and inspires.
What should Barnard Castle do?
12/30 Performance is relative. It's important to understand your client's position in a market; the opportunity for growth and/or expansion into new markets. 🚀
@semrush has done a fantastic job of helping with this with their Market Explorer report.
semrush.com/market-explore…
@semrush has done a fantastic job of helping with this with their Market Explorer report.
semrush.com/market-explore…
13/30 you should stress test your SEO hypothesis before you waste time digging deep into the data.
Ask, what assumptions am I making that need to be true, in order for my hypothesis to be true. 💡
Using this simple test, you can quickly discover whether it’s worth pursuing.
Ask, what assumptions am I making that need to be true, in order for my hypothesis to be true. 💡
Using this simple test, you can quickly discover whether it’s worth pursuing.
14/30 Redirects during a large migration can be painstaking. You can do a lot of the pattern matching using G Sheets but it can be ineffective at scale.
getredirects.com can match thousands of URLs from your legacy website -> new. 🔥
getredirects.com can match thousands of URLs from your legacy website -> new. 🔥
15/30 HALF WAY THERE 🎉
If you're interested to see where you'd rank if you didn't own the featured snippet add:
&num=9 to the URL in Incognito.
If you're interested to see where you'd rank if you didn't own the featured snippet add:
&num=9 to the URL in Incognito.
16/30 An oldie but goodie 🙃
Want to see competitor GMB categories? 🔥
1. Head over to G Maps 📍
2. Enter your competitor 🏆
3. View source 🤖
4. Cmd/Ctrl + F 'primary category' 🔎
Want to see competitor GMB categories? 🔥
1. Head over to G Maps 📍
2. Enter your competitor 🏆
3. View source 🤖
4. Cmd/Ctrl + F 'primary category' 🔎
17/30 You can thank @Kevin_Indig for this one!
With an organic keywords export from @ahrefs you can use SERP features to classify intent with a simple IF formula.
eg. Shopping = Do, Buy / Featured Snippet = Know Simple
READ: kevin-indig.com/user-intent-ma…
With an organic keywords export from @ahrefs you can use SERP features to classify intent with a simple IF formula.
eg. Shopping = Do, Buy / Featured Snippet = Know Simple
READ: kevin-indig.com/user-intent-ma…
18/30 Know which search results you can own and which search results you need to rent.
Commercial investigative query modifiers can be a good way of segmenting rent vs buy.
Across some markets, modifiers such as 'best' are almost exclusively owned by affiliates.
Commercial investigative query modifiers can be a good way of segmenting rent vs buy.
Across some markets, modifiers such as 'best' are almost exclusively owned by affiliates.
19/30 Don't take organic data in GA at face value.
Image search traffic could be skewing your conversion rate as shown by @ajkohn blindfiveyearold.com/the-problem-wi…
Safari ITP could be skewing your attribution. simoahava.com/analytics/itp-…
Better data, better results. 👍
Image search traffic could be skewing your conversion rate as shown by @ajkohn blindfiveyearold.com/the-problem-wi…
Safari ITP could be skewing your attribution. simoahava.com/analytics/itp-…
Better data, better results. 👍
20/30 Regex in GA can be incredibly useful.
For ecom sites in particular, using REGEX to match the number of subfolders can give you a ton of insight 🚀
1 subfolder: ^/[^/]+/$
2 subfolders: ^/[^/]+/[^/]+/$
1 subfolder (no trailing slash): ^/[^/]+/[^/]+[a-zA-Z0-9]$
For ecom sites in particular, using REGEX to match the number of subfolders can give you a ton of insight 🚀
1 subfolder: ^/[^/]+/$
2 subfolders: ^/[^/]+/[^/]+/$
1 subfolder (no trailing slash): ^/[^/]+/[^/]+[a-zA-Z0-9]$
21/30 Structure your keyword data and group by position.
Page 2 = quick wins 💨
Page 3+ = longer term opps ⏰
You can usually find some keyword gems > page 2. Keywords where landing pages aren’t as relevant as they could be and a more specific landing page will rank better.
Page 2 = quick wins 💨
Page 3+ = longer term opps ⏰
You can usually find some keyword gems > page 2. Keywords where landing pages aren’t as relevant as they could be and a more specific landing page will rank better.
22/30 understand cannibalisation and opportunities within your affiliate, reseller & marketplace mix in search.
1. can you outrank partners to increase your profit?💰
2. can you increase your search coverage to increase your avg. CTR in search results? 📈
1. can you outrank partners to increase your profit?💰
2. can you increase your search coverage to increase your avg. CTR in search results? 📈
23/30 Dev teams taking too long or you want to implement a test quickly? Google Tag Manager can be a good, free way to:
Add noindex tags ⛔
Change page templates and content ✍️
Create dynamic meta titles 🔍
& more 🔥
Also check out sloth.cloud by @salt_agency
Add noindex tags ⛔
Change page templates and content ✍️
Create dynamic meta titles 🔍
& more 🔥
Also check out sloth.cloud by @salt_agency
24/30 Topical authority is so important!
One way to identify where you're topically relevant in GSC is to look at which search query classes you tend to rank well for. ie. bike hire [location] 🚴
These are repeatable query patterns you can use to scale your SEO campaigns. 💥
One way to identify where you're topically relevant in GSC is to look at which search query classes you tend to rank well for. ie. bike hire [location] 🚴
These are repeatable query patterns you can use to scale your SEO campaigns. 💥
25/30 Ahhhh good old duplication. 🤦
Search console is a great way to identify multiple pages ranking for the same query, and potential cannibalisation.
I believe I may have got this function and rejigged it a bit from @ahrefs - go deduplicate! (client info blanked out)👇
Search console is a great way to identify multiple pages ranking for the same query, and potential cannibalisation.
I believe I may have got this function and rejigged it a bit from @ahrefs - go deduplicate! (client info blanked out)👇
26/30 keyword = (not provided) 😭
To get this data back in GA use keyword-hero.com
I really love the brain behind this tool and it matches between 80-85% of keywords with sessions. 🧠
To get this data back in GA use keyword-hero.com
I really love the brain behind this tool and it matches between 80-85% of keywords with sessions. 🧠
27/30 Use image tags in Google Images to find related entities, especially for visual searches.
If we take a query like 'chicken recipes' we see related entities such as 'easy' & 'healthy'. These are cues on what you should include in your content or use to develop an info hub.
If we take a query like 'chicken recipes' we see related entities such as 'easy' & 'healthy'. These are cues on what you should include in your content or use to develop an info hub.
28/30 Be aware of the refinement options for your target keywords, as Google locks you into their ecosystem. More than ever, you need to be visible for refined search queries as users dig deeper.
For 'adidas trainers' this could be -> Originals -> Originals Gazelle 👟
For 'adidas trainers' this could be -> Originals -> Originals Gazelle 👟
29/30 A smarter way to use G Translate for international projects!
Install the G Translate Chrome extension so that you can translate all of the keywords in your tool of choice.
Use the G Translate function in G Sheets to translate at scale eg. =googletranslate(A2,"auto","fr")
Install the G Translate Chrome extension so that you can translate all of the keywords in your tool of choice.
Use the G Translate function in G Sheets to translate at scale eg. =googletranslate(A2,"auto","fr")
30/30 Last one!
My biggest piece of advice is to keep on learning. All of my tips have ultimately came from others, or things I've picked up along the way. 📖 🚀
Hope you got some use out of them! (though I did miss a few days) 😄
My biggest piece of advice is to keep on learning. All of my tips have ultimately came from others, or things I've picked up along the way. 📖 🚀
Hope you got some use out of them! (though I did miss a few days) 😄
