Overview
This connector ingests Amazon DSP campaign delivery and metadata via the Amazon Ads V3 API.
Granularity: Campaign → Ad → Creative level
Purpose: Track delivery (impressions, clicks, video views) and enrich with advertiser, campaign, ad group, and creative metadata
Refresh Cadence: Daily
Update Modes: Append (for data), Refresh (for metadata)
For more information on the Amazon DSP integration please follow this link
🔌 Connection Setup
Key | Description | Required | Type |
amazon_client_id | Amazon Ads API Client ID | Yes | Hidden |
amazon_client_secret | Amazon Ads API Client Secret | Yes | Hidden |
amazon_profile_id | Amazon Ads Profile ID | Yes | Text |
amazon_advertisers | Comma-separated list of Advertiser IDs | Yes | Text |
🔄 Jobs & Scheduling
1. Amazon DSP Delivery Data Job
Setting | Value |
Feed |
|
Job Label | Amazon Ads V3 - Data Delivery |
Table |
|
Type | Data |
Description | Amazon Ads - Delivery Data |
Update Mode | Append |
Create Target | True |
Date Column |
|
Lookback | 5 days |
First Run Hour | 05:00 UTC |
Poll Frequency | 24 hours |
Options (Target):
Key | Value | Description |
skip_clean_source_file | true | Skip clean-up |
fields_escaped_by | "\" | Field escape char |
amazon_dsp_report_type | dspCampaign | Report type: Campaign-level |
amazon_dsp_group_by | campaign,ad,creative | Grouping granularity |
2. Amazon DSP Metadata Job
Setting | Value |
Feed |
|
Job Label | Amazon Ads V3 - Meta Import |
Type | Lookup (multiple targets) |
Lookback | 1 day |
First Run Hour | 02:00 UTC |
Poll Frequency | 24 hours |
Update Mode | Refresh |
Create Targets | True |
Metadata Tables Created:
Table Name | Description |
| Advertiser info |
| Campaign-level metadata |
| Ad Group metadata |
| Creative metadata |
🗃️ Tables & Fields
Data Table: amazon_data_campaign
Field | Description |
advertiserId | ID of the advertiser |
orderId | Campaign/Order ID |
lineItemId | Line Item / Ad Group ID |
creativeId | Creative ID |
date | Date of delivery metrics |
totalCost | Spend amount |
clicks | Number of clicks |
impressions | Number of impressions |
viewableImpressions | Viewable impressions |
measurableImpressions | Measurable impressions |
videoAdStart | Video starts |
videoAdFirstQuartile | 25% viewed |
videoAdMidpoint | 50% viewed |
videoAdThirdQuartile | 75% viewed |
videoAdComplete | 100% completed views |
Metadata Tables
amazon_meta_advertiser
Field | Description |
dspAdvertiserId | Advertiser ID |
accountName | Account name |
country | Advertiser country |
amazon_meta_campaign
Field | Description |
campaignId | Order/Campaign ID |
name | Campaign name |
amazon_meta_adgroup
Field | Description |
adGroupId | Line item ID |
name | Ad group name |
amazon_meta_creative
Field | Description |
adCreativeId | Creative ID |
name | Creative name |
adCreativeFormatProperties_adCreativeFormatType | Format type (e.g. video, display) |
🔗 Joins / Relationships
The following joins are used to enrich amazon_data_campaign with metadata:
Data Field | Lookup Table | Join To Field |
advertiserId | amazon_meta_advertiser | dspAdvertiserId |
orderId | amazon_meta_campaign | campaignId |
lineItemId | amazon_meta_adgroup | adGroupId |
creativeId | amazon_meta_creative | adCreativeId |
📐 Dimensions
Dimension Name | Source Field |
Account Name [Amazon] | amazon_meta_advertiser.accountName |
Advertiser Country [Amazon] | amazon_meta_advertiser.country |
Order Name [Amazon] | amazon_meta_campaign.name |
Line Item Name [Amazon] | amazon_meta_adgroup.name |
Creative Name [Amazon] | amazon_meta_creative.name |
Creative Format Type [Amazon] | amazon_meta_creative. adCreativeFormatProperties_adCreativeFormatType |
📊 Base Metrics
Metric Name | Formula | Description |
Spend [Amazon] | SUM(totalCost) | Total spend |
Clicks [Amazon] | SUM(clicks) | Total clicks |
Impressions [Amazon] | SUM(impressions) | Total impressions |
Viewable Impressions [Amazon] | SUM(viewableImpressions) | Viewable impressions |
Measure Impressions [Amazon] | SUM(measurableImpressions) | Measurable impressions |
Video Starts [Amazon] | SUM(videoAdStart) | Video ad starts |
Video Views First Quartile [Amazon] | SUM(videoAdFirstQuartile) | 25% view completion |
Video Views Mid Point [Amazon] | SUM(videoAdMidpoint) | 50% view completion |
Video Views Third Quartile [Amazon] | SUM(videoAdThirdQuartile) | 75% view completion |
Video Completes [Amazon] | SUM(videoAdComplete) | Full video views |
📈 Composite Metrics
Name | Formula |
CPC [Amazon] | Spend / Clicks |
CPM [Amazon] | Spend / Impressions × 1000 |
CTR [Amazon] | Clicks / Impressions × 1000 |
CPV [Amazon] | Spend / Video Starts |
CPCV [Amazon] | Spend / Video Completes |
VCR [Amazon] | Video Completes / Video Starts × 100 |
VTR [Amazon] | Video Completes / Impressions × 100 |
⏱️ Summary of Scheduling
Job Type | Tables | Frequency | First Run (UTC) | Lookback |
Data | amazon_data_campaign | Daily | 05:00 | 5 days |
Meta | 4 meta tables | Daily | 02:00 | 1 day |
✅ Summary
The Amazon DSP (V3) connector provides structured campaign performance and metadata ingestion for reporting on spend, impressions, clicks, and video views. It supports granular breakdowns by advertiser, campaign, ad group, and creative. The connector uses a reliable append + refresh strategy with clear join logic for enrichment. Ideal for building media performance dashboards and cost-based optimization reporting in Amazon DSP.