Integrations
Microsoft Advertising datasets and fields
The 15 datasets Maven lands from Microsoft Advertising, every field in them, and how the connection syncs.
Maven lands 15 datasets from Microsoft Advertising in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the Microsoft Advertising integration page.
Connection and sync#
You connect Microsoft Advertising by signing in to it and approving access, so nobody shares a password.
The first Microsoft Advertising sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 3 years in total. After that, each scheduled sync re-reads the last 7 days, so late changes are picked up.
Datasets#
Accounts#
Selected Microsoft Advertising account identity, lifecycle, currency, and reporting timezone from Customer Management GetAccount.
| Field | Type |
|---|---|
| account ID | Text |
| customer ID | Text |
| account name | Text |
| account number | Text |
| currency code | Text |
| time zone | Text |
| account status | Text |
| financial status | Text |
| account mode | Text |
| language | Text |
| auto tag type | Text |
| last modified at | Timestamp |
| msclkid auto tagging enabled | True/false |
Asset performance#
Daily Microsoft Advertising creative asset performance at campaign and asset grain.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| campaign ID | Text |
| campaign name | Text |
| asset ID | Text |
| asset content | Text |
| asset type | Text |
| asset source | Text |
| impressions | Integer |
| clicks | Integer |
| CTR | Number |
| spend | Number |
| conversions | Number |
| revenue | Number |
| video views | Integer |
Asset parent performance#
Daily Microsoft Advertising asset performance under its parent.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| customer ID | Text |
| campaign ID | Text |
| campaign name | Text |
| ad group ID | Text |
| ad group name | Text |
| ad ID | Text |
| asset group ID | Text |
| asset ID | Text |
| asset content | Text |
| asset type | Text |
| asset source | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| conversions | Number |
| revenue | Number |
| video views | Integer |
| video views p25 | Integer |
| video views p50 | Integer |
| video views p75 | Integer |
| completed video views | Integer |
| report type | Text |
| aggregation | Text |
| client ID | Text |
Campaign performance#
Campaign-level performance metrics.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| customer ID | Text |
| campaign ID | Text |
| campaign name | Text |
| campaign status | Text |
| campaign type | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| conversions | Number |
| revenue | Number |
| conversions qualified | Number |
| all conversions | Number |
| all conversions qualified | Number |
| all revenue | Number |
| view through conversions | Number |
| view through conversions qualified | Number |
| view through revenue | Number |
| assists | Number |
| tracking template | Text |
| custom parameters | Text |
| final URL suffix | Text |
| average CPC | Number |
| quality score | Integer |
| report type | Text |
| aggregation | Text |
| client ID | Text |
| conversion rate | Text |
| cost per conversion | Text |
| CTR | Text |
Ad group performance#
Ad group-level performance metrics.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| customer ID | Text |
| campaign ID | Text |
| campaign name | Text |
| campaign status | Text |
| ad group ID | Text |
| ad group name | Text |
| ad group status | Text |
| ad group type | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| conversions | Number |
| revenue | Number |
| conversions qualified | Number |
| all conversions | Number |
| all conversions qualified | Number |
| all revenue | Number |
| view through conversions | Number |
| view through conversions qualified | Number |
| view through revenue | Number |
| assists | Number |
| average CPC | Number |
| quality score | Integer |
| report type | Text |
| aggregation | Text |
| client ID | Text |
| conversion rate | Text |
| cost per conversion | Text |
| CTR | Text |
Ad performance#
Ad-level performance metrics.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| customer ID | Text |
| campaign ID | Text |
| campaign name | Text |
| ad group ID | Text |
| ad group name | Text |
| ad ID | Text |
| ad name | Text |
| ad title | Text |
| ad type | Text |
| ad status | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| conversions | Number |
| revenue | Number |
| conversions qualified | Number |
| all conversions | Number |
| all conversions qualified | Number |
| all revenue | Number |
| view through conversions | Number |
| view through conversions qualified | Number |
| view through revenue | Number |
| assists | Number |
| average CPC | Number |
| report type | Text |
| aggregation | Text |
| client ID | Text |
| conversion rate | Text |
| cost per conversion | Text |
| CTR | Text |
| custom parameters | Text |
| final URL | Text |
| final URL suffix | Text |
| tracking template | Text |
Ad conversion performance#
Daily Microsoft Advertising conversion goals reported at delivered-ad grain.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| customer ID | Text |
| campaign ID | Text |
| campaign name | Text |
| ad group ID | Text |
| ad group name | Text |
| ad ID | Text |
| ad title | Text |
| ad type | Text |
| ad status | Text |
| conversion action ID | Text |
| conversion action name | Text |
| conversion action type | Text |
| conversions | Number |
| conversions qualified | Number |
| revenue | Number |
| all conversions | Number |
| all conversions qualified | Number |
| all revenue | Number |
| view through conversions | Number |
| view through conversions qualified | Number |
| view through revenue | Number |
| report type | Text |
| aggregation | Text |
| client ID | Text |
Conversion report coverage daily#
Successful Microsoft Ads native conversion-report coverage, including empty account-date windows.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| report name | Text |
| requested grain | Text |
| reported grain | Text |
| report status | Text |
| row count | Integer |
| is partial | True/false |
Keyword performance#
Keyword-level performance metrics.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| customer ID | Text |
| campaign ID | Text |
| campaign name | Text |
| ad group ID | Text |
| ad group name | Text |
| keyword ID | Text |
| keyword | Text |
| match type | Text |
| bid match type | Text |
| quality score | Integer |
| max CPC | Number |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| conversions | Number |
| revenue | Number |
| conversions qualified | Number |
| all conversions | Number |
| all conversions qualified | Number |
| all revenue | Number |
| view through conversions | Number |
| view through conversions qualified | Number |
| view through revenue | Number |
| assists | Number |
| average CPC | Number |
| final URL | Text |
| final URL suffix | Text |
| tracking template | Text |
| custom parameters | Text |
| report type | Text |
| aggregation | Text |
| client ID | Text |
| conversion rate | Text |
| cost per conversion | Text |
| CTR | Text |
Conversion performance#
Conversion-goal-level daily performance.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| customer ID | Text |
| campaign ID | Text |
| campaign name | Text |
| campaign status | Text |
| ad group ID | Text |
| ad group name | Text |
| ad group status | Text |
| keyword ID | Text |
| keyword | Text |
| keyword status | Text |
| device type | Text |
| conversion action ID | Text |
| conversion action name | Text |
| conversion action type | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| CTR | Text |
| conversions | Number |
| conversions qualified | Number |
| conversion rate | Text |
| cost per conversion | Number |
| all conversions | Number |
| all conversions qualified | Number |
| revenue | Number |
| revenue per conversion | Number |
| all revenue | Number |
| view through conversions | Number |
| view through conversions qualified | Number |
| view through revenue | Number |
| report type | Text |
| aggregation | Text |
| client ID | Text |
Geographic performance daily#
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| customer ID | Text |
| campaign ID | Text |
| campaign name | Text |
| country | Text |
| state | Text |
| metro area | Text |
| county | Text |
| postal code | Text |
| location type | Text |
| most specific location | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| conversions qualified | Number |
| revenue | Number |
| report type | Text |
| aggregation | Text |
| client ID | Text |
Campaigns#
| Field | Type |
|---|---|
| account ID | Text |
| campaign ID | Text |
| campaign name | Text |
| campaign status | Text |
| campaign type | Text |
| campaign objective | Text |
| bid strategy | Text |
| target cpa | Number |
| target ROAS | Number |
| max CPC amount | Number |
| conversion goal IDs json | Text |
| daily budget | Text |
| end date | Text |
| lifetime budget | Text |
| start date | Text |
Conversion goals#
| Field | Type |
|---|---|
| account ID | Text |
| conversion goal ID | Text |
| conversion goal name | Text |
| conversion goal type | Text |
| goal category | Text |
| conversion window minutes | Integer |
| count type | Text |
| exclude from bidding | True/false |
| scope | Text |
| tag ID | Text |
Uet tags#
Daily snapshot of the account's Universal Event Tracking (UET) tag catalog.
| Field | Type |
|---|---|
| account ID | Text |
| customer ID | Text |
| tag ID | Text |
| tag name | Text |
| tag description | Text |
| tracking status | Text |
| customer share json | Text |
| has tracking script | True/false |
| snapshot date | Date |
Configured target coverage#
Current completeness status for Microsoft Advertising configured conversion-goal collection by account scope.
| Field | Type |
|---|---|
| coverage key | Text |
| account ID | Text |
| scope level | Text |
| collection status | Text |
| source entity count | Integer |
| configured target count | Integer |
| capability reason | Text |
| collected at | Timestamp |