Ipsos Statex: Most-used fields

The table below gives information about most-used fields that you can import from Ipsos Statex. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Use in Adverity
actual_add_size	actual_ad_size	dimension
ad_start_time_hour	tv_spot_start_time_hour	metric
ad_start_time_minute	tv_spot_start_time_minute	metric
ad_start_time_second	tv_spot_start_time_second	metric
amnt_paid	amnt_paid	dimension
amount	amount	dimension
book_agency	booking_agency	dimension
brand	brand	dimension
brand_agency	brand_agency	dimension
brand_code	brand_code	metric
break_number	break_number	metric
c_trans_date	c_trans_date	dimension
campaign_status	campaign_status	dimension
campaigns_count	campaigns_count	metric
category	category	dimension
category_code	category_code	metric
color	press_ad_color	dimension
country	country	dimension
country_code	country_code	dimension
dates	dates	dimension
dd	dd	metric
distributor	distributor	dimension
domain	program_domain	dimension
final_media_type	final_media_type	dimension
frequency	frequency	metric
internet_channel	internet_channel	dimension
internet_device	internet_device	dimension
internet_visual_digital_type	internet_visual_digital_type	dimension
internet_website_category	internet_website_category	dimension
language	ad_language	dimension
media	media	dimension
media_code	media_code	metric
medium	medium	dimension
medium_code	medium_code	metric
mm	mm	metric
origin_country_by_brand	origin_country_by_brand	dimension
origin_country_by_subbrand	origin_country_by_subbrand	dimension
page_number	page_number	metric
producer	producer	dimension
product	product	dimension
product_code	product_code	metric
prog_sub_type	program_sub_type	dimension
program	tv_program_name	dimension
program_detail	program_detail	dimension
program_duration	program_duration	metric
program_status	program_status	dimension
program_type	tv_program_type	dimension
promotion_sponsorship	promotion_sponsorship	dimension
sector	sector	dimension
sector_code	sector_code	metric
size	press_size	dimension
space	space	metric
spot_amount	spot_amount	dimension
spot_duration	spot_duration	dimension
spot_number	spot_number	metric
spot_position	spot_position	dimension
spot_visual	spot	dimension
spot_visual_code	spot_visual_code	metric
spot_visual_picture_name	ad_picture_name	dimension
subbrand	subbrand	dimension
subbrand_code	subbrand_code	metric
subject	subject	dimension
submedium	sub_medium_descr	dimension
submedium_code	sub_medium_code	metric
target_by_product	target_by_product	dimension
total_breaks_in_program	total_breaks_in_program	metric
total_page_in_publication	total_pages_in_publication	metric
total_spot_in_break	total_spots_in_break	dimension
tv_15_minute_interval	tv_ad_15_minutes_interval	metric
tv_prog_end_time_hour	tv_program_to_hour	metric
tv_prog_end_time_minute	tv_program_to_minute	metric
tv_prog_end_time_second	tv_program_to_second	metric
tv_prog_from_time_hour	tv_program_from_hour	metric
tv_prog_from_time_minute	tv_program_from_minute	metric
tv_prog_from_time_second	tv_program_from_second	metric
type	type_descr	dimension
visual_campaign	visual_campaign	dimension
visual_size	visual_size	dimension
yy	yy	metric