Weld logo
microsoft-ads logo
Weld logo

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

microsoft-ads logo

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.

logo for Microsoft Ads
Microsoft Ads
raw.microsoft_ads.table1
raw.microsoft_ads.table2
background grid

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.
microsoft-ads logo
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.
microsoft-ads logo
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.
microsoft-ads logo
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.
microsoft-ads logo
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

Start working with your Microsoft Ads data today

Get started building your data warehouse with Microsoft Ads and connect all your apps and databases

microsoft-ads logo
Weld logo
Get started for free

Explore more connectors

Select the tools you need data from and start syncing your data now.

View all Marketing connectors
background
Weld logo

Tired of scattered data? Sync your data in minutes with our AI-powered ETL platform. Seamlessly connect all your apps, files, and databases.

Backed by leading investors
Frontline logoCherry logoInnnovation Fund logo
Twitter LogoLinkedIn Logo
GDPR logoSOC2
© 2024 Weld. All rights reserved.