List of metrics available in Domo

The table below provides detail about the performance metrics and data available to you (formerly the IX Data Dictionary). If you see a reporting metric that you would like access to, please contact your IX Representative.

General Notes

  • All revenue totals appear in US dollars.
  • Blank values display as "omitted".
  • A dimension is a category by which you can group data in a visualization. For example, if you had a bar chart that represented sales by product type, the dimension is product type. In a bar chart, a dimension is usually on the x-axis. In a pie chart, the dimensions are usually the slices of the pie.
  • A measure is a calculation used in visualizations. For example, if you had a bar chart that represented sales by product type, the measure is the total sales in dollars. In a bar chart, a measure is usually on the y-axis. In a pie chart, the measure is usually the sum of each slice's value.
  • A calculated measure is a business-value calculation created using combinations of the core data.

Metrics and Data

Metric Type Description

ad_domain

Dimension

Advertiser domain passed to IX from DSPs.

adserver_win_rate

Calculated measure

Rate of impressions served from the number of bids that were sent to the ad server.

Calculation:impressions / bid_chosen

app_bundle

Dimension

A platform-specific mobile application ID intended to be unique to the application. This dimension does not apply to web or mobile web traffic.

Possible values:

  • android ID = string, package name
  • IOS ID = numeric identifier
  • n/a = not applicable

avg_competing_bid_price

Calculated measure

Average bid response price for bids that were candidates to compete in the auction (that is, bid_eligible and bid_chosen bid response types).

Calculation:

(bid_eligible_opportunity +

bid_chosen_opportunity)

/ (bid_eligible + bid_chosen)

avg_marketplace_bid_price

Calculated measure

Average bid price for all bid types in the entire bid cycle, regardless of whether they were candidates for the auction.

Calculation:

[(bid_below_floor_opportunity +
bid_in_review_opportunity +
bid_blocked_opportunity +
bid_eligible_opportunity +
bid_chosen_opportunity) /
(bid_below_floor + bid_in_review +
bid_blocked +bid_eligible +
bid_chosen)] * 1000

avg_competing_bid_price

Calculated measure

 

Average bid response price for bids that were candidates to compete in the auction (that is, bid_eligible and bid_chosen bid response types).

Calculation:

(bid_eligible_opportunity +
bid_chosen_opportunity)
/ (bid_eligible + bid_chosen)

avg_marketplace_bid_price

Calculated measure

Average bid price for all bid types in the entire bid cycle, regardless of whether they were candidates for the auction.

Calculation:

[(bid_below_floor_opportunity +
bid_in_review_opportunity +
bid_blocked_opportunity +
bid_eligible_opportunity +
bid_chosen_opportunity) /
(bid_below_floor + bid_in_review +
bid_blocked + bid_eligible +
bid_chosen)] * 1000

bid_below_floor

Measure

Populated when a bid response is below the floor price set for the auction.

bid_below_floor_opportunity

Measure

Sum of CPM bid prices from bid_below_floor events.

bid_below_floor_rate

Calculated measure

Percentage of bid responses that were below the floor rate.

Calculation:bid_below_floor / total_bids

bid_blocked

Measure

Populated when the bid is blocked because of the publisher's creative settings.

bid_blocked_opportunity

Measure

Sum of CPM bid prices from bid_blocked events.

bid_blocked_rate

Calculated measure

Percentage of bids blocked, based on the publisher's creative settings.

Calculation:bid_blocked / total_bids

bid_bucket

Dimension

Bid response bucket a bid_stage maps to.

Possible values are:

  • bid_error
  • bid_timeout
  • bid_pass
  • bid_below_floor
  • bid_in_review
  • bid_blocked
  • bid_eligible
  • bid_chosen

bid_chosen

Measure

The highest bid in a given auction that is submitted to the ad server as a candidate to potentially win an impression.

The bid_chosen and bid_eligible responses are mutually exclusive.

bid_chosen_opportunity

Measure

Sum of CPM bid prices from bid_chosen events.

bid_eligible

Measure

A bid response that has no blocks and is eligible to compete in the auction. Unlike bid_chosen responses, eligible bids are not the highest bid of a given auction, and are therefore not sent to the ad server.

