
Follow us for #googlesheets / #seo tips, tricks and resources. Get the latest SEO automation templates π https://nitter.cf/t.co/SyC3pB4xNk | Made by @jsvxc
a cell far far away
Joined October 2018
- Tweets199
- Following160
- Followers1K
- Likes62
Sheets for Marketers π₯ retweeted
If you want to grab a copy of the checklist, it's here π
docs.google.com/spreadsheetsβ¦
Sheets for Marketers π₯ retweeted
Free SEO Forecasting in Sheets π
Part of the template from my Forecasting for SEO course which provides a simple linear regression + seasonality model and Holt-Winters model. π
Template & Video instructions on keywordsinsheets.com
Sheets for Marketers π₯ retweeted
There are some real good people in our industry! π
@jsvxc from @sheetsmarketers sent me a branded template for my keywordsinsheets.com scripts out of the blue yesterday. π²
It looks π₯ π₯ π₯
Sheets for Marketers π₯ retweeted
I've been heads down in Google Data Studio for the past few weeks, here are a few tips I learned along the way:
β¨THREADβ¨
Sheets for Marketers π₯ retweeted
Today I'm launching Keywords in Sheets. π
A website to house all of my FREE Google Sheets scripts for SEO (with templates) + instructions on how to add them.
Sign up and you'll be updated every time a new script is added. π
Link in below π
Sheets for Marketers π₯ retweeted
New Post π¨ The Keywords Mapping Cheatsheet (the Different types of Pages and Queries Patterns to Target with each) For Different Types of Sites [with a Google Sheets Included for E-Commerce and SaaS along Examples]
aleydasolis.com/en/search-enβ¦
Sheets for Marketers π₯ retweeted
Just took @keywordinsights for a spin... holy sh!t it's good. Never thought I'd be so happy to see a pivot table.
Thanks for saving me hours of work @suganthan & @digitalquokka
Sheets for Marketers π₯ retweeted
Just published this #SERP analysis post on @CXLdotcom
You'll learn:
β
A brief history of the SERPs
β
7 ways to get more traffic from SERP features
β
How to keep up to date w/ SERPs (via @SaijoGeorge, @rustybrick, @TTTSEOCommunity, @SEOSignalsLab)
cxl.com/blog/analyze-serps/
Sheets for Marketers π₯ retweeted
How different does your Audience searches based on the used device? I've created this Google Data Studio Dashboard to Easily Analyze Mobile vs. Desktop Website Search Behavior!
Check and Copy: aleydasolis.com/en/search-enβ¦
But aren't we living in a mobile first world anyway?...
Sheets for Marketers π₯ retweeted
In an effort to become more pro-active, I'm launching a new thing to help dogs (and offer some SEO advice).
jsvxc.com/seo-for-dogs/
Sheets for Marketers π₯ retweeted
How neat! Keep a daily track of your Core Web Vitals in Google Sheets! π₯
Yet another incredible resource from Amit Agarwal (@labnol)! π
Article: labnol.org/core-web-vitals-2β¦
Link to sheet: docs.google.com/spreadsheetsβ¦
#AppsScript #SEO #PageSpeed
Sheets for Marketers π₯ retweeted
URLs Changes & Web Migration within same Domain Minimum Viable SEO Validation Checklist [In Google Sheets]:
docs.google.com/spreadsheetsβ¦
- I shared it with a client to set expectations for upcoming URLs changes within same domain and thought could be also helpful to others ππ
Sheets for Marketers π₯ retweeted
Wow my template made it to sheetsformarketers.com/data-β¦ πππ
Thanks so much @jsvxc ππ β at Sandnes, Norge
Sheets for Marketers π₯ retweeted
Cool stuff for marketers (& fellow geeks)
Even though we are in strange times, here's some some cool tech/marketing things I've discovered or made recently:
π
Sheets for Marketers π₯ retweeted
Awesome article on getting SEO stuff done by @JonEricDelaCruz (& not just because he's a spreadsheet fan + mentioned my website π)
siegemedia.com/seo/organizatβ¦
Sheets for Marketers π₯ retweeted
We've shown you our Data Studio report gallery. @sheetsmarketers also compiled 50+ Data Studio Templates you may find valuable as you plan your next visualization.
Check them out: https://nitter.cf/t.co/0IwlOJySt4 #measure
Sheets for Marketers π₯ retweeted
Created a new Google Data Studio report for local keyword research.
It shows:
Top 10 keywords in GMB (by impr)
Top 10 keywords in organic (by impr)
Group keywords into categories
Impr. data for locations
& more
verygoodlocalseo.com/local-kβ¦
ty @JordanChoo & @noahlearner for the help!
Sheets for Marketers π₯ retweeted
I fucking love Google sheets. Almost anything we need within our agency to improve processes can be solved by creating a minimum viable product within Google sheets. #googlesheets #Productivity #agencylife


















