Master Marketing Profile Export

IMPORTANT
Read more about Data Workbench’s End-of-life announcement.

Data Workbench lets you export files to integrate with Profiles and Audiences as part of an integrated Adobe Experience Cloud.

Profiles and Audiences is part of the Experience Cloud Identity Service, a core service of the Adobe Experience Cloud. The Profiles and Audiences export allows audiences to be shared across the Experience Cloud using a unique Experience Cloud ID (ECID) that is assigned to every visitor and then used by Audience Manager. The ExportIntegration.exe application ( E:\Server\Scripts) is employed to generate both MMP and Adobe Target exports.

Configuring the FSU Server to use Profiles and Audiences

  1. Access your FSU server.

  2. Open the MMPExport.cfg file. Server/Admin/Export/MMPExport.cfg.

  3. Enter values in the all fields as required. For example:

    note note
    NOTE
    MMP/AAM integration relies on Amazon’s s3 bucket for data transfer.
    The s3 information required for MMP (s3) transfer can be obtained from Audience Manager team.
    code language-none
    Sample MMPExport.cfg
    MMP Export Configuration = MMPExportConfiguration:
    s3 Bucket = string: aws_bucket_for_mmp
    s3 Object Directory = string: test/files/
    s3 Region = string: us-east-1
    s3 Access Key = string: ZZKI62OO5YBA
    s3 Secret Key = string: ioqwa3OpNE5
    data Provider Name = string: 895
    client ID = string: mcprofile2-test
    client Secret = string: saea1287617212987q
    username = string: mmptest
    password = string: pass
    numRecordsPerChunk = int:
    numThreads = int:
    maxRetriesOnSendFailure = unsigned int:
    
    note note
    NOTE
    The MMPExport.cfgfile also lets you take all records, split them into sets, and create chunks of records. The chunks of records are then exported to Amazon S3. Three mandatory parameters are required to create chunks of records: numRecordsPerChunk, numThreads, and maxRetriesOnSendFailure.

Definition of Parameters

Parameter
Definition
s3 Bucket
The AWS S3 bucket where the export is transferred to.
s3 Object Directory

A path to save s3 files. This supports sub-directories.

Important: Space and multibyte characters are not allowed in the path and will create errors in the export. (The hypen is allowed).

s3 Region
The AWS s3 Region where the export is sent to. Ex. us-east-1
s3 Access Key
AWS s3 Access Key
s3 Secret Key
AWS s3 Secret Key
data Provider Name
This will be the folder name that is used for storing segments and traits in AAM respectively. This should be unique per customer.
client ID
This is a unique client ID provided to a customer when provisioned for MMP.
client Secret
This is a unique client secret provided to a customer when he/she is provisioned for MMP.
username
MMP username
password
MMP password
numRecordsPerChunk

Determines the chunk size in terms of number of records.

The implementation clips the user specified value to min = 1000 records (~50 KB chunks) and max = 50000 records (~2.5 MB chunks). A default value of 10000 is used in case the user does not specify this configuration property.

numThreads
Determines the parallelism of the chunk sending part. It accepts a value between 1 to 24 threads, and its default value is 12 threads.
maxRetriesOnSendFailure

Determines the number of retry attempts to be made in case of chunk send failures. Default value is 0 specifying no retries.

Sleep interval of 2 seconds is used between retries.

Generating MMP export from the client

  1. From the client, open a workspace and right-click Tools> Detail Table.

  2. Add Level.

  3. Right-click the header and select Add Attributes.

  4. Right-click the header and select New Master Marketing Profile Export.

  5. Expand Query.

  6. Expand MMP Configuration.

  7. (required) Enter the MMP Segment Name and MMP Visitor ID Field. These parameters cannot be left empty.

  8. The MMP Segment Name should match the Segment ID defined in the MMP.

  9. The MMP Visitor ID is the attribute column defined in step 4 that corresponds to the Visitor ID.

  10. Once these fields are entered, you can save the export by right-clicking the header for the export and choose Save as “User.export”.

  11. Open Admin > Profile Manager and save the export to the profile.

    If all data is entered correctly, this will generate an export file in the FSU (Server/Exports) and it will also transfer the export to the AWS using the information in MMPExport.cfg. The log for this is provided in Server/Trace/. eg., MMP-102014-133651- <Segment Export Name> .log

Query = SegmentExportQuery:
Command = string: ExportIntegration.exe
Command Arguments = string: \"%file%.cfg\" \"%file%\"
Filter = string:
Level = string: Page View
MMP Configuration = MMPConfiguration:
MMP Segment Name = string: 12345
MMP Visitor ID Field = string: Tracking ID
Oneshot = bool: true
Output Fields = vector: 3 items
0 = ColumnDefinition:
Column Name = string:
Field Name = string: Tracking ID
1 = ColumnDefinition:
Column Name = string:
Field Name = string: PID
2 = ColumnDefinition:
Column Name = string:
Field Name = string: SID
Output File = string: MMPTest.txt
Output Format = string: %1%\t%2%\t%3%\r\n
Schedule End Time = string:
Schedule Every = string:
Schedule Start Time = string:
Time Limit (sec) = double: 1800
Configuration Details
Description
MMP Segment ID
Required. This is an identifier you would define first in Audience Manager.
MMP Visitor ID Field
Map the ECID.
6586dc9d1b0434ed2e627930