AdSense report template

Five pages: Start here, Overview, Sites, Countries and Ad units. Overview compares estimated earnings, page views, page RPM and page CTR with the previous period. Sites and Countries show where earnings and RPM come from. Ad units shows impressions, clicks and impression RPM for each ad unit.

Add AdSense as a data source in Datapipe, sign in with Google and choose your AdSense account, then create this dashboard. Authorize Google Sheets separately. Datapipe prepares four worksheets, Daily, Sites, Countries and Ad units, and a copy link that replaces the report sources. Save your private Data Studio report; scheduled exports update the same workbook.

Page RPM is total estimated earnings divided by total page views, times 1,000. Page CTR is total ad clicks divided by total page views. CPC is total estimated earnings divided by total ad clicks. All are calculated from the totals for the selected dates, not averaged across days.

Overview reads the whole account. Sites lists the sites you have added in AdSense, so ads shown on other domains, such as staging copies, are counted in the Overview but not on the Sites page.

AdSense counts page views per page, not per ad unit. The Ad units page compares units by impressions, clicks and impression RPM instead.

No. AdSense reports estimated earnings, which can change until AdSense finalizes them. Amounts stay in your account currency.

Up to the last 90 days of complete days by default, and up to 366 days. The dashboard opens on the last 28 days, ending yesterday, compared with the 28 days before that.

The template, editable Data Studio copy, PDF and CSV are free. You need a Google account to save a copy. Datapipe plans apply when you connect and refresh your own data.