Index Data Dictionary

The table below provides detail about the performance metrics and data available to you. 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.
  • For Wrapper Pulse API parameters, see here.

Metrics and Data

Metric Type How it's accessed Description
adserver_win_rate Calculated measure Domo

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

Calculation:

impressions / bid_chosen

app_bundle Dimension Domo

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

  • Android ID = string, package name
  • IOS ID = numeric identifier
  • n/a = not applicable
avg_competing_bid_price Calculated measure Domo

Average bid response price for bids that were candidates to compete in the auction (i.e., 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 Domo

Average bid price for all bid types in the entire bid cycle, whether or not 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

Domo

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

bid_below_floor_opportunity

Measure

Domo

Sum of CPM bid prices from bid_below_floor events.

bid_below_floor_rate Calculated measure Domo

Percentage of bid responses that were below the floor rate.

Calculation:

bid_below_floor / total_bids

bid_blocked

Measure

Domo

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

bid_blocked_opportunity

Measure

Domo

Sum of CPM bid prices from bid_blocked events.

bid_blocked_rate

Calculated measure

Domo

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

Calculation:

bid_blocked / total_bids

bid_chosen

Measure

Domo

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

Domo

Sum of CPM bid prices from bid_chosen events.

bid_eligible

Measure

Domo

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.

*also known as eligible_bid in Wrapper Pulse

bid_eligible_opportunity

Measure

Domo

Sum of CPM bid prices from bid_eligible events.

bid_error

Measure

Domo, Wrapper Pulse

The total number of times the system received a response containing an error from the bidder. A broken bid response that has been classified as an error, which can happen for a number of reasons. For example, there could be missing data in the response, such as a bid lower than $0.01.

bid_error_rate

Calculated measure

Domo

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

Domo

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

bid_in_review_opportunity

Measure

Domo

Sum of CPM bid prices from bid_in_review events.

bid_in_review_rate

Calculated measure

Domo

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

Wrapper Pulse

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

bid_outbid_rate

Calculated measure

Domo

Percentage of bids that were outbid.

Calculation:

(bid_eligible + bid_chosen - impressions) / total_bids

bid_pass

Measure

Domo,

Wrapper Pulse

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 Wrapper.

*also known as bid_passes in Wrapper Pulse

bid_pass_rate

Calculated measure

Domo

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

Calculation:

bid_pass / bid_requests

bid_request

Measure

Domo,

Wrapper Pulse

An open RTB bid request sent to a downstream partner (i.e., DSP or bidder) requesting a response for potential impressions.

bid_timeout

Measure

Domo,

Wrapper Pulse

The total number of times a bidder returned a bid after their designated timeout window. Populated when Index Exchange (IX) can determine that a downstream partner timed out, either because a response was not received before the auction closed.

bid_timeout_rate

Calculated measure

Domo

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

Calculation:

bid_timeout / bid_requests

brand_id Integer Domo IX identifier for the brand_name.
brand_name Dimension Domo The product or service being advertised.

browser

Dimension

Domo

  • 4-character browser code
  • unknown = unrecognized browser
buyer_name Dimension Domo The name of the buyer or agency spending an advertising budget to get ads seen.

competing_bids

Calculated measure

Domo

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

Calculation:

bid_eligible + bid_chosen

country

Dimension

Domo

creative_type

Dimension

Domo

The type of advert being requested:

  • Banner
  • Video

day

Dimension

Domo

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

deal_gross_revenue

Measure

Domo

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

deal_id

Dimension

Domo

Corresponds to Open RTB "dealid". An alphanumeric string that represents a private marketplace deal (i.e. what IX signals to DSPs to bid upon).

deal_impressions

Measure

Domo

Total impressions rendered that transacted on a deal_id.

deal_net_revenue

Measure

Domo

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

device_type

Dimension

Domo

The type of device from which the impression originated:

  • Desktop
  • Mobile
  • Other

domain

Dimension

Domo

Populated by the domain extracted from the URL of the slot_request. Returns the top level domain with a public suffix. 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. This does not apply to in-app traffic.

  • n/a = not applicable

dsp_bid_rate

Calculated measure

Domo

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

Domo

IX DSP identifier.

dsp_name Dimension Domo The demand-side platform that represents multiple trading desks.

dsp_win_rate

Calculated measure

Domo

Percentage of impressions served from the competing bids.

Calculation:

impressions / competing_bids

eligible_bid Measure Wrapper Pulse

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

* not to be confused with bid_eligible in Domo

gross_revenue

Measure

Domo

All revenue is measured in USD. Gross revenue for the publisher before share.

hour

Dimension

Domo

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

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

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

  • Unmatched
  • Matched = a new matched user
  • Matched_known = a repeat matched user

impressions

Measure

Domo

When an auction is won in the ad server and a creative is served on a page. This is the total number of impressions, including deal impressions.

inventory_channel

Dimension

Domo

The environment through which the ad is shown.

ix_chosen_rate

Calculated measure

Domo

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

Domo

All revenue is measured in USD. Net revenue for the publisher. Gross IX revenue accounting for transaction type.

noncompeting_bids

Calculated measure

Domo

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

Domo

Device operating system.

  • 4-character operating system code
  • unknown = unrecognized operating system

partner_id

Dimension

Domo

IX publisher identifier

site_id

Dimension

Domo

IX site identifier

size

Dimension

Domo

The size of the advert, in pixels, being requested:

  • Display – advert width by height
  • Video – player width by height

slot_error

Measure

Domo

A catch-all condition for a broken slot response.

slot_pass

Measure

Domo

Populated when there are no competing bids from all DSPs.

slot_request

Measure

Domo

An ad request for a potential impression.

slot_timeout

Measure

Domo

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

slot_valid

Measure

Domo

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

supply_source

Dimension

Domo

The source of the bid request upstream from IX. Where the bid actually comes from. Possible sources include the following:

  • direct (tag-based)
  • adapter – publisher is using IXinside a 3rd party wrapper
  • wrapper – publisher is utilizing the IX Wrapper
  • ebda – publisher is using Google's EBDA product
  • enterprise – publisher is using IX's enterprise product
  • other

total_bids

Calculated measure

Domo

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

trading_desk_id Integer Domo IX identifier for trading desk that indicates the buyer_name.