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
Access your FSU server.
Open the MMPExport.cfg file.
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.
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:
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
|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.|
This is a unique client secret provided to a customer when he/she is provisioned for MMP.
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.
Determines the parallelism of the chunk sending part. It accepts a value between 1 to 24 threads, and its default value is 12 threads.
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
From the client, open a workspace and right-click Tools> Detail Table.
Right-click the header and select Add Attributes.
Right-click the header and select New Master Marketing Profile Export.
Expand MMP Configuration.
(required) Enter the MMP Segment Name and MMP Visitor ID Field. These parameters cannot be left empty.
The MMP Segment Name should match the Segment ID defined in the MMP.
The MMP Visitor ID is the attribute column defined in step 4 that corresponds to the Visitor ID.
Once these fields are entered, you can save the export by right-clicking the header for the export and choose Save as “User.export”.
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
|MMP Segment ID||Required. This is an identifier you would define first in Audience Manager.|
|MMP Visitor ID Field||Map the ECID.|