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	Description	Use in Adverity
actual_add_size	actual_ad_size	The measured physical or digital size of the advertisement.	dimension
ad_start_time_hour	tv_spot_start_time_hour	The hour component of the start time for a TV spot.	metric
ad_start_time_minute	tv_spot_start_time_minute	The minute component of the start time for a TV spot.	metric
ad_start_time_second	tv_spot_start_time_second	The second component of the start time for a TV spot.	metric
amnt_paid	amnt_paid	The actual monetary amount paid for an advertisement or service.	dimension
amount	amount	The general monetary value associated with an advertising event, such as an estimated spend.	dimension
book_agency	booking_agency	The name of the agency responsible for booking the advertisement.	dimension
brand	brand	The name of the brand advertised.	dimension
brand_agency	brand_agency	The name of the agency associated with the brand.	dimension
brand_code	brand_code	A unique identifier for the brand.	metric
break_number	break_number	The sequential number of the advertising break within a program.	metric
c_trans_date	c_trans_date	The date of the transaction or event related to the advertisement.	dimension
campaign_status	campaign_status	The current operational status of an advertising campaign.	dimension
campaigns_count	campaigns_count	The total number of advertising campaigns.	metric
category	category	The general classification or category of the product or service advertised.	dimension
category_code	category_code	A unique identifier for the product or service category.	metric
color	press_ad_color	Indicates whether a press advertisement is in color or black and white.	dimension
country	country	The name of the market or country where the data was collected or the advertisement was aired.	dimension
country_code	country_code	A unique identifier for the market or country.	dimension
dates	dates	The date(s) associated with the collected advertising data.	dimension
dd	dd	The day component of a date, often used for daily reporting.	metric
dealer_corporate	dealer_corporate		dimension
distributor	distributor	The entity responsible for distributing the product or service advertised.	dimension
domain	program_domain	The thematic domain or genre of the program in which an advertisement appears.	dimension
final_media_type	final_media_type	The ultimate classification of the media channel used for the advertisement, after any processing or categorization.	dimension
frequency	frequency	The number of times an advertisement was aired or published within a given period.	metric
internet_channel	internet_channel	The specific internet channel or platform where the advertisement appeared.	dimension
internet_device	internet_device	The type of device (e.g., desktop, mobile) on which the internet advertisement was viewed.	dimension
internet_visual_digital_type	internet_visual_digital_type	The digital format or type of the visual creative for an internet advertisement.	dimension
internet_website_category	internet_website_category	The category of the website where the internet advertisement was displayed.	dimension
language	ad_language	The language used in the advertisement.	dimension
media	media	The name of the media type (e.g., ‘Television’, ‘Radio’, ‘Press’).	dimension
media_code	media_code	A unique identifier for the media type.	metric
medium	medium	A broader classification of the media channel, often a parent to submedium.	dimension
medium_code	medium_code	A unique identifier for the broader media channel classification.	metric
mm	mm	The month component of a date, often used for monthly reporting.	metric
origin_country_by_brand	origin_country_by_brand	The country of origin associated with the brand.	dimension
origin_country_by_subbrand	origin_country_by_subbrand	The country of origin associated with the subbrand.	dimension
page_number	page_number	The page number within a publication where a press advertisement appeared.	metric
producer	producer	The entity responsible for producing the advertisement or the program in which it appeared.	dimension
product	product	The name of the specific product being advertised.	dimension
product_code	product_code	A unique identifier for the specific product.	metric
prog_sub_type	program_sub_type	A more detailed sub-type or category of the television program.	dimension
program	tv_program_name	The name of the television program during which an advertisement was broadcast.	dimension
program_detail	program_detail	Additional detailed information about the program.	dimension
program_duration	program_duration	The total duration of the television program.	metric
program_status	program_status	The current status of the program, e.g., live, rerun, completed.	dimension
program_type	tv_program_type	The general type or genre of the television program.	dimension
promotion_sponsorship	promotion_sponsorship	Indicates whether an ad is part of a promotion or sponsorship activity.	dimension
sector	sector	The business sector or industry to which the advertiser or brand belongs.	dimension
sector_code	sector_code	A unique identifier for the business sector or industry.	metric
size	press_size	The physical size or dimensions of an advertisement placed in print media, such as newspapers or magazines. This field helps categorize and analyze ad placements based on their physical presence.	dimension
space	space	The allocated space for an advertisement within a medium, e.g., column inches or percentage of page.	metric
spot_amount	spot_amount	The cost or value associated with a single advertising spot.	dimension
spot_duration	spot_duration	The length of the advertisement in a specific media channel. This is a key metric for monitoring ad campaigns across various media.	dimension
spot_number	spot_number	A sequential identifier for a specific advertising spot within a break or program.	metric
spot_position	spot_position	The position of an advertisement within a break or programming block.	dimension
spot_visual	spot	An identifier or description of the visual creative used for the advertising spot.	dimension
spot_visual_code	spot_visual_code	A unique identifier for the visual creative used in the advertising spot.	metric
spot_visual_picture_name	ad_picture_name	The name or identifier for the visual creative used in an advertisement. Ipsos Statex uses AI-driven image recognition to detect brand exposures in ads.	dimension
subbrand	subbrand	The name of a subbrand associated with the main brand.	dimension
subbrand_code	subbrand_code	A unique identifier for a specific subbrand under a main brand.	metric
subject	subject	The main topic or theme of the advertisement or program.	dimension
submedium	sub_medium_descr	A descriptive name for the sub-medium type (e.g., ‘National TV’ for ‘Television’).	dimension
submedium_code	sub_medium_code	A unique identifier for the sub-medium type (e.g., specific TV channel within ‘Television’ medium).	metric
target_by_product	target_by_product	Information about the target audience or market segment for a specific product.	dimension
total_breaks_in_program	total_breaks_in_program	The total number of advertising breaks within a given television program.	metric
total_page_in_publication	total_pages_in_publication	The total number of pages in the publication where an advertisement appeared.	metric
total_spot_in_break	total_spots_in_break	The total number of advertising spots within a single advertising break.	dimension
tv_15_minute_interval	tv_ad_15_minutes_interval	The 15-minute time interval during which a television advertisement was broadcast. This helps to pinpoint the specific time segments when ads appeared, useful for scheduling and audience analysis.	metric
tv_prog_end_time_hour	tv_program_to_hour	The hour component of the end time for a TV program.	metric
tv_prog_end_time_minute	tv_program_to_minute	The minute component of the end time for a TV program.	metric
tv_prog_end_time_second	tv_program_to_second	The second component of the end time for a TV program.	metric
tv_prog_from_time_hour	tv_program_from_hour	The hour component of the start time for a TV program.	metric
tv_prog_from_time_minute	tv_program_from_minute	The minute component of the start time for a TV program.	metric
tv_prog_from_time_second	tv_program_from_second	The second component of the start time for a TV program.	metric
type	type_descr	The classification or format of the advertisement or the media channel it appeared on. Ipsos Statex tracks ads across various media, including display, video, and social.	dimension
visual_campaign	visual_campaign	The name or identifier of the advertising campaign associated with a visual creative.	dimension
visual_size	visual_size	The size characteristics of a visual creative element.	dimension
yy	yy	The year component of a date, often used for yearly reporting.	metric