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.

FieldType
account IDText
customer IDText
account nameText
account numberText
currency codeText
time zoneText
account statusText
financial statusText
account modeText
languageText
auto tag typeText
last modified atTimestamp
msclkid auto tagging enabledTrue/false

Asset performance#

Daily Microsoft Advertising creative asset performance at campaign and asset grain.

FieldType
dateDate
account IDText
campaign IDText
campaign nameText
asset IDText
asset contentText
asset typeText
asset sourceText
impressionsInteger
clicksInteger
CTRNumber
spendNumber
conversionsNumber
revenueNumber
video viewsInteger

Asset parent performance#

Daily Microsoft Advertising asset performance under its parent.

FieldType
dateDate
account IDText
customer IDText
campaign IDText
campaign nameText
ad group IDText
ad group nameText
ad IDText
asset group IDText
asset IDText
asset contentText
asset typeText
asset sourceText
impressionsInteger
clicksInteger
spendNumber
conversionsNumber
revenueNumber
video viewsInteger
video views p25Integer
video views p50Integer
video views p75Integer
completed video viewsInteger
report typeText
aggregationText
client IDText

Campaign performance#

Campaign-level performance metrics.

FieldType
dateDate
account IDText
customer IDText
campaign IDText
campaign nameText
campaign statusText
campaign typeText
impressionsInteger
clicksInteger
spendNumber
conversionsNumber
revenueNumber
conversions qualifiedNumber
all conversionsNumber
all conversions qualifiedNumber
all revenueNumber
view through conversionsNumber
view through conversions qualifiedNumber
view through revenueNumber
assistsNumber
tracking templateText
custom parametersText
final URL suffixText
average CPCNumber
quality scoreInteger
report typeText
aggregationText
client IDText
conversion rateText
cost per conversionText
CTRText

Ad group performance#

Ad group-level performance metrics.

FieldType
dateDate
account IDText
customer IDText
campaign IDText
campaign nameText
campaign statusText
ad group IDText
ad group nameText
ad group statusText
ad group typeText
impressionsInteger
clicksInteger
spendNumber
conversionsNumber
revenueNumber
conversions qualifiedNumber
all conversionsNumber
all conversions qualifiedNumber
all revenueNumber
view through conversionsNumber
view through conversions qualifiedNumber
view through revenueNumber
assistsNumber
average CPCNumber
quality scoreInteger
report typeText
aggregationText
client IDText
conversion rateText
cost per conversionText
CTRText

Ad performance#

Ad-level performance metrics.

FieldType
dateDate
account IDText
customer IDText
campaign IDText
campaign nameText
ad group IDText
ad group nameText
ad IDText
ad nameText
ad titleText
ad typeText
ad statusText
impressionsInteger
clicksInteger
spendNumber
conversionsNumber
revenueNumber
conversions qualifiedNumber
all conversionsNumber
all conversions qualifiedNumber
all revenueNumber
view through conversionsNumber
view through conversions qualifiedNumber
view through revenueNumber
assistsNumber
average CPCNumber
report typeText
aggregationText
client IDText
conversion rateText
cost per conversionText
CTRText
custom parametersText
final URLText
final URL suffixText
tracking templateText

Ad conversion performance#

Daily Microsoft Advertising conversion goals reported at delivered-ad grain.

FieldType
dateDate
account IDText
customer IDText
campaign IDText
campaign nameText
ad group IDText
ad group nameText
ad IDText
ad titleText
ad typeText
ad statusText
conversion action IDText
conversion action nameText
conversion action typeText
conversionsNumber
conversions qualifiedNumber
revenueNumber
all conversionsNumber
all conversions qualifiedNumber
all revenueNumber
view through conversionsNumber
view through conversions qualifiedNumber
view through revenueNumber
report typeText
aggregationText
client IDText

Conversion report coverage daily#

Successful Microsoft Ads native conversion-report coverage, including empty account-date windows.

FieldType
dateDate
account IDText
report nameText
requested grainText
reported grainText
report statusText
row countInteger
is partialTrue/false

Keyword performance#

Keyword-level performance metrics.

FieldType
dateDate
account IDText
customer IDText
campaign IDText
campaign nameText
ad group IDText
ad group nameText
keyword IDText
keywordText
match typeText
bid match typeText
quality scoreInteger
max CPCNumber
impressionsInteger
clicksInteger
spendNumber
conversionsNumber
revenueNumber
conversions qualifiedNumber
all conversionsNumber
all conversions qualifiedNumber
all revenueNumber
view through conversionsNumber
view through conversions qualifiedNumber
view through revenueNumber
assistsNumber
average CPCNumber
final URLText
final URL suffixText
tracking templateText
custom parametersText
report typeText
aggregationText
client IDText
conversion rateText
cost per conversionText
CTRText

Conversion performance#

Conversion-goal-level daily performance.

FieldType
dateDate
account IDText
customer IDText
campaign IDText
campaign nameText
campaign statusText
ad group IDText
ad group nameText
ad group statusText
keyword IDText
keywordText
keyword statusText
device typeText
conversion action IDText
conversion action nameText
conversion action typeText
impressionsInteger
clicksInteger
spendNumber
CTRText
conversionsNumber
conversions qualifiedNumber
conversion rateText
cost per conversionNumber
all conversionsNumber
all conversions qualifiedNumber
revenueNumber
revenue per conversionNumber
all revenueNumber
view through conversionsNumber
view through conversions qualifiedNumber
view through revenueNumber
report typeText
aggregationText
client IDText

Geographic performance daily#

FieldType
dateDate
account IDText
customer IDText
campaign IDText
campaign nameText
countryText
stateText
metro areaText
countyText
postal codeText
location typeText
most specific locationText
impressionsInteger
clicksInteger
spendNumber
conversions qualifiedNumber
revenueNumber
report typeText
aggregationText
client IDText

Campaigns#

FieldType
account IDText
campaign IDText
campaign nameText
campaign statusText
campaign typeText
campaign objectiveText
bid strategyText
target cpaNumber
target ROASNumber
max CPC amountNumber
conversion goal IDs jsonText
daily budgetText
end dateText
lifetime budgetText
start dateText

Conversion goals#

FieldType
account IDText
conversion goal IDText
conversion goal nameText
conversion goal typeText
goal categoryText
conversion window minutesInteger
count typeText
exclude from biddingTrue/false
scopeText
tag IDText

Uet tags#

Daily snapshot of the account's Universal Event Tracking (UET) tag catalog.

FieldType
account IDText
customer IDText
tag IDText
tag nameText
tag descriptionText
tracking statusText
customer share jsonText
has tracking scriptTrue/false
snapshot dateDate

Configured target coverage#

Current completeness status for Microsoft Advertising configured conversion-goal collection by account scope.

FieldType
coverage keyText
account IDText
scope levelText
collection statusText
source entity countInteger
configured target countInteger
capability reasonText
collected atTimestamp