π Director: @crawlseo β¨ Co-Founder: @sheet_copilot π¨βπ» Chief of Scripts: https://t.co/X6TC17szR7 π Forecasting For SEO Course
3 subscribers
Feb 1, 2024 β’ 10 tweets β’ 3 min read
Say hello to Sheet Copilot β¨
Use AI to run tasks in Google Sheets.
Tell @sheet_copilot what you want it to do, and it'll do it!
Oh, and it's FREE in Beta. Just plug in your OpenAI key.
Find out more:
This has been over a year in the making:
1. We started with using AI for formula generation and code execution in Google Sheets.
2. Then we built a chat interface for Google Sheets to analyse data and help with formulas.
It never felt like we realised our initial vision.
Jun 7, 2023 β’ 10 tweets β’ 3 min read
Formula God (BETA) is now live π
Talk to Google Sheets with AI and discover spreadsheet omnipotence β¨
Ask Formula God to grant:
β’ Complex 'if' statements
β’ Effortless data sorting
β’ Data insight & analysis
β’ and much more
Let's dive into what it can do...
1/ Summary stats simplified across columns
Jan 27, 2022 β’ 10 tweets β’ 3 min read
Can we rank? π€·ββοΈ
A question every SEO asks themselves, or gets asked.
Don't blindly follow third party keyword difficulty metrics. There's more you can do!
Here's 7 other ways you can approach it...π§΅π
Just before I start, I'm not against keyword difficulty metrics from platforms.
They're great for quickly filtering keywords, and do tend to correlate pretty well.
But there's more you can learn from SERPs to get the full picture.
Jan 11, 2022 β’ 23 tweets β’ 5 min read
Two of the most common questions I'm asked from clients are:
"What will be the impact? And how long will it take?"
Here's how I go about answering them...(it's complicated) π§΅π
The answer depends on the situation:
1οΈβ£ Is the expected impact from one change or a strategy?
2οΈβ£ Is the relationship with the client new or old?
3οΈβ£ Is the website new or old?
4οΈβ£ Is the website small or large?
These questions are critical for confidence of impact & timeline.
Dec 29, 2021 β’ 18 tweets β’ 6 min read
In 2021 I released Keywords in Sheets and published 17 scripts & templates to over 10k SEOs.
Here they are ππ§΅...
Append your keywords with all locations, from any country.
With this script you can input your target keyword and any country, and it will return your target keyword appended by all of the locations from the country, in seconds. π
Nov 10, 2021 β’ 7 tweets β’ 3 min read
10 Google Analytics tips for SEOs to help you track performance better π‘
1/ Use Acquisition -> Channels -> Organic Search vs an Organic Search segment to avoid sampling.
2/ Annotate now and add annotations retrospectively. They help with forecasting and benchmarking.
π§΅...
3/ If you get a high proportion of mobile traffic, Safari is likely messing with your attribution.
10 things / tips about Search Console performance data you mightn't know about π‘
1/ Position is only recorded when an impression is recorded.
2/ If you only operate in one country, your data will be skewed by default. Filter by country.
π§΅...
3/ Position is calculated on the left (primary side) top-to-bottom and then then on right side.
4/ If there's many pages ranking for the same query, Search Console records the best position. When it aggregates avg. position, it averages the best position across queries.
Oct 27, 2021 β’ 5 tweets β’ 2 min read
Sneak Peek...Keywords in Sheets Add-On π π
This is one of many functions; search volume, with a difference π
Get search volume & growth metrics for 1000s of keywords, across any location. π
What metrics does it include π
π Avg. 12 months sv, Avg. last 3 months sv, last month sv.
π Last 12 month sv.
π CPC.
π Growth from initial & quarterly growth.
π Keyword Age (< 12 month).
Jan 24, 2021 β’ 19 tweets β’ 3 min read
Some lessons Iβve learned from my time working in SEO.
BΜΆrΜΆaΜΆiΜΆnΜΆ DΜΆuΜΆmΜΆpΜΆ A Thread...π
Remember to check for this on migration day:
Disallow: /
Usually a low priority for devs, but a high priority for SEOs.
Look twice, migrate once.
Jan 12, 2021 β’ 11 tweets β’ 5 min read
New from me:
Iβm launching my Forecasting For SEO course next month.
Itβs everything Iβve learned, tried and tested about SEO forecasting.
Drill down functionality in Data Studio is super useful for quickly seeing the keywords URLs rank for! π₯
Thread π
1/
You can drill down in the @ahrefs top pages report (which is great) but it's nice to be able to brand it in a Data Studio report and manipulate the data as you see fit.
Here's how I done it on a Danish website
May 11, 2020 β’ 32 tweets β’ 15 min read
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 ππ
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.
