Avocet: Most-used fields#
The table below gives information about most-used fields that you can import from Avocet. 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.
action Dimension
Represents a specific user interaction or event associated with an ad, such as a click, conversion, or engagement.
app_bundle Dimension
The unique identifier or bundle ID of the mobile application where an ad was displayed.
attribution_mode Dimension
The method used to assign credit for a conversion or other event to a particular ad touchpoint.
billing_period_name Dimension
The name or identifier of the billing period associated with the reported data, used for financial reconciliation and reporting within the programmatic advertising platform.
billing_period_ref_id Dimension
A unique reference ID for the billing period, providing a distinct identifier for financial transactions and reporting cycles.
brand_name Dimension
The name of the brand associated with the advertising campaign. This data is available in performance reports and can be retrieved via the /brand API endpoint.
brand_ref_id Dimension
A unique identifier for the brand associated with the advertising campaign.
browser_name Dimension
The name of the web browser used by the user when viewing the advertisement.
city Dimension
The city from which the ad impression or event originated, used for geographic targeting and reporting.
clicks Metric
The total number of times users interacted with and clicked on the advertisement.
connection_type_name Dimension
The name of the user's internet connection type (e.g., Wi-Fi, 4G, DSL) at the time of the ad interaction.
connection_type_ref_id Dimension
A unique reference identifier for the internet connection type.
conversion_priority Dimension
The priority level assigned to a specific conversion event, often used in optimization strategies.
country Dimension
The country from which the ad impression or event originated, used for geographic targeting and reporting.
country_subdivision Dimension
A geographic subdivision within a country, such as a state, province, or region.
creative_dimensions Dimension
The pixel dimensions (e.g., 300x250) of the ad creative displayed.
creative_height Dimension
The height of the creative asset in pixels.
creative_name Dimension
The name of the creative asset used in the advertisement.
creative_ref_id Dimension
A unique identifier for the creative asset used in the advertisement.
creative_width Dimension
The width of the creative asset in pixels.
cross_device Dimension
Indicates whether a user's journey or conversion involved interactions across multiple devices.
ctr Metric
The Click-Through Rate, calculated as the number of clicks divided by the number of impressions, expressed as a percentage.
currency_code Dimension
The ISO 4217 code for the currency used in financial transactions (e.g., 'USD' for United States Dollar).
currency_name Dimension
The full name of the currency used for financial reporting.
currency_ref_id Dimension
A unique reference identifier for the currency.
currency_symbol Dimension
The symbol representing the currency (e.g., '$', '€').
cv_rate Metric
The Conversion Rate, calculated as the number of conversions divided by the number of impressions or clicks, expressed as a percentage.
day_of_week Dimension
The day of the week (e.g., Monday, Tuesday) when the ad interaction or event occurred.
device_type_name Dimension
The category of device on which the advertisement was displayed (e.g., desktop, mobile, tablet). This field can also be used as a filter in report configuration.
device_type_ref_id Dimension
A unique reference identifier for the type of device used (e.g., mobile, desktop, tablet).
domain Dimension
The internet domain associated with an ad impression, such as the publisher's domain or the referring domain.
ecpa Metric
The Effective Cost Per Action (or Acquisition), calculated as the total cost divided by the number of conversions.
ecpc Metric
The Effective Cost Per Click, calculated as the total cost divided by the number of clicks.
ecpm Metric
The Effective Cost Per Mille (thousand impressions), calculated as the total cost divided by the number of impressions, multiplied by 1000.
erpa Metric
The Effective Revenue Per Action, calculated as the total revenue generated divided by the number of actions or conversions.
erpc Metric
The Effective Revenue Per Click, calculated as the total revenue generated divided by the number of clicks.
erpm Metric
The Effective Revenue Per Mille (thousand impressions), calculated as the total revenue generated divided by the number of impressions, multiplied by 1000.
events Metric
The total count of specified events that occurred within the reporting period.
fee Metric
The amount charged or incurred as a fee for programmatic advertising activities, contributing to overall ad spend.
fee_currency_name Dimension
The name of the currency in which the fee is denominated (e.g., 'US Dollar', 'Euro').
fee_currency_symbol Dimension
The symbol representing the currency of the fee (e.g., '$', '€').
fee_ecpm Metric
The effective cost per thousand impressions (eCPM) for the specific fee, calculated to understand the cost efficiency relative to ad views.
fee_usd Metric
The fee amount converted and reported in United States Dollars (USD) for standardized financial analysis.
fee_usd_ecpm Metric
The effective cost per thousand impressions (eCPM) for the fee, converted and reported in United States Dollars (USD).
fees Metric
An aggregation or collection of various fees associated with the programmatic advertising campaigns and platform usage.
hour_of_day Dimension
The hour of the day (0-23) when the ad interaction or event occurred, used for granular time-based reporting.
hour_of_week Dimension
The hour within the week (0-167) when the ad interaction or event occurred.
impression_type Dimension
The specific type of ad impression (e.g., display, video, native).
impressions Metric
The total number of times an advertisement was displayed to users.
insertion_order_name Dimension
The name of the insertion order, which is a contractual agreement that outlines the terms of an advertising campaign.
insertion_order_ref_id Dimension
A unique identifier for the insertion order.
inventory_ref_id Dimension
A unique reference identifier for the ad inventory where the ad was displayed.
inventory_source_name Dimension
The name of the source or publisher providing the ad inventory.
inventory_source_ref_id Dimension
A unique reference identifier for the inventory source.
language_name Dimension
The name of the language associated with the user or the content where the ad was served.
language_ref_id Dimension
A unique reference identifier for the language.
measurable_impressions Metric
The number of impressions that were measurable for viewability according to industry standards.
month Dimension
The month of the year when the ad interaction or event occurred.
month_of_year Dimension
The numerical representation of the month within the year (1-12).
operating_system_name Dimension
The name of the operating system (e.g., iOS, Android, Windows) of the device on which the ad was displayed.
operating_system_ref_id Dimension
A unique reference identifier for the operating system.
order_revenue Metric
The total revenue generated from orders attributed to advertising efforts.
page_domain Dimension
The internet domain of the webpage where the ad was displayed.
page_position_name Dimension
The descriptive name of the ad's position on a webpage (e.g., 'Above the Fold', 'Sidebar').
page_position_ref_id Dimension
A unique reference identifier for the ad's position on a page.
post_click_conversions Metric
The number of conversions attributed to a user clicking on an advertisement.
post_click_cv_rate Metric
The post-click conversion rate, measuring the percentage of users who convert after clicking on an ad.
post_code Dimension
The postal code associated with the user's location, used for geographic targeting and reporting.
post_view_conversions Metric
The number of conversions attributed to a user viewing an advertisement without clicking it.
post_view_cv_rate Metric
The post-view conversion rate, measuring the percentage of users who convert after seeing an ad but not clicking on it.
post_viewable_conversions Metric
The number of conversions attributed to viewable ad impressions.
post_viewable_cv_rate Metric
The post-viewable conversion rate, measuring the percentage of users who convert after a viewable ad impression.
referer_domain Dimension
The domain of the webpage that referred the user to the page where the ad was displayed.
request_domain Dimension
The internet domain from which the ad request originated.
revenue Metric
The total gross revenue generated from advertising activities.
serving_fees Metric
Fees specifically incurred for the delivery or serving of advertisements.
source_device_type_name Dimension
The name of the device type (e.g., 'Mobile', 'Desktop', 'Tablet') from which the ad request originated.
source_device_type_ref_id Dimension
A unique reference identifier for the source device type.
supply_type_name Dimension
The name of the supply channel or inventory type (e.g., 'Web', 'In-App', 'Video').
supply_type_ref_id Dimension
A unique reference identifier for the supply type.
total_conversions Metric
This field represents the total number of conversion events recorded for advertising campaigns within the specified reporting period. Conversions can include various desired actions like purchases, sign-ups, or app installs.
total_cost_dollars Metric
The total advertising cost in US Dollars.
total_cost_dollars_inc_serving_fees Metric
The total advertising cost in US Dollars, including all serving fees.
total_cost_insertion_order_currency Metric
The total advertising cost in the native currency specified by the insertion order.
total_cost_insertion_order_currency_inc_serving_fees Metric
The total advertising cost in the native currency specified by the insertion order, including all serving fees.
vcpm Metric
The Viewable Cost Per Mille (thousand viewable impressions), calculated as total cost divided by the number of viewable impressions, multiplied by 1000.
video_average_percentage_completed Metric
The average percentage of a video ad that users watched before stopping or skipping.
video_completion_rate Metric
The percentage of video ads that were played to 100% completion.
video_completions Metric
The number of times a video advertisement was played entirely to its conclusion.
video_cost_per_completion Metric
The average cost incurred for each video ad completion.
video_fill_rate Metric
The percentage of video ad requests that were successfully filled with an ad.
video_interaction_rate Metric
The rate at which users interacted with a video ad (e.g., clicks, unmute, pause).
video_preimpressions Metric
Counts the number of times a video advertisement was loaded or prepared to be displayed, prior to being counted as a standard video impression.
video_quartile_25_count Metric
The number of times a video advertisement was played for at least 25% of its total duration.
video_quartile_50_count Metric
The number of times a video advertisement was played for at least 50% of its total duration.
video_quartile_75_count Metric
The number of times a video advertisement was played for at least 75% of its total duration.
video_revenue_per_completion Metric
The average revenue generated for each video ad completion.
video_start_rate Metric
The percentage of video ads that began to play after being requested.
video_starts Metric
The number of times a video advertisement began playing.
view_duration Metric
The total duration in seconds that an ad creative was considered viewable by a user.
viewability_rate Metric
The percentage of ad impressions that met the industry standard for viewability (e.g., 50% of pixels in view for 1 second for display ads).
viewable_impressions Metric
The number of impressions that were deemed viewable according to established industry standards.
vrpm Metric
The Viewable Revenue Per Mille (thousand viewable impressions), calculated as total revenue divided by the number of viewable impressions, multiplied by 1000.
week_of_year Dimension
The week number within the year (1-52 or 53) when the ad interaction or event occurred.
ymd Dimension
The date for which the programmatic advertising data is reported or aggregated. This field is used to define the reporting period for the collected data.
ymdh Dimension
A concatenated timestamp representing Year, Month, Day, and Hour, used for precise time-based reporting.