Overview
Adform is an integrated advertising platform offering a full-stack DSP, DMP, and ad-serving solution. The Adform API provides programmatic access to campaign configuration, line item and creative metadata, delivery performance, audience segments, and conversion tracking data.
Data handled by the integration:
Account & Campaign Data
Advertiser accounts and account IDs
Campaigns and insertion orders
Campaign types (display, video, mobile, native, CTV)
Objectives, pacing, budgets, and bid strategies
Campaign status (active, paused, ended)
Line Item / Sub-Campaign Data
Line item configuration
Targeting information (geography, audience segments, devices)
Flight dates, budget allocation, frequency caps
Creative & Ad Data
Creative metadata: ad ID, name, size, and format
Creative type (banner, native, rich media, video)
Associated campaign and line item
Approval and QA status
Performance Metrics
Impressions, clicks, CTR
Cost, CPC, CPM, spend
Conversions (post-click and post-view)
Conversion value and revenue
Viewability metrics (where available)
Engagement metrics for rich media or video creatives
Audience & Targeting Data
First-party and third-party audience segments
Device, browser, and operating system information
Publisher / domain performance
Geographic breakdowns
Metadata & Reference Tables
Hierarchical structure (campaign → line item → creative)
Device, region, and domain mappings
Ad format and creative type taxonomy
Conversion event definitions
Granularity
The Adform connector supports reporting at: Campaign, Line item, Creative, Placement and Audience level
Purpose
Monitor Adform campaign delivery and performance
Analyse line item, placement, and creative effectiveness
Evaluate domain and publisher performance across programmatic inventory
Track conversions, attribution models, and CPA/ROAS
Integrate Adform metrics into multi-platform dashboards
Perform historical analysis, optimisation, and QA of campaign delivery
Refresh Cadence:
Data is refreshed daily.
Update Modes:
Append (for data table), Refresh (for metadata)
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) |