## The table below gives information about all the data fields that you can import to Adriel from Flashtalking.

Field API name |
Data Type |
Description |
Use in Adriel |
---|---|---|---|

Category |
string |
Content categories are used to group placements in reports. For example create categories such as ‘Sports’ or ’News’ and ‘Music’. |
dimension |

ClickNoScript |
long |
A click on an ad where a no script tag was called rather than the script tag. |
metric |

ClickTag1 |
long |
The number of clicks on the clickTag 1 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag10 |
long |
The number of clicks on the clickTag 10 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag11 |
long |
The number of clicks on the clickTag 11 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag12 |
long |
The number of clicks on the clickTag 12 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag13 |
long |
The number of clicks on the clickTag 13 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag14 |
long |
The number of clicks on the clickTag 14 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag15 |
long |
The number of clicks on the clickTag 15 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag16 |
long |
The number of clicks on the clickTag 16 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag17 |
long |
The number of clicks on the clickTag 17 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag18 |
long |
The number of clicks on the clickTag 18 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag19 |
long |
The number of clicks on the clickTag 19 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag2 |
long |
The number of clicks on the clickTag 2 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag20 |
long |
The number of clicks on the clickTag 20 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag3 |
long |
The number of clicks on the clickTag 3 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag4 |
long |
The number of clicks on the clickTag 4 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag5 |
long |
The number of clicks on the clickTag 5 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag6 |
long |
The number of clicks on the clickTag 6 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag7 |
long |
The number of clicks on the clickTag 7 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag8 |
long |
The number of clicks on the clickTag 8 section of the Flash ad. Maximum of 20 variations. |
metric |

ClickTag9 |
long |
The number of clicks on the clickTag 9 section of the Flash ad. Maximum of 20 variations. |
metric |

CombinedDeliveredImpressions |
long |
Combination of Desktop and Mobile App and Mobile Web Rendered Impressions. |
metric |

ContentCategoryID |
string |
ID associated with a Content Category |
dimension |

CostPerAquisition |
float |
Total Cost/Acquisition |
metric |

CreativeDimensions |
string |
The size in pixels of the creative asset. |
dimension |

CreativeGroup1ID |
string |
ID associated with Creative Group 1 |
dimension |

CreativeGroup2ID |
string |
ID associated with Creative Group 2 |
dimension |

FTCostType |
string |
The media cost model for the placement (e.g. CPM or CPC) |
dimension |

MediaCostTotal |
float |
The units of media cost type multiplied by media cost rate. For example for CPM (impressions/1000) x Media Cost Rate. |
metric |

PlacementId |
string |
ID associated with a Placement |
dimension |

Strategy |
string |
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. |
dimension |

StrategyID |
string |
ID associated with a Strategy |
dimension |

ThirdPartyIDCreative |
string |
In ad server there is a free form name for Third Party IDS (dimension name). |
dimension |

ThirdPartyIdPlacement |
string |
Identifier for a placement created by a third party. |
dimension |

TotalConversionValue |
long |
Total value captured as a passed value against the selected spotlights |
metric |

TotalConversionValuefromclicks |
long |
Total value captured as a passed value against the selected spotlights following a click attributed event |
metric |

TotalConversionValuefromviews |
long |
Total value captured as a passed value against the selected spotlights following a view attributed event |
metric |

TotalSpotRatefromclicks |
float |
Calculated as (Total Spotlights (from clicks)/ Requested Impressions) * 100 |
metric |

TotalSpotRatefromviews |
float |
Calculates as (Total Spotlights (from views)/ Requested Impressions) * 100 |
metric |

TotalSpotlightRate |
float |
Calculated as (Total Spotlights/ Requested Impressions) * 100 |
metric |

TotalSpotlights |
long |
The number of individual last touch attributed users that have reached any of the targeted spotlight pages. |
metric |

