Microsoft Ads Connector

Start moving your Microsoft Ads data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Microsoft Ads connector in the Weld documentation

ad_group

id

ad_schedule_use_searcher_...

28 more microsoft-ads tables

Explore available Microsoft Ads data

Browse all the data tables available for the Microsoft Ads connector, in our interactive ERD data viewer.

View the Microsoft Ads Data Schema

Transform and model Microsoft Ads data

Get clean data models from your Microsoft Ads data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Microsoft Ads

raw.microsoft_ads.table1

raw.microsoft_ads.table2

Get started with Microsoft Ads SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Microsoft Ads.

Account Report

Generates an account report by integrating with Microsoft Ads. It retrieves data from the ad_performance_daily_report and account tables, joins them based on the account_id, and calculates metrics such as clicks, impressions, and spend. The resulting report includes information about the date, account name, account ID, time zone, device OS, device type, network, and currency code.

Ad Group Report

Generates a report that combines data from the "ad_performance_daily_report," "ad_group," "campaign," and "account" tables in the Microsoft Ads integration. It joins these tables based on specific columns and calculates aggregated metrics such as clicks, impressions, and spend. The resulting report includes information on the date, account, campaign, ad group, device, network, and currency code.

Campaign Report

Generates a campaign report by integrating with Microsoft Ads. It combines data from the campaign performance daily report, campaign, and account tables. The joined table includes information such as date, account name and ID, campaign name and ID, campaign type and status, device OS and type, network, currency code, clicks, impressions, and spend.

Ad Report

Generates an ad report by joining data from multiple tables related to Microsoft Ads. It retrieves information such as date, account name and ID, campaign name and ID, ad group name and ID, ad name and ID, device OS, device type, network, currency code, clicks, impressions, and spend. The template performs a left join on the specified tables and groups the data based on selected columns. The final result includes all columns from the joined data.

View all Microsoft Ads templates