Result data is available in two types of mapping tables: horizontal and vertical. They contain the same data, but the structure is different. You can indicate which format you prefer.
The mapping tables use Match IDs (shown below in GUID format). These are IDs that tie together clusters of User IDs that belong to the same person. Read more about MatchIDs here.
Optionally, mapping table may also include Household IDs. These are clusters of User IDs that belong to the same household. For more on Household IDs and how they are implemented in the result data please go here
Incremental (daily) updates
As Screen6 processes your data on a daily basis, you can ask us to only send updates to the mapping table in comparison to yesterdays results.
The default content format is "horizontal", and the file delivery format is Tab Separated GZip.
Match ID Graph Extract Format
- Horizontal: Each line starts with a Match ID followed by its related User IDs.
- Vertical: Each line starts with a MatchID followed by one of its related User IDs
bc00966f-e5a6-410c-97aa-93dfab936a6a 34302050,93436308,15420117
e5b06fdc-0f2c-447b-9f36-801c48f25517 53410606,59794190
bc00966f-e5a6-410c-97aa-93dfab936a6a 34302050
bc00966f-e5a6-410c-97aa-93dfab936a6a 93436308
bc00966f-e5a6-410c-97aa-93dfab936a6a 15420117
e5b06fdc-0f2c-447b-9f36-801c48f25517 53410606
e5b06fdc-0f2c-447b-9f36-801c48f25517 59794190
Separation characters can be customized on request. User IDs may be separated by comma even if the file format uses tab separation.
Filtering and Prefixing IDs
If your source data contains multiple types of User IDs (for example: cookie and MAID) then you can ask us to include just one or all types of IDs in the result data.
Optionally, IDs may be prefixed with their type. For example:
bc00966f-e5a6-410c-97aa-93dfab936a6a cookie:34302050,cookie:93436308,ifa:15420117
e5b06fdc-0f2c-447b-9f36-801c48f25517 cookie:53410606,ifa:59794190
Similarly, Device Type associated with the ID - for example: PC, mobile phone, tablet, TV, etc. - can also be included as an ID prefix.
Household Graph Extract Format
Household graphs contain all matches at the Match ID level, in addition to matching shared devices (such as game consoles, televisions, etc) that were not attributed to a specific profile.
We can send results in one combined graph with Match ID, or two separate graphs for Household and Match IDs. Options are the same for vertical or horizontal user identifiers, prefixes, etc.
Household ID Match ID User IDs
e5b06fdc 0f2c-447b 34302050,93436308,15420117
e5b06fdc e5a6-410c 34599960,84838884,12223444
e5b06fdc <blank> 25934732
Household ID User IDs
e5b06fdc 34302050,93436308,15420117,34599960,84838884,12223444,25934732
Graph Expiry Configuration
Once matched, Screen6 keeps Identifiers in your graph for as long as they are active, and for a configurable length of time after their last seen activity.
The default length is 60 days for persistent identifiers and 30 days for non-persistent types. Expired IDs can be delivered daily to help you maintain your graph.