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.
actual_add_size actual_ad_size Dimension
The measured physical or digital size of the advertisement.
ad_start_time_hour tv_spot_start_time_hour Metric
The hour component of the start time for a TV spot.
ad_start_time_minute tv_spot_start_time_minute Metric
The minute component of the start time for a TV spot.
ad_start_time_second tv_spot_start_time_second Metric
The second component of the start time for a TV spot.
amnt_paid Dimension
The actual monetary amount paid for an advertisement or service.
amount Dimension
The general monetary value associated with an advertising event, such as an estimated spend.
book_agency booking_agency Dimension
The name of the agency responsible for booking the advertisement.
brand Dimension
The name of the brand advertised.
brand_agency Dimension
The name of the agency associated with the brand.
brand_code Metric
A unique identifier for the brand.
break_number Metric
The sequential number of the advertising break within a program.
c_trans_date Dimension
The date of the transaction or event related to the advertisement.
category Dimension
The general classification or category of the product or service advertised.
category_code Metric
A unique identifier for the product or service category.
color press_ad_color Dimension
Indicates whether a press advertisement is in color or black and white.
country Dimension
The name of the market or country where the data was collected or the advertisement was aired.
country_code Dimension
A unique identifier for the market or country.
dates Dimension
The date(s) associated with the collected advertising data.
distributor Dimension
The entity responsible for distributing the product or service advertised.
domain program_domain Dimension
The thematic domain or genre of the program in which an advertisement appears.
final_media_type Dimension
The ultimate classification of the media channel used for the advertisement, after any processing or categorization.
frequency Metric
The number of times an advertisement was aired or published within a given period.
language ad_language Dimension
The language used in the advertisement.
media Dimension
The name of the media type (e.g., 'Television', 'Radio', 'Press').
media_code Metric
A unique identifier for the media type.
medium Dimension
A broader classification of the media channel, often a parent to submedium.
medium_code Metric
A unique identifier for the broader media channel classification.
origin_country_by_brand Dimension
The country of origin associated with the brand.
origin_country_by_subbrand Dimension
The country of origin associated with the subbrand.
page_number Metric
The page number within a publication where a press advertisement appeared.
producer Dimension
The entity responsible for producing the advertisement or the program in which it appeared.
product Dimension
The name of the specific product being advertised.
product_code Metric
A unique identifier for the specific product.
prog_sub_type program_sub_type Dimension
A more detailed sub-type or category of the television program.
program tv_program_name Dimension
The name of the television program during which an advertisement was broadcast.
program_detail Dimension
Additional detailed information about the program.
program_duration Metric
The total duration of the television program.
program_status Dimension
The current status of the program, e.g., live, rerun, completed.
program_type tv_program_type Dimension
The general type or genre of the television program.
promotion_sponsorship Dimension
Indicates whether an ad is part of a promotion or sponsorship activity.
sector Dimension
The business sector or industry to which the advertiser or brand belongs.
sector_code Metric
A unique identifier for the business sector or industry.
size press_size Dimension
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.
space Metric
The allocated space for an advertisement within a medium, e.g., column inches or percentage of page.
spot_amount Dimension
The cost or value associated with a single advertising spot.
spot_duration Dimension
The duration of an advertisement spot in the collected advertising monitoring data. This field is relevant for understanding the length of ad creatives across various media channels tracked by Ipsos Statex.
spot_number Metric
A sequential identifier for a specific advertising spot within a break or program.
spot_position Dimension
The position of an advertisement within a break or programming block.
spot_visual spot Dimension
An identifier or description of the visual creative used for the advertising spot.
spot_visual_code Metric
A unique identifier for the visual creative used in the advertising spot.
subbrand Dimension
The name of a subbrand associated with the main brand.
subbrand_code Metric
A unique identifier for a specific subbrand under a main brand.
subject Dimension
The main topic or theme of the advertisement or program.
submedium sub_medium_descr Dimension
A descriptive name for the sub-medium type (e.g., 'National TV' for 'Television').
submedium_code sub_medium_code Metric
A unique identifier for the sub-medium type (e.g., specific TV channel within 'Television' medium).
target_by_product Dimension
Information about the target audience or market segment for a specific product.
total_breaks_in_program Metric
The total number of advertising breaks within a given television program.
total_page_in_publication total_pages_in_publication Metric
The total number of pages in the publication where an advertisement appeared.
total_spot_in_break total_spots_in_break Dimension
The total number of advertising spots within a single advertising break.
tv_15_minute_interval tv_ad_15_minutes_interval Metric
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.
tv_prog_end_time_hour tv_program_to_hour Metric
The hour component of the end time for a TV program.
tv_prog_end_time_minute tv_program_to_minute Metric
The minute component of the end time for a TV program.
tv_prog_end_time_second tv_program_to_second Metric
The second component of the end time for a TV program.
tv_prog_from_time_hour tv_program_from_hour Metric
The hour component of the start time for a TV program.
tv_prog_from_time_minute tv_program_from_minute Metric
The minute component of the start time for a TV program.
tv_prog_from_time_second tv_program_from_second Metric
The second component of the start time for a TV program.
type type_descr Dimension
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.
visual_size Dimension
The size characteristics of a visual creative element.