AdRoll SQL sends your AdRoll performance (impressions, clicks, conversions) data to a Redshift, MySql, or Postgres database that you host. It’s an easy way to extract, transform and load your AdRoll data into other data sets. 

Setup your AdRoll SQL here. For technical details, see AdRoll SQL on the AdRoll Developer site.

Set up your warehouse

  1. Choose your warehouse: Redshift or Postgres.
  2. Enter the credentials for access, the host and the port. Please note that the port needs to be added separately from the host.
  3. Test your connection by clicking Connect. If you see an error, it means AdRoll couldn't access your database. Please check the permissions on the host.
  4. If we're able to successfully connect, we'll sync the data at the end of the day UTC.


Was this article helpful?

Related articles