E1 · Import and generate
15 minImport the example folder (or your CSVs) and generate the report for one site.
Done when: the terminal shows the line "semana … sem marca … pauta …" and relatorio.html opens with the weekly series.
Lesson 4 · 17 min
gsc-historico: Search Console forever
Search Console keeps 16 months. Two years from now, the week your site started being found by people who don't know your brand will be gone. gsc-historico imports the weekly CSV into a local database that never deletes anything and builds the report that matters: branded, non-branded and anonymized, what went up, what went down, and the content backlog.
Start the lesson
In this lesson you will
- 1Where the CSV comes from and what "anonymized" means
- 2Import without duplicating and generate the report
- 3Read the weekly series and the up/down
- 4Content backlog and pages with no clicks: the tool's rules, not Google's
Goal: import the weekly CSVs into a database that doesn't delete, and read branded × non-branded × anonymized, the content backlog and the pages with no clicks.
01From Search Console to the history
Every week, the same path. Click each step.
Click each block in the diagram to see what it does.
The data is Google's; the long-term memory is yours.
02Read what the report shows
Click each list.
1. Series
Branded is people who already know you. Non-branded is new people arriving through the topic. Anonymized is what Google hides because it is rare: total minus branded minus non-branded.
Track non-branded impressions and clicks, week by week.
Real INEMA case
inema.club, from 09/16–22 to 10/05–11: non-branded impressions went from 8 to 157 and non-branded queries from 3 to 51, with 0 non-branded clicks. The first 2 non-branded clicks came on inema.pro (2/293), driven by "curso jev".
2. Up and down
Adds up the impressions and clicks of each query, current week against the previous one. The position shown is the best among the pages.
A query that drops several weeks in a row is a sign to look at its page.
3. Content backlog
A new query (never seen in the database) with no owner page goes into the content backlog: write a page made for it.
Owner page is a rule of this tool: any page on Google's 1st page, or with a word from the query in the URL.
You decide
The rule compares words with the URL, not with the content. A Spanish page may already show up for the query, off the 1st page, and the query still comes out as backlog. The paginas_hoje column shows who appears today.
4. No clicks
A page with 5+ non-branded impressions in the week and 0 clicks: rewrite the title and description with a specific promise.
It may have branded clicks; the list looks only at non-branded searches.
03Import and generate the report
Run it from the ferramentas/gsc-historico folder. The example uses the real inemaSEO CSVs that come in the repository.
Terminal · import (folder or files)
cd ferramentas/gsc-historico python3 gsc_historico.py importar ../../exemplos/gsc-historico/entrada --db dados/gsc.sqlite
Terminal · report for one site
python3 gsc_historico.py relatorio --db dados/gsc.sqlite --site inema.club --saida saida/inema.club # another comparison: --atual YYYY-MM-DD --anterior YYYY-MM-DD
Terminal · every week, with your CSVs
# after gsc_semanal.py (inemaseo-metodo), point to its folder python3 gsc_historico.py importar ~/path/to/gsc-folder --db dados/gsc.sqlite python3 gsc_historico.py relatorio --db dados/gsc.sqlite --site <yoursite.com> --saida saida/<yoursite.com>
Template · API mode (uses the Google API; not run in this course)
# runs gsc_semanal.py with your credential (gcloud) and imports; not tested live by the author python3 gsc_historico.py puxar --script ~/projetos/inemaseo-metodo/tools/gsc_semanal.py --pasta dados/gsc-csv
Example from the repository
importado: 10 linha(s) de resumo, 244 linha(s) de consulta → dados/gsc.sqlite inema.club semana 2026-10-11 (comparada com 2026-10-04): sem marca 0 cliques / 157 impr.; subiram 15, caíram 15, pauta 18, páginas sem clique 5 → saida/inema.club/relatorio.html inema.pro semana 2026-10-11 (comparada com 2026-10-04): sem marca 2 cliques / 293 impr.; subiram 15, caíram 5, pauta 6, páginas sem clique 6 → saida/inema.pro/relatorio.html
Start of pauta.csv (query, impressions, best position, page that appears today):
ia para principiantes,6,38.5,…/es/aprender-inteligencia-artificial/ guía ia principiantes,5,60.8,…/es/aprender-inteligencia-artificial/ tutorial ia desde cero,5,29.4,…/es/aprender-inteligencia-artificial/
Start of paginas_sem_clique.csv:
…/es/aprender-inteligencia-artificial/,106 impr.,posição 39.1,22 consultas https://buscas.inema.club/,12 impr.,posição 26.6,6 consultas
The Spanish page already appears for these queries; the owner page rule does not recognize it because the words are not in the URL. Here the decision is to improve the page that exists, not to write another one.
- Adding up overlapping weeks: 09/27–10/03 and 09/28–10/04 share days; the database keeps both and the report warns you.
- Reading the content backlog as an order: it is a heuristic; check the column for the page that appears today.
- Putting the database in git: it lives in dados/, which the .gitignore already excludes.
04Practice: your history
No CSV of your own yet? Do it with the example and come back when gsc_semanal.py runs.
E2 · Three backlog decisions
20 minPick 3 queries from the content backlog and decide for each: write a new page or improve the one that already appears (today's page column).
Done when: 3 lines with the query, the decision (new or improve) and the URL of the page you would create or change.
05Test what you learned
The explanation shows up after your answer.
Question 1 of 4
Why store Search Console in a local database?skill
Correct
The data is the same; the difference is memory. Without archiving, your site's history disappears after 16 months.Not that one
The data is the same; the difference is memory. Without archiving, your site's history disappears after 16 months.Review: From Search Console to the historyQuestion 2 of 4
Total 114 clicks, branded 87, non-branded 0. Where do the other 27 come from?
Correct
This is the week of 10/05–10/11 for inema.club. Anonymized = total minus branded minus non-branded. That's why the three columns never add up without it.Not that one
This is the week of 10/05–10/11 for inema.club. Anonymized = total minus branded minus non-branded. That's why the three columns never add up without it.Review: Read what the report showsQuestion 3 of 4
A query came out as a content backlog item, but today's page column shows one of your pages already appearing, outside the first page. What should you do?
Correct
The rule compares words in the query with the address. If a page already appears, improving it is usually worth more than creating a competitor inside your own site.Not that one
The rule compares words in the query with the address. If a page already appears, improving it is usually worth more than creating a competitor inside your own site.Review: Import and generate the reportQuestion 4 of 4
Which number shows new people arriving through the topic?
Correct
Branded means people who already know you. Non-branded measures whether the content attracts people who don't know the site yet.Not that one
Branded means people who already know you. Non-branded measures whether the content attracts people who don't know the site yet.Review: Read what the report showsQuiz complete
You got {a} of {n} right. Get them all right and the lesson is marked as complete.Pick an option. The explanation appears after you try.
06Takeaways
MemoryWeekly CSV → SQLite that never deletes; re-importing doesn't duplicate.
The numberNon-branded, week by week; anonymized explains the difference.
Content backlogTool heuristic: check the page that already appears before writing another.