Microsoft Ads report template

Four pages: Start here, Overview, Campaigns, and Networks and revenue. Overview compares spend, clicks, conversions and cost per conversion with the previous period. Campaigns shows CTR, average CPC and conversion rate for each campaign. Networks and revenue shows revenue, ROAS and results by network.

Add Microsoft Ads as a data source in Datapipe, sign in with Microsoft and choose the ad account, then create this dashboard. Authorize Google Sheets separately. Datapipe prepares the worksheet and a copy link that replaces the report source. Save your private Data Studio report; scheduled exports update the same workbook.

The campaign performance report from the Microsoft Advertising Reporting API, aggregated daily, with one row per campaign, day and network. Days a campaign had no activity are left out, as Microsoft leaves them out.

Cost per conversion is total spend divided by total conversions. CTR is total clicks divided by total impressions. ROAS is total revenue divided by total spend. All are calculated from the totals for the selected dates, not averaged across rows.

Revenue appears only when your conversion goals report a revenue value. Without it, revenue and ROAS show no data; spend, clicks and conversions still fill the report.

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. Amounts stay in the account currency.

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.