Sizmek MDX
The table below gives information about all the data fields that you can import from Sizmek MDX.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
|
Field UI name |
Field API name |
Data Type |
Description |
Use in Adverity |
Docs |
|---|---|---|---|---|---|
|
|
ActionName |
string |
The name of the ROI action that was defined when setting up the campaign. |
dimension |
|
|
|
ActionValue |
string |
The value of the ROI action. |
dimension |
|
|
|
AdFormat |
string |
The Sizmek ad format- for example- Expandable Banner. |
dimension |
|
|
|
AdID |
string |
The unique ID the Sizmek system assigned to the display ad when it was created. Appears in the Attribution Report Builder as Display Ad ID. |
dimension |
|
|
|
AdName |
string |
The display ad's name as defined during setup. For Smart Versioning ads- this field is used also to indicate the creative version. Appears as Display Ad Name in the Attribution Report Builder. |
dimension |
|
|
|
AdvertiserID |
string |
The ID of the Advertiser. |
dimension |
|
|
|
AdvertiserName |
string |
The name of the Advertiser. |
dimension |
|
|
|
AvgDwellTime |
float |
The average dwell time. |
metric |
|
|
|
Brand |
string |
The name of the brand. |
dimension |
|
|
|
CTR |
percentage |
Clickthrough rate: The percentage of clicks out of served impressions. Calculation: CTR = Total Clicks / Served Impressions. |
metric |
|
|
|
CampaignEndDate |
date |
The end date of the campaign. |
dimension |
|
|
|
CampaignID |
string |
The ID of the campaign. |
dimension |
|
|
|
CampaignName |
string |
The name of the campaign defined during setup. |
dimension |
|
|
|
CampaignStartDate |
date |
The start date of the campaign. |
dimension |
|
|
|
Clicks |
long |
The number of clicks. |
metric |
|
|
|
ClickthroughURL |
string |
The Click-Through URL. |
dimension |
|
|
|
ConversionTagID |
string |
The ID of the Conversion Tag. |
dimension |
|
|
|
ConversionTagName |
string |
The name of the conversion tag as defined during setup. |
dimension |
|
|
|
Date |
date |
A date in a format determined by the account's region or country (mm/dd/yyyy or dd/mm/yyyy). Indicates a time period determined by the report's date resolution. For example- if the date resolution of the report is Months- and the Date is 1/1/2013- then the data reflects January 2013. |
dimension |
|
|
|
DeliveryDate |
date |
The date of delivery. |
dimension |
|
|
|
Device |
string |
The name of the device. |
dimension |
|
|
|
EndDate |
date |
The end date. |
dimension |
|
|
|
EngagedViews |
long |
The number of engaged views. |
metric |
|
|
|
ImpresionsWithVideoStart |
long |
The number of impressions with a video start. |
metric |
|
|
|
Impressions |
long |
The number of impressions. |
metric |
|
|
|
ImpressionsWithDwell |
long |
The total number of impressions for which users engaged with the ad for at least one second. |
metric |
|
|
|
ImpressionsWithVideoStart |
long |
The number of impressions with at least one instance of a user starting to play video. |
metric |
|
|
|
Interactions |
long |
The number of interactions. |
metric |
|
|
|
LastUpdatingDate |
date |
The date of last update. |
dimension |
|
|
|
MediaCost |
currency |
The total cost for the ad for a specific period. Calculation depends on the Cost-Based Model. CPM: Cost per Unit * (Served Impressions/1000). CPC: Cost per Unit * Total Clicks. CPA: Cost per Unit * Total Actions. Zero Cost: The placement cost is free (no cost for the advertiser). Time-Based: The cost is fixed for a prearranged time period. There is no cost for days without delivery. Flat Fee: The cost is fixed and is calculated as ((booked cost) / (number of scheduled days or hours) * (Number of running days or hours past the start date - within time periods)). |
metric |
|
|
|
NonVisibleImpressions |
long |
The number of impressions which were not visible. |
metric |
|
|
|
PackageID |
string |
The ID of the package. |
dimension |
|
|
|
PlacementClassfication1 |
string |
PlacementClassfication1 |
dimension |
|
|
|
PlacementClassfication2 |
string |
PlacementClassfication2 |
dimension |
|
|
|
PlacementClassfication3 |
string |
PlacementClassfication3 |
dimension |
|
|
|
PlacementClassfication4 |
string |
PlacementClassfication4 |
dimension |
|
|
|
PlacementClassfication5 |
string |
PlacementClassfication5 |
dimension |
|
|
|
PlacementID |
string |
The unique ID the Sizmek system assigned to the placement when it was created. |
dimension |
|
|
|
PlacementName |
string |
The placement's meaningful name that helps identify the location- content- rotation- targeting- and so on. |
dimension |
|
|
|
Post-ClickConversions |
long |
The number of conversions that occurred as a result of an impression after clicking the ad. |
metric |
|
|
|
Post-ClickRevenue |
currency |
The amount of revenue resulting from post-click conversions. |
metric |
|
|
|
Post-ImpressionsConversions |
long |
The number of conversions that occurred as a result of an impression without clicking the ad. |
metric |
|
|
|
Post-ImpressionsRevenue |
currency |
The amount of revenue resulting from post-view conversions. |
metric |
|
|
|
PostClickConversions |
long |
The number of conversions that occurred as a result of an impression after clicking the ad. |
metric |
|
|
|
PostImpressionsConversions |
long |
The number of conversions that occurred as a result of an impression without clicking the ad. |
metric |
|
|
|
SectionID |
string |
The ID of the section. |
dimension |
|
|
|
SectionName |
string |
The name for the specific area of the site where the system serves the ad- as defined during placement setup. |
dimension |
|
|
|
ServedImpressions |
long |
The total number of impressions served (includes rich media- standard and default impressions). For campaigns with Ad Blocking enabled- Sizmek includes blocked impressions when calculating Served Impressions (Calculation: Served Impressions = unblocked impressions + Blocked Impressions). |
metric |
|
|
|
SiteID |
string |
The ID of the site. |
dimension |
|
|
|
SiteName |
string |
The name of the site as defined in the system during site setup. Appears as Display Site Name in the Attribution Report Builder. |
dimension |
|
|
|
StartDate |
string |
The start date. |
dimension |
|
|
|
TotalActions |
long |
The total number of the revenue-returning actions defined in the campaign's placement or package settings (clicks- interactions- and so on). This metric influences ROI calculations. |
metric |
|
|
|
TotalConversion |
long |
All conversions that occurred as a result of an ad impression or an ad click. Calculation: Total Conversions = Post-Click Conversions + Post-Impression Conversions. |
metric |
|
|
|
TotalInteractions |
long |
The total number of user-initiated interactions. The number can include clicks- opening (expanding) a panel- Flash movie replay- video mute- video sound on- video pause- full screen video mode start/pause/end- and any Sizmek custom interactions defined in an ad. Note: There can be more than one interaction per impression. |
metric |
|
|
|
TotalRevenue |
currency |
The income that Sizmek calculates according to the ROI action and revenue per action defined for the placement(s)- plus conversion revenue. Calculation: Total Revenue = Revenue as defined by the placement or package ROI settings + Conversion Revenue. |
metric |
|
|
|
UniqueClickingUsers |
long |
The number of unique users who clicked an ad. Sizmek counts a user who clicks multiple ads as a single unique clicking user. Note: To track unique users- the user must have cookies enabled. |
metric |
|
|
|
UniqueClicks |
long |
The number of unique clicks. |
metric |
|
|
|
UniqueExpansions |
long |
The number of unique expansions. |
metric |
|
|
|
UniqueImpressions |
long |
The number of impressions viewed by different users. Sizmek counts multiple impressions viewed by the same user as a single unique impression. |
metric |
|
|
|
UniqueInteractingUsers |
long |
The number of unique users who interacted with any of an ad's interactions. Note: To track unique users- the users must have cookies enabled. |
metric |
|
|
|
UniqueInteractions |
long |
The number of unique interactions. |
metric |
|
|
|
UniqueVideoStarted |
long |
The number of unique video starts. |
metric |
|
|
|
UnitSize |
string |
Available for banner ads only- the dimensions in pixel size- expressed as width x height (for example: 300x250). N/A appears for non-banner ads. |
dimension |
|
|
|
Video |
string |
The name of the video package or asset defined during setup. |
dimension |
|
|
|
VideoAverageDuration |
float |
The average duration the video was played- including user and auto-initiated videos (in seconds). This metric complies with the IAB definition for time spent viewing LinearVideo Ads with or without Companion Ad: Amount of video viewed at normal speed in seconds or other appropriate time-based units; if a rewind event occurs during play- time spent viewing may be calculated on total amount of video viewed at normal speed (i.e. including additional amounts of video viewed after rewind). This metric is supported for VPAID and In-Banner Video ads. |
metric |
|
|
|
VideoFullyPlayed |
long |
The number of times a video was fully played. |
metric |
|
|
|
VideoPlayed25Percent |
percentage |
The percentage of times the video played at least 25% of the video’s duration out of the number of times the video started. Calculation: Video 25% Played Rate = Video Played 25% / Video Started. |
metric |
|
|
|
VideoPlayed50Percent |
percentage |
The percentage of times the video played at least 50% of the video’s duration out of the number of times the video started. Calculation: Video 50% Played Rate = Video Played 50% / Video Started. |
metric |
|
|
|
VideoPlayed75Percent |
percentage |
The percentage of times the video played at least 75% of the video’s duration out of the number of times the video started. Calculation: Video Played 75% Rate = Video Played 75% / Video Started. |
metric |
|
|
|
VideoReplayed |
percentage |
The number of times a vide was replayed. |
metric |
|
|
|
VideoStarted |
long |
The number of times a video started. Sizmek counts both user- and auto-initiated video starts. Note: There can be more than one video per ad- so the number of instances can be higher than that of the number of impressions. |
metric |
|
|
|
VisibleImpressions |
long |
The number of impressions that were visible. |
metric |
|