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.