SeitenreportSEO & website analysis since 2007

Free · without registration

Deduce next steps from Search Console data.

Load the CSV export of your searches or pages. Find entries with flashy CTR, positions between 5 and 20, or click losses over a second export.

Processing directly in your browser · no file upload · no account required

Search Console → Performance → Search queries or pages → Export → CSV. From a ZIP, please first unpack “Search Requests.csv” / “Sites.csv”. Per file a maximum of 8 MB or 50,000 lines of data.

For a meaningful comparison, export the same length of time with the same filters, countries, devices and search types. The CSV content does not contain these settings reliably; the tool cannot match them.

This is how the notes are prioritized.

  1. Click loss: Entry present in both exports, currently fewer clicks. In addition, check impressions, ranking, season and search demand. A decline does not prove a technical error.
  2. Ranking Opportunity: Average position between 5 and 20 Check search intention, content and internal linking of the matching landing page.
  3. Test CTR: Average position up to 10 and CTR below your check threshold. Compare title, description, and search result with the search query.

Within the same priority, entries with more impressions are at the top. The preset two percent CTR is a variable test threshold, not a general quality standard. CTR depends, among other things, on the brand, position and design of the search results. The notes are a work list and not a forecast of additional visitors.

What the export shows – and what does not

The evaluation accepts German and English CSV headers. Requires search query or page as well as clicks, impressions and position. CTR is calculated from clicks and impressions. Duplicate entries are merged; invalid rows are omitted with a note.

The sums relate exclusively to the lines read in. Exports can be limited and omit anonymized searches. Missing comparison entries are therefore not treated as zero clicks. Average positions do not replace a single ranking query. For reading: Google Help to Export Search Console Data.

Frequent questions

Do I need to set up Google access?

No. Export the data as CSV and select the file here. The evaluation runs in the browser; the CSV is not uploaded to Seitenreport.

Why do I see different sums than in Search Console?

The sums of this tool contain only the valid data lines of the file. Export limits, anonymized searches, filters and different time periods can explain deviations.

Are the indications visitor forecasts?

No. They help to find entries for a more detailed examination. Whether changes bring additional clicks depends on the cause, your implementation and the competition.