Step-by-step guide to connecting your Microsoft Ads account and syncing campaign data seamlessly.
Authorize Connection to Microsoft Ads
Ensure that the account you're granting access to holds admin-level permissions for your Microsoft Ads accounts.
Navigate to Data Integration -> Connectors
- Click on "Connect A new platform"
- Select Microsoft Ads and follow the on-screen prompts to grant the necessary permissions to access and retrieve your data.
Upon successful connection of the Microsoft account, you will be presented with a dashboard displaying your linked Microsoft Ads accounts. This dashboard will also feature four buttons located directly beneath the Microsoft Account section:
- Add a New Account: This button enables you to link additional Microsoft Ads accounts to the platform.
- Reauthorize: This button allows you to refresh the authorization for your Microsoft account, ensuring continued data access.
- Test Connection: This button initiates a test to verify the connectivity between the platform and the Microsoft account.
- Delete Connection: This button severs the link between the platform and the Microsoft account, removing the account and its data from the dashboard.
Extracted Data
These are the extracted data fields that we extract from Microsoft Ads:
|
Data Field |
Extracted Data Source |
Explanation |
|
date |
timeperiod |
The date for which the advertising data is reported. |
|
campaign_type |
campaigntype |
The type of campaign (e.g., Search, Display, Shopping). |
|
campaign_name |
campaignname |
The name of the advertising campaign. |
|
spend |
spend |
The amount spent on the advertising campaign. |
|
clicks |
clicks |
The number of clicks on the advertisement. |
|
impressions |
impressions |
The number of times the advertisement was displayed. |
|
conversions |
conversions |
The number of conversions attributed to the advertisement. |
|
revenue |
revenue |
The revenue generated from conversions attributed to the advertisement. |
Date Range and Data Freshness
- Date Range: 1080 days (36 months)
- Data Freshness: Data is updated daily.
- Data Granularity: Data is provided at a daily level.
Data Validation
The validation is done over the spend metric.