Note: This field is not to be confused with eligible_bid in Library Pulse

bid_eligible_opportunity

Measure

Sum of CPM bid prices from bid_eligible events.

bid_error

Measure

The total number of times the system received a response containing an error from the bidder.

For Domo users, this corresponds to bid response errors. For example, a broken bid response that has been classified as an error. This can happen for a number of reasons, including missing data in the response, such as a bid lower than $0.01.

For Library Pulse users, this corresponds to bid response errors as well as IX Wrapper Library errors from IX.

bid_error_rate

Calculated measure

Percentage of bid responses that resulted in errors due to a malformed bid response over the rest of the total bid response types.

Calculation:

bid_error / total_bids

bid_in_review

Measure

Populated when the bid is associated with a campaign that is currently waiting to be reviewed or audited.

bid_in_review_opportunity

Measure

Sum of CPM bid prices from bid_in_review events.

bid_in_review_rate

Calculated measure

Percentage of bid responses that were part of campaigns still in creative review, and so were not candidates to compete in the auction.

Calculation:

bid_in_review / total_bids

bid_latency

Measure

The response times of each individual bidder. This metric tracks the total response time, starting from when the bid request is sent (by the IX Library) and ending when a valid bid is returned (to the IX Wrapper Library). All valid bid responses are divided into a latency bucket based on response time.

bid_outbid_rate

Calculated measure

 

Percentage of bids that were outbid.

Calculation:

(bid_eligible + bid_chosen -

impressions) / total_bids

bid_pass

Measure

Populated when there is a "no bid" response from a downstream partner. The total number of times a bidder passed on a bid request. This metric is based on the number of times a bidder actually submits a pass response (also known as a “no bid” response) to the IX Wrapper Library.

Note: This field is also known as bid_passes in Library Pulse.

bid_pass_rate

Calculated measure

Percentage of passes ("no bid" response) received over the rest of the total bid response types.

Calculation:

bid_pass / bid_requests

bid_request

Measure

An OpenRTB bid request sent to a downstream partner (DSP or bidder) requesting a response for potential impressions.

bid_stage

Dimension

Granular audit log stage to get more information about a bid response.

bid_stage_count

Measure

Count of bids in a particular bid_stage.

bid_stage_opportunity

Measure

Sum of CPM bid prices from corresponding bid_stage events.

bid_timeout

Measure

The total number of times a bid was returned after the designated timeout window. It's populated when IX can determine that a partner timed out.

For Domo users, this indicates the server-side timeout between a DSP and IX.

For Library Pulse users, this indicates the client-side timeout of the adapter, based on the Library UI setup.

bid_timeout_rate

Calculated measure

Percentage of bids that fell outside of the timeout window over the rest of the total bid response types.

Calculation:

bid_timeout / bid_requests

billing_term_id

Integer

 

The unique identifier for the billing_term that was applied on the impression.

Current functionality:

  • ID 0 indicates that the publisher's standard rate was applied. This may change over time as we build out more transaction features.
  • An ID greater than 0 indicates that an Exchange Reduction Fee (XRF) was applied, which you'll see reflected in the pub_rev_share field.

Future functionality may include additional transaction features. In this case, we may add publisher rates or potentially capture all rate types. Please keep this in mind when you are designing your reporting framework.

Note: This field is only available for log files associated with impression event types.

blocked_reason

String

The explicit reason why a combination of dimensions (like a campaign and brand) are blocked by a publisher's campaign settings in the IX app.

brand_id

Integer

IX identifier for the brand_name.

brand_name

Dimension

The product or service being advertised.

browser

Dimension

4-character browser code. unknown = unrecognized browser.

buyer_name

Dimension

The name of the buyer or agency spending an advertising budget to get ads seen.

campaign_id

Dimension

IX identifier for a campaign.

competing_bids

Calculated measure

Total number of bids that were candidates to compete in the auction.

Calculation:

bid_eligible + bid_chosen

consent_status

Measure

