Home UI Sorting data in tables

Sorting data in tables

Last updated on Sep 04, 2025

Topify tables (Queries, Pages, Countries, Devices) let you sort results so you can spot what matters first—top performers, rising opportunities, and items that need attention.

Where sorting applies

  • All four tables on the Dashboard.

  • Detail drawers opened from a row.

  • Exports respect your filters; the sort is applied to the on-screen view (and used in CSV/Sheets when supported by your browser).

Sort views: Popular, Growing, Decaying

Each table has a view selector. It changes the default sort logic for that table:

Popular (default)

Surfaces high-impact rows first.

  • Queries/Pages: primarily by Clicks (desc), with Impressions as a tiebreaker, then Avg. position and CTR.

  • Countries/Devices: by Clicks (desc), then Impressions.

Use it for: weekly reporting, “top of the pile,” and sanity checks.

Decaying

Prioritizes rows with significant negative movement vs the previous comparable period.

  • Mirrors Growing but for declines (drops in clicks/CTR or worse position), with the same minimum-volume guardrails.

Use it for: early-warning triage, pages to refresh, queries losing intent match, device-specific regressions.

Growing

Highlights rows with meaningful positive movement vs the previous comparable period (with day-of-week matching).

  • We compute a Growth Score that blends:

    • Δ Clicks (relative and absolute),

    • Δ CTR,

    • Δ Avg. position (improvements count more when volume is non-trivial),

    • light smoothing to reduce noise.

  • Rows below a small volume threshold are down-weighted to avoid “one-click spikes.”

Use it for: quick wins, content to double-down on, titles that started working, new markets/devices gaining traction.

Column sorting (manual)

You can override the view’s default by clicking a column header:

  • First click: sort descending by that column.

  • Second click: flip to ascending.

  • Third click (or “Reset view”): return to the view’s default logic.

Common useful sorts:

  • Avg. position (asc) → find near-top opportunities (positions 6–10).

  • CTR (desc) → pages/queries with compelling snippets; compare to impressions.

  • Impressions (desc) → “visibility without clicks” → improve titles/intent.

Tip: Combine a view + column sort. Example: Growing + Avg. position (6–15) finds rising keywords that are close to page one.

How comparisons work

When a view shows ▲/▼ changes or uses Growing/Decaying:

  • Comparison window: Previous period of the same length, with day-of-week matching to avoid weekend/weekday bias.

  • Smoothing: minor smoothing for CTR/position signals at low volume.

  • Minimum volume: we require a small base of impressions/clicks before flagging growth/decay.

Interactions with filters

Sorting runs after filters:

  • Date range, Query, Page, Country, Device, Branded, and Topics/Clusters all constrain the dataset first.

  • Branded = Off often makes Growing/Decaying more actionable (no brand noise).

  • For large ranges, narrow by Country or Device to cut noise before sorting.

Practical recipes

  • Find money terms near the top:

    Filters: Branded OffView: PopularSort: Avg. position (asc) → focus on positions 6–10.

  • Double-down on winners:

    View: GrowingSort: Clicks (desc) → open rows with strong ΔCTR or better position.

  • Triage losses fast:

    View: DecayingSort: Clicks (desc) → check pages/queries with worse position and falling CTR.

  • Market/device issues:

    Filters: choose Country/DeviceView: Decaying → scan CTR and position to isolate intent/snip issues.

FAQ

Why does the sorted list differ from GSC UI?

Topify loads the full dataset (up to 50,000 rows/day), while the GSC UI shows a sampled 1,000-row view. Totals and ordering can differ—Topify is more complete.

Do exports keep my sort?

Exports always respect your filters. The row order follows the table’s active sort when supported; otherwise, re-apply the sort in your spreadsheet.

Why isn’t a tiny keyword flagged as Growing?

We apply a small volume threshold and smoothing to avoid false positives from one-off clicks or very low impressions.

Position got “worse” but CTR went up—what wins?

In Growing/Decaying, multiple signals are blended. If CTR gains outweigh small position drift (and volume is there), the row can still rank as Growing.