Entity Read Files Format - V2

Shared Types

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

Numeric Id type

ScalarDescription
integerA 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

ScalarDescription
integerAn enumeration of multiple possible options. The different options are described in more detail in the parent type.

Time type

ScalarDescription
integerA unix time in microseconds (1/1,000,000 second), for example 1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570.

Currency Micro type

ScalarDescription
integerThe 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

ScalarDescription
integerA percentage shown in millis (1/1,000 of a percent), for example 100 means 0.1%.

FileSummary type

Field NameTypeDescription
namestringThe file's file name (not including the bucket or directory name).
num_recordsintegerThe number of entities in the file.
versionintegerThe 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 NameTypeDescription
idNumeric IdUnique 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.
namestringThe UI-visible name of the entity.
activebooleanStatus 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_codestringIntegration code set by the user

ExchangeSettings type

Field NameTypeDescription
exchange_idNumeric IdThe ID for the exchange. Joinable with SupportedExchange.id
seat_idstringSeat ID for the exchange
seat_user_namestringThe user name related to this seat (only applicable for Right Media non-RTB seats).

ApprovalStatus type

Field NameTypeDescription
auditorEnum0=DOUBLECLICK_BID_MANAGER
1=DOUBLECLICK_AD_EXCHANGE
2=APPNEXUS
3=APPNEXUS_MICROSOFT
4=RIGHT_MEDIA_NON_RTB
statusEnum0=APPROVED
1=REJECTED
2=PENDING
3=NO_AUDIT
4=UN_AUDITABLE
5=UNKNOWN
6=IN_AUDIT
feedbackstringFeedback form the auditor which may cotain additional information such as rejection reasons.
sync_timeTimeLast time that the entity was synced with the auditor
external_idNumeric IdPopulated 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 NameTypeDescription
start_time_usecTimeStart time of the budget period.
end_time_usecTimeEnd time of the budget period.
max_impressionsintegerMaximum number of impressions for this budget. If this field is missing it is an unlimited-impression budget.
max_spend_advertiser_microsintegerMaximum spend (in advertiser currency micros) for this budget. If this field is missing it is an unlimited-spend budget.
pacing_typeEnum0=FLIGHT
1=DAILY
pacing_max_impressionsintegerMaximum 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_microsintegerMaximum 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_distributionEnum0=ASAP
1=EVEN
2=AHEAD

FrequencyCap type

Field NameTypeDescription
max_impressionsintegerThe maximum number of impressions in each capping interval.
time_unitEnumThe unit of time:
0=MINUTE
1=HOUR
2=DAY
3=WEEK
4=MONTH
5=LIFE_TIME
time_rangeintegerThe 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 NameTypeDescription
cpm_fee_1_advertiser_microsintegerCPM 1 Fee in advertiser currency micros.
cpm_fee_2_advertiser_microsintegerCPM 2 Fee in advertiser currency micros.
cpm_fee_3_advertiser_microsintegerCPM 3 Fee in advertiser currency micros.
cpm_fee_4_advertiser_microsintegerCPM 4 Fee in advertiser currency micros.
cpm_fee_5_advertiser_microsintegerCPM 5 Fee in advertiser currency micros.
media_fee_percent_1_millisintegerMedia Fee 1 in Percentage Milli
media_fee_percent_2_millisintegerMedia Fee 2 in Percentage Milli
media_fee_percent_3_millisintegerMedia Fee 3 in Percentage Milli
media_fee_percent_4_millisintegerMedia Fee 4 in Percentage Milli
media_fee_percent_5_millisintegerMedia Fee 5 in Percentage Milli
cpm_fee_1_cost_typeEnum0=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_typeEnumSame as for cpm_fee_1_cost_type.
cpm_fee_3_cost_typeEnumSame as for cpm_fee_1_cost_type.
cpm_fee_4_cost_typeEnumSame as for cpm_fee_1_cost_type.
cpm_fee_5_cost_typeEnumSame as for cpm_fee_1_cost_type.
media_fee_percent_1_cost_typeEnumSame as for cpm_fee_1_cost_type.
media_fee_percent_2_cost_typeEnumSame as for cpm_fee_1_cost_type.
media_fee_percent_3_cost_typeEnumSame as for cpm_fee_1_cost_type.
media_fee_percent_4_cost_typeEnumSame as for cpm_fee_1_cost_type.
media_fee_percent_5_cost_typeEnumSame as for cpm_fee_1_cost_type.
cpm_fee_1_bill_to_typeEnum0=DEFAULT_BILL_TO_TYPE
1=INVITE_MEDIA
2=PARTNER
cpm_fee_2_bill_to_typeEnumSame as for cpm_fee_1_bill_to_type.
cpm_fee_3_bill_to_typeEnumSame as for cpm_fee_1_bill_to_type.
cpm_fee_4_bill_to_typeEnumSame as for cpm_fee_1_bill_to_type.
cpm_fee_5_bill_to_typeEnumSame as for cpm_fee_1_bill_to_type.
media_fee_percent_1_bill_to_typeEnumSame as for cpm_fee_1_bill_to_type.
media_fee_percent_2_bill_to_typeEnumSame as for cpm_fee_1_bill_to_type.
media_fee_percent_3_bill_to_typeEnumSame as for cpm_fee_1_bill_to_type.
media_fee_percent_4_bill_to_typeEnumSame as for cpm_fee_1_bill_to_type.
media_fee_percent_5_bill_to_typeEnumSame as for cpm_fee_1_bill_to_type.

