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.

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.

On this page

Adobe Summit Banner

A virtual event April 27-28.

Expand your skills and get inspired.

Register for free
Adobe Summit Banner

A virtual event April 27-28.

Expand your skills and get inspired.

Register for free
Adobe Maker Awards Banner

Time to shine!

Apply now for the 2021 Adobe Experience Maker Awards.

Apply now
Adobe Maker Awards Banner

Time to shine!

Apply now for the 2021 Adobe Experience Maker Awards.

Apply now