Linking AdRoll as a source
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Contents
You can sync advertising entity data from AdRoll (NextRoll) by configuring it as a source in PostHog. The supported entities that can be synced include:
| Entity | Description |
|---|---|
| Advertisables | Your organization's advertisable entities |
| Campaigns | Campaigns for each advertisable |
| Ads | Ads for each advertisable |
Campaigns and ads include an _advertisable_eid field that links each row back to its parent advertisable. All entities use eid as their primary key and sync via full refresh.
Additional entities and performance reports will be added based on user feedback we receive via our in-app support form.
Requirements
- An AdRoll account with access to the organization data you want to sync.
- A personal access token and an app Client ID from the NextRoll developer console.
To get your credentials:
- Go to the NextRoll developer console.
- Create a personal access token.
- Create an app — the app's Client ID is sent as the
apikeyon every API request.
NextRoll's default API quota is 100 requests per day. A full sync costs 1 + 2× the number of advertisables in your organization. If you have a large number of advertisables, contact NextRoll support to raise your quota before setting up the source.
Configuring PostHog
Connect PostHog to your AdRoll account using your API credentials.
- In PostHog, go to the Data pipelines tab.
- Open the + New drop-down menu in the top-right and select Source.
- Find AdRoll in the sources list and click Link.
- Enter the Client ID from your NextRoll app.
- Enter your Personal access token.
- (Optional) Add a prefix for the table name.
Configuration
| Option | Type | Required |
|---|---|---|
Client ID (apikey) | text | Yes |
Personal access token | password | Yes |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
organization | The AdRoll organization the credentials belong to — the top of the organization, account, advertisable hierarchy. | Full refresh | — | — |
accounts | An account under your AdRoll organization, grouping the advertisables that are billed together. | Full refresh | — | — |
advertisables | An advertisable entity (a brand or product) under your AdRoll organization that campaigns run against. | Full refresh | — | — |
campaigns | An advertising campaign belonging to an advertisable, grouping ads toward a goal and budget. | Full refresh | — | — |
adgroups | An ad group within a campaign, pairing a set of ads with the segments and placements they target. | Full refresh | — | — |
ads | An individual ad creative belonging to an advertisable, served within campaigns. | Full refresh | — | — |
segments | An audience segment on an advertisable's active pixel, used to target or exclude visitors in ad groups. | Full refresh | — | — |
advertisable_reports | Lifetime delivery metrics per advertisable, as returned by the CRUD reporting API in its entity format. | Full refresh | — | — |
campaign_reports | Lifetime delivery metrics per campaign, as returned by the CRUD reporting API in its entity format. Prospecting and new-style Facebook campaigns are not covered by this endpoint. | Full refresh | — | — |
ad_reports | Lifetime delivery metrics per ad, as returned by the CRUD reporting API in its entity format. | Full refresh | — | — |