PartnerRevenueModel type

Field NameTypeDescription
typeEnum0=CPM
1=MEDIA_COST_MARKUP
2=TOTAL_MEDIA_COST_MARKUP
amount_advertiser_microsintegerThe revenue amount in advertiser current micros. This value is only set if the type is CPM.
media_cost_markup_percent_millisintegerThe revenue percentage markup in Percentage Milli. This value is only set if the type is MEDIA_COST_MARKUP or TOTAL_MEDIA_COST_MARKUP.
post_view_conversion_tracking_fractionfloatFraction 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 NameTypeDescription
pixel_idNumeric IdThe ID of the tracking pixel - note that two CostTrackingPixels may share the same pixel_id but have different view or click window values.

This value can be joined with Pixel.common_data.id.
view_window_minutesintegerThe number of minutes in which to look for post-view conversions.
click_window_minutesintegerThe number of minutes in which to look for post-click conversions.
floodlight_activity_idNumeric IdCM Floodlight activity ids. This value can be joined with Pixel.dcm_floodlight_id.

Target type

Field NameTypeDescription
criteria_idNumeric IdJoinable with another table depending on the type defined in the TargetList. This value might be missing.
parameterstringAdditional parameter whose definition depends on the type defined in the TargetList. This value might be missing.
excludedbooleanWhen true this means that the target is excluded. A missing value means false.

TargetUnion type

Field NameTypeDescription
union[Target]An array of Target types representing the union of targets.
excludedbooleanWhen true this means that the target union is excluded. A missing value means false.

TargetList type

Field NameTypeDescription
inventory_sources [Target]Array of Target types for inventory sources. Target.criteria_id is joinable with InventorySource.id and Target.parameter is undefined.
geo_locations [Target] Array of Target types for geo locations. Target.criteria_id is joinable with GeoLocation.id and Target.parameter is undefined.
ad_position Target A Target indicating the advert's position on the publisher page. The Target.criteria_id values are
0=ALL_POSITIONS
1=ABOVE_THE_FOLD
2=BELOW_THE_FOLD
3=UNKNOWN_POSITION

Target.parameter is undefined.
net_speed Target A Target indicating the network speed.
The 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).

Target.parameter is undefined.
browsers TargetUnion TargetUnion type for browsers. Target.criteria_id is joinable with Browser.id and Target.parameter is undefined.
device_criteria [Target]Array of Target types for device criteria. Target.criteria_id is joinable with DeviceCriteria.id and Target.parameter is undefined.
languages TargetUnionTargetUnion type for language. Target.criteria_id is joinable with Language.id and Target.parameter is undefined.
day_parting TargetUnionTargetUnion type for day parting. 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.

