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_sizeactual_ad_sizeDimension
The measured physical or digital size of the advertisement.
ad_start_time_hourtv_spot_start_time_hourMetric
The hour component of the start time for a TV spot.
ad_start_time_minutetv_spot_start_time_minuteMetric
The minute component of the start time for a TV spot.
ad_start_time_secondtv_spot_start_time_secondMetric
The second component of the start time for a TV spot.
amnt_paidDimension
The actual monetary amount paid for an advertisement or service.
amountDimension
The general monetary value associated with an advertising event, such as an estimated spend.
book_agencybooking_agencyDimension
The name of the agency responsible for booking the advertisement.
brandDimension
The name of the brand advertised.
brand_agencyDimension
The name of the agency associated with the brand.
brand_codeMetric
A unique identifier for the brand.
break_numberMetric
The sequential number of the advertising break within a program.
c_trans_dateDimension
The date of the transaction or event related to the advertisement.
categoryDimension
The general classification or category of the product or service advertised.
category_codeMetric
A unique identifier for the product or service category.
colorpress_ad_colorDimension
Indicates whether a press advertisement is in color or black and white.
countryDimension
The name of the market or country where the data was collected or the advertisement was aired.
country_codeDimension
A unique identifier for the market or country.
datesDimension
The date(s) associated with the collected advertising data.
distributorDimension
The entity responsible for distributing the product or service advertised.
domainprogram_domainDimension
The thematic domain or genre of the program in which an advertisement appears.
final_media_typeDimension
The ultimate classification of the media channel used for the advertisement, after any processing or categorization.
frequencyMetric
The number of times an advertisement was aired or published within a given period.
languagead_languageDimension
The language used in the advertisement.
mediaDimension
The name of the media type (e.g., 'Television', 'Radio', 'Press').
media_codeMetric
A unique identifier for the media type.
mediumDimension
A broader classification of the media channel, often a parent to submedium.
medium_codeMetric
A unique identifier for the broader media channel classification.
origin_country_by_brandDimension
The country of origin associated with the brand.
origin_country_by_subbrandDimension
The country of origin associated with the subbrand.
page_numberMetric
The page number within a publication where a press advertisement appeared.
producerDimension
The entity responsible for producing the advertisement or the program in which it appeared.
productDimension
The name of the specific product being advertised.
product_codeMetric
A unique identifier for the specific product.
prog_sub_typeprogram_sub_typeDimension
A more detailed sub-type or category of the television program.
programtv_program_nameDimension
The name of the television program during which an advertisement was broadcast.
program_detailDimension
Additional detailed information about the program.
program_durationMetric
The total duration of the television program.
program_statusDimension
The current status of the program, e.g., live, rerun, completed.
program_typetv_program_typeDimension
The general type or genre of the television program.
promotion_sponsorshipDimension
Indicates whether an ad is part of a promotion or sponsorship activity.
sectorDimension
The business sector or industry to which the advertiser or brand belongs.
sector_codeMetric
A unique identifier for the business sector or industry.
sizepress_sizeDimension
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.
spaceMetric
The allocated space for an advertisement within a medium, e.g., column inches or percentage of page.
spot_amountDimension
The cost or value associated with a single advertising spot.
spot_durationDimension
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_numberMetric
A sequential identifier for a specific advertising spot within a break or program.
spot_positionDimension
The position of an advertisement within a break or programming block.
spot_visualspotDimension
An identifier or description of the visual creative used for the advertising spot.
spot_visual_codeMetric
A unique identifier for the visual creative used in the advertising spot.
subbrandDimension
The name of a subbrand associated with the main brand.
subbrand_codeMetric
A unique identifier for a specific subbrand under a main brand.
subjectDimension
The main topic or theme of the advertisement or program.
submediumsub_medium_descrDimension
A descriptive name for the sub-medium type (e.g., 'National TV' for 'Television').
submedium_codesub_medium_codeMetric
A unique identifier for the sub-medium type (e.g., specific TV channel within 'Television' medium).
target_by_productDimension
Information about the target audience or market segment for a specific product.
total_breaks_in_programMetric
The total number of advertising breaks within a given television program.
total_page_in_publicationtotal_pages_in_publicationMetric
The total number of pages in the publication where an advertisement appeared.
total_spot_in_breaktotal_spots_in_breakDimension
The total number of advertising spots within a single advertising break.
tv_15_minute_intervaltv_ad_15_minutes_intervalMetric
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_hourtv_program_to_hourMetric
The hour component of the end time for a TV program.
tv_prog_end_time_minutetv_program_to_minuteMetric
The minute component of the end time for a TV program.
tv_prog_end_time_secondtv_program_to_secondMetric
The second component of the end time for a TV program.
tv_prog_from_time_hourtv_program_from_hourMetric
The hour component of the start time for a TV program.
tv_prog_from_time_minutetv_program_from_minuteMetric
The minute component of the start time for a TV program.
tv_prog_from_time_secondtv_program_from_secondMetric
The second component of the start time for a TV program.
typetype_descrDimension
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_sizeDimension
The size characteristics of a visual creative element.