Awin
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.
Connect Awin to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Enter your Awin API token to pull your Awin affiliate data into the PostHog Data warehouse.
Create a personal OAuth2 token from the Awin API settings. The same token grants access to every publisher account your user can see.
Configuration
| Option | Description |
|---|---|
API tokenType: password Required: True | |
RegionType: select Required: True | Your Awin account's primary region. Used to sync the advertiser performance report. |
Linking Awin to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Awin
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
accounts | The publisher and advertiser accounts your Awin API token can access. | Full refresh | — | — |
programmes | Advertiser programmes a publisher account has joined. | Full refresh | — | — |
transactions | Only syncs the last 365 days on initial sync | Incremental, Full refresh | transactionDate, validationDate | — |
reports_advertiser | Full refresh only. A rolling snapshot of the last 30 days of performance, aggregated per advertiser | Full refresh | — | — |