TotalSpotlightsfromclicks |
long |
The number of individual last touch attributed users that have reached any of the targeted spotlight pages following a click |
metric |

TotalSpotlightsfromviews |
long |
The number of individual last touch attributed users that have reached any of the targeted spotlight pages following an impression with no click |
metric |

U1 |
string |
U1 |
dimension |

U2 |
string |
U2 |
dimension |

adGapId |
string |
Ad Gap Id |
dimension |

altGifImpressions |
long |
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. |
metric |

averageInteractionTime |
float |
The average time the user has been interacting with the ad. |
metric |

backupGifclick |
long |
The number of times the backup GIF has been clicks; mostly due to the user not having an HTML5 compatible browser. |
metric |

bookedCost |
long |
Booked costs |
metric |

broadband |
float |
The percentage of users who were on broadband internet connections. |
metric |

browser |
string |
Browser the conversion occured in |
dimension |

campaign |
string |
Coordinated media delivery plan that includes placements or creatives etc |
dimension |

campaignID |
string |
ID associated with a Campaign |
dimension |

city_code |
string |
City Code |
dimension |

clickThroughRate |
float |
The number of clicks per impressions. Calculated as clicks/impressions. |
metric |

clickViewDate |
string |
Date the attributed click or view was served on |
dimension |

clickViewHour |
string |
Hour within the day the attributed click or view was served at |
dimension |

clicks |
long |
The total number of times the ad has been clicked on. |
metric |

clientID |
string |
ID of the client |
dimension |

clientName |
string |
Name of the client |
dimension |

configID |
string |
Configuration ID |
dimension |

configuration |
string |
Configuration is one of the default names |
dimension |

conversionType |
string |
Event associated with conversion either click or impression |
dimension |

costCapPeriod |
string |
The time period a fix cost cap applies to. |
dimension |

costGroupID |
string |
Identifier assigned by Report Builder to a cost group. |
dimension |

costGroupName |
string |
A group of two or more placements within a single publisher that are bought as a package. |
dimension |

costPerClick |
float |
The count of clicks multiplied by CPC or cost/count of clicks. |
metric |

country_code |
string |
Country code |
dimension |

creative |
string |
The visual advertisement that will be shown to users. |
dimension |

creativeGroup1 |
string |
Collection of related creatives that have been grouped together. |
dimension |

creativeGroup2 |
string |
Additional collection of related creatives that have been grouped together. |
dimension |

creativeID |
string |
ID associated with a Creative |
dimension |

creativeType |
string |
The classification of creative asset |
dimension |

currency |
string |
The monetary unit used to buy or sell media (ex. USD or EUR or etc.) |
dimension |

date |
string |
Date of performance |
dimension |

dimensions |
string |
The size in pixels of the creative asset. |
dimension |

eMediaCostRate |
float |
Effective Media Cost Rate - the fixed cost calculated CPM (see Cost Cap Period) or applied Media Cost Rate (CPM/CPC). |
metric |

endDate |
string |
Placement End Date (inherited from Campaign when absent). |
dimension |

enhancedAveIntTime |
float |
The average time the user has been interacting with the enhanced ad |
metric |

enhancedCTR |
float |
The number of clicks per impressions on enhanced ad. Calculated as clicks/impressions. |
metric |

enhancedClick |
long |
The total number of times the enhanced ad has been clicked on. |
metric |

enhancedImp |
long |
The number of times the enhanced ad has been served |
metric |

enhancedInt |
long |
The number of users who interacted with the enhanced ad |
metric |

enhancedIntRate |
float |
The total number of interactions as a percentage of impressions requested for an enhancement ad |
metric |

enhancedIntTime |
long |
The total time value of all interactions with enhanced ad |
metric |

expandClickThroughRate |
float |
The number of clicks per impressions on expand ads. |
metric |

expandDimensions |
string |
The size in pixels of the fully expanded creative. |
dimension |

expandRate |
float |
The rate in which an ad is viewed in the expanded state (total number of expands/total impressions). |
metric |

