# Entity Read Files Format - V2

> [!WARNING]
> Entity Read Files have sunset. [Migrate to use the
> Display \& Video 360 API.](https://developers.google.com/display-video/api/guides/how-tos/erf-migration)

> [!CAUTION]
> Null scalars as well as empty arrays are omitted from the files.

- [Shared Types](https://developers.google.com/bid-manager/guides/entity-read/format-v2#sharedTypes)
- [Private Tables](https://developers.google.com/bid-manager/guides/entity-read/format-v2#privateTables)
- [Public Tables](https://developers.google.com/bid-manager/guides/entity-read/format-v2#publicTables)

## Shared Types

These types define the nested fields in some tables; these fields do not have their own tables.

### `Numeric Id` type

| Scalar | Description |
|---|---|
| `integer` | A numerical ID number used as an identifier for entities. The IDs should not be treated as universally unique, for example there may be the same ID value used for a Campaign that is also used for a Pixel. |

### `Enum` type

| Scalar | Description |
|---|---|
| `integer` | An enumeration of multiple possible options. The different options are described in more detail in the parent type. |

### `Time` type

| Scalar | Description |
|---|---|
| `integer` | A unix time in microseconds (1/1,000,000 second), for example 1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. |

### `Currency Micro` type

| Scalar | Description |
|---|---|
| `integer` | The currency-specific amount in micros (1/1,000,000 of a currency unit), for example if the currency was EUR, `75000000` would mean €75 or if the currency was USD, `250000` would mean $0.25. There is no conversion to or from dollar amounts. |

### `Percentage Milli` type

| Scalar | Description |
|---|---|
| `integer` | A percentage shown in millis (1/1,000 of a percent), for example `100` means 0.1%. |

### `FileSummary` type

| Field Name | Type | Description |
|---|---|---|
| `name` | `string` | The file's file name (not including the bucket or directory name). |
| `num_records` | `integer` | The number of entities in the file. |
| `version` | `integer` | The major version number of the file. This number may change if new versions of the entity data format are created in the future. |

### `EntityCommonData` type

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique ID within each entity type - for example with Partner entities this ID would be the Partner ID, for Advertisers it would be the Advertiser ID and so on. |
| `name` | `string` | The UI-visible name of the entity. |
| `active` | `boolean` | Status as set by the user - the entity may not be *serving* for other reasons, e.g. a depleted budget, out of flight and so on. |
| `integration_code` | `string` | Integration code set by the user |

### `ExchangeSettings` type

| Field Name | Type | Description |
|---|---|---|
| `exchange_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID for the exchange. Joinable with [SupportedExchange](https://developers.google.com/bid-manager/guides/entity-read/format-v2#supportedexchange).id |
| `seat_id` | `string` | Seat ID for the exchange |
| `seat_user_name` | `string` | The user name related to this seat (only applicable for Right Media non-RTB seats). |

### `ApprovalStatus` type

| Field Name | Type | Description |
|---|---|---|
| `auditor` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=DOUBLECLICK_BID_MANAGER 1=DOUBLECLICK_AD_EXCHANGE 2=APPNEXUS 3=APPNEXUS_MICROSOFT 4=RIGHT_MEDIA_NON_RTB` |
| `status` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=APPROVED 1=REJECTED 2=PENDING 3=NO_AUDIT 4=UN_AUDITABLE 5=UNKNOWN 6=IN_AUDIT` |
| `feedback` | `string` | Feedback form the auditor which may cotain additional information such as rejection reasons. |
| `sync_time` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#time` | Last time that the entity was synced with the `auditor` |
| `external_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Populated only if `auditor` is `APPNEXUS`, `APPNEXUS_MICROSOFT` or `RIGHT_MEDIA_NON_RTB`. This is the id of the entity in the auditor space. |

### `Budget` type

| Field Name | Type | Description |
|---|---|---|
| `start_time_usec` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#time` | Start time of the budget period. |
| `end_time_usec` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#time` | End time of the budget period. |
| `max_impressions` | `integer` | Maximum number of impressions for this budget. If this field is missing it is an unlimited-impression budget. |
| `max_spend_advertiser_micros` | `integer` | Maximum spend (in advertiser currency micros) for this budget. If this field is missing it is an unlimited-spend budget. |
| `pacing_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=FLIGHT 1=DAILY` |
| `pacing_max_impressions` | `integer` | Maximum number of impressions per pacing interval set by the `pacing_type`. If this field is missing then there is not limit on impressions. |
| `pacing_max_spend_advertiser_micros` | `integer` | Maximum spend (in advertiser currency micros) per pacing interval set by the `pacing_type`. If this field is missing then there is not limit on spend. |
| `pacing_distribution` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=ASAP 1=EVEN 2=AHEAD` |

### `FrequencyCap` type

| Field Name | Type | Description |
|---|---|---|
| `max_impressions` | `integer` | The maximum number of impressions in each capping interval. |
| `time_unit` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | The unit of time: `0=MINUTE 1=HOUR 2=DAY 3=WEEK 4=MONTH 5=LIFE_TIME` |
| `time_range` | `integer` | The number of `time_units`, for example if the `time_unit` were `1` then a value of 6 for `time_range` is 6 hours. |

### `PartnerCosts` type

| Field Name | Type | Description |
|---|---|---|
| `cpm_fee_1_advertiser_micros` | `integer` | CPM 1 Fee in advertiser currency micros. |
| `cpm_fee_2_advertiser_micros` | `integer` | CPM 2 Fee in advertiser currency micros. |
| `cpm_fee_3_advertiser_micros` | `integer` | CPM 3 Fee in advertiser currency micros. |
| `cpm_fee_4_advertiser_micros` | `integer` | CPM 4 Fee in advertiser currency micros. |
| `cpm_fee_5_advertiser_micros` | `integer` | CPM 5 Fee in advertiser currency micros. |
| `media_fee_percent_1_millis` | `integer` | Media Fee 1 in `https://developers.google.com/bid-manager/guides/entity-read/format-v2#percentagemilli` |
| `media_fee_percent_2_millis` | `integer` | Media Fee 2 in `https://developers.google.com/bid-manager/guides/entity-read/format-v2#percentagemilli` |
| `media_fee_percent_3_millis` | `integer` | Media Fee 3 in `https://developers.google.com/bid-manager/guides/entity-read/format-v2#percentagemilli` |
| `media_fee_percent_4_millis` | `integer` | Media Fee 4 in `https://developers.google.com/bid-manager/guides/entity-read/format-v2#percentagemilli` |
| `media_fee_percent_5_millis` | `integer` | Media Fee 5 in `https://developers.google.com/bid-manager/guides/entity-read/format-v2#percentagemilli` |
| `cpm_fee_1_cost_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=DEFAULT_COST_TYPE 1=BID_MANAGER_FEE 2=THIRDPARTY_AD_SERVER 3=DOUBLE_VERIFY 4=ADSAFE 5=ADXPOSE 6=VIZU 7=AGGREGATE_KNOWLEDGE 8=TERACENT 9=EVIDON 10=ATD_FEE 11=DMP_FEE 12=INTEGRAL_AD_SCIENCE_PREBID 13=DOUBLE_VERIFY_PREBID 14=SHOP_LOCAL 15=TRUST_METRICS 16=MEDIACOST_DATA 17=INTEGRAL_AD_SCIENCE_VIDEO 18=MOAT_VIDEO 19=NIELSON_OCR 20=COMSCORE_VCE 21=ADLOOX 22=ADLOOX_PREBID 23=EXTRA_XBID_FEE 24=ADLINGO_FEE 25=CUSTOM_FEE_1 26=CUSTOM_FEE_2 27=CUSTOM_FEE_3 28=CUSTOM_FEE_4 29=CUSTOM_FEE_5` The `ATD_FEE` represents the Agency Trading Desk fee. |
| `cpm_fee_2_cost_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_cost_type`. |
| `cpm_fee_3_cost_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_cost_type`. |
| `cpm_fee_4_cost_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_cost_type`. |
| `cpm_fee_5_cost_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_cost_type`. |
| `media_fee_percent_1_cost_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_cost_type`. |
| `media_fee_percent_2_cost_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_cost_type`. |
| `media_fee_percent_3_cost_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_cost_type`. |
| `media_fee_percent_4_cost_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_cost_type`. |
| `media_fee_percent_5_cost_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_cost_type`. |
| `cpm_fee_1_bill_to_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=DEFAULT_BILL_TO_TYPE 1=INVITE_MEDIA 2=PARTNER` |
| `cpm_fee_2_bill_to_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_bill_to_type`. |
| `cpm_fee_3_bill_to_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_bill_to_type`. |
| `cpm_fee_4_bill_to_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_bill_to_type`. |
| `cpm_fee_5_bill_to_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_bill_to_type`. |
| `media_fee_percent_1_bill_to_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_bill_to_type`. |
| `media_fee_percent_2_bill_to_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_bill_to_type`. |
| `media_fee_percent_3_bill_to_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_bill_to_type`. |
| `media_fee_percent_4_bill_to_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_bill_to_type`. |
| `media_fee_percent_5_bill_to_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Same as for `cpm_fee_1_bill_to_type`. |

### `PartnerRevenueModel` type

| Field Name | Type | Description |
|---|---|---|
| `type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=CPM 1=MEDIA_COST_MARKUP 2=TOTAL_MEDIA_COST_MARKUP` |
| `amount_advertiser_micros` | `integer` | The revenue amount in advertiser current micros. This value is only set if the type is `CPM`. |
| `media_cost_markup_percent_millis` | `integer` | The revenue percentage markup in `https://developers.google.com/bid-manager/guides/entity-read/format-v2#percentagemilli`. This value is only set if the type is `MEDIA_COST_MARKUP` or `TOTAL_MEDIA_COST_MARKUP`. |
| `post_view_conversion_tracking_fraction` | `float` | Fraction of post-view conversions to be counted for conversion tracking. If it is 0, only post-click conversions are counted; if 1.0 all conversions are tracked. |

### `CostTrackingPixel` type

| Field Name | Type | Description |
|---|---|---|
| `pixel_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the tracking pixel - note that two `https://developers.google.com/bid-manager/guides/entity-read/format-v2#costtrackingpixel`s may share the same `pixel_id` but have different view or click window values. This value can be joined with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#pixel.common_data.id`. |
| `view_window_minutes` | `integer` | The number of minutes in which to look for post-view conversions. |
| `click_window_minutes` | `integer` | The number of minutes in which to look for post-click conversions. |
| `floodlight_activity_id` | [Numeric Id](https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid) | CM Floodlight activity ids. This value can be joined with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#pixel.dcm_floodlight_id`. |

### `Target` type

| Field Name | Type | Description |
|---|---|---|
| `criteria_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Joinable with another table depending on the type defined in the `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetlist`. This value might be missing. |
| `parameter` | `string` | Additional parameter whose definition depends on the type defined in the `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetlist`. This value might be missing. |
| `excluded` | `boolean` | When `true` this means that the target is excluded. A missing value means `false`. |

### `TargetUnion` type

| Field Name | Type | Description |
|---|---|---|
| `union` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` | An array of `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` types representing the union of targets. |
| `excluded` | `boolean` | When `true` this means that the target union is excluded. A missing value means `false`. |

### `TargetList` type

| Field Name | Type | Description |
|---|---|---|
| `inventory_sources` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` | Array of `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` types for inventory sources. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#inventorysource.id` and `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |
| `geo_locations` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` | Array of `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` types for geo locations. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#geolocation.id` and `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |
| `ad_position` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` | A `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` indicating the advert's position on the publisher page. The `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` values are `0=ALL_POSITIONS 1=ABOVE_THE_FOLD 2=BELOW_THE_FOLD 3=UNKNOWN_POSITION` `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |
| `net_speed` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` | A `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` indicating the network speed. The `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` values are: `0=ALL_CONNECTION_SPEEDS` `1=BROADBAND` (2.0mbps and faster). `2=DIALUP` (56 kbps and slower). `3=UNKNOWN_CONNECTION_SPEED` `4=EDGE` (Enhanced Data for GSM Evolution (2G). 57 kbps and faster). `5=UMT` (Universal Mobile Telecom System (3G). 384 kbps and faster). `6=DSL` (Digital Subscriber Line. 768 kbps and faster). `7=HSDPA` (High-Speed Downlink Packet Access (3.5G). 1.8mpbs and faster). `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |
| `browsers` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetunion` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetunion` type for browsers. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#browser.id` and `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |
| `device_criteria` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targe` | `Array of https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` types for device criteria. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#deviceCriteria.id` and `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |
| `languages` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetunion` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetunion` type for language. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#language.id` and `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |
| `day_parting` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetunion` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetunion` type for day parting. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` has 6 digits: `(TimeZone)(DayOfWeek)(StartTime)(EndTime)` TimeZone: `0=USER 1=EASTERN 2=PACIFIC 3=LONDON 4=COPENHAGEN 5=SYDNEY 6=AUCKLAND 7=HONG_KONG 8=TOKYO 9=CALCUTTA 10=ADVERTISER` DayOfWeek: `0=MONDAY 1=TUESDAY 2=WEDNESDAY 3=THURSDAY 4=FRIDAY 5=SATURDAY 6=SUNDAY` StartTime: Minutes since midnight, divied by 15. Range from 0 to 95. EndTime: Minutes since midnight, dividied by 15. Range from 1 to 96. For example a value of `200380` means Monday 00:45 to 20:00 in Pacific time. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |
| `audience_intersect` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetunion` | Array of `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetunion` types for the intersection of audiences, for example ``` [{“union”: [A, B]}, {“union”: [C, D]}, {“union”: [E, F], “excluded”: true}] ``` Would mean "(A OR B) AND (C OR D) AND NOT (E OR F)". `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#userlist.id` and `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is the pixel recency value in microseconds. If this value is missing then it means targeting all audiences. |
| `keywords` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` | Array of `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` types for keywords. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is undefined and `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is a single keyword. |
| `kct_include_uncrawled_sites` | `boolean` | Flag to indicate whether unindexed websites should be included in the KCT. |
| `page_categories` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` | Array of `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` types for [AdExchange page verticals](https://developers.google.com/adwords/api/docs/appendix/verticals). `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is the numeric ID of a vertical and `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |
| `universal_channels` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` | Array of `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` types for channels. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#universalchannel.id` and `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |
| `sites` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` | Array of `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target` types for sites. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#universalsite.id` or is not set if the site is not in `UniversalSite`. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is a site such as `google.com` but is not necessarily found in `https://developers.google.com/bid-manager/guides/entity-read/format-v2#universalsite`. |
| `isps` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetunion` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetunion` type for Internet Service Provider. `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.criteria_id` is joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#isp.id` and `https://developers.google.com/bid-manager/guides/entity-read/format-v2#target.parameter` is undefined. |

### `SummaryFile` type

| Field Name | Type | Description |
|---|---|---|
| `file` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#fileSummary` | An array of zero or more `https://developers.google.com/bid-manager/guides/entity-read/format-v2#fileSummary` entries. If this array is empty then there was no data generated on that date. |

### `UserListAdvertiserPricing` type

| Field Name | Type | Description |
|---|---|---|
| `pricing` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#userListPricing` |   |
| `advertiser_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` |   |

### `UserListPricing` type

| Field Name | Type | Description |
|---|---|---|
| `cost_type` | `string` |   |
| `currency_code` | `string` | ISO 4217 three-letter currency code, for example USD for US Dollars. |
| `cost_micros` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#currencymicro` |   |

## Private Tables

### `Partner` table

| Field Name | Type | Description |
|---|---|---|
| `common_data` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#entitycommondata` | Contains the common data about this partner such as name and ID. |
| `currency_code` | `string` | ISO 4217 three-letter currency code, for example `USD` for US Dollars. |
| `exchange_settings` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#exchangesettings` | Array of `https://developers.google.com/bid-manager/guides/entity-read/format-v2#exchangesettings` types containing information such as their seat IDs. Only enabled exchanges will be present. |
| `default_partner_costs` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#partnercosts` | Contains information about the deafault costs for this partner. |
| `default_partner_revenue_model` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#partnerrevenuemodel` | Contains information about the default revenue model for this partner. |
| `default_target_list` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetlist` | Contains the default targeting options for the partner. Currently only default geo-targeting is supported here. |

### `Advertiser` table

| Field Name | Type | Description |
|---|---|---|
| `common_data` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#entitycommondata` | Contains the common data about this advertiser such as name and ID. |
| `partner_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent partner object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#partner.common_data.id`. |
| `currency_code` | `string` | ISO 4217 three-letter currency code, for example `USD` for US Dollars. |
| `timezone_code` | `string` | The canonical timezone code, for example "America/Los_Angeles". If the `dfa_configuration` is set as `NORMAL` or `HYBRID` this value will be the same as the associated DFA advertiser's time zone. |
| `landing_page_url` | `string` | The default landing page URL. |
| `available_channel_ids` | `[integer]` | Array of integers containing the available channels associated with this advertiser. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#universalchannel.id`. |
| `blacklist_channel_id` | `[integer]` | Array of integers containing the blacklist channels for this advertiser. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#universalchannel.id`. |
| `dcm_configuration` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=NONE 1=NORMAL 2=HYBRID` |
| `dcm_network_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the CM360 network. This value will be missing if the `dcm_configuration` is set as `NONE`. |
| `dcm_advertiser_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the CM360 advertiser. This value will be missing if the `dcm_configuration` is set as `NONE`. |
| `dcm_floodlight_group_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | This value will be missing if the `dcm_configuration` is set as `NONE`. |
| `dcm_syncable_site_ids` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Array of `Numeric Id` types for each syncable site for this advertiser. |
| `enable_oba_tags` | `boolean` | OBA tags are enabled when this is set as `true`. |

### `Campaign` table

| Field Name | Type | Description |
|---|---|---|
| `common_data` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#entitycommondata` | Contains the common data about this campaign such as name and ID. |
| `advertiser_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent advertiser object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#advertiser.common_data.id` |
| `budget` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#budget` | The planned budget for this campaign. Includes the start time and end time. |
| `frequency_cap` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#frequencycap` | The frequency cap active for this campaign. This value will be missing if there is no frequency cap set. |
| `default_target_list` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetlist` | Contains information about the targeting in effect for this campaign. |
| `uses_video_creatives` | `boolean` | When set to true, video insertion orders will be recommended. |
| `uses_display_creatives` | `boolean` | When set to true, display insertion orders will be recommended. |
| `uses_audio_creatives` | `boolean` | When set to true, audio insertion orders will be recommended. |
| `objective` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Values are: `1 = BRAND_AWARENESS` `2 = ONLINE_ACTION` `3 = OFFLINE_ACTION` `4 = APP_INSTALL` |
| `metric` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Key performance indicator. Use this field to keep track of the primary metric you'll use to evaluate the success of your campaign. Possible values are: `1 = IMPRESSIONS` `2 = VIEWABLE_IMPRESSIONS` `3 = CPM` `4 = CPV` `5 = UNIQUES` `6 = GRP` `7 = TRP` `8 = VCR` `9 = CPA` `10 = ROAS` `11 = CTR` `12 = CPC` `13 = CVR` `14 = CPI` `15 = VIEWABLE_PERCENT` `16 = CPIAVC` `17 = OTHER` |
| `objective_description` | `String` | When the metric is `OTHER` this is the short the description of the metric. |
| `metric_amount_micros` | `integer` | The target amount for the metric in micros. |

### `InsertionOrder` table

| Field Name | Type | Description |
|---|---|---|
| `common_data` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#entitycommondata` |   |
| `advertiser_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent advertiser object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#advertiser.common_data.id`. |
| `campaign_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent campaign object. |
| `overall_budget` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#budget` | The overall budget for this insertion order. Includes the start time and the end time. |
| `scheduled_segments` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#budget` | Contains any scheduled budget segments. This array might be empty or entirely absent. |
| `frequency_cap` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#frequencycap` | The frequency cap active for this insertion order. This value will be missing if there is no frequency cap set. |
| `default_partner_costs` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#partnercosts` |   |
| `default_target_list` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetlist` |   |

### `LineItem` table

| Field Name | Type | Description |
|---|---|---|
| `common_data` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#entitycommondata` |   |
| `line_item_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=RTB 1=RMX_NON_RTB 2=RTB_EXPANDABLE 3=RTB_MOBILE 4=RTB_VIDEO 5=TRUEVIEW 6=NON_RTB_EXCHANGES 7=RTB_AUDIO 8=GMAIL 9=ADWORDS_UAC 11=OUT_OF_HOME` |
| `insertion_order_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent insertion order object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#insertionorder.common_data.id`. |
| `creative_ids` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | An array of creatives that are assigned to this line item. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#creative.common_data.id`. |
| `max_cpm_advertiser_micros` | `integer` | The maximum CPM value in advertiser currency micros. |
| `performance_goal` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=NONE` (vCPM is disabled) `1=CPC 2=CPA 3=ROI 4=CPCV 5=CPM 6=AVCPM 7=IMP_VALUE_ROAS 8=CIVA 9=IVO_TEN 10=AV_VIEWED 11=INCREMENTAL_CONVERSIONS` |
| `goal_advertiser_micros` | `integer` | The vCPM goal in advertiser currency micros. This value will be missing if the `performance_goal` is set as `NONE`. |
| `partner_revenue_model` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#partnerrevenuemodel` | The partner revenue model being used for this line item. |
| `cost_tracking_pixels` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#costtrackingpixel` | Array of CostTrackingPixels assigned to track this line item. |
| `Budget` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#budget` | The overall budget for this line item. Includes the start time and the end time. |
| `frequency_cap` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#frequencycap` | The frequency cap active for this line item. This value will be missing if there is no frequency cap set. |
| `partner_costs` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#partnercosts` |   |
| `target_list` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#targetlist` | Contains information about the targeting in effect for this line item. |

### `Creative` table

| Field Name | Type | Description |
|---|---|---|
| `common_data` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#entitycommondata` |   |
| `advertiser_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent advertiser object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#advertiser.common_data.id`. |
| `dcm_placement_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The CM360 placement ID associated with this creative. |
| `width_pixels` | `integer` | The width of the creative in pixels. |
| `height_pixels` | `integer` | The height of the creative in pixels. |
| `approval_status` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#approvalstatus` | An array containing `https://developers.google.com/bid-manager/guides/entity-read/format-v2#approvalstatus` objects representing the status of the creatives in exchanges which approve creatives. |
| `expanding_direction` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=Not Expandable 1=Expanding Up 2=Expanding Down 3=Expanding Left 4=Expanding Right 5=Expanding Up Left 6=Expanding Up Right 7=Expanding Down Left 8=Expanding Down Right 9=Expanding Up or Down 10=Expanding Left or Right 11=Expanding Any Diagonal` |
| `creative_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=Image or HTML5 1=Expandable 2=Video 3=Mobile 4=Native Site 5=Facebook Exchange Page Post (News Feed) Ads 6=Templated App Install Mobile Ads (Banner) 10=Native Site Square 12=Templated App Install Mobile Ads (Interstitial/Video Interstitial) 13=Lightbox 14=Native App Install 15=Native App Install Square 16=Audio 17=Publisher Hosted 18=Native Video 22=Flipbook 23=Templated App Install Video 24=TRACKING` |

### `Pixel` table

| Field Name | Type | Description |
|---|---|---|
| `common_data` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#entitycommondata` |   |
| `advertiser_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent advertiser object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#advertiser.common_data.id`. |
| `partner_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent partner object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#partner.common_data.id`. |
| `dcm_floodlight_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The DFA Floodlight ID associated with this pixel. |
| `allow_google_redirect` | `boolean` |   |
| `allow_rm_redirect` | `boolean` | When set to `true` the pixel will be enabled for reidrection to/from Right Media. |
| `remarketing_enabled` | `boolean` | When set to `true` this pixel will be enabled for use in targeting. This value will be present only if the parent advertiser's `dfa_configuration` is set as `NONE`. |
| `is_secure` | `boolean` | When set to `true` this pixel will use HTTPS. This value will be present only if the parent advertiser's `dfa_configuration` is set as `NONE`. |

### `Floodlight Activity` table

| Field Name | Type | Description |
|---|---|---|
| `common_data` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#entitycommondata` |   |
| `advertiser_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent advertiser object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#advertiser.common_data.id`. |
| `partner_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent advertiser's managing partner object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#partner.common_data.id`. |
| `remarketing_enabled` | `boolean` | When set to `true` this activity will be enabled for use in targeting. |
| `ssl_required` | `boolean` | When set to `true` tags are required to be compliant. |

### `InventorySource` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for the inventory source. |
| `unclassified` | `boolean` | When set to `true` all unclassified inventory will be included. |
| `inventory_name` | `string` | The name of the inventory source as shown in the UI. This field may be absent. If `inventory_name` is absent and `unclassified` is true, it refers to the unclassified inventory of the exchange. If it is absent and `unclassified` is false, the inventory source is exchange level inventory. |
| `exchange_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the exchange where this inventory source is available. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#supportedexchange.id`. |
| `accessing_advertisers` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | An array of advertiser IDs, joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#advertiser.common_data.id`, permissioned to use this inventory source. Note: If an inventory source is available to ALL advertisers, this field will not be present. |
| `external_id` | `string` | The external ID given to this inventory source and defined by the exchange, typically known as a deal or seller ID. This field might be absent. |
| `min_cpm_micros` | `integer` | The effective floor price of this inventory source in currency micros. |
| `min_cpm_currency_code` | `string` | The 3-letter ISO 4217 currency code used for the `min_cpm_micros`. |

### `UserList` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for the user list. |
| `name` | `string` | The name of the user list as shown in the UI. |
| `data_partner_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#datapartner.id`. This field is only set for third party user lists. |
| `accessing_advertisers` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | An array of advertiser IDs, joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#advertiser.common_data.id`, permissioned to use this user list. Note: If a user list is available to ALL advertisers, this field will not be present. |
| `partner_pricing` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#userListPricing` | Cost type will always be CPM, Currency Code will always be USD. |
| `advertiser_pricings` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#userListAdvertiserPricing` | Cost type will always be CPM, Currency Code will always be USD. |

### `CustomAffinity` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for the custom affinity. |
| `name` | `string` | The name of the custom affinity as shown in the UI. |
| `description` | `string` | The description of the custom affinity as shown in the UI. |
| `advertiser_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent advertiser object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#advertiser.common_data.id`. |

### `UniversalChannel` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for the channel. |
| `name` | `string` | The name of the channel as shown in the UI. |
| `site_ids` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | An array containing the IDs of the `https://developers.google.com/bid-manager/guides/entity-read/format-v2#universalsite`s in this channel. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#universalsite.id`. |
| `accessing_advertisers` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | An array of advertiser IDs, joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#advertiser.common_data.id`, permissioned to use this channel. Note: If a channel is available to ALL advertisers, this field will not be present. |
| `is_deleted` | `boolean` | When set to `true` no new line items will be able to target this channel, butexisting line items that already target this channel will continue to do so. |
| `is_brand_safe_channel` | `boolean` | When set to `true` this channel can be used for brand safety filtering. Currently this is `true` only for the 4 built in brand safety tiers. |

### `NegativeKeywordList` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for the negative keyword list. |
| `name` | `string` | The name of the negative keyword list as shown in the UI. |
| `advertiser_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The ID of the parent advertiser object. Joinable with `https://developers.google.com/bid-manager/guides/entity-read/format-v2#advertiser.common_data.id`. |

## Public Tables

### `SupportedExchange` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for the exchange. |
| `name` | `string` | Name of the exchange, for example `Ad Exchange`. |

### `DataPartner` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for the third party data provider. |
| `name` | `string` | Name of the third party data provider, for example `BlueKai`. |

### `UniversalSite` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for the universal site. |
| `name` | `string` | The site URL or name, for example `google.com` or `Google Unclassified`. |

### `SiteIdToPlacementId` table

| Field Name | Type | Description |
|---|---|---|
| `siteId` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Mapping from Universal Site ID to Web Placement IDs. |
| `placementId` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | The web placement URL or name, for example `google.com` or `Google Unclassified`. |

### `GeoLocation` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for the geo location. |
| `canonical_name` | `string` | Comma-concatenated string of location and its parents. Example: "Seattle, Washington, United States". |
| `geo_name` | `string` | Name of location. Example: "Seattle". |
| `country_code` | `string` | ISO-3166 alpha-2 country code for this geo location, for example `US`. |
| `region_code` | `string` | ISO-3166-2 subdivision code for this geo location, for example `US-WA`. This field might be missing. |
| `city_name` | `string` | The name of the city for this geo location, for example `Seattle`. This field might be missing. |
| `postal_code` | `string` | The postal code for this geo location, for example `98033`. This field might be missing. |
| `dma_code` | `integer` | The DMA code for this geo location, for example `510`. This field might be missing. |

### `Language` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for this language. |
| `code` | `string` | ISO-639-1 code for this language, or one of `zh_CN` for Chinese (simplified), `zh_TW` for Chinese (traditional), or `other` for other languages. |

### `DeviceCriteria` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for this Device Criteria. |
| `is_mobile` | `boolean` | If true, this criterion covers only mobile devices. If false, this entry covers only non-mobile devices, even if its name (e.g., "Other") does not indicate so. |
| `name` | `string` | The familiar name of the Device Criteria. |
| `criteria_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | `0=OPERATING_SYSTEM 1=MOBILE_MAKE_MODEL 2=DEVICE_TYPE` |
| `operating_system_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#Numericid` | Identifies the operating system. This field is only populated when the `criteria_type` is `0`. |
| `mobile_brand_name` | `string` | The brand name of the device. This field is only populated when the `criteria_type` is `1`. |
| `mobile_model_name` | `string` | The model name of the device. This field is only populated when the `criteria_type` is `1`. Optional. |
| `mobile_make_model_id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#Numericid` | Identifies the model number of the device. This field is only populated when the `criteria_type` is `1`. Optional. |
| `device_type` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#enum` | Indicates the type of device. This field is only populated when the `criteria_type` is `2`. `0=COMPUTER 1=OTHER 2=SMARTPHONE 3=TABLET 4=SMARTTV 5=CONNECTEDTV 6=SET_TOP_BOX 7=CONNECTEDDEVICE` |

### `Browser` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for this browser. |
| `is_mobile` | `boolean` | If true, this criterion covers only mobile devices. If false, this entry covers only non-mobile devices, even if its name (e.g., "Other") does not indicate so. |
| `name` | `string` | The familiar name of the browser, for example `Safari 5`. It does not include the full user-agent string. |

### `Isp` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for this Internet Service Provider. |
| `is_mobile` | `boolean` | If true, this criterion covers only mobile devices. If false, this entry covers only non-mobile devices, even if its name (e.g., "Other") does not indicate so. |
| `name` | `string` | The name of this Internet Service Provider. |
| `secondary_criteria_id` | `integer` | Optional alternative ID that can be used to identify the entity. |

### `AppCollection` table

| Field Name | Type | Description |
|---|---|---|
| `id` | `https://developers.google.com/bid-manager/guides/entity-read/format-v2#numericid` | Unique key for this app collection. |
| `name` | `string` | The name of this app collection. |