Target.parameter is undefined.
audience_intersect [TargetUnion]Array of 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)".

Target.criteria_id is joinable with UserList.id and Target.parameter is the pixel recency value in microseconds. If this value is missing then it means targeting all audiences.
keywords[Target]Array of Target types for keywords. Target.criteria_id is undefined and Target.parameter is a single keyword.
kct_include_uncrawled_sitesbooleanFlag to indicate whether unindexed websites should be included in the KCT.
page_categories[Target]Array of Target types for AdExchange page verticals. Target.criteria_id is the numeric ID of a vertical and Target.parameter is undefined.
universal_channels[Target]Array of Target types for channels. Target.criteria_id is joinable with UniversalChannel.id and Target.parameter is undefined.
sites[Target] Array of Target types for sites. Target.criteria_id is joinable with UniversalSite.id or is not set if the site is not in UniversalSite. Target.parameter is a site such as google.com but is not necessarily found in UniversalSite.
ispsTargetUnionTargetUnion type for Internet Service Provider. Target.criteria_id is joinable with ISP.id and Target.parameter is undefined.

SummaryFile type

Field NameTypeDescription
file[FileSummary]An array of zero or more FileSummary entries. If this array is empty then there was no data generated on that date.

UserListAdvertiserPricing type

Field NameTypeDescription
pricingUserListPricing
advertiser_idNumeric Id

UserListPricing type

Field NameTypeDescription
cost_typestring
currency_codestringISO 4217 three-letter currency code, for example USD for US Dollars.
cost_microsCurrency Micro

Private Tables

Partner table

Field NameTypeDescription
common_dataEntityCommonDataContains the common data about this partner such as name and ID.
currency_codestringISO 4217 three-letter currency code, for example USD for US Dollars.
exchange_settings[ExchangeSettings]Array of ExchangeSettings types containing information such as their seat IDs. Only enabled exchanges will be present.
default_partner_costsPartnerCostsContains information about the deafault costs for this partner.
default_partner_revenue_modelPartnerRevenueModelContains information about the default revenue model for this partner.
default_target_listTargetListContains the default targeting options for the partner. Currently only default geo-targeting is supported here.

Advertiser table

Field NameTypeDescription
common_dataEntityCommonDataContains the common data about this advertiser such as name and ID.
partner_idNumeric IdThe ID of the parent partner object. Joinable with Partner.common_data.id.
currency_codestringISO 4217 three-letter currency code, for example USD for US Dollars.
timezone_codestringThe 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_urlstringThe default landing page URL.
available_channel_ids[integer]Array of integers containing the available channels associated with this advertiser. Joinable with UniversalChannel.id.
blacklist_channel_id[integer]Array of integers containing the blacklist channels for this advertiser. Joinable with UniversalChannel.id.
dcm_configurationEnum0=NONE
1=NORMAL
2=HYBRID
dcm_network_idNumeric IdThe ID of the CM360 network. This value will be missing if the dcm_configuration is set as NONE.
dcm_advertiser_idNumeric IdThe ID of the CM360 advertiser. This value will be missing if the dcm_configuration is set as NONE.
dcm_floodlight_group_idNumeric IdThis value will be missing if the dcm_configuration is set as NONE.
dcm_syncable_site_ids[Numeric Id]Array of Numeric Id types for each syncable site for this advertiser.
enable_oba_tagsbooleanOBA tags are enabled when this is set as true.

Campaign table

Field NameTypeDescription
common_dataEntityCommonDataContains the common data about this campaign such as name and ID.
advertiser_idNumeric IdThe ID of the parent advertiser object. Joinable with Advertiser.common_data.id
budgetBudgetThe planned budget for this campaign. Includes the start time and end time.
frequency_capFrequencyCapThe frequency cap active for this campaign. This value will be missing if there is no frequency cap set.
default_target_listTargetListContains information about the targeting in effect for this campaign.
uses_video_creativesbooleanWhen set to true, video insertion orders will be recommended.
uses_display_creativesbooleanWhen set to true, display insertion orders will be recommended.
uses_audio_creativesbooleanWhen set to true, audio insertion orders will be recommended.
objectiveEnum Values are:
1 = BRAND_AWARENESS
2 = ONLINE_ACTION
3 = OFFLINE_ACTION
4 = APP_INSTALL
metricEnum 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_descriptionStringWhen the metric is OTHER this is the short the description of the metric.
metric_amount_microsintegerThe target amount for the metric in micros.

