Aleyda Solis πŸ•ŠοΈ Profile picture
Dec 10, 2021 β€’ 8 tweets β€’ 6 min read β€’ Read on X
Are you forecasting your organic search traffic/conversions/revenue for next year?

Here are a few Free SEO forecasting templates, guides and easy to use resources to help you:

πŸ”­ SEO Forecasting in Google Sheets - A template by @THCapper

moz.com/blog/seo-forec…

...
...

πŸ”­ A Quick Guide to SEO Forecasting + A Free Google Sheets Template by @helpyourhumans

morphio.ai/blog/seo-forec…

...
...

πŸ”­ How to Forecast SEO Potential With Google Data Studio by @seocounseling [With Template]

searchenginejournal.com/forecast-seo-d…

...
...

πŸ”­ Auto-SEO forecasting with StreamProphet! A @streamlit Web app using Google Search Console data πŸš€ by @DataChaz

charlywargnier.com/post/auto-seo-…
...

πŸ”­ Forecasting For SEO – Creating expectation and showing return on investment (ROI) by @mira_inam - Learn how to forecast from scratch using Excel with this step by step:

erudite.agency/insights/forec…
...

πŸ”­ SEO Forecasting in Google Sheets Template by @bertiecharlton using Google Analytics and The Solver add-on:

keywordsinsheets.com/seo-forecastin…
...

πŸ”­ Finally, do you use @ahrefs ? Check this @patrickstox guide: How to Use Data Forecasting for SEO [Scripts Included]

ahrefs.com/blog/seo-forec…

...
Happy new year forecasting! πŸ™ŒπŸ”­ ... and remember, it's always useful to have different ways to achieve the expected results, as well as a few optimistic & pessimistic scenarios depending on what's planned (and what can go wrong)! πŸ˜‰πŸ’ͺ

β€’ β€’ β€’

Missing some Tweet in this thread? You can try to force a refresh
γ€€

Keep Current with Aleyda Solis πŸ•ŠοΈ

Aleyda Solis πŸ•ŠοΈ Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @aleyda

Oct 11, 2023
"I can't see issues with content quality or experience of my pages, can't see why they dropped in the latest updates"

Here's what to do:

1. Copy this sheet:

2. Assess your pages that dropped for top terms with these questions

...docs.google.com/spreadsheets/d…
3. Asses w/ those questions those well ranking pages, shown in top positions instead of yours. Don't do this only yourself, ask others, colleagues and non-colleagues, your actual users (!) to answer them. They might see stuff differently than you do.
4. Compare and identify the gap between your pages and top ranking ones! Remember that:
A) Many times the devil is in the detail, eg. a few more ads that make the experience annoying.
B) Other times is not that you did something "wrong", your pages content type/format might...
Read 4 tweets
Sep 1, 2023
4 πŸ”₯ Free/Freemium SEO tools you're likely not yet using I recommend to try out πŸ‘‡

1. Keytrends -
From identifying trending topics to monitoring content indexability connected w GSC, it also offers support through the content workflow with AI features. keytrends.ai

Image
Image
2. InLinks -
Automate your site internal linking, structured data and content development process.

... inlinks.com
Image
3. Internal Linking -
Identify internal linking opportunities within your site automatically

... internallinking.com
Image
Read 5 tweets
Jul 26, 2023
SEO Area Importance vs Website Size πŸ‘€
I've created this chart based on the one the awesome @thetafferboy (shockingly still suspended over here) shared as one of his unsolicited SEO tips (which you can see here: ) adding backlinks and nuance for content ... https://t.co/voF4yFbRVwlinkedin.com/pulse/200-unso…
Image
Mark chart showed how the biggest the site, the most important technical issues tend to be, and how content is more important for smaller sites.

I've used this graph as a base to integrate another critical area: backlinks; as well as to add nuance to the content aspect

...
1. Add another important area of SEO: Backlinks. Which also (in most cases, although there might be exceptions) become less of an issue the biggest the size of the site, as they tend to be more authoritative and established, with more content attracting backlinks naturally too...
Read 5 tweets
Jul 18, 2023
Having a fun leveraging ChatGPT with Code Interpreter to identify low hanging fruit from an SEO Workbook (featuring the tech, content, link popularity and ranking metrics of a site) πŸ‘€

...

Image
Image
Image
1. Get pages ranking in position 2-10 for non-branded queries of at least 100 in SV, with less than 10 backlinks or internal links

... Image
2. Get top pages ranking for non-branded queries not yet in the best position with the highest search volume but lowest number of clicks

... Image
Read 5 tweets
Jun 23, 2023
5 Useful ChatGPT Plugins and Ways to Use them to help you in SEO Tasks πŸ€–πŸ”₯πŸ‘‡

1. Website Performance Plugin: Get Speed and Core Web Vitals Metrics in Bulk for Pages and ask for recommendations to optimize them.

...

2. Video Highlight Plugin: Get Video Topics Suggestions based on trending ones, as well as recommendations for optimized titles, descriptions, tags.

...

3. Scholar AI Plugin: Get facts from scientific papers that you can quote in your content, along with their sources.

...
Read 6 tweets
May 18, 2023
SEO Recommendations execution Issues + What to Do for Success in 2023 πŸš€

The top execution challenges shared in the #SEOFOMO SEO Auditing Survey are:

* Decision makers priorities & understanding
* Org factors
* Tech & overall Constraints

What to do About it? Read on... Image
1. Enough of recos of +20 pages with complex prioritization that nobody will read. Apply a radical SEO prioritization approach delivering a top 10 actions plan featuring only high-impact executions with an executive summary explaining the β€œwhy” and value for the business. Image
2. Always establish an SEO quality framework with education (to set an understanding base), validation and monitorization workflows in the organization, to prevent, catch and address issues fast. Do it along the reco's delivery. I've spoken about it here: speakerdeck.com/aleyda/goodbye… Image
Read 9 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(