AdRollSQL 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.
4 steps to setting 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. You can test your connection by clicking on "Connect". If you see an error like this, it means AdRoll cannot access your database. Please check the permissions on the host.
4. If we are able to successfully connect, we will sync the data at the end of the day UTC.