Skip to main content

Quantcast API Connector

Updated this week
Quantcast Logo and Wordmark by Jonathan Smiley for Quantcast on Dribbble

Overview

Quantcast provides audience measurement, real-time advertising, and campaign performance insights across digital media. The Quantcast API allows programmatic access to campaign-level metrics, targeting, and audience insights, supporting reporting, optimisation, and verification for display, video, and programmatic campaigns.

This connector focuses on advertising performance, audience measurement, and campaign analytics.

Data handled by the integration:

Account & Campaign Data

  • Advertiser accounts and campaign hierarchies

  • Campaign objectives and statuses

  • Budget, bid, and pacing configurations

  • Targeting segments applied to campaigns

Creative & Ad Data

  • Creative metadata (ad ID, format, size, media type)

  • Associated campaign and placement information

  • Creative approval status

Performance Metrics

  • Impressions, clicks, CTR

  • Cost, CPC, CPM, spend

  • Conversions and conversion value

  • Engagement metrics (video views, interaction rates)

  • Frequency and reach

Audience & Targeting

  • Demographics (age, gender, location)

  • Interest segments and behaviour categories

  • Custom and lookalike audience performance

  • Device type and platform breakdowns

Measurement & Verification Metrics

  • Viewability metrics

  • Fraud / invalid traffic detection

  • Brand safety compliance

  • Contextual targeting categories

Metadata & Reference Tables

  • Campaign and creative hierarchy

  • Audience taxonomy and segment definitions

  • Device and geography tables

  • Ad format and environment mapping

Measurement & Verification Metrics

  • Viewability metrics

  • Fraud / invalid traffic detection

  • Brand safety compliance

  • Contextual targeting categories

Granularity

The Quantcast connector provides metrics at multiple levels: Account, Campaign, Ad, Creative and Placement Level

Purpose

  • Monitor campaign performance and spend

  • Analyse creative and placement effectiveness

  • Track audience engagement and conversion metrics

  • Evaluate targeting segments and demographic reach

  • Optimise campaigns for better ROI

  • Integrate Quantcast metrics into dashboards and BI platforms

  • Audit campaigns for viewability, fraud, and brand safety

Refresh Cadence:

Data is refreshed daily.

Update Modes:

Append (for data table), Refresh (for metadata)

For more information on this integration, please follow the link here.

Jobs

1. Quantcast Delivery Import

  • Feed: quantcast

  • Status: Active (1)

  • Job Label: Quantcast Delivery Import

  • Lookback: Last 5 days

  • First Run Hour: 4 AM

  • Poll Frequency: Every 24 hours

  • Lookback Window: 0

Targets:

  • Type: data

  • Table: quantcast_data_aggregate

  • Priority: 1

  • Description: Quantcast - Daily

  • Update Mode: append

  • Create Target: true

  • Date Column Name: date

2. Quantcast Ads - Meta Refresh

  • Feed: quantcast

  • Status: Active (1)

  • Job Label: Quantcast Ads - Meta Refresh

  • Lookback: Last 1 day

  • First Run Hour: 7 AM

  • Poll Frequency: Every 24 hours

  • Lookback Window: 0

Targets:

Type

Table

Description

Update Mode

Create Target

lookup

quantcast_meta_accounts

Quantcast - Accounts Meta

refresh

true

lookup

quantcast_meta_campaigns

Quantcast - Campaign Meta

refresh

true

lookup

quantcast_meta_adsets

Quantcast - AdSets Meta

refresh

true

lookup

quantcast_meta_creatives

Quantcast - Creative Meta

refresh

true

Connection Configuration

Key

Required

Description

Hint

quantcast_api_key

Yes

Quantcast API Key

API Key generated by Quantcast

quantcast_api_secret

Yes

Quantcast Secret

Quantcast secret generated with the API Key

quantcast_account_ids

Yes

Quantcast Account IDs

Comma delimited list of account ids

Dimensions

Name

Result Fields

Account [Quantcast]

quantcast_meta_accounts.name

Campaign [Quantcast]

quantcast_meta_campaigns.name

AdSet [Quantcast]

quantcast_meta_adsets.name

Creative [Quantcast]

quantcast_meta_creatives.name

Base Metrics

Name

Formula

Impressions [Quantcast]

SUM({quantcast_data_aggregate.impressions})

Clicks [Quantcast]

SUM({quantcast_data_aggregate.clicks_advanced_ivt})

Spend [Quantcast]

SUM({quantcast_data_aggregate.ad_spend})

Revenue [Quantcast]

SUM({quantcast_data_aggregate.revenue})

Video Completes [Quantcast]

SUM({quantcast_data_aggregate.completed_views})

Results [Quantcast]

SUM({quantcast_data_aggregate.results})

Video 25% View [Quantcast]

SUM({quantcast_data_aggregate.25_pct_completion_rate})

Video 50% View [Quantcast]

SUM({quantcast_data_aggregate.50_pct_completion_rate})

Video 75% View [Quantcast]

SUM({quantcast_data_aggregate.75_pct_completion_rate})

Video 100% View [Quantcast]

SUM({quantcast_data_aggregate.100_pct_completion_rate})

Datasource Joins

LHS Column

RHS Table Column

ad_set_id

quantcast_meta_adsets.id

account_id

quantcast_meta_accounts.id

campaign_id

quantcast_meta_campaigns.id

creative_id

quantcast_meta_creatives.id

Source Table: quantcast_data_aggregate

Composite Metrics

Name

Formula

Round

Prefix /

Suffix

Notes

CTR [Quantcast]

({Clicks [Quantcast]} / {Impressions [Quantcast]}) * 100

2

%

Click-through rate

CPM [Quantcast]

({Spend [Quantcast]} / {Impressions [Quantcast]}) * 1000

2

£

Cost per thousand impressions

CPC [Quantcast]

{Spend [Quantcast]} / {Clicks [Quantcast]}

2

£

Cost per click

VTR [Quantcast]

({Video Completes [Quantcast]} / {Impressions [Quantcast]}) * 100

2

%

View-through rate

CPCV [Quantcast]

{Spend [Quantcast]} / {Video Completes [Quantcast]}

2

£

Cost per completed view

Did this answer your question?