The Trade Desk export destination

1. Ask in #help_product for TTD Destinationdestination to be added to the CDPMeiro Business Explorer

2. Create MIin WorkspaceMeiro Integrations workspace for TTD Destinationdestination

3. In Setup > Destinations, select the workspace from MIMeiro Integrations to be used by the destinationdestination.

4. Setup Mandatorymandatory and Exportedexported Attributeattributes to be an Attributeattribute holding the list of all TTD User IDs of the customer entity.

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

6. Create CDP Destination Connectorconnector in MIMeiro Workspace,Integration workspace, fill in Destinationdestination ID from CDPMeiro Business Explorer and credentials.

7. Using Python Codecode 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 Loaderloader (https://github.com/meiroio-components/ttd_loader ) to use the {{audience_id}} as name, fill in advertiser ID, secret and TTL.

9. Done 🙂