Page Summary
-
This document describes the fields in the read-only beta version of the QA file format for Structured Data Files (SDF).
-
The file format includes fields covering identifiers, ad types, dates, budgets, pacing, frequency capping, revenue models, conversion tracking, fees, integration codes, details, bid strategies, targeting options, and various settings for TrueView and Demand Gen line items.
-
Specific fields detail geography, language, device, browser, brand safety, channel, site, app, category, genre, keyword, and audience targeting.
-
TrueView and Demand Gen line items have dedicated fields for bid adjustments, category exclusions, inventory sources, and third-party measurement vendors for viewability, brand safety, reach, and brand lift.
-
Additional fields cover settings for video sequences, Merchant Center accounts, related videos, video sequence steps, minimum duration, and video ad inventory control.
See the overview for an explanation of format.
This is a QA file format . Files in this format are read-only and cannot be uploaded.
Only writable when creating, not editing.
Select one of the following values:
- Display
- Video
- TrueView
- Audio
- Demand Gen
Select one of the following values:
- Simple
- Non Skippable
- Action
- Reach
- View
- Audio
- Over The Top
- Mobile App Install
- Mobile App Buying
- Simple Over The Top
- Non Skippable Over The Top
- Reach Over The Top
- Target Frequency
- Demand Gen
- Video Sequence
'Action' is not compatible with TrueView line items.
'Video Sequence' is only available for a closed list of Display & Video 360 clients.
- Active
- Paused
- Archived
- Deleted
- Draft
- Amount
- Impressions
- Unlimited
- Automatic
- TrueView Budget
The time period used to spend to the pacing amount.
- Daily
- Monthly
- Flight
The rate of pacing for this entry.
- ASAP
- Even
- Ahead
- Minutes
- Hours
- Days
- Weeks
- Months
- Lifetime
- TRUE
- FALSE
- Days
- Weeks
- Months
- TMCM - Total Media Cost Markup
- MCM - Media Cost Markup
- CPM - Cost Per thousand impressions
- Count all
- Count post-click
- Count %
The floodlight activities used for conversions and related settings.
This column uses Display & Video 360 API FloodlightActivity
resource display name and measurements, in minutes, of post-view and post-click windows.
List of list format = ((FloodlightActivity.displayName; view_window_days; click_window_days;);(FloodlightActivity.displayName; view_window_days; click_window_days;);).
This list is generated in ascending alphabetical order.
- Fee category
- CPM
- Media
- Fee amount
- Float
- Pct as float
- Fee type
- (string, see table in fees)
- Invoiced
- True
- False
- blank
Example '(CPM; 2; Display & Video 360 Fee; False) ; (Media; 13; Default; True);'Acceptable values are provided in the following table:
| Fee category | Fee Type | Invoiced option |
|---|---|---|
|
CPM/Media
|
Default | Not permitted (leave blank) |
|
CPM/Media
|
Third-Party Ad Server | Not permitted (leave blank) |
|
CPM/Media
|
DoubleVerify | Permitted (True/False) |
|
CPM/Media
|
Adsafe | Not permitted (leave blank) |
|
CPM/Media
|
Adxpose | Not permitted (leave blank) |
|
CPM/Media
|
Vizu | Not permitted (leave blank) |
|
CPM/Media
|
Aggregate Knowledge | Not permitted (leave blank) |
|
CPM/Media
|
Teracent | Not permitted (leave blank) |
|
CPM/Media
|
Evidon | Not permitted (leave blank) |
|
CPM/Media
|
Agency Trading Desk Fee | Not permitted (leave blank) |
|
CPM/Media
|
Adloox | Permitted (True/False) |
|
CPM
|
ShopLocal | Required (True) |
|
CPM
|
TrustMetrics | Not permitted (leave blank) |
|
CPM
|
Integral Ad Science Video | Permitted (True/False) |
|
CPM
|
MOAT Video | Not permitted (leave blank) |
|
Media
|
Display & Video 360 Fee | Required (True) |
|
Media
|
Media Cost Data | Not permitted (leave blank) |
|
Media
|
Scibids Fee | Required (True) |
- Minimize: While spending the full budget, minimize CPA/CPC
- Maximize: While spending the full budget, maximize Impression Value or Quality Impression
- Beat: Meet or beat a goal of X CPA/CPC
- Optimize vCPM: Optimize for viewable CPM bid of X
- Fixed: Specify a fixed bid of X
Note that no Bid Strategy Value is required for the Bid Strategy Type 'Minimize' or 'Maximize'
- CPA
- CPC
- custom impr. value/cost
- CIVA
- IVO_TEN
- AV_VIEWED
- REACH
This corresponding algorithm ID must be used when Bid Strategy Unit is set to custom impr. value/cost.
Any floodlight activies used in the algorithm assigned to this column must be included in the 'Conversion Floodlight Activity Ids' column. Attempts to assign an algorithm without properly updating the 'Conversion Floodlight Activity Ids' column will result in an error.
Whether this line item serves European Union political ads.
If you have declared that this advertiser does not serve EU political ads, new line items will be assigned the 'No' value if the column is not set.
This value can be updated for existing line items using the UI, SDF or API.
- Yes
- No
- Unset
The primary status for the entry.
The following are possible statuses:
- Eligible
- Not eligible
- Paused
- Removed
- Ended
- Limited
- Pending
- Misconfigured
The cause of the current primary status.
- Campaign group paused
- Campaign group all group budgets ended
- Campaign ended
- Campaign paused
- Campaign pending
- Campaign removed
- No ad groups
- Has ads disapproved
- Has ads limited by policy
- No ad group ads
- Most ads under review
- No mobile application ad group criteria
- Bidding strategy learning
- Missing location targeting
- Line Item
- Ad Group
List of proximity targets each in the format "(Latitude; Longitude; Radius; Unit; FullAddress;);". Latitude is between -90 and 90 degrees (inclusive); Longitude is between -180 and 180 degrees (inclusive); Radius is a distance between 1 and 500 (inclusive) in Unit; Unit can be "mi" or "km"; FullAddress is optional. For example: "(38.907192; -77.03687; 1.0; mi; Washington D.C., DC, USA;); (40.712775; -74.005972; 20.5; km; 40.712775, -74.005972;); (20.000234; -56.675423; 5.0; mi; ;);".
If the 'Type' column is set to 'Demand Gen', this column is only available if the line item has a geography and language targeting level set to line item in the UI.
- G
- PG
- T
- MA
- ?
- Do not block
- Use Campaign Manager 360 Verification
- Use custom
- Sexual
- Derogatory
- Downloads & Sharing
- Weapons
- Gambling
- Violence
- Suggestive
- Profanity
- Alcohol
- Drugs
- Tobacco
- Politics
- Religion
- Tragedy
- Transportation Accidents
- Sensitive social issues
- Shocking
- None
- Integral Ad Science
- DoubleVerify
- Adloox
List of sites to include in targeting. The list is strings of URLs.
List format = (someurl.com; someurltwo.com; etc.). This list is generated in alphabetical order.
If the total character length of the list exceeds 32700 characters, individual URLs in the list will be truncated as needed. Truncated URLs will be no shorter than 10 characters.
List of sites to exclude in targeting. The list is strings of URLs.
List format = (someurl.com; someurltwo.com; etc.). This list is generated in alphabetical order.
If the total character length of the list exceeds 32700 characters, individual URLs in the list will be truncated as needed. Truncated URLs will be no shorter than 10 characters.
List of apps to include in targeting. The list is concatenated strings of app platform and app platform ID.
The following values are used to define the app platform:
-
APP(This encompasses both Android Play store and Apple App store platforms) -
ROKU_APP -
AMAZON_FIRETV_APP -
XBOX_APP -
PLAYSTATION_APP -
APPLE_TV_APP -
SAMSUNG_TV_APP -
ANDROID_TV_APP -
GENERIC_CTV_APP -
LG_TV_APP -
VIZIO_TV_APP
The concatenated string of app platform and ID is separated by a colon, for example: APP:com.google.android.gm
.
List format = (APP:com.google.android.gm; APP:422689480; etc.). This list is generated in ascending alphabetical order.
If the total character length of the list exceeds 32700 characters, individual entries in the list will be truncated as needed. Truncated entries will be no shorter than 10 characters.
List of apps to exclude in targeting. The list is concatenated strings of app platform and app platform ID.
The following values are used to define the app platform:
-
APP(This encompasses both Android Play store and Apple App store platforms) -
ROKU_APP -
AMAZON_FIRETV_APP -
XBOX_APP -
PLAYSTATION_APP -
APPLE_TV_APP -
SAMSUNG_TV_APP -
ANDROID_TV_APP -
GENERIC_CTV_APP -
LG_TV_APP -
VIZIO_TV_APP
The concatenated string of app platform and ID is separated by a colon, for example: APP:com.google.android.gm
.
List format = (APP:com.google.android.gm; APP:422689480; etc.). This list is generated in ascending alphabetical order.
If the total character length of the list exceeds 32700 characters, individual entries in the list will be truncated as needed. Truncated entries will be no shorter than 10 characters.
List of keyword strings to include in targeting. This list is generated in alphabetical order.
If the total character length of the list exceeds 32700 characters, individual entries in the list will be truncated as needed. Truncated entries will be no shorter than 10 characters.
List of keyword strings to exclude in targeting. This list is generated in alphabetical order.
If the total character length of the list exceeds 32700 characters, individual entries in the list will be truncated as needed. Truncated entries will be no shorter than 10 characters.
List of negative keyword lists to exclude in targeting. List format = (Negative keyword list name; Negative keyword list name; etc.). This list is generated in alphabetical order.
Enables your line item to bid lower than your fixed bid.
This column must be unset or set to 'TRUE' unless 'Bid Strategy Type' is 'Fixed'.
- TRUE
- FALSE
Optimized targeting is not compatible with all bid strategies. This column must be 'FALSE' if:
- 'Bid Strategy Type' is 'Fixed'
- 'Bid Strategy Type' is 'Optimized vCPM'
- 'Bid Strategy Type' is 'Maximum' and 'Bid Strategy Unit' is 'CIVA', 'IVO_TEN', or 'AV_VIEWED'
List of first- and third-party audience lists to include in targeting.
For first-party audience lists, each audience is listed as a pair of display name and recency setting. A pair is (Audience name;1d;), where 1d is a sample recency representing 1 day recency. Recency is not available for third-party audiences, so the list format is (Audience name;);(Audience name;);. To "AND" and "OR" groups of audiences, follow this example: To combine pairs with and without recency: '((audience 1 name;1d;);(audience 2 name;365d;));((audience 3 name;);(audience 4 name;5m;);(audience 5 name;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 first- and third-party audience lists to exclude in targeting.
For first-party audience lists, each audience is listed as a pair of display name and recency setting. A pair is (Audience name;1d;), where 1d is a sample recency representing 1 day recency. Recency is not available for third-party audiences, so the list format is (Audience name;);(Audience name;);. To "AND" and "OR" groups of audiences, follow this example: To combine pairs with and without recency: '((audience 1 name;1d;);(audience 2 name;365d;));((audience 3 name;);(audience 4 name;5m;);(audience 5 name;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
A list of life envents audiences names to include in targeting.
List format: Life Event Name; Life Event Name;
A list of life envents audiences names to exclude in targeting.
List format: Life Event Name; Life Event Name;
A list of detailed demo audiences names to include in targeting.
List format: Detailed Demo Name; Detailed Demo Name;
A list of detailed demo audiencesnames to exclude in targeting.
List format: Detailed Demo Name; Detailed Demo Name;
- Authorized Direct Sellers
- Authorized Direct Sellers And Resellers
- Authorized and Non-Participating Publisher
List of inventory sources, exchanges, and sub-exchanges to include in targeting.
List format = (Inventory source/Exchange/Sub-exchange name; Inventory source/Exchange/Sub-exchange name; etc.)
List of inventory sources, exchanges, and sub-exchanges to exclude in targeting.
List format = (Inventory source/Exchange/Sub-exchange name; Inventory source/Exchange/Sub-exchange name; etc.)
- True
- False
List of Deal groups to include in targeting.
List format = (Grouped deal name; Grouped deal name; etc.). This list is generated in alphabetical order.
List of DayParts to target. Each daypart is constructed in the format "day_of_the_week start_time end_time":
- "day_of_the_week" is Monday, Tuesday, Wednesday, Thursday, Friday, Saturday or Sunday
- "start_time" and "end_time" are represented as HH:MM in 24-hour format.
Example list: (Monday 01:20 13:20; Tuesday 09:00 10:00;)
This list is generated in ascending time order, starting with Monday.
- Web
- Web Not Optimized
- App
- TRUE
- FALSE
If OMID targeting is enabled at the advertiser level and supported for the entity, this column cannot be set to 'FALSE'. If this column is not set at resource creation for a supported entity, it will default to the advertiser level setting.
- Above the fold
- Below the fold
- Unknown
- In-Article
- In-Feed
- In-Banner
- Interstitial
- Unknown
- In-Article
- In-Feed
- In-Banner
- Interstitial
- Unknown Out-Stream
- Pre-Roll
- Mid-Roll
- Post-Roll
- Unknown In-Stream
- Pre-Roll
- Mid-Roll
- Post-Roll
- Unknown
- unknown
- small
- large
- HD
- 0-1
- 1-5
- 5-15
- 15-30
- 30-60
- 60+
- unknown
- livestream
- on-demand
- unknown
- online radio
- streaming music
- podcasts
Full list of genders being targeted.
List format = (Female; Male; Unknown;)
- Female
- Male
- Unknown
Full list of ages being targeted.
List format = (25-34; 35-44; Unknown;)
- 18-24
- 25-34
- 35-44
- 45-54
- 55-64
- 65+
- Unknown
Full list of household incomes being targeted.
List format = (Top 10%; 11-20%; 21-30%;)
- Top 10%
- 11-20%
- 21-30%
- 31-40%
- 41-50%
- Lower 50%
- Unknown
Full list of parental status being targeted.
List format = (Parent;)
- Parent
- Not a parent
- Unknown
- All
- 2G
- 3G
- DSL
- 4G
List of popular content across YouTube and Google video partners to exclude. Individual content groupings should have the structured 'video_content:: Content Grouping ID '.
List format = (video_content:: Content Grouping ID ; video_content:: Content Grouping ID ; etc.).
This column is only available if 'Subtype' is 'Video Sequence'.
List of URLs to exclude in targeting. The list consists of URL strings.
List format = (someurl.com; someurltwo.com; etc.).
This column is only available if 'Subtype' is 'Video Sequence'.
List of mobile apps to exclude in targeting. The list consists of app platform IDs.
The ID is provided by the relevant platform, such as a bundle ID from Android's Play store (example: com.google.android.gm) or a App ID from Apple's App store (example: 422689480).
List format = (com.google.android.gm; 422689480; etc.).
This column is only available if 'Subtype' is 'Video Sequence'.
Skippable / In-feed Video are TrueView video ad types sold on a CPV basis. Non skippable video ads are in-stream ads between 6 and 15 seconds sold on a CPM basis. Skippable / Bumper / Non-skippable video ads are acceptable TrueView video ad types for line items with a 'Target Frequency' or 'Video Sequence' subtype sold on a CPM basis. Responsive video ads are ad types that serve as multiple formats.
- Skippable
- Skippable / In-feed Video
- Non Skippable
- Skippable / Bumper / Non-skippable
- Responsive
Select one of the following values:
- Manual CPV: Manual view-based bidding where you pay per view.
- Manual CPM: Manual impression-based bidding where you pay per thousand impressions. This value is not supported for new Trueview or Demand Gen line items.
- Target CPM: Automated bid strategy that optimizes bids to help get as many impressions as possible using a target amount for how much you're willing to pay every thousand times your ad is shown.
- Maximize Conversions: Automated bid strategy that optimizes bids to help get as many conversions as possible.
- Target CPA: Automated bid strategy that optimizes bids to help get as many conversions as possible using a target amount for how much you're willing to pay per conversion.
- Maximize Conversion Value: Automated value-based bidding strategy that optimizes for the higher value conversions.
- Target ROAS: A value-based bidding strategy that optimizes for higher value of a conversion.
- Maximize Clicks: Automated bidding strategy that optimizes bids to maximize clicks based on budget
- Increase
- Decrease
Bid adjustment to increase chances of showing ads on mobile. Acceptable adjustments are for Bid Adjustment Option 'Increase': [0;900%]; and for 'Decrease': [0;90%] or 100%.
When 'TrueView Bid Strategy Type' is 'Target CPA 'or 'Maximize Conversions', or when 'Subtype is 'Demand Gen' or 'Video Sequence', acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
- Increase
- Decrease
Bid adjustment to increase chances of showing ads on desktop. Acceptable adjustments are for Bid Adjustment Option 'Increase': [0;900%]; and for 'Decrease': [0;90%] or 100%.
When 'TrueView Bid Strategy Type' is 'Target CPA 'or 'Maximize Conversions', or when 'Subtype is 'Demand Gen' or 'Video Sequence', acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
- Increase
- Decrease
Bid adjustment to increase chances of showing ads on tablet. Acceptable adjustments are for Bid Adjustment Option 'Increase': [0;900%]; and for 'Decrease': [0;90%] or 100%.
When 'TrueView Bid Strategy Type' is 'Target CPA 'or 'Maximize Conversions', or when 'Subtype is 'Demand Gen' or 'Video Sequence', acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
- Increase
- Decrease
Bid adjustment to increase chances of showing ads on connected TVs. Acceptable adjustments are for Bid Adjustment Option 'Increase': [0;900%]; and for 'Decrease': [0;90%] or 100%.
When 'TrueView Bid Strategy Type' is 'Target CPA 'or 'Maximize Conversions', or when 'Subtype is 'Demand Gen' or 'Video Sequence', acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
- Embedded Videos
- Live Streaming
- Games
- Families
Lists of TrueView inventory sources to include
- YouTube
- Google TV
- Video Partners
'Video Partners' must be included for Demand Gen line items.
Select one of the following values:
- None
- Moat
- DoubleVerify
- Integral Ad Science
Select one of the following values:
- None
- DoubleVerify
- Integral Ad Science
- Zefr
Select one of the following values:
- None
- Nielsen
- Comscore
- Kantar
- Gemius
- Video Research
- Media Scope
- Audience Project
- iSpot TV
- VideoAmp
Select one of the following values:
- None
- Kantar
- Dynata
- Intage
- Nielsen
- Macromill
- Weekly
- Monthly
Select one or more of the acceptable ad format values:
- In-stream
- In-feed
- Shorts
Merchant Center Account Id. Immutable once set.
Only valid if 'Type' is 'TrueView' or 'Demand Gen'.
List of related YouTube videos. If set, the list must contain 2 to 5 YouTube video IDs.
List format = (YouTube Video ID; YouTube Video ID; etc.).
Only valid if 'Type' is 'TrueView'.
A list of values representing the sequence of steps that constitutes a video sequence line item. Each item in the list represents a 'step' in the sequence.
Each step, formatted as "(step_id; previous_step_id; interaction_type; ad_group_type; video_asset_id;)", uses the following fields:
- step_id: the unique ID of the step. If this is a new step, you must use a negative number as a temporary ID, such as -1, -2, etc. Once saved, the system will assign a new ID to this step.
- previous_step_id: the step ID of the previous step in the sequence. Steps connected by 'Skip' and 'Paid View' interactions may have the same previous step, creating a branching sequence.
- interaction_type: the type of interaction that connects the previous step to this step. Accepted values are 'Impression', 'Skip', and 'Paid View'.
- ad_group_type: the ad group type of the step. Accepted values are 'In-stream', 'Bumper', and 'Non skippable'.
- video_asset_id: the asset ID of the step's ad video.
Sequences must follow the following rules:
- The first step of a sequence must have empty 'previous_step_id' and 'interaction_type' values.
- The previous step has to be in front of its next step in the list.
- Leaving the column empty will remove any existing video sequence for the line item on upload.
List format = ((step_id; previous_step_id; interaction_type; ad_group_type; video_asset_id;);(step_id; previous_step_id; interaction_type; ad_group_type; video_asset_id;);)
This column is only available if 'Subtype' is 'Video Sequence'.
The minimum amount of time required for a user to repeat an ad sequence.
- Week
- Month
Only available for 'Video Sequence' line items.

