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
-
Access your FSU server.
-
Open the MMPExport.cfg file.
Server/Admin/Export/MMPExport.cfg
. -
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
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).
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 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.
-
Add Level.
-
Right-click the header and select Add Attributes.
-
Right-click the header and select New Master Marketing Profile Export.
-
Expand Query.
-
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