For the complete documentation index, see llms.txt. This page is also available as Markdown.

AdForm - Supported Columns

Every column the AdForm connector can download.

These are the columns available to a AdForm connector. The recommended template uses a small subset of them, listed on the AdForm page. The rest can be added to a connector through the Advanced Editor, which stops that connector receiving template updates.

Dimensions

Column
Type
Category
Description

year

Int

Time

Time dimension, groups information by year, e.g. 2009, 2010, etc.

yearID

String

Time

Time dimension, groups information by year, e.g. 2009, 2010, etc.

yearMonth

String

Time

Time dimension, groups information by year and month, e.g. 2009-12.

yearWeek

String

Time

Time dimension, groups information by year and week, e.g. 2009-24

monthID

Int

Time

Time dimension, groups information by month, e.g. 1, 2, etc.

month

String

Time

Time dimension, groups information by month, e.g. January, February, etc.

dayMonth

Int

Time

Time dimension, groups information by day of a month (from 1 to 31).

week

Int

Time

Time dimension, groups information by the week number, e.g. 1, 2, etc.

weekday

String

Time

Time dimension, groups information by weekday, e.g. Monday, Tuesday, etc.

weekdayID

Int

Time

Time dimension, groups information by weekday, e.g. 1, 2, etc.

date

DateTime

Time

This dimension groups information by date when a transaction happened.

hour

Int

Time

Time dimension, groups information by hour of the day (values from 0 to 23).

client

String

Campaign

Displays client/advertiser information. Used to group campaigns, in benchmarking reports etc.

clientID

String

Campaign

This dimension groups data by Adform client ID.

campaign

String

Campaign

This dimension shows and groups information by campaign. The campaign is the base item in Adform system, it contains media, placements, banners.

campaignID

String

Campaign

This dimension groups data by Adform campaign ID.

campaignType

String

Campaign

This dimension groups information by campaign type. Campaign type can be assigned in Campaign Details page, possible values: Display, Affiliate, Email, Social Media and other.

campaignBillingID

String

Campaign

This dimension groups data by Adform campaign billing ID, which is of the form AA-BB-0123, where AA is agency's abbreviation, BB is country's abbreviation and 0123 is an identifying number.

campaignStartDate

DateTime

Campaign

This dimension indicates the date on which a campaign starts.

campaignEndDate

DateTime

Campaign

This dimension indicates the date on which a campaign ends.

seAccount

String

Campaign

This dimension groups information by Search Engine acount.

agencyIDOVK

String

Campaign

This dimension groups data by Agency ID (OVK). Agency ID (OVK) is a unique identifier of an Agency or Agency office

industryVertical

String

Campaign

This dimension groups data by industry vertical, collected from Client Management section. Useful for benchmarking reports when analyzing multiple advertisers' data.

banner

String

Banner

This dimension groups information by banner for Display campaigns, or by Adgroup for Search campaigns. Banner is an advertisement vehicle. The banner is displayed through different medias/publishers on different placements. Adgroup contains one or more keywords used in Search Engine campaigns.

bannerID

String

Banner

This dimension groups data by Adform banner ID.

bannerSize

String

Banner

This dimension groups information by banner size. Banner size is shown as "width x height" in pixels, e.g. 300 x 250.

bannerTypeID

String

Banner

This dimension groups information by creative material type. Most common banner types include Flash, Image, Rich Media, Link, Keyword and other.

bannerFormat

String

Banner

This dimension indicates the format of the banner, such as "Skyscraper", "Advertorials", etc. Collected from Banner Overview page.

bannerFormatID

String

Banner

This dimension indicates the format of the banner, such as "Skyscraper", "Advertorials", etc. Collected from Banner Overview page.

bannerMember

String

Banner

Groups data by the name of synchronized ads members. It shows data only for Synchronized Ads and is compatible with clicks and event only.

bannerBackup

String

Banner

This dimension indicates with a "X" symbol whether a back-up banner exists or not. Usually used with Banner/Adgroups dimension. Collected from Banner Overview page.

bannerWeight

String

Banner

This dimension groups information by banner weight.

bannerAdMessage

String

Banner

This dimension indicates what ad message was used in XML enabled banner through Adform Content Manager.

clickDetail

String

Banner

This dimension groups information by banner click details. Click details allow seperating clicks on back-up and flash banners, and clicks on different clickable areas defined by different click-tags implemented in the banners.

dcoProduct

String

Banner

This dimension groups data by the items used in Product Retargeting ads.

paidKeyword

String

Banner

This dimension lists paid search keywords that visitors used to reach advertiser's website.

bannerGlobalID

String

Banner

Groups information by Banner Global ID. When banner is copied, all its copies will have the same Global ID as the original banner. This way, statistics could be used to check how the same banner is performing across different campaigns. Note: When banner is copied, a unique Banner ID is assigned each time, therefore to check banner performance across different client campaigns, Global ID has to be used.

bannerAttribute1

String

Banner

This dimension groups information by Banner Attribute 1. Banner attribute is a user-defined property of a banner. Banner Attribute 1 is usually assigned to the banner batch column in Banner Overview page.

bannerAttribute1ID

String

Banner

Groups metrics by the Adform Banner Attribute ID

bannerAttribute2

String

Banner

This dimension groups information by Banner Attribute 2. Banner attribute is a user-defined property of a banner. Collected from Banner Overview page.

bannerAttribute3

String

Banner

This dimension groups information by Banner Attribute 3. Banner attribute is a user-defined property of a banner. Collected from Banner Overview page.

bannerAttribute4

String

Banner

This dimension groups information by Banner Attribute 4. Banner attribute is a user-defined property of a banner. Collected from Banner Overview page.

bannerAttribute5

String

Banner

This dimension groups information by Banner Attribute 5. Banner attribute is a user-defined property of a banner. Collected from Banner Overview page.

lineItem

String

Buying

This dimension groups information by Line Item. Line Item is an advertisement spot on a media/publisher.

lineItemID

String

Buying

This dimension groups data by Adform Line Item ID.

lineItemNote

String

Buying

This dimension displays Line Item Notes for the selected Line Item. Collected from Mediaplan section.

lineItemStartDate

DateTime

Buying

This dimension displays Line Item start date collected from Mediaplan scheduler.

lineItemEndDate

DateTime

Buying

This dimension displays Line Item end date collected from Mediaplan scheduler.

lineItemAdGapID

String

Buying

AdGap ID is used to minimize effort of comparing Advertiser and Publisher reports by sharing unique ID per line item with the publisher to gain a common, shareable report.

media

String

Buying

Media/publisher is the provider of online advertising space, such as an online newspaper, social network site or other.

mediaID

String

Buying

This dimension groups data by Adform media ID.

mediaLineItem

String

Buying

A joint dimension to list Media:Line Item combination as one dimension values.

mediaSection

String

Buying

This dimension groups information by media section. Media section can have several placements and it is usually devoted for publishing information of similar content, e.g. sports, finance, transportation etc.

mediaCountry

String

Buying

This dimension indicates media/publisher country, where the selected media is located. Collected from Media database.

mediaGlobal

String

Buying

Groups information by media, automatically synchronized with the global media database.

buyType

String

Buying

This dimension indicates the booking/buy types of the selected placement. Possible values: Impressions (CPM), Clicks (CPC), Viewable Impressions (vCPM), Days, Weeks, Months and Conversions.

buyTypeID

String

Buying

This dimension indicates the booking/buy type ID of the selected placement.

network

String

Buying

This dimension groups information by network. Networks are organisations containing several medias (publishers) usually of certain industry vertical.

networkID

String

Buying

This dimension groups data by Adform Network ID.

order

String

Buying

