🔎 Focus: SEO Strategy
🔴 Impact: High
🟠 Difficulty: Mid
Dear Tech SEO 👋
Let’s dive into self-made SEO/GEO dashboards…
‘Cause they are better and you can build them with AI.
SEO Tools I *barely* use
Anyone can build their own tools now. I build everything on top of Google Sheet just because…
I pay a lot for regular SEO tools. The same ones you use. They have 100s of mini tools I barely use. So instead of paying for things I barely use, my goal is to build my own dashboards using APIs and MPCs.
Today I bring you 2 x Dashboards built with Data for SEO
Dashboard 1: Share of Branded Search
Dashboard 2: Google AI Mode Citations
In fact, I shared Dashboard 1 on a previous newsletter edition but this time I bring you a much more efficient way and more budget conscious 💸
The stack you’ll need:
Google Sheets
Sheets Scripts
Gemini (or Chat GPT, Claude, Copilot…)
I found a workaround, at least a temporary one until all SEO tools solve these /goto folder issue…
Ready? Let’s goooooooo
All Becomes A Google Sheet
At least on my case. No matter how advanced is the project or the data I am analyzing. Everything will become a CSV, Excel or Google Sheet at one point.
💫 Benefit of Google Sheets: You have embedded Gemini which can act as agent to create tables, tabs, charts and analyze data.
⚠ Important: you will need your own API credentials from Data For SEO to make this work. You can add it in the scripts:
Go to the each Dashboard Sheet > Extensions > Apps Scripts. There just add your credentials and start playing:
How to add your API credentials to the scripts
If people search for brand queries like “netflix login“ or “apple tv login“ you want to now what is the share of your brand vs competitors… Do it with this dashboard.
This dashboard works like this:
You add the domain of yours and your competitors (starting from column A21)
You check the domains you want to compare
Click “Calculate SoS“ and it will show you the share of branded search
The amount of keywords per brand is limited to 500. Imagine all combinations “netflix price“, “netflix movie“, “login netflix“, etc. I bet the top 90% of the demand is on the top 500 keywords but you can change this on the code.
Snapshot of the Share of Branded Search
Dashboard 2 Sheet Template - AI Mode Citations Monitoring
With Data For SEO you got access to Google AI Mode endpoint which means you can run queries and get the response real time to evaluate mentions and citations.
I focused on citations for this dashboard. This dashboard works as follows:
You add your seed keywords or topic ideas
From those seed terms, you will get a full list of related or matching keywrods
The top keyword (search volume) per seed keywords will be send to the Google AI Mode
In short, it only gets the response from the most searched query on Google AI Mode.
27min Video Tutorial
You could just copy and play with the sheets but if you want full background please check out this video:
Free Tech SEO analysis + 1-on-1 session
I am selecting one website per newsletter edition for a:
Free Tech SEO analysis + 1-on-1 session.
If you want to participate respond to this email with "Q4" and I will follow up asap.
That’s it for today, practical and simple.
Until next time 👋
—