[AdRoll, AdRoll, is a prospecting and re-targeting platform. It allows users to place ads, monitor performance, and run campaigns., Features, Feature Name, Supported, Notes, Capture Deletes, Custom Data, Data Blocking, Column Hashing, Re-sync, check, Connector level, History, API Configurable, check, Priority-first sync, check, Reporting tables, dbt Package, Setup guide, Follow our step-by-step , AdRoll setup guide, to connect AdRoll with your destination using Fivetran connectors., Schema information, Tables and fields, Fivetran generates one table for each selected report. The fields selected during integration setup constitute the columns in table., For , ALL_CAMPAIGNS , ALL_ADVERTISABLES and , ALL_ADGROUPS, reports , eid, is a mandatory field., For , ALL_ADS, and , ALL_AUDIENCES, reports , eid, and , campaign, are mandatory fields., For , CONVERSIONS, report , audienceEID, is mandatory field., Available reports, The followings are different types of reports available for the AdRoll connector:, ALL_ADVERTISABLES, – This is an organization level report. Use this report to fetch all the advertisables in an organization., ALL_CAMPAIGNS, – This is a user level report. Use this report to fetch all the Campaigns visible to the selected account(s)., ALL_ADS, – This is a user level report. Use this report to fetch all the Advertisements visible to the selected account(s)., ALL_ADGROUPS, – This is a user level report. Use this report to fetch all the Adgroups visible to the selected account(s)., ALL_AUDIENCE, – This is a user level report. Use this report to fetch all the Audience data for all the ads visible to the selected account(s)., ALL_ADS, – This is a user level report. Use this report to fetch all the Advertisements visible to the selected account(s)., CONVERSION, – This is a user level report. Use this report to fetch all the Conversions for all the Campaigns, Adgroups, and Ads visible to the selected account(s)., Reporting delay, We fetch 48 hours old data from AdRoll. As per AdRoll documentation data is not considered finalized until after 48 hours of the current UTC day. Refer to , “AdRolls FAQ”, for details.]