The Transparency and Consent Framework (TCF) consent status received by IX for the request. For more information, see TCF 2.0.

  • explicit_consent = the user granted consent to the publisher.
  • explicit_no_consent = the user explicitly declined to grant consent.
  • missing_consent = the consent string was not present in the request.
  • invalid_type_consent = the consent string was present in the request but the format was invalid.
  • malformed_consent = the consent string was present in the request but the string was malformed.
  • parsing_fail = the consent string was present and IX failed to parse it.
  • empty_string_consent = the consent string was present and is empty.

cookie_match_status

Dimension

Cookie match status. Possible values are:

  • matched = IX has a buyeruid for the corresponding DSP.
  • unmatched = IX has no buyeruid for the corresponding DSP.
  • attempted = IX has attempted to reach out to the DSP for a buyeruid, but no response has been received.
  • expired = the buyeruid has exceeded its expiration time and needs to be re-matched.
  • skipped = the DSP has explicitly indicated that IX should not try to obtain a match for this user.

country

Dimension

2-character ISO country code.

unknown = unrecognized country.

creative_type

Dimension

The type of advert being requested.

Possible values:

  • banner
  • video

day

Dimension

Timestamp in UTC (Coordinated Universal Time), floored to the day.

dc_id

Dimension

Identifier for the IX virtual data center.

deal_gross_revenue

Measure

Gross revenue (in USD) associated with private marketplace activity, transacted on deal_id.

deal_id

Dimension

Corresponds to the OpenRTB deal_id An alphanumeric string that represents a private marketplace deal that DSPs can bid on.

deal_impressions

Measure

Total impressions rendered that transacted on a deal_id.

deal_net_revenue

Measure

Net revenue, in USD, associated with private marketplace activity, transacted on deal_id.

device_type

Dimension

The type of device from which the impression originated. Possible values:

  • mobile/tablet = when the UA is from a mobile or tablet like a Samsung galaxy.
  • personal_computer = a Macbook Pro.
  • connected_tv = a TV that has built in connection to the internet, like a Samsung smart TV.
  • phone = an iPhone or Nokia.
  • tablet = an iPad or Amazon Fire HD.
  • connected_device = an Amazon Firestick, Xbox, PlayStation, Apple TV.
  • set_top_box = a Comcast X1 Box (or type of cable box).

device_match_status

Dimension

Device match status. Possible values are:

  • unmatched = none of the deviceIDs supported by the corresponding DSP are present.
  • matched = deviceIDs supported by the corresponding DSP are present.

Note: This field is not applicable for desktop clients (marked as n/a).

discount_amount

Dimension

The dollar amount that a publisher has discounted the final price of the deal transaction. The percentage discount is set by the publisher on the deal as a spend incentive. Bids with this deal setting compete as normal and the discount set by the publisher is applied upon auction win.

Note: This field is only available for log files associated with impression event types.

domain

Dimension

Populated by the domain extracted from the URL of the slot_request.

Returns the top level domain with a public suffix.

For example:

x.adwords.google.co.uk returns google.co.uk, since co.uk is a public suffix.

Similarly, a bid request made from myblog.blogspot.com returns the same domain, myblog.blogspot.com, since blogspot.com is a public suffix.

Note: This dimension does not apply to in-app traffic. n/a = not applicable.

dsp_bid_rate

Calculated measure

Rate that IX received responses from the bid requests that IX sent.

Calculation:

(bid_in_review + bid_blocked +
bid_eligible + bid_chosen +
bid_below_floor + bid_error) /
bid_requests

dsp_id

Dimension

IX DSP identifier.

dsp_name

Dimension

The demand-side platform that represents multiple trading desks.

dsp_win_rate

Calculated measure

Percentage of impressions served from the competing bids.

Calculation:

impressions / competing_bids

eligible_bid

Measure

In Library Pulse, eligible_bid is a bid response type that is returned to the IX Library from all partners within the IX Library that are candidates to compete in the auction.

Note: Not to be confused with bid_eligible in Domo

external_pub_id

Dimension

The publisher identifier, from either an Enterprise partner or Google's EBDA.

external_site_id

Dimension

The site identifier, from either an Enterprise partner or Google's EBDA.

gross_revenue

Measure

Gross revenue for the publisher before share.

Note: All revenue is measured in USD.

hour

Dimension