This dimension shows and groups information by order. Usually, it is used to group line items for the long running campaigns.

orderID

String

Buying

This dimension groups data by Adform Order ID.

tag

String

Buying

Tag is a small piece of code used to track online advertisements. This dimension groups information in relations to tags, it could be used to show rotators information.

tagID

String

Buying

This dimension groups data by Adform Tag ID, also known as BN number.

tagUID

String

Buying

This dimension groups data by Tag UID. Tag UID is a unique identifier of a tag, and can be used for matching Adform's statistics to Media's data. Collected from Tags page.

mediaGroup2

String

Buying

This dimension groups information by media group 2 values. There can be several media groups containing different types of information, all of which describes medias and helps to group them, e.g. content, media type, target group, etc. Collected from Media database.

mediaGroup3

String

Buying

This dimension groups information by media group 3 values. There can be several media groups containing different types of information, all of which describes medias and helps to group them, e.g. content, media type, target group, etc. Collected from Media database.

mediaGroup4

String

Buying

This dimension groups information by media group 4 values. There can be several media groups containing different types of information, all of which describes medias and helps to group them, e.g. content, media type, target group, etc. Collected from Media database.

mediaGroup5

String

Buying

This dimension groups information by media group 5 values. There can be several media groups containing different types of information, all of which describes medias and helps to group them, e.g. content, media type, target group, etc. Collected from Media database.

appName

String

RTB

Groups information by app name provided by app store e.g. Angry Birds.

appStore

String

RTB

Groups information by app store name e.g. Apple App Store.

deal

String

RTB

Groups information by Deal Name, used in Private Marketplaces.

dealID

String

RTB

Groups information by Deal ID, used in Private Marketplaces.

rtbDomain

String

RTB

This dimension groups data by RTB domain. RTB domains show 2nd level URLs of publisher sites (e.g. cnn.com), where a banner was displayed when impression was registered. RTB domain values are tracked and sent to Adform by AdExchanges.

rtbInventorySource

String

RTB

Groups information by RTB Inventory Source. Inventory source is an ad exchange, which can be selected for running a Real Time Bidding campaign, e.g. Admeld, Microsoft Ad Exchange, etc.

rtbInventorySourceID

String

RTB

Groups information by RTB Inventory Source ID. Inventory Source ID is an ID, used in Adform, for ad exchange, which can be selected for running a Real Time Bidding (RTB) campaign, e.g. Admeld, Microsoft Ad Exchange, etc.

rtbAudience

String

RTB

This dimension groups information by RTB audience selected in the Targeting step. An audience is a customized segment of users to be targeted, e.g. women from Denmark using Android devices.

rtbAdPosition

String

RTB

Groups data by an ad's position on a page, such as "Above the fold" or "Below the fold".

frequencyCampaign

String

Delivery

This dimension groups information depending on the individual impression frequency on a campaign. A user, who has been exposed to a campaign advertisement twice, has a frequency of 2. A value of zero means that a user does not accept cookies. If this dimension is used with metric Clicks, then user may appear in several rows if s/he clicks several times. For example, a user clicks the first time after seeing a campaign banner twice (this click falls into frequency 2 row), and clicks the second time after seeing a banner the 5th time (this click falls into frequency 5 row).

frequencyLineItem

String

Delivery

This dimension groups information depending on the individual impression frequency on each and every Line Item. A user, who has been exposed to an advertisement from a Line Item twice, has a frequency of 2. A value of zero means that a user does not accept cookies. If this dimension is used with metric Clicks, then user may appear in several rows if s/he clicks several times. For example, a user clicks the first time after seeing a banner from a Line item twice (this click falls into frequency 2 row), and clicks the second time after seeing a banner from the same Line Item for the 5th time (this click falls into frequency 5 row). Tip: this dimension should always be used with Line Item dimension.

bannerDomain2Level

String

Delivery

This dimension shows 2nd level URLs of publisher sites (e.g. *.cnn.com), where banner was displayed when a clicks or an impression was registered.

bannerDomain3Level

String

Delivery

This dimension shows 3rd level URLs of publisher sites (e.g. *.editorial.cnn.com), where banner was displayed when a click was registered. When using this dimension with Impressions metric, 2nd level banner domain information is reported (less detailed information is provided).

dmpDspDataProvider

String

DMP

This dimension groups data by DMP Data Providers whose data was used in RTB to win an impression.

dmpDspDataProviderIds

String

DMP

This dimension groups data by IDs of DMP Data Providers whose data was used in RTB to win an impression.

dmpDspSegment

String

DMP

This dimension groups data by DMP audiences that were used (included or excluded) in RTB to win an impression.

dmpDspSegmentIds

String

DMP

This dimension groups data by DMP audience IDs that were used (included or excluded) in RTB to win an impression.

dmpDspSegmentSource

String

DMP

This dimension groups data by sources (e.g., original, ID Fusion, audience extension) of the DMP segments that were used in RTB to win an impression.

dmpRotatorsDataProvider

String

DMP

This dimension groups data by DMP Data Providers whose data was used in creatives to show an impression.

dmpRotatorsDataProviderIds

String

DMP

This dimension groups data by IDs of DMP Data Providers whose data was used in creatives to show an impression.

dmpRotatorsSegmentIds

String

DMP

This dimension groups data by IDs of DMP Data Provider Segments that were used in creatives to show an impression.

dmpRotatorsSegment

String

DMP

This dimension groups data by DMP Data Provider Segments that were used in creatives to show an impression.

dmpRotatorsSegmentSource

String

DMP

This dimension groups data by sources (e.g., original, ID Fusion, audience extension) of the DMP segments that were used in creatives to show an impression.

event

String

Engagement

This dimension groups information by banner event name. Banner events can be implemented in flash banners in order to track user interactions with banners, such as expands, clicks on play button, etc.

viewabilityTime

String

Engagement

Amount of time that a banner was viewable. This dimension groups information by time intervals, e.g., 0-5 sec., 5-10 sec.

city

String

Geographical

Geographical dimension, groups information by visitor's city, e.g. Copenhagen, Oslo, Stockholm, London etc.

region

String

Geographical

Geographical dimension, shows visitor related information grouped by region.

regionID

String

Geographical

Used for drilling.

zip

String

Geographical

Geographical dimension, groups data by visitor's postal code.

country

String

Geographical

Geographical dimension, groups information by visitor's country e.g. Denmark, UK, USA, etc.

countryID

String

Geographical

Used for drilling.

continent

String

Geographical

Geographical dimension, groups information by visitor's continent, e.g. Australia, Europe, etc.

continentID

String

Geographical

Used for drilling.

page

String

Site Tracking

Website tracking dimension. Page is a definable content unit in advertiser's site. Usually one tracking point is implemented per page.

pageID

String

Site Tracking

This dimension groups data by Adform Page ID, also known as Tracking Point ID.

website

String

Site Tracking

Website tracking dimension, groups information by tracking website. It is the highest member of tracking hierarchy, and can contain one or more tracking sections. Collected from Tracking page.

websiteSection

String

Site Tracking

Website tracking dimension, groups information by tracking section. Tracking section can hold a group of tracking points assigned to a certain campaign, or a group of tracking points implemented on one section of client's website and used for many different campaigns. Collected from Tracking page.

websiteSubsection

String

Site Tracking

Website tracking dimension, groups information by tracking subsection. Tracking subsection is a part of tracking section and can hold a group of tracking points assigned to a certain campaign, or a group of tracking points implemented on one subsection of client's website and used for many different campaigns. Collected from Tracking page.

reactionTime

String

Site Tracking

This dimension groups information by reaction time in intervals (in days) between click and conversion (pageview). If there is no click in visitor's path, then between the impression and the conversion (pageview).

referrerType

