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.

Contents:

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.

Metadata Element Description

File Extension

Overlap report files are gzip compressed and have a .gz file extension. You must add the .csv extension to the file after decompression.

File Name

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

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.

Multiple Files

We increment the last digit in the file name if a report contains multiple files.

Examples

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.

Label Description

segment_id1

The ID of the segment you're comparing to the baseline segment.

segment_name1

The name of the segment you're comparing to the baseline segments.

segment_id2

The ID of your baseline segment. The baseline segment is the segment you want to compare with other segments.

segment_name2

The name of the baseline segment you're comparing to other segments.

rangeid

You can get reports for 7- and 30-day look-back intervals. The rangeid corresponds to the time intervals shown below.

  • 7: 7-days
  • 30: 30-days

datethru

The processing date for a report.

segment_uniques1

The number of unique users in the segment you're comparing to the baseline segment.

segment_uniques2

The number of unique users in the baseline segment.

overlap_uniques

A total count of the overlap of unique users between the baseline segment and the other segments selected for comparison.

Overlap_perc

The % overlap of unique users between the baseline segment and the other segments selected for comparison.

Segment-to-Trait Report Records

A data file for your Segment-to-Trait Overlap Report contains the following records.

Label Description

trait_id

Trait ID.

trait_name

Trait name.

dataprovider_type

The data provider ID. IDs include:

  • 1st Party
  • 3rd Party

dataprovider

Name of the data provider.

rangeid

You can get reports for 7- and 30-day look-back intervals. The rangeid corresponds to the time intervals shown below.

  • 7: 7-days
  • 30: 30-days

datethru

The processing date for a report.

segment_uniques

The number of unique users in the selected segment.

trait_uniques

The number of unique users in a trait. In the UI report, this number appears in the pop up window when you hover over a trait in the heatmap results.

overlap_uniques

The number of unique users shared between the selected segments and traits. In the UI report, this number appears in the pop up window when you hover over a trait in the heatmap results.

trait_uniques_overlap_perc

% of unique users that overlap between the trait and segment. In the UI report, this number appears in the pop up window when you hover over a trait in the heatmap results.

segment_uniques_overlap_perc

% of uniques users that overlap between the segment and trait. In the UI report, this number appears in the pop up window when you hover over a trait in the heatmap results.

Trait-to-Trait Report Records

A data file for your Trait-to-Trait Overlap Report contains the following records.

Label Description

overlap_trait_id

The ID of the trait you're comparing to the baseline trait.

overlap_trait_name

The name of the trait you're comparing to the baseline trait.

base_trait_id

The ID of your baseline trait. The baseline trait is the trait you want to compare with other traits.

base_trait_name

The name of the baseline trait you're comparing to other traits.

dataprovider_type

The data provider ID. IDs include:

  • 1st Party
  • 3rd Party

dataprovider

Name of the data provider.

rangeid

You can get reports for 7- and 30-day look-back intervals. The rangeid corresponds to the time intervals shown below.

  • 7: 7-days
  • 30: 30-days

datethru

The processing date for a report.

overlap_trait_uniques

The number of unique users shared between the selected traits. In the UI report, this number appears in the pop up window when you hover over a trait in the heatmap results.

base_trait_uniques

The number of unique users in a base trait. In the UI report, this number appears in the pop up window when you hover over a trait in the heatmap results.

overlap_uniques

The number of unique users shared between the selected traits. In the UI report, this number appears in the pop up window when you hover over a trait in the heatmap results.

overlap_trait_uniques_overlap_perc

% of unique users that overlap between the selected traits. In the UI report, this number appears in the pop up window when you hover over a trait in the heatmap results.

base_trait_uniques_overlap_perc

% of uniques users that overlap between the selected traits. In the UI report, this number appears in the pop up window when you hover over a trait in the heatmap results.