Overview
Adalyser is a TV attribution and campaign measurement platform used to track the performance of linear, BVOD, and connected TV advertising. The Adalyser API provides programmatic access to spot logs, campaign metadata, performance metrics, and attribution insights, enabling marketers to integrate TV campaign measurement into dashboards.
Data handled by the integration:
Campaign & Account Data
Advertiser accounts and account IDs
Campaign metadata (name, objective, start/end dates)
TV channels, programmes, and regions
Buying types (spot-based, sponsorship, BVOD, connected TV)
Spot / Log Data
Individual spot airings
Spot timestamps (broadcast time, daypart)
Channel/station names
Creative versions and durations
Break position and programme metadata (where available)
Performance & Attribution Metrics
Attributed responses (web visits, conversions, app activity, etc.)
Response curves
Cost, CPR, and effective attribution
Uplift metrics (incremental visits, incremental conversions)
Spot-level response windows (e.g., 3 min, 5 min, 10 min post-airing)
Creative & Asset Data
Creative IDs and versions
Duration, naming conventions
Assignment to campaigns and channels
Metadata & Reference Tables
Channel/station list
Region mapping
Programme categories and dayparts
Attribution settings and response windows
Granularity:
Adalyser data supports Campaign, Channel, Creative and Spot level data.
Purpose:
Analyse TV, BVOD, and connected TV campaign effectiveness
Attribute digital responses to spot airings
Evaluate channel, programme, and daypart performance
Compare creatives and identify best-performing versions
Build cross-channel attribution dashboards
Support budget allocation and optimisation decisions
Provide transparent spot-level logs for auditing and verification
Refresh Cadence:
Data is refreshed daily.
Update Modes:
Append (for data table), Refresh (for metadata)
Please read more about the use cases of our Adalyser Integration here.
Connection Setup / Requirements
Key | Description | Required | Type |
| Username used to log in to the Adalyser UI | Yes | Text |
| Corresponding password | Yes | Password |
Note API host / token parameters are not required; the connector authenticates via the Adalyser web credentials you supply.
Import Configuration
1. Data Import
Setting | Value |
Feed |
|
Job Label | Adalyser – Data Import |
Status | Enabled (1) |
Target Table |
|
Target Type | Data |
Update Mode | Append |
Create Target |
|
Date Column |
|
Look‑back | 5 days |
First Run (UTC) | 05 : 00 |
Poll Frequency | Every 24 hours |
Required Option |
|
2. Meta Refresh – Campaign
Setting | Value |
Target Table |
|
Target Type | Lookup |
Update Mode | Refresh |
Create Target |
|
Priority | 1 (runs first among lookups) |
3. Meta Refresh – Creative
Setting | Value |
Target Table |
|
Target Type | Lookup |
Update Mode | Refresh |
Create Target |
|
Priority | 2 |
Import Schedule
Job Type | Frequency | Look‑back Window | First Run (UTC) |
Data Import | 24 h | 5 days | 05 : 00 |
Meta Refresh | 24 h | 0 days (full refresh) | 05 : 00 |
Poll Frequency controls how often the connector executes. Look‑back dictates the rolling window pulled on each run.
Required User Input
Adalyser credentials – username & password (connection settings).
Campaign IDs – comma‑separated list (
adalyser_campaign_id) to limit the import to specific campaigns.
Both inputs must be configured before the first run.
Tables Created
Table Name | Description | Type | Update Mode |
| Individual TV‑spot performance rows | Data | Append |
| Campaign‑level metadata | Lookup | Refresh |
| Creative‑level metadata | Lookup | Refresh |
Table Relationships
Source Column (in | Target Table | Target Column |
|
|
|
|
|
|
These joins enrich raw spot data with campaign and creative attributes for reporting.
Available Dimensions
Dimension Name | Source Field(s) | Description |
Sales House [Adalyser] |
| TV sales‑house responsible for airtime |
Channel [Adalyser] |
| Broadcast channel where the spot aired |
Programme [Adalyser] |
| TV programme during which spot aired |
Creative [Adalyser] |
| Creative identifier / name |
Type [Adalyser] |
| Spot type (e.g., National, Regional) |
Available Metrics
Base Metrics
Metric Name | Calculation Formula | Round | Description |
Spend [Adalyser] |
| 2 | Media spend (billing currency) |
Sessions [Adalyser] |
| 0 | Web sessions attributed to the spot |
Sign Ups [Adalyser] |
| 0 | Successful sign‑ups / appointments |
Sales [Adalyser] |
| 0 | Closed sales attributed |
Lead Count [Adalyser] |
| 0 | Leads generated (same field as Sessions if treated equivalently) |
Composite Metrics
Metric Name | Calculation Formula | Rounding | Prefix/Suffix | Description |
Cost per Session [Adalyser] |
| 2 | £ | Average cost per attributed session |
Cost per Sign‑up [Adalyser] |
| 2 | £ | Average cost per sign‑up |
Additional Information
Daily batch import: the connector runs once every 24 hours at 05 : 00 UTC.
Automatic table creation: set to true for the fact table; lookup tables must exist beforehand (allows governance over metadata structures).
Granularity: each row in
adalyser_data_spotsrepresents a single aired TV spot.Multi‑campaign support: restrict data to specific campaigns via the
adalyser_campaign_idoption; omit or leave blank to ingest all accessible campaigns.
Performance Data Tables
Spot-Level Data (adalyser_data_spots)
This table contains detailed information about each TV ad spot and its associated performance metrics.
Field Name | Data Type | Description |
bright_custom_date |
| The date the spot was aired (used for time series). |
bright_custom_campaign_id |
| Campaign identifier. |
creative |
| Identifier for the creative aired. |
salesHouse |
| Sales house responsible for the spot. |
channel |
| Channel where the spot was broadcast. |
programme |
| Name of the programme into which the spot aired. |
type |
| Classification of the spot (e.g., Spot, Sponsorship). |
clientCost |
| The client’s net cost for the spot. |
leadCount |
| Number of leads generated from the spot. |
apptCount |
| Number of appointments/sign-ups. |
saleCount |
| Number of actual sales. |
Lookup Metadata Tables
Campaign Metadata (adalyser_meta_campaign)
Field Name | Data Type | Description |
id |
| Unique identifier for the campaign. |
name |
| Human-readable name of the campaign. |
Creative Metadata (adalyser_meta_creative)
Field Name | Data Type | Description |
id |
| Unique identifier for the creative. |
name |
| Human-readable name of the creative. |
Datasource Joins
Left Field (LHS) | Right Field (RHS) | Join Purpose |
creative | adalyser_meta_creative.id | Joins spot-level data to creative metadata. |
bright_custom_campaign_id | adalyser_meta_campaign.id | Joins spot-level data to campaign metadata. |
Dimensions
Dimension Name | Mapped Field |
Sales House [Adalyser] | adalyser_data_spots.salesHouse |
Channel [Adalyser] | adalyser_data_spots.channel |
Programme [Adalyser] | adalyser_data_spots.programme |
Creative [Adalyser] | adalyser_data_spots.creative |
Type [Adalyser] | adalyser_data_spots.type |
Base Metrics
Metric Name | Formula | Rounding | Prefix/ Suffix |
Spend [Adalyser] | SUM(adalyser_data_spots.clientCost) | 2 | £ |
Sessions [Adalyser] | SUM(adalyser_data_spots.leadCount) | 0 |
|
Sign Ups [Adalyser] | SUM(adalyser_data_spots.apptCount) | 0 |
|
Sales [Adalyser] | SUM(adalyser_data_spots.saleCount) | 0 |
|
Lead Count [Adalyser] | SUM(adalyser_data_spots.leadCount) | 0 |
|
Composite Metrics
Metric Name | Formula | Rounding | Prefix/ Suffix |
Cost per Session [Adalyser] | Spend [Adalyser] / Sessions [Adalyser] | 2 | £ |
Cost per Sign-up [Adalyser] | Spend [Adalyser] / Sign Ups [Adalyser] | 2 |
|
(Optional) Keyword‑Level Metadata
Adalyser does not expose keyword entities; instead, the creative and campaign tables provide the core lookup context. No keyword table is included by default.