Site Rollup

A Search Console report for all your sites in one table

One row per property makes problems easy to spot. Four columns do most of the work.

Clicks and impressions, with the change

Compare the last 28 days with the 28 before. Sorting by the change, not the total, puts a site that lost a third of its clicks above a large site that moved by two percent.

CTR

Clicks divided by impressions for the whole period. Do not average the daily CTRs: add the clicks and impressions first, then divide.

Average position

Weight each day's position by its impressions, otherwise a day with ten impressions counts as much as a day with ten thousand. Lower is better, and a small move on a low-traffic site is usually noise.

Why a table and not a dashboard of charts

With twenty sites, twenty charts hide the outliers. A sortable table shows which sites changed most in one glance, and you open the chart only for those.

Site Rollup builds this table for every property on your Google account, with read-only access. The top 3 properties are free.