GSC Audit Tool

25 analytical methods for your Search Console data. Upload a CSV or fetch directly from your connected GSC account.

Connect Search Console to fetch data directly

Choose a method

The list on the right shows every method that will eventually be available.

Pick the method you want to preview.
Upload a CSV file or fetch directly from your connected GSC account.
Upload any exported CSV from Search Console or SEO tools.
For CSV uploads, optionally filter to a specific property.
Optional start date for the query range (YYYY-MM-DD).
Optional end date for the query range (YYYY-MM-DD).

Show Data requirements

Required columns: query, page, clicks, impressions, ctr, position

Optional columns: date

  • Sort column string

    Choose which column (clicks/impressions/ctr/position) orders the preview.

  • Row limit integer

    Optional cap on the number of rows surfaced in the preview.

Available methods

1

Show Data

Return the raw query/page/clicks/impressions/CTR/position table so you can audit every row.

Requires: query, page, clicks, impressions, ctr, position

Params: 2 available

2

CTR Yield Curve

Bucket positions and average CTR so you can spot performance gaps and prioritized clicks.

Requires: position, ctr

Params: 2 available

3

Group Data by Period

Aggregate the same metrics by day, week, or month to compare performance trends.

Requires: date, clicks, impressions, ctr, position

Params: 2 available

4

Active Pages

Summarize which URLs are publishing most often and flag pages losing traction.

Requires: page, date, clicks, impressions

Params: 2 available

5

Cannibalization

Highlight queries where multiple URLs from the same property compete for the same keywords.

Requires: query, page, clicks, impressions, ctr, position

Params: 2 available

6

Brand vs. Non-Brand

Split metrics between branded queries and generic terms to understand voice-of-brand dynamics.

Requires: query, clicks, impressions

Params: 1 available

7

Keyword Gap

Find missing queries when comparing two time ranges or datasets to spot lost opportunity.

Requires: query, clicks, impressions

Params: 2 available

8

Update URLs

Apply mappings or regex replacements to normalize URLs before aggregating metrics.

Requires: page, query, clicks, impressions, ctr, position

Params: 2 available

9

Extract Search Volume

Append search volume data from DataForSEO or a CSV lookup for each query.

Requires: query

Params: 2 available

10

Potential Content to Kill

Flag low-performing pages that may be candidates for consolidation or removal.

Requires: page, clicks, impressions, ctr, position, date

Params: 2 available

11

Content Decay

Compare two periods and identify pages that lost clicks/positions over time.

Requires: page, date, clicks, impressions

Params: 2 available

12

Pages Not in Sitemap

List GSC pages that are missing from your sitemap so you can submit them.

Requires: page

Params: 2 available

13

Winners & Losers

Show delta metrics between two periods and sort the pages by winners or losers.

Requires: page, query, date, clicks, impressions, ctr, position

Params: 2 available

14

Long Tail Keywords

Spot queries with high word counts that may need new content clusters.

Requires: query, clicks, impressions

Params: 2 available

15

CTR Outliers

Flag queries where CTR is wildly above/below what you would expect for the given position.

Requires: position, ctr, clicks, impressions

Params: 2 available

16

ABCD Buckets

Classify URLs into A/B/C/D buckets so you can prioritize work on the worst performers.

Requires: query, page, clicks, impressions, ctr, position

Params: 2 available

17

Pages per Day

Count how many unique pages rank per day and surface volatility in the index coverage.

Requires: page, date

Params: 2 available

18

Pages Lifespan

Track first_seen/last_seen timestamps so you know how long a URL stays visible.

Requires: page, date

Params: 2 available

19

Seasonality per Day

Compare performance by day-of-week to highlight seasonality patterns.

Requires: date, clicks, impressions, ctr, position

Params: 2 available

20

Replace Query from List

Swap queries for canonical names or tag them for easier reporting.

Requires: query, page, clicks, impressions, ctr, position

Params: 2 available

21

UQC (Unique Query Count)

Count how many unique queries each page ranks for across the dataset.

Requires: page, query

Params: 2 available

22

Classify Pages

Group pages by classification rules and summarize the metrics per bucket.

Requires: page, clicks, impressions, ctr, position

Params: 2 available

23

Add First Found

Enrich each row with the first time this query/page showed up in the dataset.

Requires: page, query, date

Params: 2 available

24

Word Frequency

Count the most frequent words in queries or titles while ignoring stopwords.

Requires: query

Params: 2 available

25

Position over Time

Return average position per date bucket so you can track editorial progress.

Requires: page, date, position

Params: 2 available