String

Site Tracking

Website tracking dimension, groups information by referrer type, such as "Direct Traffic", "Referring Site" or "Natural Search".

adInteractionType

String

Site Tracking

This dimension can be used to group view-through and click-through activity e.g. conversions, orders etc.

sendingVariables

String

Site Tracking

Website tracking dimension. This dimension indicates whether tracked page (tracking point) sends variable data or not. A variable contains information collected from visitors on a tracked page of a client's website.

sysvarAge

String

Site Tracking

This dimension groups information by system variable Age Group and is an Order level variable. A system variable contains information collected from visitors on a tracked page of a client's website. Age Group variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by Age Group variable, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases.

sysvarGender

String

Site Tracking

This dimension groups information by system variable Gender and is an Order level variable. A system variable contains information collected from visitors on a tracked page of a client's website. Gender variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by Gender variable, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases.

sysvarCountry

String

Site Tracking

This dimension groups information by a system variable Country and is an Order level variable. A system variable contains information collected from visitors on a tracked page of a client's website. Country variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by Country variable, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases.

sysvarCurrency

String

Site Tracking

This dimension groups information by system variable Currency and is an Order level variable. A system variable contains information collected from visitors on a tracked page of a client's website. Currency variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by Currency variable, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases.

sysvarProduct

String

Site Tracking

This dimension groups information by a system variable Product Name and is a Product level variable. A system variable contains information collected from visitors on a tracked page of a client's website. Product Name variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by Product Name variable, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases.

sysvarProductID

String

Site Tracking

This dimension groups information by a system variable Product ID and is a Product level variable. A system variable contains information collected from visitors on a tracked page of a client's website. Product ID variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by Product ID variable, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases.

sysvarProductGroup

String

Site Tracking

This dimension groups information by a system variable Product Category and is a Product level variable. A system variable contains information collected from visitors on a tracked page of a client's website. Product Category variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by Product Category variable, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases.

sysvar1

String

Site Tracking

This dimension groups information by system variable 1. A system variable contains information collected from visitors on a tracked page of a client's website. System variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by system variable 1, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases. System variable 1 name can be edited on the Variables tab in Tracking section.

sysvar2

String

Site Tracking

This dimension groups information by system variable 2. A system variable contains information collected from visitors on a tracked page of a client's website. System variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by system variable 2, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases. System variable 2 name can be edited on the Variables tab in Tracking section.

sysvar3

String

Site Tracking

This dimension groups information by system variable 3. A system variable contains information collected from visitors on a tracked page of a client's website. System variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by system variable 3, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases. System variable 3 name can be edited on the Variables tab in Tracking section.

sysvar4

String

Site Tracking

This dimension groups information by system variable 4. A system variable contains information collected from visitors on a tracked page of a client's website. System variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by system variable 4, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases. System variable 4 name can be edited on the Variables tab in Tracking section.

sysvar5

String

Site Tracking

This dimension groups information by system variable 5. A system variable contains information collected from visitors on a tracked page of a client's website. System variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by system variable 5, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases. System variable 5 name can be edited on the Variables tab in Tracking section.

sysvar6

String

Site Tracking

This dimension groups information by system variable 6. A system variable contains information collected from visitors on a tracked page of a client's website. System variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by system variable 6, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases. System variable 6 name can be edited on the Variables tab in Tracking section.

sysvar7

String

Site Tracking

This dimension groups information by system variable 7. A system variable contains information collected from visitors on a tracked page of a client's website. System variable should be used to track information, which can be well aggregated and does not exceed 1000 different values. If more than 1000 different values are sent by system variable 7, all the exceeding values will be represented by N/A row in this report. Please use Variable Data Export in order to see all different values in exceeding cases. System variable 7 name can be edited on the Variables tab in Tracking section.

deviceType

String

Technical

Technical dimension, groups data by device type, which can be: Desktop and Laptop, Small Screen Phone, Smart Phone, Tablet, Other Mobile, Media Hub, Console, TV, eReader, Smart Watch, Smart Speaker. It shows what share of traffic comes from different device types.

browser

String

Technical

Technical dimension, shows information grouped by visitors' web browser, such as "Explorer 8" or "Firefox 2".

operatingSystem

String

Technical

Technical dimension, groups information by operating system of a visitor, e.g. Windows, iOS.

screenResolution

String

Technical

Technical dimensions, groups information by visitors' screen resolution e.g. 1280x1024.

cookiesEnabled

String

Technical

Technical dimension, groups information by visitor's cookie acceptance setting. "Enabled", "Disabled" and "Opt out" are among possible values here. "Enabled" means that a visitor accepts all cookies, "Disabled" means that a visitor doesn't accept cookies at all, "Opt out" means that a visitor doesn't accept Adform cookies.

languageBrowser

String

Technical

This dimension groups data by user's browser language (e.g., English, Danish).

flashVersion

String

Technical

Technical dimension, groups information by visitor's used Flash version.

lineItemLabel1

String

Buying

This dimension groups data by Line Item Label 01. Line Item Labels can be set in Mediaplan page.

lineItemLabel2

String

Buying

This dimension groups data by Line Item Label 02. Line Item Labels can be set in Mediaplan page.

lineItemLabel3

String

Buying

This dimension groups data by Line Item Label 03. Line Item Labels can be set in Mediaplan page.

lineItemLabel4

String

Buying

This dimension groups data by Line Item Label 04. Line Item Labels can be set in Mediaplan page.

lineItemLabel5

String

Buying

This dimension groups data by Line Item Label 05. Line Item Labels can be set in Mediaplan page.

lineItemLabel6

String

Buying

This dimension groups data by Line Item Label 06. Line Item Labels can be set in Mediaplan page.

lineItemLabel7

String

Buying

This dimension groups data by Line Item Label 07. Line Item Labels can be set in Mediaplan page.

lineItemLabel8

String

Buying

This dimension groups data by Line Item Label 08. Line Item Labels can be set in Mediaplan page.

lineItemLabel9

String

Buying

This dimension groups data by Line Item Label 09. Line Item Labels can be set in Mediaplan page.

lineItemLabel10

String

Buying

This dimension groups data by Line Item Label 10. Line Item Labels can be set in Mediaplan page.

lineItemLabel11

String

Buying

This dimension groups data by Line Item Label 11. Line Item Labels can be set in Mediaplan page.

lineItemLabel12

String

Buying

This dimension groups data by Line Item Label 12. Line Item Labels can be set in Mediaplan page.

lineItemLabel13

String

Buying

This dimension groups data by Line Item Label 13. Line Item Labels can be set in Mediaplan page.

lineItemLabel14

String

Buying

This dimension groups data by Line Item Label 14. Line Item Labels can be set in Mediaplan page.

lineItemLabel15

String

Buying

This dimension groups data by Line Item Label 15. Line Item Labels can be set in Mediaplan page.

lineItemLabel16

String

Buying

This dimension groups data by Line Item Label 16. Line Item Labels can be set in Mediaplan page.

lineItemLabel17

String

Buying

This dimension groups data by Line Item Label 17. Line Item Labels can be set in Mediaplan page.

lineItemLabel18

String

Buying

This dimension groups data by Line Item Label 18. Line Item Labels can be set in Mediaplan page.

lineItemLabel19

String

Buying

This dimension groups data by Line Item Label 19. Line Item Labels can be set in Mediaplan page.

lineItemLabel20

String

Buying

This dimension groups data by Line Item Label 20. Line Item Labels can be set in Mediaplan page.

campaignLabel1

String

Campaign

This dimension groups data by Campaign Label 1. Data collected from Campaign Details page.

campaignLabel2

String

Campaign

