Flashtalking

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

If you require help with this topic, please contact Adriel Support using the chat box.