Linking AdRoll as a source
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 |
|---|---|---|---|---|
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 | — | — |
ads | An individual ad creative belonging to an advertisable, served within campaigns. | Full refresh | — | — |