Timestamp in UTC (Coordinated Universal Time), floored to the hour.

identity_partner_id

Dimension

Real Time Identity (RTI) IX identifier for identity partner. Used to track DSP bidding performance when an RTI adapter is enabled.

identity_status

Dimension

Real Time Identity (RTI) identifier. Indicates status of the user. Possible values are:

  • unmatched
  • matched = a new matched user
  • matched_known = a repeat matched user

impressions

Measure

Specifies the total number of impressions, including deal impressions. An impression occurs when an auction is won in the ad server and a creative is served on a page.

inventory_channel

Dimension

The environment through which the ad is shown. The possible values are:

is_ipv6

Measure

Specifies if the request was made using version 6 of the Internet Protocol (IPv6). For more information on IPv6, see the IPv6 Specification.

ix_chosen_rate

Calculated measure

The percentage of bids that were candidates to compete in the auction that IX sent to the ad server.

Calculation:bid_eligible / bid_chosen

net_revenue

Measure

The publisher's net revenue. All revenue is measured in USD.We provide net_revenue and pub_rev_share to buyers in cases where the publisher has agreed to share this information. Publishers always receive these values.

Note: gross_revenue * pub_rev_share = net_revenue.

Note: This field is only available for log files associated with impression event types.

noncompeting_bids

Calculated measure

Total number of bids that were not candidates to compete in the auction.

Calculation:bid_timeout + bid_error +
bid_below_floor + bid_in_review +
bid_blocked

operating_system

Dimension

4-character device operating system. unknown = unrecognized operating system.

page_url

Dimension

The URL of the webpage where the ad call originated.

Note: This field is only available for log files associated with impression event types.

partner_id

Dimension

IX publisher identifier.

p_id

Key value pairs

Unique identifier for people-based IDs. Only available in certain cases.

p_ids

String

Unique identifiers for people-based IDs that allow Real-Time Identity (RTI) providers to attribute impressions to in-store purchases or conversions for brands. Also allows publishers who enable RTI adapters to curate people-based audiences.

The format is an array of key value pairs wrapped in a string. For example, "1:XYZ12345;32:ABCDEF;4:98765432"

  • The key value pairs are separated by a semicolon (;) delimiter.
  • The key represents the provider_id (for example, 3 = LiveRamp IDL), and the value is the people-based identifier.
  • The keys and values are separated by a colon (:) delimiter.

Note: This field is only available for log files associated with impression event types.

price_levels

Dimension

Price levels set in Google Ad Manager.

pub_rev_share

Dimension

The publisher revenue share, or, the percent of ad spend IX pays out to the publisher. This is a fraction between 0 and 1; when multiplied by 100, you get the percentage value. For example, 0.75 denotes that 75% of ad spend goes to the publisher.

Note: gross_revenue * pub_rev_share = net_revenue.

Note: We provide net_revenue and pub_rev_share to buyers in cases where the publisher has agreed to share this information. Publishers always receive these values. Also, the data in this field may be anonymized in some event logs, in which case the value will be -1.

region

Dimension

Geographical region. The possible values are:

  • EMEA
  • APAC
  • LATAM
  • OTHER

region_market

Dimension

Geographical regions, along with select key countries in those regions. The possible values are:

  • APAC - AU
  • APAC - IN
  • APAC - JP
  • APAC - KR
  • APAC - NZ
  • APAC - OTHER
  • EMEA - DE
  • EMEA - ES
  • EMEA - FR
  • EMEA - IT
  • EMEA - NL
  • EMEA - OTHER
  • EMEA - PL
  • EMEA - TR
  • EMEA - UK
  • LATAM - BR
  • LATAM - MX
  • LATAM - OTHER
  • NA - CA
  • NA - US
  • OTHER

site_id

Dimension

IX site identifier.

size

Dimension

The size of the advert, in pixels, being requested. The possible values are:

  • display = advert width by height
  • video = player width by height

slot_error

Measure

A catch-all condition for a broken slot response.

slot_id

Dimension

Slot identifiers received from a header integration (either IX Library or a third-party wrapper).

slot_pass

Measure

Populated when there are no competing bids from all DSPs.

slot_request

Measure

An ad request for a potential impression.

