Yahoo ads predefined reports

The Yahoo Ads data source in Data Integration includes predefined reports. Each report includes a short description of the data, a list of customizable fields (if applicable), and the schema mapping.

These reports follow a standardized format, so specific fields are locked, and you can only access them through the Custom reports feature.

note

Yahoo Ads does not have any source-level selections to filter each report in the Data Flow.

Campaigns

The Campaigns report returns a list of campaigns and their attributes for the specified Yahoo Ads account.

Field	Data Type	Dimension/Metric
id	Integer	Dimension
advancedGeoNeg	String	Dimension
advertiserId	Integer	Metric
biddingStrategy	String	Dimension
budget	Integer	Metric
budgetType	String	Dimension
campaignName	String	Dimension
channel	String	Dimension
conversionRuleConfig	Record	Dimension
conversionRuleIds	Integer	Metric
createdDate	Integer	Metric
customParameters	String	Dimension
editorialStatus	String	Dimension
effectiveStatus	String	Dimension
advancedGeoPos	String	Dimension
isDeepLink	String	Dimension
isPartnerNetwork	String	Dimension
language	String	Dimension
lastUpdateDate	Integer	Metric
objective	String	Dimension
status	String	Dimension
subChannel	String	Dimension
subChannelModifier	String	Dimension
tagId	Integer	Metric
trackingUrl	String	Dimension

Adgroups

The Adgroups report returns a list of adgroups and their attributes for the specified Yahoo Ads account. The only customization available for this report is a Campaign filter option, which enables you to narrow the output by specific campaigns.

Field	Data Type	Dimension/Metric
id	Integer	Dimension
adGroupName	String	Dimension
advancedGeoPos	String	Dimension
advertiserId	Integer	Metric
bidSet	Record	Dimension
biddingStrategy	String	Dimension
campaignId	Integer	Metric
createdDate	Integer	Metric
customParameters	String	Dimension
dpaAudienceStrategy	String	Dimension
ecpaGoal	Float	Metric
editorialStatus	String	Dimension
endDateStr	String	Dimension
advancedGeoNeg	String	Dimension
isPromotionIncluded	String	Dimension
lastUpdateDate	Integer	Metric
productSetId	String	Dimension
startDateStr	String	Dimension
status	String	Dimension
trackingUrl	String	Dimension

Ads

The Ads report returns a list of ads and their attributes for the specified Yahoo Ads account.

Field	Data Type	Dimension/Metric
id	Integer	Dimension
adGroupId	Integer	Metric
advertiserId	Integer	Metric
assets	Record	Dimension
callToActionText	String	Dimension
campaignId	Integer	Metric
contentUrl	String	Dimension
createdDate	Integer	Metric
customParameters	String	Dimension
description	String	Dimension
displayUrl	String	Dimension
displayUrlPath1	String	Dimension
displayUrlPath2	String	Dimension
dpaDomain	String	Dimension
editorialStatus	String	Dimension
finalUrl	String	Dimension
flashSaleConfig	String	Dimension
adName	String	Dimension
imageUrl	String	Dimension
imageUrlHQ	String	Dimension
imageUrlThumbnail	String	Dimension
impressionTrackingUrls	Record	Dimension
isAdTemplate	String	Dimension
landingUrl	String	Dimension
lastUpdateDate	Integer	Metric
mailAssetUrl	String	Dimension
mobileFinalUrl	String	Dimension
optimizeAssets	Boolean	Dimension
rejectionReasons	String	Dimension
runAsSingleImage	Boolean	Dimension
sponsoredBy	String	Dimension
status	String	Dimension
styles	String	Dimension
title	String	Dimension
title2	String	Dimension
trackingUrl	String	Dimension
videoAutoloop	String	Dimension
videoCaptionUrl	String	Dimension
videoPreviewStartTime	Integer	Metric
videoPrimaryUrl	String	Dimension
videoScrolling	String	Dimension