Overview
The Adform connector ingests daily delivery‑level performance data from the Adform DSP along with campaign and line‑item metadata for richer reporting.
Granularity: one row per campaign × line‑item × day.
Purpose: monitor spend, delivery, viewability, and efficiency KPIs across programmatic activity.
Refresh cadence: daily append of delivery rows plus daily lookup refreshes.
Please read more about the use cases of our Adform integration here.
Connection Setup / Requirements
Key | Description | Required | Type |
| Pre‑configured client ID ( | No | Hidden |
| Pre‑configured API secret | No | Hidden |
¹ These credentials are bundled with the connector; no additional user input is needed unless you override them with your own Adform app registration.
Import Configuration
1. Data Import
Setting | Value |
Feed |
|
Job Label | Adform – Data Import |
Status | Enabled (1) |
Target Table |
|
Target Type | Data |
Update Mode | Append |
Create Target |
|
Date Column |
|
Look‑back | 10 days |
First Run (UTC) | 05 : 00 |
Poll Frequency | Every 24 hours |
2. Meta Refresh
Setting | Value |
Target Tables |
|
Target Type | Lookup |
Update Mode | Refresh |
Create Target |
|
Priority | Campaign = 1, LineItem = 2 |
Import Schedule
Job Type | Frequency | Look‑back Window | First Run (UTC) |
Data Import | 24 h | 10 days | 05 : 00 |
Meta Refresh | 24 h | 0 days (full refresh) | 05 : 00 (runs immediately after delivery import) |
Required User Input
No user input is required by default because the connector ships with its own Adform OAuth credentials. Supply alternate adform_client_id
/ adform_client_secret
only if you need to use a different Adform application.
Tables Created
Table Name | Description | Type | Update Mode |
| Daily delivery / performance facts | Data | Append |
| Campaign lookup | Lookup | Refresh |
| Line‑item lookup | Lookup | Refresh |
Table Relationships
Source Column (in | Target Table | Target Column |
|
|
|
|
|
|
Available Dimensions
Dimension Name | Source Field(s) | Description |
Client [Adform] |
| End advertiser or agency client |
Campaign [Adform] |
| Campaign name (lookup) |
Line Item [Adform] |
| Line‑item / insertion order name (lookup) |
Banner [Adform] |
| Creative/banner label |
Available Metrics
Base Metrics
Metric Name | Calculation Formula | Round | Prefix /Suffix | Description |
Spend [Adform] |
| 2 | £ | Media spend |
Impressions [Adform] |
| 0 |
| Served impressions |
Clicks [Adform] |
| 0 |
| Clicks |
Conversions [Adform] |
| 0 |
| Post‑click or post‑view conversions |
Measurable Impressions [Adform] |
| 0 |
| Impressions eligible for viewability measurement |
Viewable Impressions [Adform] |
| 0 |
| Viewable impressions |
Composite Metrics
Metric Name | Calculation Formula | Round | Prefix/Suffix | Description |
CPC [Adform] |
| 2 | £ | Cost per click |
CPM [Adform] |
| 2 | £ | Cost per thousand impressions |
CTR [Adform] |
| 2 | % | Click‑through rate (‑per‑thousand basis) |
Additional Information
Daily batch import: runs once per day, loading the last 10 days to backfill late data.
Automatic table creation: enabled for
adform_data_delivery
; metadata tables must already exist to preserve schema governance.Granularity: one record per campaign × line‑item × banner × day.
Viewability support: both measurable and viewable impression counts are provided to calculate viewability rate in your BI layer.
Adform – Data Tables
Field | Type | Description |
date |
| Reporting date |
client |
| Advertiser or agency client |
campaignID |
| Foreign key to |
lineItemID |
| Foreign key to |
banner |
| Banner / creative label |
impressions |
| Served impressions |
measurableImpressions |
| Impressions eligible for viewability measurement |
viewImpressions |
| Viewable impressions |
clicks |
| Total clicks |
conversions |
| Total conversions (post-click and post-view) |
cost |
| Spend in delivery currency |
device |
| Device type (e.g. Desktop, Mobile) |
site |
| Publisher site or app name |
placement |
| Placement ID or name on publisher side |
country |
| Country (ISO 2-letter code) |
region |
| Region or state within country |
creativeSize |
| Creative dimensions (e.g. 300×250) |
currency |
| Currency code (e.g. GBP, EUR) |
costModel |
| Cost model (CPM, CPC, CPA, etc.) |
Campaign Metadata (adform_meta_campaign
)
Lookup table for campaign-level attributes, joined via campaignID
.
Field | Type | Description |
id |
| Campaign ID (primary key) |
name |
| Campaign name |
status |
| Campaign status (e.g. Active, Paused) |
startDate |
| Campaign start date |
endDate |
| Campaign end date |
objective |
| Campaign objective (e.g. Awareness, Performance) |
advertiser |
| Advertiser name |
buyingType |
| Buying method (e.g. Guaranteed, RTB) |
budget |
| Total campaign budget |
currency |
| Budget currency |
timeZone |
| Reporting time zone |
Line Item Metadata (adform_meta_lineitem
)
Lookup table for line item attributes, joined via lineItemID
.
Field | Type | Description |
id |
| Line item ID (primary key) |
name |
| Line item name |
campaignID |
| Foreign key to campaign |
status |
| Line item status |
goalType |
| Goal type (e.g. CPC, CPM) |
goalValue |
| Goal threshold value |
budget |
| Allocated budget |
pacing |
| Delivery pacing (Even, ASAP) |
startDate |
| Line item start date |
endDate |
| Line item end date |
targeting |
| Targeting parameters (audience, geo, device) |
Summary
With built‑in credentials, the Adform connector:
Appends daily delivery rows, backfilling the last 10 days.
Refreshes campaign & line‑item lookups for accurate names and statuses.
Supplies a concise set of dimensions and metrics—plus cost, viewability, and efficiency KPIs—to power programmatic advertising dashboards.
Blend Adform data with your wider media ecosystem to measure true omni‑channel performance.