This dimension groups data by Campaign Label 2. Data collected from Campaign Details page.

campaignLabel3

String

Campaign

This dimension groups data by Campaign Label 3. Data collected from Campaign Details page.

campaignLabel4

String

Campaign

This dimension groups data by Campaign Label 4. Data collected from Campaign Details page.

campaignLabel5

String

Campaign

This dimension groups data by Campaign Label 5. Data collected from Campaign Details page.

campaignLabel6

String

Campaign

This dimension groups data by Campaign Label 6. Data collected from Campaign Details page.

campaignLabel7

String

Campaign

This dimension groups data by Campaign Label 7. Data collected from Campaign Details page.

campaignLabel8

String

Campaign

This dimension groups data by Campaign Label 8. Data collected from Campaign Details page.

campaignLabel9

String

Campaign

This dimension groups data by Campaign Label 9. Data collected from Campaign Details page.

campaignLabel10

String

Campaign

This dimension groups data by Campaign Label 10. Data collected from Campaign Details page.

campaignLabel11

String

Campaign

This dimension groups data by Campaign Label 11. Data collected from Campaign Details page.

campaignLabel12

String

Campaign

This dimension groups data by Campaign Label 12. Data collected from Campaign Details page.

campaignLabel13

String

Campaign

This dimension groups data by Campaign Label 13. Data collected from Campaign Details page.

campaignLabel14

String

Campaign

This dimension groups data by Campaign Label 14. Data collected from Campaign Details page.

campaignLabel15

String

Campaign

This dimension groups data by Campaign Label 15. Data collected from Campaign Details page.

campaignLabel16

String

Campaign

This dimension groups data by Campaign Label 16. Data collected from Campaign Details page.

campaignLabel17

String

Campaign

This dimension groups data by Campaign Label 17. Data collected from Campaign Details page.

campaignLabel18

String

Campaign

This dimension groups data by Campaign Label 18. Data collected from Campaign Details page.

campaignLabel19

String

Campaign

This dimension groups data by Campaign Label 19. Data collected from Campaign Details page.

campaignLabel20

String

Campaign

This dimension groups data by Campaign Label 20. Data collected from Campaign Details page.

dynamicAd

String

Dynamic Ad

This dimension groups data by Dynamic Ad. A Dynamic Ad is an entity that links specific Creative Shell, Version List and Dynamic Ad Setup. Serving tag is created for each specific Dynamic Ad.

dynamicAdCreativeShell

String

Dynamic Ad

This dimension groups data by Dynamic Ad Creative Shell. A Dynamic Ad Creative Shell is a creative (banner) that is used as a shell containing dynamic variable rendering logic.

dynamicAdSetup

String

Dynamic Ad

This dimension groups data by Dynamic Ad Setup. A Dynamic Ad Setup is an entity consisting of information about Creative Shells, Versions data and Dynamic Strategy set.

dynamicAdVersion

String

Dynamic Ad

This dimension groups data by Dynamic Ad Version. A Dynamic Ad Version is a single set of data variables and values used for messaging.

deviceVendor

String

Technical

This dimension indicates the name of the company that manufactures the device or primarily sells it, e.g. Samsung.

deviceModel

String

Technical

This dimension indicates the device model name or number used primarily by the hardware vendor to identify the device, e.g. SM-T805S.

adCreativeType

String

Banner

This dimension groups information by the following ad creative types: Video, Display, Pixel Tag. It helps to evaluate how different types contribute to campaign performance in order to optimize line item strategies accordingly.

appID

String

RTB

Groups information by app ID provided by app store.

bannerClickInteractionCoordinateX

Int

Banner

Shows banner click interaction coordinate X. It is used to draw Banner Heat Map report overlay.

bannerClickInteractionCoordinateY

Int

Banner

Shows banner click interaction coordinate Y. It is used to draw Banner Heat Map report overlay.

bannerType

String

Banner

This dimension groups information by creative material type. Most common banner types include Flash, Image, Rich Media, Link, Keyword and other.

preBidBrandSafetyProviders

String

RTB

This dimension groups data by the pre-bid brand safety providers whose data was used to prevent adspace from being bought on domains with undesirable, brand-incompatible content.

preBidBrandSafetyProviderId

String

RTB

This dimension groups data by the pre-bid brand safety provider id whose data was used to prevent adspace from being bought on domains with undesirable, brand-incompatible content.

dateID

String

Time

Time dimension, groups information by date.

rtbCategory

String

RTB

This dimension groups data by RTB categories. RTB categories shows Tier 1 and Tier 2 Categories, so that user can check on best/worst performing categories to be included/excluded in RTB Targeting, and evaluate current RTB Category targeting

rtbParentCategory

String

RTB

This dimension groups data by RTB parent categories. RTB parent categories shows the best/worst performing Tier 2 categories.

crossDeviceDataProvider

String

Buying

This dimension groups data by Identity Data Providers whose algorithms are used to connect identifiers that belong to the same user.

connectionType

String

Technical

Technical dimension, groups data by users' connection type, such as "WiFi" or "3G".

videoPlayerSize

String

Technical

Technical dimension, groups data by video player size, such as "Small (240p or less)" or "HD (720p-1079p)".

rtbLossReason

String

RTB

This dimension groups Lost bids by the reason why they were not won. The reasons are imported from integrated partners and have various names (e.g., Lost; Creative was outbid; Creative requires additional review).

contextualTargetingProviderId

String

RTB

This dimension groups data by Contextual Targeting Provider ID.

environmentType

String

Technical

This dimension groups data by the type of device environment: Desktop, Mobile (undefined), Mobile Web, Mobile In-App, CTV. The CTV category includes traffic from game consoles, streaming devices, and smart TVs. The CTV environment is not accredited by the Media Rating Council (MRC).

videoPlacementType

String

Technical

This dimension groups data by video placement type. The values indicate whether the ad was played in the video player itself (In-stream) or outside the video player and autoplays in a large format player whenever it is in view (Out-stream). If video placement type was not provided by exchange, it falls under "Unresolved".

videoPosition

String

Technical

This dimension groups data by video ad position. The values (Pre-roll, Mid-roll, Post-roll) indicate whether the ad was played before, during or after the streaming of the video content. If video ad position was not provided by exchange, it falls under "Unresolved".

dma

String

Geographical

DMA region is a geographical dimension that groups information by user‘s designated market area (DMA), also referred to as a media market.

programmaticBuyType

String

RTB

This dimension groups information by line item‘s buy type: RTB and Programmatic Guaranteed. Real-Time Bidding includes an open auction, private auction, and preferred deals. While Programmatic Guaranteed enables the buyer to buy inventory directly from the publisher.

videoStartMode

String

Technical

This dimension groups data by the start mode of the video ads: Auto-play, Click-to-play, and Unknown. If you are using Adform tags (3rd party tags) and want to track auto-play videos, an additional auto-play parameter needs to be added to the URL.

brandSafetyFeatures

String

RTB

This dimension groups data by the brand safety features used to prevent adspace from being bought on domains with undesirable, brand-incompatible content.

brandSafetyFeatureId

String

RTB

This dimension groups data by the brand safety feature ID used to prevent adspace from being bought on domains with undesirable, brand-incompatible content.

contextualTargetingProviders

String

RTB

This dimension groups data by Contextual Targeting Providers names.

contextualTargetingFeatures

String

RTB

This dimension groups data by features used in Contextual Targeting.

contextualTargetingFeatureId

String

RTB

This dimension groups data by feature ID used in Contextual Targeting.

Metrics

Column
Type
Category
Description

rtbMediaCost

Decimal

Cost

This metric shows the cost for which inventory was purchased from ad exchanges.

rtbTradingDeskFee