expandViews |
long |
The number of times ad expand ad was seen by a user while the ad was expanded. |
metric |

facebookClick |
long |
Facebook Click |
metric |

flashtalkingunitcost |
float |
The cost per thousands units if CPM or cost per unit if other buying model |
metric |

frequency |
float |
Requested Impressions / Impression Reach |
metric |

ft_custom |
string |
Custom |
dimension |

ft_section |
string |
Section |
dimension |

fullscreen |
long |
The number of video creatives that played in fullscreen mode |
metric |

geoMatch |
string |
Geo match |
dimension |

geoProximityMatch |
string |
Geo proximity match |
dimension |

goalimp |
long |
Goal Impressions |
metric |

goalrate |
float |
Goal Rate |
metric |

goalvalue |
long |
Goal Value |
metric |

groupType |
string |
Type of the group |
dimension |

guid |
string |
Unique identifier of user |
dimension |

impressionsBooked |
long |
Number of booked impressions |
metric |

impressionsDelivered |
long |
Number of delivered impressions |
metric |

interactionRate |
float |
The total number of interactions as a percentage of impressions requested. |
metric |

interactionsUniqueByImpressions |
long |
The number of users who interacted with the ad. |
metric |

ispMatch |
string |
Isp match |
dimension |

itemname |
string |
Name of item |
dimension |

keyword |
string |
Keyword |
dimension |

keywordMatch |
string |
Keyword match |
dimension |

market |
string |
Market |
dimension |

measuredRate |
float |
The percentage of viewable and non-viewable impressions compared to the number of impressions |
metric |

mediaCostRate |
float |
The rate applied to cost type. |
metric |

mediacosttype |
string |
The cost model applied to media (CPM or CPC or CPA or fixed). |
dimension |

metro_code |
string |
Metro Code |
dimension |

metro_name |
string |
Metro ID |
dimension |

narrowband |
float |
The percentage of users who were on narrowband internet connections. |
metric |

natSearchClick |
long |
Nat search click |
metric |

natsearchtponly |
long |
Nat search tp only |
metric |

noScriptGifImpressions |
long |
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. |
metric |

nonViewableRenderedImp |
long |
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. |
metric |

os |
string |
Operating System the Conversion occured on |
dimension |

percentageNonViewable |
float |
Calculated as ( non-viewable impressions / rendered impressions) x 100 |
metric |

percentageUndetermined |
float |
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. |
metric |

percentageViewable |
float |
Calculated as (viewable served impressions / rendered impressions) x 100 |
metric |

placement |
string |
An object that contains tags and represents a unit of available ad space on a web page. |
dimension |

profitPerThousandImpressions |
float |
ROI / (Impressions/1000) |
metric |

retargetingMatch |
string |
Retargeting match |
dimension |

richAveIntTime |
float |
The average time the user has been interacting with the rich media ad |
metric |

richCTR |
float |
The number of clicks per impressions on rich media ad. Calculated as clicks/impressions. |
metric |

richClick |
long |
The total number of times the rich media ad has been clicked on. |
metric |

richImp |
long |
The number of times the rich media ad has been served |
metric |

richInt |
long |
The number of users who interacted with the rich media ad |
metric |

richIntRate |
float |
The total number of interactions as a percentage of impressions requested for an rich media ad |
metric |

richIntTime |
long |
The total time value of all interactions with rich media ad |
metric |

salesHour |
string |
Hour of Day the Sale occured at |
dimension |

salesTimestamp |
string |
Time The sale occured at |
dimension |

salesType |
string |
Type of sales |
dimension |

salesValue |
float |
The sales value of the order as provided by the advertiser on confirmation page |
metric |

site |
string |
Publisher or ad network or website or SSP which provides inventory space where media can be bought. |
dimension |

siteID |
string |
ID associated with a Site |
dimension |

soundOn |
long |
The number of users who clicked on the sound on button. |
metric |

