Page Summary
-
This SDF version is deprecated and users should migrate to SDF v9 before November 4, 2025.
-
The document describes various fields for structured data files, including their requirements, types, writability, and descriptions.
-
Key fields include Product Id, Plan Id, Campaign Id, Name, Type, Start Date, End Date, Budget, Frequency settings, and various targeting options (Geography, Language, Channel, Category, Audience, Affinity & In Market, Demographic, Device, Video Player Size, and Private deal details).
-
Several fields are not required, while some, like Name and Frequency Enabled, are required, and Frequency Exposures, Period, and Amount are required when Frequency Enabled is TRUE.
-
Targeting options can often include or exclude specific criteria using lists of resource IDs or predefined acceptable values, with specific formats and examples provided for each.
See the overview for an explanation of format.
- Open Auction Display
- Open Auction Audio
- Open Auction Video
- Video View Campaign
- Efficient Reach
- Youtube TrueView In-stream
- Youtube TrueView Discovery
- Youtube TrueView Bumper
- Youtube TrueView Reach
- Youtube Audio
- Target Frequency Bumper Skippable
- Target Frequency Non Skippable
- Target Frequency Skippable
- Target Frequency Bumper
- Google Preferred Bumper
- Google Preferred Short
- Google Preferred Long
- Google Preferred Non-skippable In-stream 30s
- Google Preferred YouTube Shorts
- Standard Reserve Short
- Standard Reserve Long
- Non-skippable In-stream
- Private (Publisher)
- Private (Inventory source)
- Private (Negotiation)
- Demand Gen
- Minutes
- Hours
- Days
- Weeks
- Months
- Lifetime
List of geographies to include in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_GEO_REGION
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of languages to include in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_LANGUAGE
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of languages to exclude in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_LANGUAGE
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of channels to include in targeting.
This column uses Display & Video 360 API Channel
resource IDs.
List format = (Channel.channelId; Channel.channelId; etc.).
List of channels to exclude in targeting.
This column uses Display & Video 360 API Channel
resource IDs.
List format = (Channel.channelId; Channel.channelId; etc.).
List of categories to include in targeting. This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_CATEGORY
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
TargetingOption
resource IDs for targeting type TARGETING_TYPE_CATEGORY
. List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of audience lists to include in targeting.
This column uses Display & Video 360 API FirstPartyAndPartnerAudience
resource IDs.
For first-party audience lists, each audience is listed as a pair of FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId and recency setting. A pair is (1;1d;), where 1d is a sample recency representing 1 day recency. Recency is not available for third-party audiences, so the list format is (3;);(4;);. To "AND" and "OR" groups of audiences, follow this example: To combine pairs with and without recency: '((1;1d;);(2;365d;));((3;);(4;5m;);(5;all;));'. This means (list 1 with 1 day recency OR list 2 with 365day recency ) AND (list 3 without a specified recency OR list 4 with 5 minute recency OR list 5 with all users).
Valid recency values are:
- all
- 1m
- 5m
- 10m
- 15m
- 30m
- 1h
- 2h
- 3h
- 6h
- 12h
- 1d
- 2d
- 3d
- 5d
- 7d
- 10d
- 14d
- 15d
- 21d
- 28d
- 30d
- 45d
- 60d
- 90d
- 120d
- 180d
- 270d
- 365d
List of audience lists to exclude in targeting.
This column uses Display & Video 360 API FirstPartyAndPartnerAudience
resource IDs.
Each audience is listed as a pair of FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId and recency setting, if the audience list is a 1P audience list. A pair is (1;1d;), where 1d is a sample recency representing 1 day recency. However, for 3P audiences, recency is not available, so the list format is (3;);(4;);.
List format = ((FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId; recency optional;); (FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId; recency optional;);)Example: "(1;1d;);(2;);".
Valid recency values are:
- all
- 1m
- 5m
- 10m
- 15m
- 30m
- 1h
- 2h
- 3h
- 6h
- 12h
- 1d
- 2d
- 3d
- 5d
- 7d
- 10d
- 14d
- 15d
- 21d
- 28d
- 30d
- 45d
- 60d
- 90d
- 120d
- 180d
- 270d
- 365d
- Female
- Male
- Unknown
Example 1: to target 18-55 and include unknown ages, specify the format {From; To ; Include unknown True/False} = 18;55;true;
Example 2: to target only users >35 years old and exclude unknown ages, specify the following = 35;+;false;.
Acceptable values for From:
- 18
- 25
- 35
- 45
- 55
- 65
Acceptable values for To:
- 25
- 35
- 45
- 55
- 65
- +
- Parent
- Not a parent
- Unknown
List of devices to include in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for the following targeting types:
-
TARGETING_TYPE_DEVICE_TYPE -
TARGETING_TYPE_DEVICE_MAKE_MODEL -
TARGETING_TYPE_OPERATING_SYSTEM
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
- unknown
- small
- large
- HD