slot_timeout

Measure

Populated if IX does not respond in time for the publisher's auction.

slot_valid

Measure

A response that is a candidate to win the upstream auction and serve an impression.

state

Dimension

State - US only.

supply_source

Dimension

 

The source of the bid request upstream from IX, which specifies where the bid actually comes from.

  • direct (tag-based)
  • adapter = publisher is using IX inside a third-party wrapper
  • wrapper = publisher is utilizing the IX Library
  • ebda = publisher is using Google's EBDA product
  • enterprise = publisher is using IX's enterprise product
  • other

tcf_version

Measure

A flag on the slot_request (and bid_request) that specifies the version of Transparency and Consent Framework (TCF) in place for the request. For more information on TCF, please read our TCF 2.0 documentation.

total_bids

Calculated measure

Total number of bids, regardless of whether they were ever candidates to compete in an auction.

Calculation:

bid_in_review + bid_blocked +
bid_eligible + bid_chosen +
bid_below_floor + bid_error +
bid_chosen + bid_below_floor +
bid_error

trading_desk_id

Integer

IX identifier for trading desk that indicates the buyer_name.

us_event_code

String

A list of event codes related to the us_privacy field that are applicable to this impression. For more information on privacy and CCPA, see: CCPA. The possible values are:

  • not_USP_regulated = the Consent Management Platform (CMP) has determined that the user is not in a state that is currently affected by US privacy regulations.
  • explicit_OptOut_No = One of the set [1:N:N:Y,1:N:N:N,1:Y:N:Y,
    1:Y:N:N,1:N:N:-
    ,1:Y:N:-,
    1:-:N:Y, 1:-:N:N,1:-:N:-]
    has been received, which means that the user has not opted out.
  • covered_OptOut_Yes = One of the set [1:N:Y:Y, 1:Y:Y:Y, 1:-:Y:Y] has been received, which means that the user has opted out and therefore this is an LSPA-covered transaction.
  • notCovered_OptOut_Yes = One of the set [1:N:Y:N,1:Y:Y:N,1:N:Y:-,1:Y:Y
    :-,1:-:Y:-,1:-:Y:N]
    has been received, which means the user has opted-out but this is not an LSPA-covered transaction
  • USP_Invalid = the user is in the US and the us_privacy field was present in the ad request but the value was incorrect (for example, the string contained invalid data or was simply blank).
  • USP_Missing = the user is in the US but the us_privacy field is absent from the ad request.
  • DAA_Optout = the user has opted out by using the DAA opt-out tool.

video_placement

Enum/

small integer

Specifies the placement type for the impression (based on table 5.9 in the OpenRTB 2.5 Specification). The possible values are:

  • 1 = In-stream. Video is played before, during, or after the streaming video content that the consumer has requested. For example, pre-roll, mid-roll, or post-roll.
  • 2 = In-banner. Exists within a web banner that leverages the banner space to deliver a video experience as opposed to another static or rich media format. The format relies on the existence of display ad inventory on the page for its delivery.

  • 3 = In-article. Loads and plays dynamically between paragraphs of editorial content; existing as a standalone branded message.
  • 4 = In-feed. Found in content, social, or product feeds.
  • 5 = Interstitial/Slider/Floating. Covers the entire or a portion of screen area, but is always on screen while displayed.

video_playback_method

Enum/

small integer

Specifies any playback methods that may be in use (based on table 5.10 in the OpenRTB 2.5 Specification. The possible values are:

  • 1 = Initiates on page load with sound on.
  • 2 = Initiates on page load with sound off by default.
  • 3 = Initiates on click with sound on.
  • 4 = Initiates on mouse-over with sound on.
  • 5 = Initiates on entering viewport with sound on.
  • 6 = Initiates on entering viewport with sound off by default.

video_rewarded

Enum/

small integer

Specifies if the user has opted in to see the video ad in exchange for receiving something of value, for example advancing to a new level in a game.

  • 0 = User did not opt in.
  • 1 = User opted in.

video_skippable

Enum/

small integer

Specifies if the video player allows the user to skip the ad or not.

  • 0 = Ad can't be skipped.
  • 1 = Ad can be skipped.