spotlightID |
string |
ID Associated with Spotlight |
dimension |

spotlightName |
string |
Spotlight Name as it Appears in Flashtalking Spot Manager |
dimension |

standardCTR |
float |
The number of clicks per impressions on standard ad. Calculated as clicks/impressions. |
metric |

standardClick |
long |
The total number of times the standard ad has been clicked on. |
metric |

standardImp |
long |
The number of times the standard ad has been served |
metric |

startDate |
string |
Placement Start Date (inherited from Campaign when absent). |
dimension |

timeToSale |
long |
The lapsed time in hours from the last click / view event prior to the conversion. |
metric |

totalCost |
long |
The combination of media total cost and FT Cost. |
metric |

totalIncome |
long |
Total Income |
metric |

totalInteractionTime |
long |
The total time value of all interactions. |
metric |

totalProfit |
long |
Calculated as (Total Income - Total Cost) |
metric |

transactionID |
string |
Id of transaction |
dimension |

transaction_quantity |
long |
Number of transactions |
metric |

undetermined |
long |
Undetermined Impressions occurred in an environment where Flashtalking determined that they could not accurately detect the visible status of an ad. |
metric |

uniqueUserClicks |
long |
The number of unique users who clicked the ad. |
metric |

uniqueUsers |
long |
The number of unique users |
metric |

uniqueuserClickthroughRate |
float |
Unique users click through rate |
metric |

vid1Average |
float |
The average percentage of the video 1 that has been viewed. |
metric |

vid1Played100 |
long |
The number of times video 1 is viewed to completion. |
metric |

vid1Played25 |
long |
The number of times video 1 is viewed to 25% completion. |
metric |

vid1Played50 |
long |
The number of times video 1 is viewed to 50% completion. |
metric |

vid1Played75 |
long |
The number of times video 1 is viewed to 75% completion. |
metric |

vid1Replay |
long |
The number of users who replayed the video 1. |
metric |

vid1Start |
long |
The number of users the video 1 began to play for. |
metric |

vid2Average |
float |
The average percentage of the video 2 that has been viewed. |
metric |

vid2Played100 |
long |
The number of times video 2 is viewed to completion. |
metric |

vid2Played25 |
long |
The number of times video 2 is viewed to 25% completion. |
metric |

vid2Played50 |
long |
The number of times video 2 is viewed to 50% completion. |
metric |

vid2Played75 |
long |
The number of times video 2 is viewed to 75% completion. |
metric |

vid2Replay |
long |
The number of users who replayed the video 2. |
metric |

vid2Start |
long |
The number of users the video 2 began to play for. |
metric |

vid3Average |
float |
The average percentage of the video 3 that has been viewed. |
metric |

vid3Played100 |
long |
The number of times video 3 is viewed to completion. |
metric |

vid3Played25 |
long |
The number of times video 3 is viewed to 25% completion. |
metric |

vid3Played50 |
long |
The number of times video 3 is viewed to 50% completion. |
metric |

vid3Played75 |
long |
The number of times video 3 is viewed to 75% completion. |
metric |

vid3Replay |
long |
The number of users who replayed the video 3. |
metric |

vid3Start |
long |
The number of users the video 3 began to play for. |
metric |

vid4Average |
float |
The average percentage of the video 4 that has been viewed. |
metric |

vid4Played100 |
long |
The number of times video 4 is viewed to completion. |
metric |

vid4Played25 |
long |
The number of times video 4 is viewed to 25% completion. |
metric |

vid4Played50 |
long |
The number of times video 4 is viewed to 50% completion. |
metric |

vid4Played75 |
long |
The number of times video 4 is viewed to 75% completion. |
metric |

vid4Replay |
long |
The number of users who replayed the video 4. |
metric |

vid4Start |
long |
The number of users the video 4 began to play for. |
metric |

vid5Average |
float |
The average percentage of the video 5 that has been viewed. |
metric |

vid5Played100 |
long |
The number of times video 5 is viewed to completion. |
metric |

