Flashtalking Connector Reference

56 metrics156 dimensions

Fields Options

The Flashtalking connector exposes 212 fields (56 metrics, 156 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Available options

include_closed Include Closed Campaigns

Whether to include closed campaigns.

depth Report Depth

Granularity of report. Default: 'creative'

Possible values (5)

campaignpublisherplacementcreativedefaultversion

Flashtalking Fields

The Flashtalking connector includes 212 fields.

Flashtalking fields (account_id to costperaquisition)

ID	Type	Name	Description
account_id	TEXT	Account ID	Account ID.
account_name	TEXT	Account Name	Account name.
adgapid	TEXT	adGapId	Ad Gap Id
altgifimpressions	TEXT	altGifImpressions	The number of times the backup GIF has been called from the ad server; mostly due to the user not having an HTML5 compatible browser.
averageinteractiontime	NUMERIC	averageInteractionTime	The average time the user has been interacting with the ad.
backupgifclick	NUMERIC	backupGifclick	The number of times the backup GIF has been clicks; mostly due to the user not having an HTML5 compatible browser.
bookedcost	TEXT	bookedCost	Booked costs
broadband	TEXT	broadband	The percentage of users who were on broadband internet connections.
campaign	TEXT	campaign	Coordinated media delivery plan that includes placements or creatives etc
campaignid	TEXT	Campaign ID (duplicate)	ID associated with a Campaign
category	TEXT	Category	Content categories are used to group placements in reports. For example create categories such as ‘Sports’ or ’News’ and ‘Music’.
clicknoscript	NUMERIC	ClickNoScript	A click on an ad where a no script tag was called rather than the script tag.
clicks	NUMERIC	clicks	The total number of times the ad has been clicked on.
clicktag1	NUMERIC	ClickTag1	The number of clicks on the clickTag 1 section of the Flash ad. Maximum of 20 variations.
clicktag10	NUMERIC	ClickTag10	The number of clicks on the clickTag 10 section of the Flash ad. Maximum of 20 variations.
clicktag11	NUMERIC	ClickTag11	The number of clicks on the clickTag 11 section of the Flash ad. Maximum of 20 variations.
clicktag12	NUMERIC	ClickTag12	The number of clicks on the clickTag 12 section of the Flash ad. Maximum of 20 variations.
clicktag13	NUMERIC	ClickTag13	The number of clicks on the clickTag 13 section of the Flash ad. Maximum of 20 variations.
clicktag14	NUMERIC	ClickTag14	The number of clicks on the clickTag 14 section of the Flash ad. Maximum of 20 variations.
clicktag15	NUMERIC	ClickTag15	The number of clicks on the clickTag 15 section of the Flash ad. Maximum of 20 variations.
clicktag16	NUMERIC	ClickTag16	The number of clicks on the clickTag 16 section of the Flash ad. Maximum of 20 variations.
clicktag17	NUMERIC	ClickTag17	The number of clicks on the clickTag 17 section of the Flash ad. Maximum of 20 variations.
clicktag18	NUMERIC	ClickTag18	The number of clicks on the clickTag 18 section of the Flash ad. Maximum of 20 variations.
clicktag19	NUMERIC	ClickTag19	The number of clicks on the clickTag 19 section of the Flash ad. Maximum of 20 variations.
clicktag2	NUMERIC	ClickTag2	The number of clicks on the clickTag 2 section of the Flash ad. Maximum of 20 variations.
clicktag20	NUMERIC	ClickTag20	The number of clicks on the clickTag 20 section of the Flash ad. Maximum of 20 variations.
clicktag3	NUMERIC	ClickTag3	The number of clicks on the clickTag 3 section of the Flash ad. Maximum of 20 variations.
clicktag4	NUMERIC	ClickTag4	The number of clicks on the clickTag 4 section of the Flash ad. Maximum of 20 variations.
clicktag5	NUMERIC	ClickTag5	The number of clicks on the clickTag 5 section of the Flash ad. Maximum of 20 variations.
clicktag6	NUMERIC	ClickTag6	The number of clicks on the clickTag 6 section of the Flash ad. Maximum of 20 variations.
clicktag7	NUMERIC	ClickTag7	The number of clicks on the clickTag 7 section of the Flash ad. Maximum of 20 variations.
clicktag8	NUMERIC	ClickTag8	The number of clicks on the clickTag 8 section of the Flash ad. Maximum of 20 variations.
clicktag9	NUMERIC	ClickTag9	The number of clicks on the clickTag 9 section of the Flash ad. Maximum of 20 variations.
clickthroughrate	PERCENT	clickThroughRate	The number of clicks per impressions. Calculated as clicks/impressions.
combineddeliveredimpressions	NUMERIC	CombinedDeliveredImpressions	Combination of Desktop and Mobile App and Mobile Web Rendered Impressions.
contentcategoryid	TEXT	ContentCategoryID	ID associated with a Content Category
costcapperiod	TEXT	costCapPeriod	The time period a fix cost cap applies to.
costgroupid	TEXT	costGroupID	Identifier assigned by Report Builder to a cost group.
costgroupname	TEXT	costGroupName	A group of two or more placements within a single publisher that are bought as a package.
costperaquisition	NUMERIC	CostPerAquisition	Total Cost/Acquisition

Flashtalking fields (costperclick to mediacostrate)

ID	Type	Name	Description
costperclick	NUMERIC	costPerClick	The count of clicks multiplied by CPC or cost/count of clicks.
creative	TEXT	Creative	The visual advertisement that will be shown to users.
creative_dimensions	TEXT	Creative Dimensions	The size in pixels of the creative asset.
creative_id	TEXT	Creative ID	ID associated with a Creative
creativegroup1	TEXT	creativeGroup1	Collection of related creatives that have been grouped together.
creativegroup1id	TEXT	CreativeGroup1ID	ID associated with Creative Group 1
creativegroup2	TEXT	creativeGroup2	Additional collection of related creatives that have been grouped together.
creativegroup2id	TEXT	CreativeGroup2ID	ID associated with Creative Group 2
creativetype	TEXT	creativeType	The classification of creative asset
data_fetched_at	TIMESTAMP	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.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	Date of performance
day_of_month	TEXT	Day of month	Day of the month
dimensions	TEXT	dimensions	The size in pixels of the creative asset.
emediacostrate	TEXT	eMediaCostRate	Effective Media Cost Rate - the fixed cost calculated CPM (see Cost Cap Period) or applied Media Cost Rate (CPM/CPC).
enddate	DATE	endDate	Placement End Date (inherited from Campaign when absent).
enhancedaveinttime	NUMERIC	enhancedAveIntTime	The average time the user has been interacting with the enhanced ad
enhancedclick	NUMERIC	enhancedClick	The total number of times the enhanced ad has been clicked on.
enhancedctr	NUMERIC	enhancedCTR	The number of clicks per impressions on enhanced ad. Calculated as clicks/impressions.
enhancedimp	TEXT	enhancedImp	The number of times the enhanced ad has been served
enhancedint	NUMERIC	enhancedInt	The number of users who interacted with the enhanced ad
enhancedintrate	NUMERIC	enhancedIntRate	The total number of interactions as a percentage of impressions requested for an enhancement ad
enhancedinttime	TEXT	enhancedIntTime	The total time value of all interactions with enhanced ad
expandclickthroughrate	TEXT	expandClickThroughRate	The number of clicks per impressions on expand ads.
expanddimensions	TEXT	expandDimensions	The size in pixels of the fully expanded creative.
expandrate	TEXT	expandRate	The rate in which an ad is viewed in the expanded state (total number of expands/total impressions).
expandviews	TEXT	expandViews	The number of times ad expand ad was seen by a user while the ad was expanded.
facebookclick	TEXT	facebookClick	Facebook Click
flashtalkingunitcost	TEXT	flashtalkingunitcost	The cost per thousands units if CPM or cost per unit if other buying model
frequency	NUMERIC	frequency	Requested Impressions / Impression Reach
ftcosttype	TEXT	FTCostType	The media cost model for the placement (e.g. CPM or CPC)
fullscreen	TEXT	fullscreen	The number of video creatives that played in fullscreen mode
grouptype	TEXT	groupType	Type of the group
impressionsbooked	TEXT	impressionsBooked	Number of booked impressions
impressionsdelivered	NUMERIC	impressionsDelivered	Number of delivered impressions
interactionrate	NUMERIC	interactionRate	The total number of interactions as a percentage of impressions requested.
interactionsuniquebyimpressions	NUMERIC	interactionsUniqueByImpressions	The number of users who interacted with the ad.
market	TEXT	market	Market
measuredrate	TEXT	measuredRate	The percentage of viewable and non-viewable impressions compared to the number of impressions
mediacostrate	TEXT	mediaCostRate	The rate applied to cost type.

Flashtalking fields (mediacosttotal to strategyid)

ID	Type	Name	Description
mediacosttotal	NUMERIC	MediaCostTotal	The units of media cost type multiplied by media cost rate. For example for CPM (impressions/1000) x Media Cost Rate.
mediacosttype	TEXT	mediacosttype	The cost model applied to media (CPM or CPC or CPA or fixed).
month	TEXT	Month	Number of the month
narrowband	TEXT	narrowband	The percentage of users who were on narrowband internet connections.
natsearchclick	TEXT	natSearchClick	Nat search click
natsearchtponly	TEXT	natsearchtponly	Nat search tp only
netivttotalvidcompletes	TEXT	netIvtTotalVidCompletes	netIvtTotalVidCompletes
netivttotalvidcompletionrate	TEXT	netIvtTotalVidCompletionRate	netIvtTotalVidCompletionRate
netivttotalvidmute	TEXT	netIvtTotalVidMute	netIvtTotalVidMute
netivttotalvidplayed25	TEXT	netIvtTotalVidPlayed25	netIvtTotalVidPlayed25
netivttotalvidplayed50	TEXT	netIvtTotalVidPlayed50	netIvtTotalVidPlayed50
netivttotalvidplayed75	TEXT	netIvtTotalVidPlayed75	netIvtTotalVidPlayed75
netivttotalvidreplays	TEXT	netIvtTotalVidReplays	netIvtTotalVidReplays
netivttotalvidstart	TEXT	netIvtTotalVidStart	netIvtTotalVidStart
netivttotalvidunmute	TEXT	netIvtTotalVidUnmute	netIvtTotalVidUnmute
nonviewablerenderedimp	TEXT	nonViewableRenderedImp	Impressions measured as non-viewable when an ad is not rendered to a browser and less 50% of the pixels in the ad were on an in-focus browser tab on the viewable space of the browser page or they were viewable for less that one continuous second.
noscriptgifimpressions	TEXT	noScriptGifImpressions	The number of times the backup GIF has been called from the ad server due to the user not having JavaScript installed/enabled on their computer.
now	TIMESTAMP	Now	Current timestamp
percentagenonviewable	TEXT	percentageNonViewable	Calculated as ( non-viewable impressions / rendered impressions) x 100
percentageundetermined	TEXT	percentageUndetermined	Calculated as (undetermined served impressions / rendered impressions) x 100 where udetermined impression occurred in an environment where Flashtalking determined that they could not accurately detect the visible status of an ad.
percentageviewable	TEXT	percentageViewable	Calculated as (viewable served impressions / rendered impressions) x 100
placement	TEXT	Placement	An object that contains tags and represents a unit of available ad space on a web page.
placement_id	TEXT	Placement ID	ID associated with a Placement
richaveinttime	NUMERIC	richAveIntTime	The average time the user has been interacting with the rich media ad
richclick	NUMERIC	richClick	The total number of times the rich media ad has been clicked on.
richctr	NUMERIC	richCTR	The number of clicks per impressions on rich media ad. Calculated as clicks/impressions.
richimp	TEXT	richImp	The number of times the rich media ad has been served
richint	NUMERIC	richInt	The number of users who interacted with the rich media ad
richintrate	NUMERIC	richIntRate	The total number of interactions as a percentage of impressions requested for an rich media ad
richinttime	TEXT	richIntTime	The total time value of all interactions with rich media ad
site	TEXT	Site	Publisher or ad network or website or SSP which provides inventory space where media can be bought.
siteid	TEXT	siteId	siteId
soundon	TEXT	soundOn	The number of users who clicked on the sound on button.
source	TEXT	Source	The name of the Windsor connector returning the row
standardclick	NUMERIC	standardClick	The total number of times the standard ad has been clicked on.
standardctr	NUMERIC	standardCTR	The number of clicks per impressions on standard ad. Calculated as clicks/impressions.
standardimp	TEXT	standardImp	The number of times the standard ad has been served
startdate	DATE	startDate	Placement Start Date (inherited from Campaign when absent).
strategy	TEXT	Strategy	Strategies are used to group placements in reports. They are typically used to describe marketing approaches for each placement. For example ‘10 percent discount’ or ‘Free shipping’ and ‘Free Trial Membership.
strategyid	TEXT	StrategyID	ID associated with a Strategy

Flashtalking fields (thirdpartyidcreative to vid5played25)

ID	Type	Name	Description
thirdpartyidcreative	TEXT	ThirdPartyIDCreative	In ad server there is a free form name for Third Party IDS (dimension name).
thirdpartyidplacement	TEXT	ThirdPartyIdPlacement	Identifier for a placement created by a third party.
today	DATE	Today	Today's date
totalcost	NUMERIC	totalCost	The combination of media total cost and FT Cost.
totalinteractiontime	NUMERIC	totalInteractionTime	The total time value of all interactions.
undetermined	TEXT	undetermined	Undetermined Impressions occurred in an environment where Flashtalking determined that they could not accurately detect the visible status of an ad.
uniqueuserclicks	NUMERIC	uniqueUserClicks	The number of unique users who clicked the ad.
uniqueuserclickthroughrate	PERCENT	uniqueuserClickthroughRate	Unique users click through rate
uniqueusers	TEXT	uniqueUsers	The number of unique users
vid1average	TEXT	vid1Average	The average percentage of the video 1 that has been viewed.
vid1played100	TEXT	vid1Played100	The number of times video 1 is viewed to completion.
vid1played25	TEXT	vid1Played25	The number of times video 1 is viewed to 25% completion.
vid1played50	TEXT	vid1Played50	The number of times video 1 is viewed to 50% completion.
vid1played75	TEXT	vid1Played75	The number of times video 1 is viewed to 75% completion.
vid1replay	TEXT	vid1Replay	The number of users who replayed the video 1.
vid1start	TEXT	vid1Start	The number of users the video 1 began to play for.
vid2average	TEXT	vid2Average	The average percentage of the video 2 that has been viewed.
vid2played100	TEXT	vid2Played100	The number of times video 2 is viewed to completion.
vid2played25	TEXT	vid2Played25	The number of times video 2 is viewed to 25% completion.
vid2played50	TEXT	vid2Played50	The number of times video 2 is viewed to 50% completion.
vid2played75	TEXT	vid2Played75	The number of times video 2 is viewed to 75% completion.
vid2replay	TEXT	vid2Replay	The number of users who replayed the video 2.
vid2start	TEXT	vid2Start	The number of users the video 2 began to play for.
vid3average	TEXT	vid3Average	The average percentage of the video 3 that has been viewed.
vid3played100	TEXT	vid3Played100	The number of times video 3 is viewed to completion.
vid3played25	TEXT	vid3Played25	The number of times video 3 is viewed to 25% completion.
vid3played50	TEXT	vid3Played50	The number of times video 3 is viewed to 50% completion.
vid3played75	TEXT	vid3Played75	The number of times video 3 is viewed to 75% completion.
vid3replay	TEXT	vid3Replay	The number of users who replayed the video 3.
vid3start	TEXT	vid3Start	The number of users the video 3 began to play for.
vid4average	TEXT	vid4Average	The average percentage of the video 4 that has been viewed.
vid4played100	TEXT	vid4Played100	The number of times video 4 is viewed to completion.
vid4played25	TEXT	vid4Played25	The number of times video 4 is viewed to 25% completion.
vid4played50	TEXT	vid4Played50	The number of times video 4 is viewed to 50% completion.
vid4played75	TEXT	vid4Played75	The number of times video 4 is viewed to 75% completion.
vid4replay	TEXT	vid4Replay	The number of users who replayed the video 4.
vid4start	TEXT	vid4Start	The number of users the video 4 began to play for.
vid5average	TEXT	vid5Average	The average percentage of the video 5 that has been viewed.
vid5played100	TEXT	vid5Played100	The number of times video 5 is viewed to completion.
vid5played25	TEXT	vid5Played25	The number of times video 5 is viewed to 25% completion.

Flashtalking fields (vid5played50 to viewableimpressions)

ID	Type	Name	Description
vid5played50	TEXT	vid5Played50	The number of times video 5 is viewed to 50% completion.
vid5played75	TEXT	vid5Played75	The number of times video 5 is viewed to 75% completion.
vid5replay	TEXT	vid5Replay	The number of users who replayed the video 5.
vid5start	TEXT	vid5Start	The number of users the video 5 began to play for.
vid6average	TEXT	vid6Average	The average percentage of the video 6 that has been viewed.
vid6played100	TEXT	vid6Played100	The number of times video 6 is viewed to completion.
vid6played25	TEXT	vid6Played25	The number of times video 6 is viewed to 25% completion.
vid6played50	TEXT	vid6Played50	The number of times video 6 is viewed to 50% completion.
vid6played75	TEXT	vid6Played75	The number of times video 6 is viewed to 75% completion.
vid6replay	TEXT	vid6Replay	The number of users who replayed the video 6.
vid6start	TEXT	vid6Start	The number of users the video 6 began to play for.
vid7average	TEXT	vid7Average	The average percentage of the video 7 that has been viewed.
vid7played100	TEXT	vid7Played100	The number of times video 7 is viewed to completion.
vid7played25	TEXT	vid7Played25	The number of times video 7 is viewed to 25% completion.
vid7played50	TEXT	vid7Played50	The number of times video 7 is viewed to 50% completion.
vid7played75	TEXT	vid7Played75	The number of times video 7 is viewed to 75% completion.
vid7replay	TEXT	vid7Replay	The number of users who replayed the video 7.
vid7start	TEXT	vid7Start	The number of users the video 7 began to play for.
vid8average	TEXT	vid8Average	The average percentage of the video 8 that has been viewed.
vid8played100	TEXT	vid8Played100	The number of times video 8 is viewed to completion.
vid8played25	TEXT	vid8Played25	The number of times video 8 is viewed to 25% completion.
vid8played50	TEXT	vid8Played50	The number of times video 8 is viewed to 50% completion.
vid8played75	TEXT	vid8Played75	The number of times video 8 is viewed to 75% completion.
vid8replay	TEXT	vid8Replay	The number of users who replayed the video 8.
vid8start	TEXT	vid8Start	The number of users the video 8 began to play for.
vid9average	TEXT	vid9Average	The average percentage of the video 9 that has been viewed.
vid9played100	TEXT	vid9Played100	The number of times video 9 is viewed to completion.
vid9played25	TEXT	vid9Played25	The number of times video 9 is viewed to 25% completion.
vid9played50	TEXT	vid9Played50	The number of times video 9 is viewed to 50% completion.
vid9played75	TEXT	vid9Played75	The number of times video 9 is viewed to 75% completion.
vid9replay	NUMERIC	vid9Replay	The number of users who replayed the video 9.
vid9start	TEXT	vid9Start	The number of users the video 9 began to play for.
videoaveinttime	NUMERIC	videoAveIntTime	The average time the user has been interacting with the video ad
videoclick	NUMERIC	videoClick	The total number of times the video ad has been clicked on.
videoctr	NUMERIC	videoCTR	The number of clicks per impressions on video ad.
videoimp	NUMERIC	videoImp	The number of times the video ad has been served
videoint	NUMERIC	videoInt	The number of users who interacted with the video ad
videointrate	NUMERIC	videoIntRate	The total number of interactions as a percentage of impressions requested for an video ad
videointtime	TEXT	videoIntTime	The total time value of all interactions with video ad
viewableimpressions	TEXT	viewableImpressions	Viewable Impressions measured as viewable when an advertisement is rendered to a browser and greater than or equal to 50% of the pixels in the advertisement were on an in-focus browser tab on the viewable space of the browser page for at least one continuous second.

Flashtalking fields (viewablerate to year_week_iso)

ID	Type	Name	Description
viewablerate	TEXT	viewableRate	The percentage of ads served that were actually seen by a user. Calculated as (Viewable Impressions / (Viewable Impressions + Non-Viewable Impressions)
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).
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

API Connectors