For data providers to natively integrate 3rd party segments into the SpringServe platform we will need the following information.
Segment Taxonomy
File type: Excel or google sheet, csv, Google Sheet
Format: The following columns should be provided in the same order if possible with no commas in the value. Commas are used as the delimiter and will skew the data. If there is no data for the un-required columns, exclude entire column.
| Column Header | Format | Description | Required | Example |
|---|
Alpha numeric
Can contain Underscores| Code | String | The DMP's segment Identifier. To be used in reporting for consolidation |
|---|
| , and visible to the user | Yes | SEG123 | ||
| External Code | String | Used for Iris.TV, otherwise this value should be the same as the Code | Yes | intid_123 |
|---|---|---|---|---|
| Political | Alpha | A Yes or No indicator if the segment is considered political. | No | Yes No |
| Vendor | Alpha | The DMP or partner name exactly how they want it to be displayed in the SpringServe platform | Yes |
|---|
Tru Optik
TruAudience Liveramp | ||||
| segment_category | Alpha | The category that the segment falls into | No | Auto - In Market Demographics Homeowner |
|---|---|---|---|---|
| description | Alpha | More detailed information about the segment such as household income range, specific car type, etc. | Yes | Online shoppers Travel Enthusiasts Married |
| CPM | Alpha Numeric | The CPM that SpringServe pays. | Yes | $1.00 |
Example format:
| segment_idCode | External Code | Political | PartnerVendor | segment_category | description | CPM |
| ABC1 | DEF_123 | No | Activate by Semcasting | Consumer - Arts and Crafts Stores Shoppers | Arts and Crafts Stores Shoppers : All | $1.50 |
| ABC2 | DEF_124 | No | Activate by Semcasting | Consumer - Arts and Crafts Stores Shoppers | Arts and Crafts Stores Shoppers : Hobby Lobby | $1.50 |
| DEF1 | DEF_125 | No | Activate by Semcasting | Consumer - Arts and Crafts Stores Shoppers | Arts and Crafts Stores Shoppers : Jo-Ann Stores | $1.50 |
| POL_RI_RI013 | DEF_126 | Yes | Activate by Semcasting | State House Districts Rhode Island - RI | RI013 | $0.90 |
| POL_RI_RI040 | DEF_127 | Yes | Activate by Semcasting | State House Districts Rhode Island - RI | RI040 | $0.90 |
| 12345678 | 12345678 | No | Tru Optik | Auto - In Market | New Vehicle | $1.50 |
| 91011121 | 91011121 | No | Tru Optik | Auto - In Market | Used Vehicle | $1.50 |
| 31415161 | 31415161 | No | Tru Optik | Auto - In Market | Small/Compact | $1.70 |
| 71819202 | 71819202 | No | Tru Optik | Auto - In Market | Midsize | $1.70 |
| 12223242 | 12223242 | No | Tru Optik | Auto - In Market | Pickup Truck | $1.70 |
...
<epoch_millis> is a numeric timestamp value.
<operation> will be OVR (overwrite) if the contents are to replace the segment_list for each named id_value, or APP (append) if the segment_list for each named id_value is to be added to the current value (if any) you have for that id_value.
<id_type> will be DVC, USR, or IPA designating that the contained id_values are device_id, user_ide, or ip_address.
<format_version> is the version of the file format that was used, currently always 0.
<HHMMSS> is the human readable hour-minute-seconds of the timestamp.
<extra_info> is anything else (such as sequence numbering or descriptive comment) that may be appended to the name. If there is none, there will be no underscore after the <HHMMSS> value, before the “.tsv.gz”. Currently all files have a "_000" value here.
".tsv" designates that it is a tab separated file.
".gz" designates that it was been GZIPped.
All dates/times are UTC.
Segment Overlap
Unless otherwise specified SpringServe will apply standard boolean logic to determine segment overlap pricing.
...
Data transfer
Storage service: SpringServe could provide S3 credentials for data transfer or we could use the data provider S3 credentials. There is no strong preference.
...