Data Overview RC

Within Report Central, you can choose from a variety of dimensions and measures. The table below shows you all available variables along with a short description and an example.

Variable	Type	Description	Example
Date - Day	Date	Day of the event in UTC.	yyyy-mm-dd
Date - Weekday	Date	Weekday of the event.	Monday
Date - Day of Month	Date	Day of the month for an event.	16
Date - Day of Year	Date	Day of the year for an event in - Starting from 01/01.	112 (= April 22th)
Date - Week of Year	Date	Week number of the year for an event - Week starts on Tuesday.	Week 15 (Current week)
Date - Month	Date	Month of the event.	March
Date - Quarter	Date	Quarter of the year for an event.	Quarter 2 (= April, May & June)
Date - Year	Date	Year of the event.	2014
Date - Hour	Date	Hour of the event	00-23
Date - Minute	Date	Minute of the event	00-59
Event Type	Integer	Type of the event. Possible values: 1 = Impression 2 = Pixel 3 = Click 4 = User ID sync 5 = Interaction 6 = Data pass	1, 2, 3, 4, 5 or 6
Interaction Type	Integer	Type of the interaction when Event Type is an Interaction (5). Possible values: 0 = No Interaction 4 = Time on Site 8 = Scroll Down 9 = Ad Hover 12 = Form Focus 13 = Form Click 14 = Form Keydown	0, 4, 8, 9, 12, 13, 14
Interaction Value		Value(s) for the Interaction Types when this is not 0. Possible values when Interaction Type is Time on Site (4): 5 = 5 seconds 10 = 10 seconds 20 = 20 seconds 30 = 30 seconds 60 = 60 seconds / 1 minute 90 = 90 seconds / 1.5 minute 120 = 120 seconds / 2 minutes 180 = 180 seconds / 3 minutes 240 = 240 seconds / 4 minutes 300 = 300 seconds / 5 minutes Possible values when Interaction Type is Scroll Down (8): 10 = 10% scroll down 25 = 25% scroll down 50 = 50% scroll down 75 = 75% scroll down 100 = 100% scroll down Possible values when Interaction Type is Ad Hover (9): 300 = 300 milliseconds 1000 = 1000 milliseconds / 1 second 3000 = 3000 milliseconds / 3 seconds
Collector Pixel ID	Integer	Pixel ID of the collector. Matches the unique ID for a specific pixel (e.g. Smart Pixel, Impression tracking, Click tracking) created within the Mapp DMP (Data Management > Real-Time Data Collection).	99
Geo - Country	String	The country where the event took place. Format: 3 characters conform ISO 3166-1 alpha-3 code; List of possible values.	GBR
Geo - State	String	The region where the event took place, using Maxminds' GeoIP database; List of possible values.	London, City of
Geo - City	String	The city where the event took place, using Maxminds' GeoIP database. Note: Accuracy may vary by country	Birmingham
Geo - Postal Code	String	The postal code of the region where the event took place, using Maxminds' GeoIP database.
User Agent	String	The User Agent - software that is acting on behalf of the user - responsible for the event.	Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.116 Safari/537.36
Device Brand	String	The brand of the device where the event took place.	Apple
Operating System	String	The operating system on the device where the event took place. Possible values: 0 = Unknown 1 = Linux 2 = Mac 3 = Windows 4 = Android 5 = iOS	0, 1, 2, 3, 4, 5
Browser	String	The name of the browser where the event took place.	Chrome
Browser Language	String	Language, as reported by the browser; 2 character format.	en
Browser Language Country	String	Language country, as reported by the browser; 2 character format.	us
Event URL	String	URL of the current event (e.g. page visit, impression shown).	http://www.nytimes.com/2014/04/23/sports/soccer/david-moyes-out-as-head-of-manchester-united.html?ref=international
Site Domain	String	Hostname of the event URL.	www.nytimes.com
Referer URL	String	Full referer URL of the page visited before an event.	http://www.nytimes.com/pages/sports/international/index.html
Size	String	The size of the placement / creative served.	728x90
Publisher ID	Integer	The platform specific ID of the Publisher Member; only available when the event was an impression or click.	123456
Site ID	Integer	The platform specific ID of the Site belonging to a Publisher Member; only available when the event was an impression or click.	123456
Placement ID	Integer	The platform specific ID of the Placement; only available when the event was an impression or click.	123456
Advertiser ID	Integer	The platform specific ID of the Advertiser; only available when the event was an impression or click.	123456 - Mapped to string when available.
Insertion Order ID	Integer	The platform specific ID of the Insertion Order; only available when the event was an impression or click.	123456
Line Item ID	Integer	The platform specific ID of the Line Item; only available when the event was an impression or click.	123456
Campaign ID	Integer	The platform specific ID of the Campaign; only available when the event was an impression or click.	123456
Creative ID	Integer	The platform specific ID of the Creative; only available when the event was an impression or click.	123456 - Mapped to string when available.
Record Count	Integer	Returns the total number of records in the data set.	224.550
Impressions	Integer	Returns the total number of impression events.	113.600
Clicks	Integer	Returns the total number of click events.	285
Pixel Loads	Integer	Returns the total number of pixel events.	113.885
Unique Users	Integer	Returns the total number of unique users who where responsible for the event(s).	54.336
Media Costs	Double	Returns the actual sum of costs paid for impression events to the platform.	230,50
Bid Price	Double	Returns the average bid price for impression events.	0,33
Clear Price	Double	Returns the average clear price for impression events.	0,21
Ad Mouse-Over Time	Double	Returns the average time (in seconds) a user hovered over an ad.	1 (serves as a filter)
Onsite - Time Spent	Double	Onsite engagement measure; only available when the event type is an interaction and the interaction type is 5. Returns the average time (in seconds) a user spent on the event URL page.	1 (serves as a filter)
Onsite - Form Focus	Double	Onsite engagement measure; only available when the event type is an interaction and the interaction type is 12. Returns the value 1 if a user interacted with a web form on the event URL page.	1 (serves as a filter)
Onsite - Form Click	Double	Onsite engagement measure; only available when the event type is an interaction and the interaction type is 13. Returns the value 1 if a user clicked on a specific field within a web form on the event URL page.	1 (serves as a filter)
Onsite - Form Keydown	Double	Onsite engagement measure; only available when the event type is an interaction and the interaction type is 14. Returns the value 1 if a user entered one or more characters in an entry field, checked a box, or hit a radio button within a web form on the event URL page.	1 (serves as a filter)
Onsite - Scroll Down	Double	Onsite engagement measure; only available when the event type is an interaction and the interaction type is 8. Returns the average percentage a user scrolled down.	1 (serves as a filter)