vid5Played25 |
long |
The number of times video 5 is viewed to 25% completion. |
metric |

vid5Played50 |
long |
The number of times video 5 is viewed to 50% completion. |
metric |

vid5Played75 |
long |
The number of times video 5 is viewed to 75% completion. |
metric |

vid5Replay |
long |
The number of users who replayed the video 5. |
metric |

vid5Start |
long |
The number of users the video 5 began to play for. |
metric |

vid6Average |
float |
The average percentage of the video 6 that has been viewed. |
metric |

vid6Played100 |
long |
The number of times video 6 is viewed to completion. |
metric |

vid6Played25 |
long |
The number of times video 6 is viewed to 25% completion. |
metric |

vid6Played50 |
long |
The number of times video 6 is viewed to 50% completion. |
metric |

vid6Played75 |
long |
The number of times video 6 is viewed to 75% completion. |
metric |

vid6Replay |
long |
The number of users who replayed the video 6. |
metric |

vid6Start |
long |
The number of users the video 6 began to play for. |
metric |

vid7Average |
float |
The average percentage of the video 7 that has been viewed. |
metric |

vid7Played100 |
long |
The number of times video 7 is viewed to completion. |
metric |

vid7Played25 |
long |
The number of times video 7 is viewed to 25% completion. |
metric |

vid7Played50 |
long |
The number of times video 7 is viewed to 50% completion. |
metric |

vid7Played75 |
long |
The number of times video 7 is viewed to 75% completion. |
metric |

vid7Replay |
long |
The number of users who replayed the video 7. |
metric |

vid7Start |
long |
The number of users the video 7 began to play for. |
metric |

vid8Average |
float |
The average percentage of the video 8 that has been viewed. |
metric |

vid8Played100 |
long |
The number of times video 8 is viewed to completion. |
metric |

vid8Played25 |
long |
The number of times video 8 is viewed to 25% completion. |
metric |

vid8Played50 |
long |
The number of times video 8 is viewed to 50% completion. |
metric |

vid8Played75 |
long |
The number of times video 8 is viewed to 75% completion. |
metric |

vid8Replay |
long |
The number of users who replayed the video 8. |
metric |

vid8Start |
long |
The number of users the video 8 began to play for. |
metric |

vid9Average |
float |
The average percentage of the video 9 that has been viewed. |
metric |

vid9Played100 |
long |
The number of times video 9 is viewed to completion. |
metric |

vid9Played25 |
long |
The number of times video 9 is viewed to 25% completion. |
metric |

vid9Played50 |
long |
The number of times video 9 is viewed to 50% completion. |
metric |

vid9Played75 |
long |
The number of times video 9 is viewed to 75% completion. |
metric |

vid9Replay |
long |
The number of users who replayed the video 9. |
metric |

vid9Start |
long |
The number of users the video 9 began to play for. |
metric |

videoAveIntTime |
float |
The average time the user has been interacting with the video ad |
metric |

videoCTR |
float |
The number of clicks per impressions on video ad. |
metric |

videoClick |
long |
The total number of times the video ad has been clicked on. |
metric |

videoImp |
long |
The number of times the video ad has been served |
metric |

videoInt |
long |
The number of users who interacted with the video ad |
metric |

videoIntRate |
float |
The total number of interactions as a percentage of impressions requested for an video ad |
metric |

videoIntTime |
long |
The total time value of all interactions with video ad |
metric |

viewability |
string |
Dimension that aims to track only impressions that were actually seen by users. If an ad is loaded at the bottom of a webpage but a user doesn't scroll down far enough to see it that impression would be deemed non-viewable. |
dimension |

viewableImpressions |
long |
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. |
metric |

viewableRate |
float |
The percentage of ads served that were actually seen by a user. Calculated as (Viewable Impressions / (Viewable Impressions + Non-Viewable Impressions) |
metric |

zipCodeMatch |
string |
zipCodeMatch |
dimension |