You are here:
External Activation Platform Files in Cloud File Storage
Learn more about the files delivered to Amazon S3 for your external activation platform.
File Paths
All your success, metadata, and activation output files arrive to S3. Use this information to interpret the file path variables and locate your files.
| File Path Variable | Description |
|---|---|
| Bucket-Name | The S3 Bucket Name that you provided when configuring your External Activation Platform in Data 360 Setup. You can write directly into the bucket without root folders or write to a specific folder within the bucket. |
| Date | The date (in UTC) the files were published. Date is expressed as YYYY-MM-DD. Success files are located here. |
| Account-ID | This value represents your Data 360 customer’s account in your external activation platform. The value is required when creating an activation target for an external activation platform. |
| Activation-Run-ID | A 36-character string to differentiate between multiple customers publishing to the same activation target. Multiple folders represent different Data 360 orgs sending data to the same Account ID in your external activation platform. Metadata files are located here. |
| ID-Type | Data 360 generates activation output files for each identifier type. This applies only when the output is grouped by user identifier (PER_USER). Supported types are hashed email, hashed phone, mobile advertising Ids, and OTT advertising Ids. |
Identifier Types (ID-Type)
This table shows the identifier type (ID-Type) values for the files. This applies only to external activation platforms created using the manual workflow.
| Type | Value | Description |
|---|---|---|
| Email Address | HEM_SHA25 | SHA256 hashed email address |
| Phone Number | PHONE_SHA256 | SHA256 hashed E164 formatted phone number |
| Mobile Advertiser ID (MAID) | MAID | Advertising ID for a mobile device |
| Over-the-top (OTT) ID | OTT | Advertising ID for an OTT or CTV device |
The file path is s3://mydatacdp/Salesforce-CDP/ActivatedSegments/2021-11-29/123-456-789/63a37da2-7474-428b-bdca-54cc0d970de5/type=HEM_SHA25/part-0000-ca80176d-e93b-46d5-a17f-c448a078d34b.c000.csv.gz.
| Value | File Path Variable |
|---|---|
| mydatacdp/Salesforce-CDP/ActivatedSegments | Bucket-Name |
| 2021-11-29 | Date |
| 123-456-789 | Account-ID |
| 63a37da2-7474-428b-bdca-54cc0d970de5 | Activation-Run-ID |
| Type=SHA256 | ID-Type |
Metadata File
The daily metadata file contains details about required and hidden fields, optional fields, segment Ids, and segment names. Data 360 admins can exclude segment names when installing your external activation platform by disabling Include segment name in activations to this platform. The metadata file includes only the segments present at the time of publishing. Segments deactivated, deleted, or expired in Data 360 don’t appear in the metadata file.
The file is stored at s3://{Bucket-Name}/{Date}/{Client-Account-ID}/{Activation-Run-ID}/metadata.json.
To identify segments deleted from Data 360, compare metadata file contents daily for differences.
{
"metadata": {
"AccountId": "123456",
"OptionalField1": "default",
"HiddenField1": "Salesforce-CDP"
},
"segments": [
{
"segmentId": "1sgRN00000002tI",
"segmentName": "Shoe Lovers"
},
{
"segmentId": "1sgRN00000001tC",
"segmentName": "High-Value Customers"
},
{
"segmentId": "1sgRN00000001rV",
"segmentName": "Email Engagement in Last 30 Days"
}
]
}
Activation Output Files
Multiple activation output files arrive each day for each identifier type with information about segments published that day. Files include the value for an ID type and a list of segments in which that ID is a member. Each partial file is an individually compressed CSV, NDJSON, or Parquet GZIP file.
CSV Format
CSV files include a header and record details for each segment.
| id | adds | removes |
|---|---|---|
| IFA-Value | Segment-IDs |
id,adds,removes
30f39b57-7a31-439b-beeb-c3aa22593b27,1sgRN00000001rV,""
NDJSON Format
NDJSON is newline delimited with format {"id":"[IFA-Value]","adds":"[Segment-IDs]","removes":""}.
This JSON file includes one segment with Id 1sgB000000000gq and IFA value 43950934.
{"id":"43950934","adds":"1sgB000000000gq","removes":""}