Skip to content
Last updated

Adobe Target Export Integration

This integration is currently in Beta, and we’re actively gathering feedback to improve its functionality and stability.

Overview

The Adobe Target connector allow marketers upload customer profiles data directly from TD platform to Adobe Target

Prerequisites

  • Basic knowledge of Treasure Data, including the TD Toolbelt.
  • Basic knowledge of Adobe Target.
  • Adobe Client Code and Adobe Profile API Access Token in case of Adobe Profile API Authentication enable

Static IP Address of Treasure Data Integration

If your security policy requires IP whitelisting, you must add Treasure Data's IP addresses to your allowlist to ensure a successful connection.

Please find the complete list of static IP addresses, organized by region, at the following link:
https://api-docs.treasuredata.com/en/overview/ip-addresses-integrations-result-workers/

Limitations & Known Issues

  • Updates generally occur in under one hour, but might take as long as 24 hours to be reflected.

Get Client Code and Profile API Authentication Token from Adobe Target

  • Login into experience.adobe.com then choose Target

  • From Target home choose Adminstration -> Implementation -> Copy Client Code

  • From Implementation page scroll down to Profile API section. Click on Require Authentication to enable if needed. After that click on Generate Authentication Token and copy and save the token for connector configuration.

Create a New Authentication

Before running your query, you must create and configure the data connection on the TD Console. As part of the data connection, you provide authentication to access the integration. Complete the following steps.

  1. Open TD Console.
  2. Navigate to Integrations Hub > Catalog.
  3. Search for and select Adobe Target. Hover over the icon and selectCreate Authentication.
  4. Ensure that the Credentials tab is selected, and then enter credential information for the integration. Choose one of the following

5. Select Continue. 6. Type a name for your connection. Select Done.

Authentication Fields

ParameterDescription
Client CodeThis is a unique identifier provided by Adobe Target, used for Adobe API authentication. Retrieved from Target admin settings
Adobe Profile API Authentication TokenOptional. Only required when Adobe Profile API authentication is enabled

Configure a Query Result for Export

The TD Console supports multiple ways to export data. Please follow these steps to export data from the Data Workbench.

  1. Navigate to Data Workbench > Queries.
  2. Select New Query, and define your query.
  3. Select Export Results to configure the data exporting.
  4. Select an existing Adobe Target authentication or create a new one described previously
  5. Select Done.

Connector Configuration Parameters

FieldDescription
Bulk Update API VersionAPI Version to be used. - v1: support for bulk profile update only. (mbox.id is supported by only v1) - v2 (default): create profile if not found.
Guaranteed UploadAdobe Target connector upload profile data file by file. If we checked the system will waiting for last uploaded file process successfully from Adobe Server Side before upload the next one.
Skip invalid records?If checked, the job will skip the invalid record and continue to handle the next record. Otherwise, the job will stop.

Detailed Guide for Query Result Data Specs

To successfully upload/modify user profile data to Adobe Target, you must construct an export query that adheres to specific data specifications.

1. Export Query Specifications

SpecificationDescription
Required FieldsAt least one of the following identifier fields must be present in your export query: - pc_id (Target-generated visitorID) - third_party_id (ID specified by the client application, which is passed to Target through an mbox call as mbox3rdPartyId) pc_id and third_party_id fields must be in String data type.
Custom FieldsAny fields not listed in the required fields will be automatically mapped to the profile param. These are displayed in Target as profile.paramName.

Export Integration Using the CLI

You can also use CLI (Toolbelt) to export results to Adobe Target.

You need to specify the information for export to your Adobe Target server using the --result option of the td query command. For more information about the td query command, refer to this article.

The format of the option is JSON, and the general structure is as follows.

type: 'adobe_target' 
client_code: xxxx  
profile_api_token: xxxxx  
api_version: v1  
guaranteed_upload: false  
skip_invalid_records: true

Example for Usage

$ td query --result '{"type":"adobe_target","client_code":"xxx","profile_api_token":"xxx", "api_version": "v1","guaranteed_upload":false,"skip_invalid_records":true}' -d sample_datasets "select ........ from ........" -T presto

The following table identifies the configuration keys with descriptions.

Config KeyTypeRequiredDescription
typestringyesvalue must be adobe_target
client_codestringyesAdobe Target client code
profile_api_tokenstringyes if Adobe profile api turn onAdobe Profile API token
api_versionstringnoSelect from v1, v2. Default is v2
guaranteed_uploadbooleannoDefault value is false. If set to true then next upload profile data will wait until current upload process done on Adobe Target Side
skip_invalid_recordsbooleannoIf set to true (default), this will skip invalid records and continue uploading valid ones. If set to false, this will terminate the job when an invalid record is encountered.

Notes

For those whose would like to retrieve uploaded pcID via API, please add edge domain to profile fetch URL for exact location. Adobe Target implements geographically distributed serving architecture to optimize response time regardless of users' location. pcId profiles are routed to nearest edge. Check the batch upload status for edge domain where the data is routed to.

See Adobe Target's document for more information https://experienceleague.adobe.com/en/docs/target-dev/developer/implementation/privacy/allowlist-edges