Show Menu
TOPICS×

Master Marketing Profile Export

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:
    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.
    <b>Sample MMPExport.cfg</b> 
    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:
    
    
    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&nbsp;(~50 KB chunks)&nbsp;and max = 50000 records (~2.5 MB chunks).&nbsp;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- # .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.