CSV Files for Overlap Reports
You can request a .csv file for an Overlap Report when that report reaches its 1-million record limit. A report may have reached this limit when you see an “Unexpected error has occurred” message. Contact Customer Care to request a compressed .csv file, which you can import and work with in your own database system. Files are available for segment-to-segment, segment-to-trait, and trait-to-trait overlap reports.
File Name Metadata
The following table list and describes the file naming conventions and file extensions use in an overlap .csv file. In the examples, italics indicates a variable placeholder.
.gz
file extension. You must add the .csv
extension to the file after decompression.File name syntax:
- Segment-to-segment files:
S2S_overlap_partner ID_yyyy-mm-dd_date range
- Segment-to-trait files:
S2T_overlap_partner ID_yyyy-mm-dd_date range
- Trait-to-trait files:
T2T_overlap_partner ID_yyyy-mm-dd_date range
The date range for a report is a 5-digit ID that includes:
70000
for a 7-day report.30000
for a 30-day report.
File name examples for a single report:
- Single, 7-day file:
S2S_overlap_12345_2017_01_14_70000.gz
- Single, 30-day file:
S2S_overlap_12345_2017_01_14_30000.gz
File name examples for a report with multiple files:
S2S_overlap_12345_2017_01_14_70000.gz
S2S_overlap_12345_2017_01_14_70001.gz
S2S_overlap_12345_2017_01_14_70002.gz
File Contents
In the file, string data is enclosed in double quotes. See the mock data below. This has been truncated for brevity and to fit the screen.
//File header
"segment_id1","segment_name1","segment_id2","segment_name3,"range_id",...
//File body
"123456","segmentA","654321","segmentB","30","yyyy-mm-dd","98765",...
Segment-to-Segment Report Records
A data file for your Segment-to-Segment Overlap Report contains the following records.
segment_id1
segment_name1
segment_id2
segment_name2
rangeid
You can get reports for 7- and 30-day look-back intervals. The rangeid
corresponds to the time intervals shown below.
7
: 7-days30
: 30-days
datethru
segment_uniques1
segment_uniques2
overlap_uniques
Overlap_perc
Segment-to-Trait Report Records
A data file for your Segment-to-Trait Overlap Report contains the following records.
trait_id
trait_name
dataprovider_type
The data provider ID. IDs include:
1st Party
3rd Party
dataprovider
rangeid
You can get reports for 7- and 30-day look-back intervals. The rangeid
corresponds to the time intervals shown below.
7
: 7-days30
: 30-days
datethru
segment_uniques
trait_uniques
overlap_uniques
trait_uniques_overlap_perc
segment_uniques_overlap_perc
Trait-to-Trait Report Records
A data file for your Trait-to-Trait Overlap Report contains the following records.
overlap_trait_id
overlap_trait_name
base_trait_id
base_trait_name
dataprovider_type
The data provider ID. IDs include:
1st Party
3rd Party
dataprovider
rangeid
You can get reports for 7- and 30-day look-back intervals. The rangeid
corresponds to the time intervals shown below.
7
: 7-days30
: 30-days
datethru
overlap_trait_uniques
base_trait_uniques
overlap_uniques
overlap_trait_uniques_overlap_perc
base_trait_uniques_overlap_perc