InsertionOrder table

Field NameTypeDescription
common_dataEntityCommonData
advertiser_idNumeric IdThe ID of the parent advertiser object. Joinable with Advertiser.common_data.id.
campaign_idNumeric IdThe ID of the parent campaign object.
overall_budgetBudgetThe overall budget for this insertion order. Includes the start time and the end time.
scheduled_segments[Budget]Contains any scheduled budget segments. This array might be empty or entirely absent.
frequency_capFrequencyCapThe frequency cap active for this insertion order. This value will be missing if there is no frequency cap set.
default_partner_costsPartnerCosts
default_target_listTargetList

LineItem table

Field NameTypeDescription
common_data EntityCommonData
line_item_typeEnum 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 Numeric Id The ID of the parent insertion order object. Joinable with InsertionOrder.common_data.id.
creative_ids[Numeric Id]An array of creatives that are assigned to this line item. Joinable with Creative.common_data.id.
max_cpm_advertiser_microsintegerThe maximum CPM value in advertiser currency micros.
performance_goalEnum0=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_microsintegerThe vCPM goal in advertiser currency micros. This value will be missing if the performance_goal is set as NONE.
partner_revenue_modelPartnerRevenueModelThe partner revenue model being used for this line item.
cost_tracking_pixels[CostTrackingPixel]Array of CostTrackingPixels assigned to track this line item.
BudgetBudgetThe overall budget for this line item. Includes the start time and the end time.
frequency_capFrequencyCapThe frequency cap active for this line item. This value will be missing if there is no frequency cap set.
partner_costsPartnerCosts
target_listTargetListContains information about the targeting in effect for this line item.

Creative table

Field NameTypeDescription
common_dataEntityCommonData
advertiser_idNumeric IdThe ID of the parent advertiser object. Joinable with Advertiser.common_data.id.
dcm_placement_idNumeric IdThe CM360 placement ID associated with this creative.
width_pixelsintegerThe width of the creative in pixels.
height_pixelsintegerThe height of the creative in pixels.
approval_status[ApprovalStatus]An array containing ApprovalStatus objects representing the status of the creatives in exchanges which approve creatives.
expanding_directionEnum0=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_typeEnum 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 NameTypeDescription
common_dataEntityCommonData
advertiser_idNumeric IdThe ID of the parent advertiser object. Joinable with Advertiser.common_data.id.
partner_idNumeric IdThe ID of the parent partner object. Joinable with Partner.common_data.id.
dcm_floodlight_idNumeric IdThe DFA Floodlight ID associated with this pixel.
allow_google_redirectboolean
allow_rm_redirectbooleanWhen set to true the pixel will be enabled for reidrection to/from Right Media.
remarketing_enabledbooleanWhen 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_securebooleanWhen 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 NameTypeDescription
common_dataEntityCommonData
advertiser_idNumeric IdThe ID of the parent advertiser object. Joinable with Advertiser.common_data.id.
partner_idNumeric IdThe ID of the parent advertiser's managing partner object. Joinable with Partner.common_data.id.
remarketing_enabledbooleanWhen set to true this activity will be enabled for use in targeting.
ssl_requiredbooleanWhen set to true tags are required to be compliant.

InventorySource table

Field NameTypeDescription
idNumeric IdUnique key for the inventory source.
unclassifiedbooleanWhen set to true all unclassified inventory will be included.
inventory_namestringThe 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_idNumeric IdThe ID of the exchange where this inventory source is available. Joinable with SupportedExchange.id.
accessing_advertisers[Numeric Id]An array of advertiser IDs, joinable with 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_idstringThe 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_microsintegerThe effective floor price of this inventory source in currency micros.
min_cpm_currency_codestringThe 3-letter ISO 4217 currency code used for the min_cpm_micros.

