Microsoft Advertising

​🏃‍♀️ Getting Started
​
In this guide, we will show you how to connect Microsoft Ads to Census. 
Prerequisites
Have your Census account ready. If you need one, create a Free Trial Census account now.
Have your Microsoft Ads account ready.
To create Customer Match syncs, your Microsoft Ads Account will need access to the Customer Match feature. See Microsoft's Customer Match policy for more details.
Have the proper credentials to access your data source. See our docs for each supported data source for further information:
​Azure Synapse​
​Databricks​
​Elasticsearch​
​Google BigQuery​
​Google Sheets​
​MySQL​
​Postgres​
​Redshift​
​Rockset​
​Snowflake​
​SQL Server​
1. Connect Microsoft Ads
Once you are in Census, Navigate to Connections​
Click the Add Service button
Select Microsoft Advertising in the dropdown list.
Follow Microsoft OAuth flow to connect to your Microsoft Advertising account.
​
Finally, select the Microsoft Advertising account you'd like to sync to
​
​
2. Connect your Data Warehouse
Please follow one of our short guides depending on your data warehouse technology
​Redshift​
​Postgres​
​BigQuery​
​Snowflake​
​Databricks​
After setting up your warehouse, your Census sync should look like this:
​
🗄 Supported Objects
Service
Object Name
Supported?
Identifiers
Customer Match Lists ( Audiences)
Customer
✅
User ID, Mobile ID, Email, Phone Number
Offline Conversions
Click, Call
✅
Click ID, Caller ID
​Contact us if you're looking for additional Microsoft Ads objects.
​
🚑 Need help connecting to Microsoft Ads?
​Contact us via [email protected] or start a conversation with us via the in-app chat.