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