UserList table

Field NameTypeDescription
idNumeric IdUnique key for the user list.
namestringThe name of the user list as shown in the UI.
data_partner_idNumeric IdJoinable with DataPartner.id. This field is only set for third party user lists.
accessing_advertisers[Numeric Id]An array of advertiser IDs, joinable with 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_pricingUserListPricingCost type will always be CPM, Currency Code will always be USD.
advertiser_pricings[UserListAdvertiserPricing]Cost type will always be CPM, Currency Code will always be USD.

CustomAffinity table

Field NameTypeDescription
id Numeric Id 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 Numeric Id The ID of the parent advertiser object. Joinable with Advertiser.common_data.id.

UniversalChannel table

Field NameTypeDescription
idNumeric IdUnique key for the channel.
namestringThe name of the channel as shown in the UI.
site_ids [Numeric Id] An array containing the IDs of the UniversalSites in this channel. Joinable with UniversalSite.id.
accessing_advertisers[Numeric Id]An array of advertiser IDs, joinable with 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_deletedbooleanWhen 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_channelbooleanWhen 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 NameTypeDescription
id Numeric Id Unique key for the negative keyword list.
name string The name of the negative keyword list as shown in the UI.
advertiser_id Numeric Id The ID of the parent advertiser object. Joinable with Advertiser.common_data.id.

Public Tables

SupportedExchange table

Field NameTypeDescription
idNumeric IdUnique key for the exchange.
namestringName of the exchange, for example Ad Exchange.

DataPartner table

Field NameTypeDescription
idNumeric IdUnique key for the third party data provider.
namestringName of the third party data provider, for example BlueKai.

UniversalSite table

Field NameTypeDescription
idNumeric IdUnique key for the universal site.
namestringThe site URL or name, for example google.com or Google Unclassified.

SiteIdToPlacementId table

Field NameTypeDescription
siteId Numeric Id Mapping from Universal Site ID to Web Placement IDs.
placementId Numeric Id The web placement URL or name, for example google.com or Google Unclassified.

GeoLocation table

Field NameTypeDescription
idNumeric IdUnique key for the geo location.
canonical_namestringComma-concatenated string of location and its parents. Example: "Seattle, Washington, United States".
geo_namestringName of location. Example: "Seattle".
country_codestringISO-3166 alpha-2 country code for this geo location, for example US.
region_codestringISO-3166-2 subdivision code for this geo location, for example US-WA. This field might be missing.
city_namestringThe name of the city for this geo location, for example Seattle. This field might be missing.
postal_codestringThe postal code for this geo location, for example 98033. This field might be missing.
dma_codeintegerThe DMA code for this geo location, for example 510. This field might be missing.

Language table

Field NameTypeDescription
idNumeric IdUnique key for this language.
codestringISO-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 NameTypeDescription
idNumeric IdUnique key for this Device Criteria.
is_mobilebooleanIf 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.
namestringThe familiar name of the Device Criteria.
criteria_typeEnum0=OPERATING_SYSTEM
1=MOBILE_MAKE_MODEL
2=DEVICE_TYPE
operating_system_idNumeric IdIdentifies the operating system. This field is only populated when the criteria_type is 0.
mobile_brand_namestringThe brand name of the device. This field is only populated when the criteria_type is 1.
mobile_model_namestringThe model name of the device. This field is only populated when the criteria_type is 1. Optional.
mobile_make_model_idNumeric IdIdentifies the model number of the device. This field is only populated when the criteria_type is 1. Optional.
device_typeEnumIndicates 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 NameTypeDescription
idNumeric IdUnique key for this browser.
is_mobilebooleanIf 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.
namestringThe familiar name of the browser, for example Safari 5. It does not include the full user-agent string.

Isp table

Field NameTypeDescription
idNumeric IdUnique key for this Internet Service Provider.
is_mobilebooleanIf 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.
namestringThe name of this Internet Service Provider.
secondary_criteria_idinteger Optional alternative ID that can be used to identify the entity.

AppCollection table

Field NameTypeDescription
idNumeric IdUnique key for this app collection.
namestringThe name of this app collection.