Decimal

Cost

This metric shows the amount of Trading desk fee.

rtbAdformIncludedFee

Decimal

Cost

This metric shows the amount of Adform included fee.

rtbContextualTargetingCost

Decimal

Cost

This metric shows the amount of Contextual targeting costs.

rtbBrandSafetyCost

Decimal

Cost

This metric shows the amount of Brand safety costs.

rtbRichMediaFee

Decimal

Cost

This metric shows the amount of Rich Media fees which are applied to heavy banners, rich media banners and banners with video.

impressions

Long

Delivery

This metric shows the number of tracked ads (formerly known as impressions) and includes both rendered and served-but-not-rendered ads. Both client-initiated and server-initiated measurement is taken into account. Only client-initiated measurement is compliant with Media Rating Council (MRC) guidelines.

impressionspct

Decimal

Delivery

This metric shows the proportion of impressions for the selected dimension, in comparison with the total number of impressions.

uniqueImpressionsPercent

Decimal

Delivery

This metric shows the percentage of unique impressions in relation to all registered impressions.

clicks

Long

Delivery

This metric shows the number of clicks for the selected dimension. A click occurs when a user interacts with the advertisement by engaging a mouse button (usually the left) while the mouse pointer is hovering over the advertisement.

uniqueClicksPercent

Decimal

Delivery

This metric shows the percentage of unique clicks in relation to all registered clicks.

ctr

Decimal

Delivery

This metric shows click-through rate for the selected dimension. It is a percentage of users who have been exposed to an advertisement and then clicked. Calculated as clicks divided from impressions, in percent.

ctrView

Decimal

Delivery

This metric shows the percentage of impressions that resulted in a click, taking into account only those impressions that were actually in the users' screens.

ctrAdjusted

Decimal

Delivery

This metric shows click-through rate for the selected dimension. It is a percentage of users who have been exposed to an advertisement and then clicked. Calculated as clicks divided from impressions, in percent. This metric considers all tag serving types such as Impressions, Invisible, Offile, etc. except for Clicks in order to assure consistent metric values.

ctrUnique

Decimal

Delivery

This metric shows unique click-through rate for the selected dimension. It is a percentage of unique users who have been exposed to an advertisement and then clicked. Calculated as campaign unique clicks divided from campaign impressions, in percent.

avgFrequency

Decimal

Delivery

This metric shows the average number of impressions to which a user has been exposed. Tip: In order to see average frequency for unique user (all duplications excluded), use Campaign Unique setting for this metric.

blockedImpressions

Int

Delivery

This metric shows the number of impressions, which were blocked according to campaign's Brand Safety settings. Impression blocking in Brand Safety means that a blank, non-clickable image is displayed instead of actual banner for brand protection purpose.

blockedImpressionsPercent

Decimal

Delivery

This metric shows the proportion of Brand Safety blocked impressions in total number of impressions. Impression blocking in Brand Safety means that a blank, non-clickable image is displayed instead of actual banner for brand protection purpose.

rtbBids

Int

Delivery

This metric shows the number of offers done by Adform in attempt to win an impression on an ad exchange auction.

rtbWinRate

Decimal

Delivery

This metric shows the proportion of impressions (won bids) in total number of bids (attempts to win an impression). Calculated as Impressions / Bids in %.

dcoProductViews

Int

Delivery

The number of times that a Product Retargeting item was shown in a banner. One of the most commonly used KPIs to evaluate the performance of an item.

ctrDco

Decimal

Delivery

The percentage of Product Retargeting item views that resulted in a click. One of the most commonly used KPIs to evaluate the performance of an item.

deliveredImpressions

Int

Mediaplan

This metric shows the number of times that an advertisement was shown on a publisher's site. Could be used to monitor under-/overdelivery. TIP: Values are only displayed for line items booked in impressions.

deliveredImpressionsPercent

Decimal

Mediaplan

This metric shows the percentage of delivered impressions in relation to booked impressions. Could be used to monitor under-/overdelivery. TIP: Values are only displayed for line items booked in impressions.

engagements

Int

Engagement

This metric shows the count of user interactions with a banner. User interactions are tracked as user-initiated banner events for Rich Media, Flash and Image banner types. Examples of user-initiated banner events are mouse-over (only if > 1 sec.), video play button press, close button press, etc. Not user-initiated banner events are not included into this metric, except for auto-expand event. Examples of not user-initiated banner event are Floating Banner Shown, 25% of Video Play, etc.

engagementRate

Decimal

Engagement

This metric is calculated as Engaging impressions / Impressions * 100 %. Engaging impressions stand for the sum of impressions, where at least one engagement occurred during each impression. Engagements are tracked as user-initiated banner events for Rich Media, Flash and Image banner types. Examples of user-initiated banner events are mouse-over (only if > 1 sec.), video play button press, close button press, etc.

avgEngagementTime

Decimal

Engagement

This metric shows the average engagement time of visible banners. A banner is visible when at least X % of its area is visible in user's screen. X parameter is collected from Campaign Details page. Three timed events are considered during calculation - mouse-over time, video play time, and expansion time. Measurement is based on sampled data.

engagingImpressions

Int

Engagement

This metric shows the sum of impressions, where at least one engagement occurred during each impression. Engagements are tracked as user-initiated banner events for Rich Media, Flash and Image banner types. Examples of user-initiated banner events are mouse-over (only if > 1 sec.), video play button press, close button press, etc.

avgExpansionTime

Decimal

Engagement

This metric shows the average amount of time that a viewable expanding banner has been in its expanded state. Could be used to evaluate user exposure.

expansionRate

Decimal

Engagement

This metric shows the ratio of banner expansions to the number of impressions. The Expansion rate is calculated as All Expands / Impressions * 100%. Data from automatically expanding banners is excluded.

avgMouseoverTime

Decimal

Engagement

This metric shows the average mouse-over time on visible banners. A banner is visible when at least X % of its area is visible in user's screen. X parameter is collected from Campaign Details page. Only mouse-overs, which lasted 1 second or more, are considered. Measurement is based on sampled data.

avgVideoPlayTime

Decimal

Engagement

This metric shows the average amount of time that a viewable video banner played. Only user-initiated video plays are considered. Could be used to evaluate user engagement.

events

Int

Engagement

This metric shows how many times an event has been invoked in a banner. Events can be implemented in flash banners in order to track user interactions with banners, such as expands, clicks on play button, etc. Tip: use with dimension Event Name if several different events are implemented.

mouseOverRate

Decimal

Engagement

This metric shows the ratio of mouse overs to the number of impressions. The Mouse Overs are counted when a user hovers his/her mouse pointer over a banner. Only mouse overs which lasted 1 second or more are counted.

mouseovers

Int

Engagement

This metric shows the number of mouse overs on banner. Only mouse overs, which lasted 1 second or more, are registered.

videoCompleteCount

Int

Engagement

This metric shows the number of times a video banner or in-stream video was played to 100% completion.

videoCompletionRate

Decimal

Engagement

Video completion rate is calculated as Video Completed / Video Play Started * 100%. For audio campaigns this rate represents LTR (Listen Through Rate).

videoPlayStartCount

Decimal

Engagement

This metric shows the total number of video starts (including both auto-play and user-initiated video plays). TIP: Only unique starts are reported.

videoStartRate

Decimal

Engagement

Video start rate is calculated as Video Play Started / Impressions * 100%

visits

Int

Site Tracking

Shows the number of visits in advertiser's website for the selected tracking setup.

newVisitsPercent

Decimal

Site Tracking

This metric shows a percentage of new visits in relation to all registered visits on an advertiser's website for the selected tracking setup.

bounceRate

Decimal

Site Tracking

