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.

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

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.

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.

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. 🚀

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.

4/ If you get a high proportion of Google Image traffic, it's likely messing with your conversion rate. blindfiveyearold.com/the-problem-wi…

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.

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).

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.

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.

The course: futurethought.io/forecasting-fo…

Following along 👇 Why forecasting?

Last year I launched futurethought.io to provide reliable forecasts to SEO teams.

It went crazy.

I also noticed an appetite for learning more about forecasting and reached out on Twitter to gauge interest:

https://twitter.com/bertiecharlton/status/1337771500116578305

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

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.