Dynamic lookups
Dynamic lookups allow you to receive additional lookup files in your data feed otherwise not available. This setting enables the following lookup tables to be sent with each data feed file:
- Carrier name: Provides additional context for the
carriercolumn. The file name included iscarrier.tsv. - Mobile attributes: Provides additional context for the
mobile_idcolumn, including all features tracked for each mobile device. The file name included ismobile_attributes.tsv. - Operating system type: Provides an alternate context for the
oscolumn. Bothoperating_systems.tsvandoperating_system_type.tsvuse theoscolumn as the key, however onlyoperating_system_type.tsvis a dynamic lookup.
Enable dynamic lookups
If you want to receive the lookup files mentioned, you must meet all the following prerequisites:
-
The key column must be included in the data feed.
- For
carrier.tsv, you must includecarrier. - For
mobile_attributes.tsv, you must includemobile_id. - For
operating_system_type.tsv, you must includeos.
- For
-
The following columns must be excluded. If any of these columns are included in the data feed, the additional lookup tables are not included.
user_agentch_hdrch_js
Once your data feed meets the column inclusion and exclusion requirements, contact Customer Care with the data feed ID and request to enable dynamic lookups.
Lookup header reference
Column headers for these lookup files do not change over time, so headers are not included in each data feed file. Use these column headers as a reference, or download their respective .tsv file.
Download carrier_headers.tsv or reference the headers below.
carrierCarrier Name
Download mobile_attributes_headers.tsv or reference the headers below.
mobile_idManufacturerDeviceDevice TypeOperating SystemDiagonal Screen SizeScreen HeightScreen WidthCookie SupportColor DepthMP3 Audio SupportAAC Audio SupportAMR Audio SupportMidi Monophonic Audio SupportMidi Polyphonic Audio SupportQCELP Audio SupportGIF87 Image SupportGIF89a Image SupportPNG Image SupportJPG Image Support3GPP Video SupportMPEG4 Video Support3GPP2 Video SupportWMV Video SupportMPEG4 Part 2 Video SupportStream MP4 AAC LC Video SupportStream 3GP H264 Level 10b Video SupportStream 3GP AAC LC Video Support3GP AAC LC Video SupportStream MP4 H264 Level 11 Video SupportStream MP4 H264 Level 13 Video SupportStream 3GP H264 Level 12 Video SupportStream 3GP H264 Level 11 Video SupportStream 3GP H264 Level 10 Video SupportStream 3GP H264 Level 13 Video Support3GP AMR NB Video Support3GP AMR WB Video SupportMP4 H264 Level 11 Video Support3GP H263 Video SupportMP4 H264 Level 13 Video SupportStream 3GP H263 Video SupportStream 3GP AMR WB Video Support3GP H264 Level 10b Video SupportMP4 ACC LC Video SupportStream 3GP AMR NB Video Support3GP H264 Level 10 Video Support3GP H264 Level 13 Video Support3GP H264 Level 11 Video Support3GP H264 Level 12 Video SupportStream HTTP Live Streaming Video Support
Download operating_system_type_headers.tsv or reference the headers below.
osOperating System Type