Sizmek Table Layouts

	A	B	C	D	E
1	Field Name	Field Format	Field Values	Field Type	Field Description
2	ad_id	integer		Attribute	The ad's unique identification number as generated by the system.
3	ad_classification1	string		Attribute	The ad's first classification.
4	ad_classification2	string		Attribute	The ad's second classification.
5	ad_classification3	string		Attribute	The ad's third classification.
6	ad_classification4	string		Attribute	The ad's fourth classification.
7	ad_classification5	string		Attribute	The ad's fifth classification.
8	placement_id	integer		Attribute	The placement's unique identification number created by the system.
9	package_id	integer		Attribute	The package's unique identification number created by the system.
10	site_id	integer		Attribute	The unique ID given to the site by the system when created.
11	campaign_id	integer		Attribute	The unique ID given to the campaign by the system when created.
12	advertiser_id	integer		Attribute	The unique ID given to the advertiser by the system when created.
13	delivery_date	timestamp		Attribute	The date of delivery.
14	last_updating_date	timestamp		Attribute	The last time the data was updated (aggregated).
15	impressions	integer		Metric	The number of served impressions.
16	clicks	integer		Metric	The total number of clicks made on an ad. Note: Only the first click is counted as a 'Click', any additional clicks are counted as 'Interactions'.
17	ctr	decimal		Metric	The percentage of Total Clicks out of Served Impressions.
18	media_cost	decimal		Metric	Calculated according to the paying method using the following formulas: CPM: CPM/CPA/CPC/Fixed Price * (Total Impressions/1000). CPC: CPM/CPA/CPC/Fixed Price * Total Clicks. CPA: CPM/CPA/CPC/Fixed Price * Total Actions. Bonus (Zero Cost): The Placement cost is free (no cost for the advertiser). Time-based: The advertiser pays for the period of time for which the ad is served. Flat Fee: The cost is fixed and is calculated as ((Booked cost)/(Number of scheduled days/hours) * (Number of running days/hours past the start date - within time periods))
19	total_revenue	decimal		Metric	The income that we calculate according to the ROI metric and ROI values defined for the placement(s). In cases where the ROI metric is conversions, the value will be taken from the conversion tags themselves.
20	total_interactions	integer		Metric	The total number of user-initiated actions. The number includes Clicks, opening (expanding) a panel, Flash movie replay, Video Mute, Video Sound On, Video Pause, Full Screen Video mode Start/Pause/End, or MediaMind Custom Interactions defined in an ad. Note: There can be more than one interaction per impression.
21	impressions_with_dwell	integer		Metric	The total number of impressions for which users engaged with the ad for at least one second.
22	avg_dwell_time	integer		Metric	The average time users spent engaging with an ad. The metric includes the following user actions: Amount of time the mouse was over an ad, user-initiated video duration, user-initiated expansion duration, and any other user-initiated Custom Interaction duration. Dwell instances lasting less than one second, are excluded.
23	visible_impressions	integer		Metric	The number of impressions served above the fold and/or viewed below the fold by way of scrolling down.
24	non_visible_impressions	integer		Metric	The number of impressions served below the fold, and were not viewed below the fold by way of scrolling down.
25	total_conversion	integer		Metric	All conversions which occurred as a result of an ad view or an ad click. This is the sum of 'Post-Click Conversions and 'Post-Impression Conversions'.
26	post_impressions_conversions	integer		Metric	The number of conversions that occurred as a result of an impression without clicking on the ad.
27	post_click_conversions	integer		Metric	The number of conversions that occurred as a result of an impression after clicking on the ad.
28	reserve1	string		Attribute	For future use
29	reserve2	string		Attribute	For future use
30	reserve3	string		Attribute	For future use
31	reserve4	string		Attribute	For future use
32	reserve5	string		Attribute	For future use
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100