Integration Options
You have 2 options integrating TripleWhale data to DatAds. In most of the cases Option 1 is the best option as it requires almost no setup on your side. In case you have special needs or special datapoints, you can implement a webhook export as explained in Option 2.
Option 1: TripleWhale API (preferred)
Requirements
Shop URL: Ensure you know your Shop URL. You can get it from https://app.triplewhale.com/store-settings/general
API-Key: You have 2 options:
Option 1: Instead of creating a new API Key, you can also invite "[email protected]" to your TripleWhale store. In that case you don't need to create a new API Key as the DatAds API Key is associated with "[email protected]" and by assigning it to your store it automatically gets access.
Option 2: Follow instructions from https://triplewhale.readme.io/reference/creating-and-managing-orcabase-api-keys to create a new API Key. When creating the developer account ensure the email address you use has access to the TripleWhale store you want to connect.
Tutorial
Ensure you have your Shop URL and API Key ready (see requirements above)
Navigate to https://app.datads.io/settings/connections
Scroll down and find the TripleWhale (API) connection
Click connect
Select the ad account you want to get TripleWhale data for. Important: You need to request a separate connection for each ad account. If you have multiple ad accounts you need to repeat this process for each ad account
Click connect
Paste your TripleWhale Shop URL and API Key into the field (see requirements above) and click on Finish setup
If you see "Connection successful" your job is done. We immediately start loading your data in the background so that you should see your TripleWhale data in DatAds within the next 2-3 hours
Option 2: TripleWhale Webhooks (Requires Moby Agents Add-On)
Requirements
Ensure you have access to Moby Workflows. Important: If you don't have access to "Moby Workflows", please open a support ticket with us. We have direct contact to TripleWhale and may be able to grant you access to this feature. However, we cannot guarantee TripleWhale will grant access
Technical knowledge is required for this setup. If you need guidance please reach out to us and we can help you set the connection up. In case you are a customer of ours the TripleWhale setup is free. If you are in the free trial we charge a one-time setup fee of 150€
Tutorial
Navigate to https://app.datads.io/settings/connections
Scroll down and find the TripleWhale connection
Click connect
Select the ad account you want to get TripleWhale data for. Important: You need to request a separate connection for each ad account. If you have multiple ad accounts you need to repeat this process for each ad account
Click connect
You will see the webhook url generated by DatAds as well as the generated SQL query for the TripleWhale workflow. Copy both as you'll need them in the following
TripleWhale Workflow Setup
Go to your TripleWhale account and navigate to Workflows
Click on "Create Workflow"
Click on "Add step", then "Tools" and finally "Run SQL"
This is the crucial part: Paste the SQL query from above it into the SQL editor. You can modify it to your needs:
Metrics are only examples. We expect you to add the metrics you need to the "SELECT" part of the query. To do so you can either modify the query directly, or you can click on "Edit in full editor" and add more metrics in the same format as the other metrics. Keep in mind, that only summable metrics like spend or conversions can be imported into DatAds. E.g. if you want to add metrics, that are aggregated not by sum like "Cost per X" you will later need to build a custom metric in DatAds using the summable metrics
Currently the SQL query exports the last 7 days. You can modify the lookback period by replacing the "7" with a different lookback e.g. "30" to get the last 30 days:
p.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE() - 1Leave the rest of the query as is. Otherwise the data format might get corrupted and DatAds is unable to match TripleWhale data to ads
Click on the "+" to add another step. Select "Destinations", then "Send to Webhook"
Paste the webhook url from above into the field
Click on "Finish Up". Give your workflow a name and select "daily" frequency. Congrats, you're all set! 🎉
Be aware that TripleWhale will send the data to DatAds only once a day so that it can take up to 1 day until you see your TripleWhale data in DatAds