Hudson MX: Most-used fields

The table below gives information about most-used fields that you can import from Hudson MX. 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
advertiser_code	advertiser_code	A unique alphanumeric code assigned to an advertiser.	dimension
advertiser_id	advertiser_id	A unique system-generated identifier for an advertiser.	dimension
advertiser_name	advertiser_name	The full name of the advertiser associated with a campaign or order.	dimension
agency_id	agency_id	A unique system-generated identifier for the agency managing the campaign or order.	dimension
campaign_billing_calendar_type	campaign_billing_calendar_type	Defines the calendar type used for billing calculations within the campaign (e.g., standard, broadcast).	dimension
campaign_billing_cycle_type	campaign_billing_cycle_type	Specifies the billing cycle frequency or method for the campaign (e.g., weekly, monthly, upfront).	dimension
campaign_buyer_user_id	campaign_buyer_user_id	The unique identifier for the user who is the buyer for the campaign.	dimension
campaign_code	campaign_code	A unique alphanumeric code assigned to a specific campaign.	dimension
campaign_cpe	campaign_cpe	Cost Per Engagement (CPE) for the campaign, indicating the cost incurred for each user engagement.	dimension
campaign_daily_weekly_indicator	campaign_daily_weekly_indicator	An indicator distinguishing whether campaign activities or reporting are structured on a daily or weekly basis.	dimension
campaign_demo_type	campaign_demo_type	The demographic type targeted by the campaign (e.g., age, gender, household income).	dimension
campaign_end_age	campaign_end_age	The upper age limit of the demographic target for the campaign.	metric
campaign_end_date	campaign_end_date	The calendar date on which the campaign is scheduled to conclude.	dimension
campaign_group	campaign_group	The group or categorization to which a campaign belongs.	dimension
campaign_hiatus_weeks	campaign_hiatus_weeks	The number of weeks during which the campaign is paused or inactive.	dimension
campaign_id	campaign_id	A unique system-generated identifier for a specific advertising campaign.	dimension
campaign_market_id	campaign_market_id	A unique identifier for a specific market within a campaign, used for market-specific data.	dimension
campaign_market_is_satisfied	campaign_market_is_satisfied	A flag indicating whether the campaign’s market delivery goals have been met.	dimension
campaign_market_name	campaign_market_name	The name of the geographic or demographic market targeted by the campaign.	dimension
campaign_measurement_source_type	campaign_measurement_source_type	The source of the data used for measuring campaign performance (e.g., Nielsen, internal analytics).	dimension
campaign_measurement_type	campaign_measurement_type	The methodology or kind of measurement applied to evaluate the campaign’s success (e.g., GRPs, impressions, reach).	dimension
campaign_media_type	campaign_media_type	The type of media used for the campaign (e.g., TV, radio, digital).	dimension
campaign_metric_type	campaign_metric_type	The primary performance metric type used to track and report on the campaign.	metric
campaign_send_to_vendors	campaign_send_to_vendors	A boolean indicator specifying whether campaign details are to be shared with external vendors.	dimension
campaign_start_age	campaign_start_age	The lower age limit of the demographic target for the campaign.	metric
campaign_start_date	campaign_start_date	The calendar date on which the campaign is scheduled to begin.	dimension
campaign_station_id	campaign_station_id	A unique identifier for the broadcast station associated with the campaign.	dimension
campaign_station_is_nielsen_subscriber	campaign_station_is_nielsen_subscriber	A flag indicating if the station associated with the campaign is a subscriber to Nielsen measurement services.	dimension
campaign_station_mnemonic	campaign_station_mnemonic	A short, memorable code or identifier for the station associated with the campaign.	dimension
campaign_station_name	campaign_station_name	The full name of the broadcast station associated with the campaign.	dimension
campaign_station_system_code	campaign_station_system_code	An internal system-generated code for the station involved in the campaign.	metric
campaign_target_demo	campaign_target_demo	A description of the primary demographic target audience for the campaign.	dimension
campaign_total_market_budget	campaign_total_market_budget	The total allocated budget for the campaign across all markets.	metric
campaign_week_start_day	campaign_week_start_day	The designated day of the week when a campaign week officially begins.	dimension
day	day	A specific day for which data is reported or relevant.	dimension
demo_value	demo_value	The specific value or segment within a demographic type (e.g., ‘18-34’ for age, ‘Female’ for gender).	metric
order_agency_number	order_agency_number	The internal agency number associated with an advertising order.	metric
order_buyer_user_id	order_buyer_user_id	The unique identifier for the user who is the buyer for the order.	dimension
order_deal_type	order_deal_type	The type of agreement or deal under which the order was placed (e.g., scatter, upfront).	dimension
order_end_date	order_end_date	The calendar date on which the advertising order is scheduled to conclude.	dimension
order_id	order_id	A unique system-generated identifier for a specific advertising order.	dimension
order_last_update	order_last_update	The timestamp indicating the last time the order details were modified.	dimension
order_line_avail_line_id	order_line_avail_line_id	An identifier for the specific line item within an availability request that corresponds to this order line.	dimension
order_line_cable_network	order_line_cable_network	The name of the cable network on which the order line item is placed.	dimension
order_line_day_part_code	order_line_day_part_code	A code representing the specific day part (e.g., prime time, morning) for the order line item.	dimension
order_line_deal_number	order_line_deal_number	The unique identifier for the deal associated with this specific order line.	dimension
order_line_demo_category_code	order_line_demo_category_code	A code representing the demographic category targeted by this specific order line.	dimension
order_line_end_time	order_line_end_time	The scheduled end time for the spot or placement within the order line item.	dimension
order_line_external_version	order_line_external_version	An external version identifier for the order line, possibly used for tracking revisions or external system synchronization.	metric
order_line_id	order_line_id	A unique system-generated identifier for a specific line item within an advertising order.	dimension
order_line_rotation_days	order_line_rotation_days	Specifies the days of the week or rotation schedule for spots within this order line.	dimension
order_line_spot_date_of_reference	order_line_spot_date_of_reference	The reference date for a spot within the order line, often indicating the broadcast date.	dimension
order_line_start_time	order_line_start_time	The scheduled start time for the spot or placement within the order line item.	dimension
order_line_week_days_distribution	order_line_week_days_distribution	Describes how spots or budget are distributed across the days of the week for this order line.	metric
order_product_id	order_product_id	A unique identifier for the product being advertised in the order.	dimension
order_product_name	order_product_name	The name of the product being advertised in the order.	dimension
order_rep_number	order_rep_number	The identification number of the sales representative associated with the order.	metric
order_seller_user_id	order_seller_user_id	The unique identifier for the user who is the seller for the order.	dimension
order_start_date	order_start_date	The calendar date on which the advertising order is scheduled to begin.	dimension
order_station_name	order_station_name	The name of the broadcast station where the order is placed.	dimension
order_station_number	order_station_number	The station-specific identification number for the broadcast station where the order is placed.	dimension
order_station_seller_id	order_station_seller_id	The unique identifier for the seller at the station associated with the order.	dimension
order_version_flight_end_date	order_version_flight_end_date	The end date of the flight period for a specific version of an order.	dimension
order_version_flight_start_date	order_version_flight_start_date	The start date of the flight period for a specific version of an order.	dimension
order_version_id	order_version_id	A unique system-generated identifier for a specific version of an advertising order.	dimension
order_version_version	order_version_version	The version number of the advertising order.	metric
rate	rate	The monetary rate charged for an advertising placement.	metric
second_rate	second_rate	A secondary or additional rate applied, potentially for specific time slots, demographics, or conditions.	metric
spot_length	spot_length	The duration of an individual advertising spot, typically in seconds.	metric
spots_per_period	spots_per_period	The number of advertising spots scheduled or delivered within a defined period (e.g., day, week).	metric
station_share	station_share	The percentage share of the audience or market that a specific station captures.	metric
third_rate	third_rate	A third or tertiary rate applied, similar to the second_rate but for another specific condition.	metric
total_market_budget	total_market_budget	The total budget allocated for a campaign or order across all markets.	metric
total_market_grps	total_market_grps	The total Gross Rating Points (GRPs) achieved for a campaign or order across all markets.	metric
total_reached_budget	total_reached_budget	The total budget allocated or spent to achieve the campaign’s reach objectives.	metric
total_reached_grps	total_reached_grps	The total Gross Rating Points (GRPs) achieved by the campaign, indicating the total audience impression.	metric