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.
Yahoo Ads does not have any source-level selections to filter each report in the river.
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 allows 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 |