This metric shows the percentage of bounces in relation to registered visits on a client's website for the selected tracking setup.

bounces

Int

Site Tracking

This metric shows the number of bounces for the selected dimension. Bounces are such visits on a advertiser's website, when only one tracked page is visited during the entire visit (session).

visitors

Int

Site Tracking

Shows the number of unique visitors in advertiser's website for the selected tracking setup.

clicksToLandingPage

Int

Site Tracking

This metric shows the percentage of clicks ending up as visits on the landing page for the selected dimension.

cov

Decimal

Site Tracking

This metric shows the conversion rate for the selected dimension. Calculated as conversions divided from clicks, in percent.

covVisitsPercent

Decimal

Site Tracking

This metric shows the visit conversion rate for the selected dimension. Calculated as conversions divided from visits, in percent.

avgPageDuration

Int

Site Tracking

This metric shows the average time spent on a tracked page. Measured in seconds.

avgOrderSales

Decimal

Site Tracking

This metric shows the sales value divided from number of conversions for the selected dimensions.

avgVisitDepth

Decimal

Site Tracking

This metric shows the average number of visited pages per visit (session).

avgVisitDuration

Int

Site Tracking

This metric shows the average time spent on a tracked website per visit (session). Measured in seconds.

entrances

Int

Site Tracking

This metric shows the number of session entries for the selected dimension. A session entry occurs when a user enters a website and starts browsing. Tip: use with dimension Page in order to see number of entries for each tracked page seperately.

exits

Int

Site Tracking

This metric shows the number of session exits for the selected dimension. A session exit occurs when a user leaves a website (either due to literally leaving the site or due to the session time-out). Tip: use with dimension Page in order to see number of exits for each tracked page seperately.

pageviews

Int

Site Tracking

This metric shows the number of all tracked pages (tracking points) pageviews, displayed as a sum for all tracked pages. It has predefined Uniqueness of 'No Repeat', which means that pageviews, generated by the same user within 15 minutes, are excluded.

pageviewsAll

Int

Site Tracking

This metric shows the number of all tracked pages (tracking points) pageviews, displayed as a sum for all tracked pages.

pageviewsSpecsTemp

Int

Site Tracking

This metric shows the number of all tracked pages (tracking points) pageviews, displayed as a sum for all tracked pages. There is a possibility to change uniqueness setting for this metric.

sales

Decimal

Site Tracking

This metric shows the sales value collected from all visits on tracked pages and is an Order level variable. Collected only if variable is implemented in Tracking points. It has predefined Uniqueness of 'No Repeat', which means that sales value form pageviews, generated by the same user within 15 minutes, are excluded.

salesAll

Decimal

Site Tracking

This metric shows the sales value collected from all visits on tracked pages. Collected only if variable is implemented in Tracking points.

salesSpecs

Decimal

Site Tracking

This metric shows the sales value collected from all visits on tracked pages. Colected only if variable is implemented in Tracking points. There is a possibility to change uniqueness setting for this metric.

salesByCost

Decimal

Cost

This metric shows Sales value divided by Cost value. Cost is either booked or accumulated cost for the selected dimension, or RTB Budget Spent in case of Real Time Bidding campaign. Sales is a system variable and represents the returned value of a campaign.

vtr

Decimal

Site Tracking

This metric shows the impression conversion rate for the selected dimension. Calculated as Conversions divided by Impressions and multiplied by 1000, in percents.

sysvarBasketSize

Int

Site Tracking

This metric shows the size of the basket (shopping cart) and is an Order level variable. It is a system variable collected from visitors on a tracked page of advertiser's website.

sysvarProductCount

Int

Site Tracking

This metric shows the number of ordered products and is a Product level variable. It is a system variable collected from visitors on a tracked page of advertiser's website.

sysvarProductSales

Decimal

Site Tracking

This metric shows the sales amount of ordered products and is a Product level variable. It is a system variable collected from visitors on a tracked page of advertiser's website.

sysvarNumeric1

Decimal

Site Tracking

This metric shows numeric information collected from visitors on a tracked page of a client's website. It is a system variable and its name can be edited on the Variables tab in Tracking section.

sysvarNumeric2

Decimal

Site Tracking

This metric shows numeric information collected from visitors on a tracked page of a client's website. It is a system variable and its name can be edited on the Variables tab in Tracking section.

cost

Decimal

Cost

This metric shows the cost value for the selected dimension (usually on a media, placement (line item) level). Please check documentation for more details.

costView

Decimal

Cost

This metric shows the cost value taking into account the percentage of viewable impressions. TIP: Check documentation for more details.

costNonView

Decimal

Cost

This metric shows the cost value taking into account the percentage of non-viewable and undetermined impressions. TIP: Check documentation for more details.

costPostClick

Decimal

Cost

This metric shows the post click conversions cost.

costBySales

Decimal

Cost

This metric shows Cost value divided by Sales value. Cost is either booked or accumulated cost for the selected dimension, or RTB Budget Spent in case of Real Time Bidding campaign. Sales is a system variable and represents the returned value of a campaign.

ecpa

Decimal

Cost

This metric shows effective Cost per Conversion with the conversion pages listed as a sum. Cost is either booked or accumulated cost for the selected dimension, or RTB Budget Spent in case of Real Time Bidding campaign.

seCPA

Decimal

Cost

This metric shows effective Cost per Conversion with the conversion pages listed as a sum. Used for Search Engine campaigns, when Search Engine calculates cost, but Adform tracks conversions.

ecpc

Decimal

Cost

This metric shows cost per click for the selected dimension. Cost is either booked or accumulated cost for the selected dimension, or RTB Budget Spent in case of Real Time Bidding campaign.

ecpi

Decimal

Cost

This metric shows cost per impression for the selected dimension. Cost is either booked or accumulated cost for the selected dimension, or RTB Budget Spent in case of Real Time Bidding campaign.

ecpm

Decimal

Cost

This metric shows cost per mille (thousand impressions) for the selected dimension. TIP: to report on eCPM (Reach) metric set Uniqueness as “Campaign Unique” and Cost type as “RTB” in metric settings.

ecpmv

Decimal

Cost

This metric shows the effective cost value of a thousand viewable impressions. TIP: Check documentation for more details.

ecpp

Decimal

Cost

This metric shows effective cost per pageview for the selected dimension. Cost is either booked or accumulated cost for the selected dimension, or RTB Budget Spent in case of Real Time Bidding campaign. All tracking points are taken into acount when calculating this metric.

roi

Decimal

Cost

This metric shows the return of investment. A positive value corresponds to capital growth, a negative value corresponds to capital decay, and a value of 0% corresponds to no change. It is calculated as (Sales - Cost) / Cost * 100%, or as (Sales - RTB Budget Spent) / RTB Budget Spent * 100% in case of Real Time Bidding campaign.

seAvgCPC

Decimal

Cost

This metric shows average cost per click value for the selected dimension in Search Engine campaigns.

seAvgPosition

Decimal

Delivery

This metric shows average position value for the selected dimension in Search Engine campaigns.

dmpDspDataCost

Decimal

Cost

This metric shows total data cost that was spent on DMP data to win an impression in RTB.

dmpRotatorsDataCost

Decimal

Cost

This metric shows total data cost that was spent on DMP data to show an impression in creatives.

videoEvents

Int

Engagement

This metric shows the interactions with video banners, where banner events are implemented. Interactions such as Play, Pause, Stop, Sound On, and others can be reported.

videoEventsPlayTimePercent

Decimal

Engagement

This metric shows the percentage of video viewed for the selected dimension.

booked

Decimal

Mediaplan

This metric shows the number of booked units for a media placement (line item). Tip: use this metric with the Buy Type dimension to be able to discern units e.g. impressions.

