Visualize Microsoft Ads Data in Looker Studio

Start by creating a new Microsoft Ads Data Mart and choose Connector as the definition type.

• Select Microsoft Ads as the data source
• Specify the Account ID and Customer ID that you want to collect data from
• Authorize access to your Microsoft Ads account

This Data Mart defines the logic once and makes it reusable.

Note: Use coma to separate multiple ad accounts (Account IDs) and collect the data together without the need to blend them afterwards.

Choose exactly which Microsoft Ads data should be collected.

• Select the appropriate API endpoint (for example, ad_performance_report)
• Choose metrics such as spend, impressions, clicks, and conversions
• Define the dataset and table where data will be stored
• Publish Microsoft Ads Data Mart once configuration is complete
• Run manually & select Backfill to load historical data
• Add a Connector run Trigger so Microsoft Ads data is collected on your schedule.

No worries, you can collect more Microsoft Ads data later on & blend them to get extraordinary reporting granularity.

Your Microsoft Ads data is now available for analysis in Looker Studio. But why stop at just this? You can reuse the same Microsoft Ads Data Mart to:

• Enable Microsoft Ads AI Insights delivered on a schedule to Slack, MS Teams or by Email
• Just go to Insights tab, use our smart prompt, customize it or start from scratch
• Blend Microsoft Ads data with GA4, CRM, or other ad platforms

One Data Mart – multiple destinations.