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.
Set up your warehouse
- Choose your warehouse: Redshift or Postgres.
- Enter the credentials for access, the host and the port. Please note that the port needs to be added separately from the host.
- 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.
- If we're able to successfully connect, we'll sync the data at the end of the day UTC.