bookedClicks

Decimal

Mediaplan

This metric shows the number of booked clicks for a media placement. Clicking means interacting with an advertisement by engaging a mouse button (usually the left) while the mouse pointer is hovering over the advertisement.

bookedConversions

Decimal

Mediaplan

This metric shows the number of booked conversions for the selected dimension. Any tracked page can be defined as a Conversion - usually a page where a sign-up is confirmed or a sale is made.

bookedImpressions

Decimal

Mediaplan

This metric shows the number of booked impressions for the selected dimension. An impression occurs when a user is exposed to an advertisement.

bookedTime

Decimal

Mediaplan

This metric shows the number of booked time units for the selected dimension.

conversions

Long

Site Tracking

A tracked page can be defined as a Conversion - usually a page where a sign-up is confirmed or a sale is made. This metric shows the number of all Conversion pageviews, displayed as a sum for all tracked conversion pages. It has predefined Uniqueness of 'No Repeat', which means that Conversion pageviews, generated by the same user within 15 minutes, are excluded.

conversionsAll

Int

Site Tracking

A tracked page can be defined as a Conversion - usually a page where a sign-up is confirmed or a sale is made. This metric shows the number of all Conversion pageviews displayed as a sum for all tracked conversion pages.

conversionsSpecs

Int

Site Tracking

A tracked page can be defined as a Conversion - usually a page where a sign-up is confirmed or a sale is made. This metric shows the number of all Conversion pageviews displayed as a sum for all tracked conversion pages. There is a possibility to change uniqueness setting for this metric.

measurableImpressions

Long

Viewability

This metric shows the number of eligible impressions that were measured for viewability. This metric has been accredited by the Media Rating Council (MRC).

measurableImpressionsPercent

Decimal

Viewability

This metric shows the part of eligible impressions that were measured for viewability, calculated as the percentage of measurable impressions in relation to eligible impressions. This metric has been accredited by the Media Rating Council (MRC).

avgBrandExposureDuration

Decimal

Viewability

This metric shows the average amount of time that a user was exposed to an advertisement, taking into account the % of user's screen covered by the banner and its time in the user's screen. TIP: Check documentation for more details.

avgViewabilityTime

Decimal

Viewability

This metric shows the average amount of time that users actually saw a viewable banner in their screen. TIP: A viewable impression is defined in the Ad Viewability settings, visible in the Campaign Details.

viewImpressions

Long

Delivery

This metric shows the number of rendered impressions that were actually in the users' screens.

renderedImpressions

Decimal

Delivery

The number of times that an advertisement was rendered anywhere in a user's browser. This metric has been accredited by the Media Rating Council (MRC).

undeterminedImpressions

Long

Viewability

This metric shows the number of eligible impressions that could not be measured for viewability. This metric has been accredited by the Media Rating Council (MRC).

impressionDistributionUndeterminedPct

Decimal

Viewability

This metric shows part of rendered impressions that were not measured for viewability, calculated as the percentage of non-measured impressions in relation to eligible impressions. This metric has been accredited by the Media Rating Council (MRC).

deliveredClicksPercent

Decimal

Mediaplan

This metric shows the percentage of delivered clicks in relation to booked clicks. Could be used to monitor under-/overdelivery. TIP: Values are only displayed for line items booked in clicks.

deliveredConversionsPercent

Decimal

Mediaplan

This metric shows the percentage of delivered conversions in relation to booked conversions. Could be used to monitor under-/overdelivery. TIP: Values are only displayed for line items booked in conversions.

overdeliveredPercent

Decimal

Mediaplan

This metric shows the percentage of units delivered over the booked volume, in relation to booked units. Could be used to monitor under-/overdelivery. TIP: Use with Buy Type dimension to discern units, e.g., impressions.

viewImpressionsPercentIAB

Decimal

Viewability

This metric shows the part of measured impressions that were actually in the users' screens, calculated as the percentage of viewable impressions in relation to measurable impressions. This metric is accredited by Media Rating Council (MRC) only when reported together with "Ad Creative Type" dimension.

viewImpressionsPercentCustom1

Decimal

Viewability

This metric shows the part of measured impressions that were actually in the users' screens, calculated as the percentage of viewable impressions in relation to measurable impressions. Note: viewable impression custom thresholds #1 and #2 can be defined in the Ad Viewability Settings in Campaign Details. This metric has been accredited by the Media Rating Council (MRC).

viewImpressionsPercentCustom2

Decimal

Viewability

This metric shows the part of measured impressions that were actually in the users' screens, calculated as the percentage of viewable impressions in relation to measurable impressions. Note: viewable impression custom thresholds #1 and #2 can be defined in the Ad Viewability Settings in Campaign Details. This metric has been accredited by the Media Rating Council (MRC).

mpAmount

Int

Mediaplan

This metric shows the spent amount visible in the Mediaplan. It can be set to show gross amount, net amount or net amount 2. Could be used to report on the cost and fee breakdown of a campaign.

delivered

Int

Mediaplan

This metric shows the number of units delivered by a publisher. Could be used to monitor under-/overdelivery. TIP: Use with Buy Type dimension to discern units, e.g., impressions.

deliveredPercent

Decimal

Mediaplan

This metric shows the percentage of units delivered by a publisher in relation to planned units. Could be used to monitor under-/overdelivery. TIP: Use with Buy Type dimension to discern units, e.g., impressions.

deliveredClicks

Int

Mediaplan

This metric shows the number of times that users clicked on a banner and were directed to an advertiser's destination. Could be used to monitor under-/overdelivery. TIP: Values are only displayed for line items booked in clicks.

deliveredConversions

Int

Mediaplan

This metric shows the number of times that users took the desired action on an advertiser's website, e.g., purchased an item, subscribed to a newsletter. Could be used to monitor under-/overdelivery. TIP: Values are only displayed for line items booked in conversions.

deliveredCostPercent

Decimal

Mediaplan

This metric shows the percentage of cost delivered until now (using max cost, fixed price method) in relation to the net amount (or net amount 2, based on client settings), or RTB cost in relation to RTB budget. Could be used to monitor under-/overdelivery.

deliveredTime

Int

Mediaplan

This metric shows the number of time units delivered by a publisher. Could be used to monitor under-/overdelivery. TIP: Values are only displayed for line items booked in time units.

ecpacrossdevice

Int

Cost

This metric shows effective Cost per Conversion (ID Fusion) with the conversion pages listed as a sum. Here, the user may have interacted with the campaign and website on different devices.

mpPrice

Decimal

Mediaplan

This metric shows the price paid per booked unit visible in the Mediaplan. It can be set to show gross price, net price or net price 2. Could be used to report on the cost and fee breakdown of a campaign.

overdelivered

Int

Mediaplan

This metric shows the number of units delivered over the booked volume. Could be used to monitor under-/overdelivery. TIP: Use with Buy Type dimension to discern units, e.g., impressions.

overdeliveredClicks

Int

Mediaplan

This metric shows the number of clicks delivered over the booked volume. Could be used to monitor under-/overdelivery. TIP: Values are only displayed for line items booked in clicks.

overdeliveredImpressions

Int

Mediaplan

This metric shows the number of impressions delivered over the booked volume. Could be used to monitor under-/overdelivery.TIP: Values are only displayed for line items booked in impressions.

viewImpressionsIAB

Int

Viewability

This metric shows the number of eligible impressions that were actually in the users' screens. According to IAB standards, an impression is counted as viewable when at least 50 % of the banner area is visible in the user's screen for at least 1 second; at least 30% of the large (greater than 242,000 pixels) banner area is visible in the user's screen for at least 1 second; at least 50% of the in-stream video is visible in the user's screen for at least 2 seconds. This metric is accredited by Media Rating Council (MRC) only when reported together with "Ad Creative Type" dimension.

