Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Basis DSP data to
Basis DSP Connector Reference
65 metrics32 dimensions
https://connectors.windsor.ai/basis_dsp?api_key=[your API key]&date_preset=last_7d&fields=date,campaign,campaign_name,campaign_id,campaign_group_id,campaign_group_name,brand_id,brand_name,eligible_impressions,clicks,gross_total_effective_cpcv,total_spend
The Basis DSP connector exposes 97 fields (65 metrics, 32 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Basis DSP Fields
The Basis DSP connector includes 97 fields.
Basis DSP fields (advertiser_spend to gross_total_effective_cpa)
| ID | Type | Name | Description |
|---|---|---|---|
| advertiser_spend | NUMERIC | Advertiser Spend | Total advertiser spend for the campaign group or campaign. |
| auctions_bid | NUMERIC | Auctions Bid | Number of auctions that the campaign bid on. |
| auctions_won | NUMERIC | Auctions Won | The number of auctions the campaign won. |
| brand_archived | BOOLEAN | Brand Archived | Indicates if the brand is archived. |
| brand_id | TEXT | Brand ID | A unique brand ID is automatically assigned when you create a brand. |
| brand_landing_page_domain | TEXT | Brand Landing Page Domain | The landing page domain is the domain name of the advertiser's website. |
| brand_name | TEXT | Brand Name | The name of the brand, up to 255 characters long. |
| brand_notes | TEXT | Brand Notes | Optional notes about the brand. |
| campaign | TEXT | Campaign | The Campaign Name |
| campaign_group_id | TEXT | Campaign Group ID | A unique group ID is automatically assigned when you create a group. |
| campaign_group_name | TEXT | Campaign Group Name | The name of the group. |
| campaign_group_notes | TEXT | Campaign Group Notes | A descriptive string for the group |
| campaign_id | TEXT | Campaign ID | A unique campaign ID is automatically assigned when you create a campaign. |
| campaign_name | TEXT | Campaign Name | The name of the campaign. |
| campaign_notes | TEXT | Campaign Notes | Notes about the campaign. |
| campaign_status | TEXT | Campaign Status | The campaign's status. Valid Values: online, offline, archived |
| click_cvr | NUMERIC | Click Cvr | conversions/impressionsWon |
| click_effective_cpa | NUMERIC | Click Effective CPA | Cost per click-through conversion: totalSpend/clickthruConversions |
| click_rpm | NUMERIC | Click RPM | ctcRevenue/(impressionsWon/1000) |
| clicks | NUMERIC | Clicks | The number of advertisement clicks. |
| clickthru_conversions | NUMERIC | Clickthru Conversions | The number of click-through conversions. |
| clickthru_rate | NUMERIC | Clickthru Rate | Click-through rate (CTR): clicks/impressionsWon |
| companion_clicks | NUMERIC | Companion Clicks | The number of clicks that were recorded for companion ads. See Companion Ads for details. |
| companion_conversions | NUMERIC | Companion Conversions | The number of conversions that were recorded for companion ads. See Companion Ads for details. |
| companion_impressions | NUMERIC | Companion Impressions | The number of impressions that were recorded for companion ads. See Companion Ads for details. |
| companion_offer_revenue | NUMERIC | Companion Offer Revenue | Revenue from companion ad click-through conversions. |
| ctc_revenue | NUMERIC | CTC Revenue | Click-through revenue: revenue associated with click-through conversions. |
| data_effective_cpm | NUMERIC | Data Effective CPM | Effective Cost Per Mille (CPM) for demographic data: dataSpend/(impressionsWon/1000) |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | |
| data_spend | NUMERIC | Data Spend | The amount that the campaign spent on demographic data. |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
| date | DATE | Date | The Date |
| day_of_month | TEXT | Day of month | Day of the month |
| effective_cpa_on_advertiser_spend | NUMERIC | Effective CPA On Advertiser Spend | The advertiser spend effective cost per conversion, the average cost to the advertiser for each conversion. |
| effective_cpc_on_advertiser_spend | NUMERIC | Effective CPC On Advertiser Spend | The advertiser spend effective cost per click, the average cost to the advertiser for each click. |
| effective_cpcv_on_advertiser_spend | NUMERIC | Effective CPCV On Advertiser Spend | The advertiser spend cost per completed view (video). Calculated for video impressions only. |
| effective_cpm | NUMERIC | Effective CPM | Effective Cost Per Mille (CPM), the average cost per 1000 impressions: totalSpend/(auctionsWon/1000) |
| effective_cpm_on_advertiser_spend | NUMERIC | Effective CPM On Advertiser Spend | The advertiser spend effective cost per mille, the average cost to the advertiser for 1000 impressions. |
| eligible_impressions | NUMERIC | Eligible Impressions | The number of impressions on which the DSP enabled viewability measurements. |
| gross_total_effective_cpa | NUMERIC | Gross Total Effective CPA | Gross total cost per acquisition: (totalSpend+nonBillableSpend)/(clickthruConversions+ viewthruConversions) |
Basis DSP fields (gross_total_effective_cpc to view_effective_cpa)
| ID | Type | Name | Description |
|---|---|---|---|
| gross_total_effective_cpc | NUMERIC | Gross Total Effective CPC | Gross total effective cost per click: (totalSpend+nonBillableSpend)/clicks |
| gross_total_effective_cpcv | NUMERIC | Gross Total Effective CPCV | Gross total effective cost per completed view: (totalSpend+nonBillableSpend)/ campaignStats.getVideoCompleted() |
| gross_total_effective_cpm | NUMERIC | Gross Total Effective CPM | Gross total effective cost per mille: ((totalSpend+nonBillableSpend) / campaignStats.getImpressionsWon())*1000.0 |
| impressions_won | NUMERIC | Impressions Won | Number of impressions that the campaign won. This value will be the same as auctionsWon except in cases where an auction might result in multiple impressions, such as digital out-of-home (DOOH). |
| margin_on_advertiser_spend | NUMERIC | Margin On Advertiser Spend | Your margin on advertiser spend. |
| measured_impressions | NUMERIC | Measured Impressions | The number of impressions, out of the eligible impressions, on which the viewability was able to successfully determined. This includes all viewable impressions and all impressions that were determined to be not viewable. |
| measured_rate | NUMERIC | Measured Rate | measuredImpressions/eligibleImpressions |
| media_spend | NUMERIC | Media Spend | The amount that the campaign spent on auctions. |
| month | TEXT | Month | Number of the month |
| now | Now | Current timestamp | |
| offer_clicks | NUMERIC | Offer Clicks | The number of offer (also known as secondary) clicks. |
| offer_clickthru_rate | NUMERIC | Offer Clickthru Rate | Click-through rate (CTR) for offer clicks: offerClicks/impressionsWon |
| primary_click_effective_cpa | NUMERIC | Primary Click Effective CPA | Cost per primary click-through conversion: totalSpend/primaryClickthruConversions |
| primary_clickthru_conversions | NUMERIC | Primary Clickthru Conversions | Primary click-through conversions: primary conversions recorded after a user clicked an ad in the campaign. |
| primary_cost_per_acquisition | NUMERIC | Primary Cost Per Acquisition | Cost per primary conversion: totalSpend/totalPrimaryConversions |
| primary_effective_cpa_on_advertiser_spend | NUMERIC | Primary Effective CPA On Advertiser Spend | Advertiser spend cost per primary click-through conversion: (advertiserSpend)/primaryClickthruConversions |
| primary_viewthru_conversions | NUMERIC | Primary Viewthru Conversions | Primary view-through conversions: primary conversions recorded after a user saw an ad from the campaign but did not click through. |
| return_on_ad_spend | NUMERIC | Return On Ad Spend | (ctcRevenue+vtcRevenue)/(totalSpend) |
| revenue | NUMERIC | Revenue | Revenue associated with all conversions: ctcRevenue+vtcRevenue |
| revenue_per_mille | NUMERIC | Revenue Per Mille | Revenue per 1000 impressions (RPM): (ctcRevenue+vtcRevenue)/{impressionsWon/1000) |
| source | TEXT | Source | The name of the Windsor connector returning the row |
| today | DATE | Today | Today's date |
| total_conversions | NUMERIC | Total Conversions | All click-through and view-through conversions added together. |
| total_cvr | NUMERIC | Total CVR | (conversions+viewthruConversions)/(auctionsWon/1000) |
| total_effective_cpa | NUMERIC | Total Effective CPA | Effective cost per acquisition (eCPA): totalSpend/clickthruConversions + viewthruConversions |
| total_effective_cpc | NUMERIC | Total Effective CPC | Cost per click (eCPC): totalSpend/clicks |
| total_effective_cpcv | NUMERIC | Total Effective CPCV | Total effective cost per completed view (video only): totalSpend/videoCompleted |
| total_effective_cpm | NUMERIC | Total Effective CPM | Total effective Cost Per Mille (CPM), equal to: effectiveCPM+dataEffectiveCPM |
| total_primary_conversions | NUMERIC | Total Primary Conversions | Primary conversions: All primary click-through and primary view-through conversions added together: primaryClickthruConversions+ primaryViewthruConversions |
| total_spend | NUMERIC | Total Spend | Total amount that the campaign spent, equal to: auctionsSpend+dataSpend |
| video_completed | NUMERIC | Video Completed | The number of completed video plays. |
| video_completion_rate | NUMERIC | Video Completion Rate | videoCompleted/videoStarted |
| video_first_quartile_reached | NUMERIC | Video First Quartile Reached | The number of video plays through the first 25%. |
| video_midpoint_reached | NUMERIC | Video Midpoint Reached | The number of video plays through the first 50%. |
| video_skipped | NUMERIC | Video Skipped | The number of videos that were skipped after starting. |
| video_skipped_rate | NUMERIC | Video Skipped Rate | videoSkipped/videoStarted |
| video_started | NUMERIC | Video Started | The number of video starts. |
| video_third_quartile_reached | NUMERIC | Video Third Quartile Reached | The number of video plays through the first 75%. |
| view_cvr | NUMERIC | View Cvr | viewthruConversions/impressionsWon |
| view_effective_cpa | NUMERIC | View Effective CPA | Cost per view-through conversion: totalSpend/viewthruConversions |
Basis DSP fields (viewability_spend to year_week_iso)
| ID | Type | Name | Description |
|---|---|---|---|
| viewability_spend | NUMERIC | Viewability Spend | The spend on viewable impressions. |
| viewable_impressions | NUMERIC | Viewable Impressions (Basis DSP) | The number of impressions that were viewable. |
| viewable_rate | NUMERIC | Viewable Rate | viewableImpressions/measuredImpressions |
| viewthru_conversions | NUMERIC | Viewthru Conversions | The number of view-through conversions. |
| vtc_revenue | NUMERIC | VTC Revenue | View-through revenue: revenue associated with view-through conversions |
| week | TEXT | Week | Week (Sun-Sat). |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). |
| win_rate | NUMERIC | Win Rate | auctionsWon/auctionsBid |
| year | TEXT | Year | Year |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |