The Trade Desk Export Destination

1. Ask in #help_product for TTD Destination to be added to the CDP

2. Create MI Workspace for TTD Destination

3. In Setup > Destinations, select the workspace from MI to be used by the destination

4. Setup Mandatory and Exported Attribute to be an Attribute holding the list of all TTD User IDs of the customer entity.

5. Setup a parameter for destination, audience_id as user input, required.

6. Create CDP Destination Connector in MI Workspace, fill in Destination ID from CDP and credentials.

7. Using Python Code unnest a list of TDD User IDs into a csv with 1 column “tdid”.

   import json, csv, sys
   
   with open('in/tables/export.csv', 'r') as inf, open('out/tables/tdid.csv','w') as outf:
   	reader = csv.DictReader(inf)
   	writer = csv.DictWriter(outf, fieldnames=['tdid'])
   	writer.writeheader()
   
   	for r in reader:
   		attrs = json.loads(r['mx_ttd_id'])
   
   		for a in attrs:
   			writer.writerow({
   				'tdid': a})

8. Set up The Trade Desk Loader (https://github.com/meiroio-components/ttd_loader ) to use the {{audience_id}} as name, fill in advertiser ID, secret and TTL.

9. Done 🙂