viewImpressionsCustom1

Int

Viewability

This metric shows the number of eligible impressions that were actually in the users' screens. Note: viewable impression custom thresholds #1 and #2 can be defined in the Ad Viewability Settings in Campaign Details. The custom thresholds can't be lower than stated in IAB standard. This metric has been accredited by the Media Rating Council (MRC).

viewImpressionsCustom2

Int

Viewability

This metric shows the number of eligible impressions that were actually in the users' screens. Note: viewable impression custom thresholds #1 and #2 can be defined in the Ad Viewability Settings in Campaign Details. The custom thresholds can't be lower than stated in IAB standard. This metric has been accredited by the Media Rating Council (MRC).

nonViewableImpressionsIAB

Int

Viewability

This metric shows the number of eligible impressions that were not in the users' screens. This metric is accredited by Media Rating Council (MRC) only when reported together with "Ad Creative Type" dimension.

nonViewableImpressionsCustom1

Int

Viewability

This metric shows the number of eligible impressions that were not in the users' screens. This metric has been accredited by the Media Rating Council (MRC).

nonViewableImpressionsCustom2

Int

Viewability

This metric shows the number of eligible impressions that were not in the users' screens. This metric has been accredited by the Media Rating Council (MRC).

impressionDistributionNonViewablePctIAB

Decimal

Viewability

This metric shows part of rendered impressions that were not in the users' screens, calculated as the percentage of non-viewable impressions in relation to eligible impressions. This metric is accredited by Media Rating Council (MRC) only when reported together with "Ad Creative Type" dimension.

impressionDistributionNonViewablePctCustom1

Decimal

Viewability

This metric shows part of rendered impressions that were not in the users' screens, calculated as the percentage of non-viewable impressions in relation to eligible impressions. This metric has been accredited by the Media Rating Council (MRC).

impressionDistributionNonViewablePctCustom2

Decimal

Viewability

This metric shows part of rendered impressions that were not in the users' screens, calculated as the percentage of non-viewable impressions in relation to eligible impressions. This metric has been accredited by the Media Rating Council (MRC).

impressionDistributionViewablePctIAB

Decimal

Viewability

This metric shows part of rendered impressions that were in the users' screens, calculated as the percentage of viewable impressions in relation to eligible impressions. This metric is accredited by Media Rating Council (MRC) only when reported together with "Ad Creative Type" dimension.

impressionDistributionViewablePctCustom1

Decimal

Viewability

This metric shows part of rendered impressions that were in the users' screens, calculated as the percentage of viewable impressions in relation to eligible impressions. This metric has been accredited by the Media Rating Council (MRC).

impressionDistributionViewablePctCustom2

Decimal

Viewability

This metric shows part of rendered impressions that were in the users' screens, calculated as the percentage of viewable impressions in relation to eligible impressions. This metric has been accredited by the Media Rating Council (MRC).

impressionscrossdevice

Int

Delivery

This metric shows the number of times that an advertisement was shown on a publisher's site. When selecting uniqueness levels, a user is considered unique across all their devices and identifiers.

clickscrossdevice

Int

Delivery

This metric shows the number of times that users clicked on a banner and were directed to an advertiser's destination. When selecting uniqueness levels, a user is considered unique across all their devices and identifiers. TIP: User engagements with rich media banners, e.g., click on video play start button, are not taken into account.

conversionscrossdevice

Int

Site Tracking

This metric shows the number of times that users took the desired action on an advertiser's website, e.g., purchased an item, subscribed to a newsletter. Here, the user may have interacted with the campaign and website on different devices or identifiers.

pageviewscrossdevice

Int

Site Tracking

This metric shows the number of times pages on an advertiser's website were viewed. Here, the user may have interacted with the campaign and website on different devices or identifiers. TIP: Use with dimension Page in order to see data for each page separately.

ctrcrossdevice

Decimal

Delivery

This metric shows the percentage of impressions that resulted in a click. When selecting uniqueness levels, a user is considered unique across all their devices and identifiers.

covcrossdevice

Decimal

Site Tracking

This metric shows the conversion rate, calculated as the ratio of conversions to clicks. Here, the user may have interacted with the campaign and website on different devices or identifiers.

avgFrequencycrossdevice

Decimal

Delivery

This metric shows the average number of impressions to which a user has been exposed. When selecting uniqueness levels, a user is considered unique across all their devices and identifiers. Could be used to evaluate reach of a campaign. TIP: To evaluate frequency capping, select the appropriate uniqueness level, and use the corresponding dimensions. Check documentation for more details.

salescrossdevice

Decimal

Site Tracking

This metric shows the sales value transmitted on conversion pages on an advertiser's website, e.g., thank you page. Here, the user may have interacted with the campaign and website on different devices or identifiers. TIP: Sales variable needs to be transmitted on a conversion tracking point.

userInitiatedVideoPlayCount

Int

Engagement

This metric shows the number of user-initiated video plays ("play" button presses).

rtbLostBids

Int

Delivery

This metric shows the number of RTB bids that were lost (for instance, when a creative was outbid or if the creative requires additional review). Statistics are based on sampled data.

rtbLossRate

Decimal

Delivery

This metric shows the part of all RTB bids that were lost (for instance, when a creative was outbid or if the creative requires additional review), calculated as Lost Bids / RTB Bids. Statistics are based on sampled lost bid data.

rtbCrossDeviceCost

Int

Cost

This metric shows the amount of ID Fusion costs.

rtbThirdPartyVendorCost

Int

Cost

This metric shows the amount of Custom third-party fee.

eligibleImpressions

Int

Delivery

This metric shows the number of eligible impressions. Eligible impressions are impressions that have been fully rendered in the user's browser, and were eligible for viewability measurement based on the creative format and tag type.

measurableRate

Decimal

Viewability

This metric shows the part of rendered impressions that were measured for viewability, calculated as the percentage of measurable impressions in relation to rendered impressions. This metric has been accredited by the Media Rating Council (MRC).

bannerClickInteractions

Int

Delivery

This metric shows the number of clicks interactions for Banner Click Coordinate X and Banner Click Coordinate Y. It is used to draw Banner Heat Map report overlay.

dmpRtbCrossDeviceCost

Decimal

Cost

This metric shows total ID Fusion extension cost that was spent on DMP ID Fusion extension data to win an impression in RTB.

dmpRtbLookalikeCost

Decimal

Cost

This metric shows total lookalike extension cost that was spent on DMP Lookalike extension data to win an impression in RTB.

verifiedImpressions

Int

Delivery

This compound metric consists of rendered impressions and tracked ads (filtered for pixel tags) and shows a net count of impressions rendered or tracked on a publisher's page.

impressionsFirstParty

Int

Delivery

This metric shows the number of times an advertisement was shown on a publisher’s site. Data is limited to specific vendors and publishers.

clicksFirstParty

Int

Delivery

This metric shows the number of clicks (1st party) for the selected dimension. Data is limited to specific vendors and publishers.

avgFrequencyFirstParty

Int

Delivery

This metric shows the average number of impressions (1st party) to which a user has been exposed. Data is limited to specific vendors and publishers.

ctrFirstParty

Decimal

Delivery

This metric shows click through rate for the selected dimension. It’s a percentage of users who have been exposed to an advertisement and then clicked. Calculated as clicks (1st party) divided from impressions (1st party), in percent. Data is limited to specific vendors and publishers.

Other columns

Column
Type
Category
Description

campaignCurrency

String

Campaign

This dimension groups information by campaign currency. Campaign currency identifies a currency unit in which campaign bookings are done and reported. Data is collected from Campaign Details page.

Was this helpful?