List of Client Audit Logs fields

The following tables describe the data recorded in each CAL file. You can view the data for impression event or bid event CAL files.

Each row in the file contains a record for a single event, and each column contains a piece of collected data. For example, each row of an impression event client audit log file contains details about a single impression, within the hour for which data was collected.

Impression event CAL files

The columns below are listed in the same order in which they appear in the CAL file:

Field Data type Description

auction_id

String

Unique identifier of the associated auction.

Note: The data in this field may be anonymized in some bid event log types, in which case the value will be XXXXX.

timestamp

String

Timestamp in UTC.

country

 

String

 

Two-character ISO country code, where:

unknown = unrecognized country.

state

String

Code = state and province.

dma

String

Designated market area (DMA).

zip_postal

String

Zip or postal code.

device_type

String

The type of device from which the impression originated (desktop, mobile, or other).

operating_system

String

3-character device operating system (unknown = unrecognized operating system).

browser

String

3-character browser code (unknown = unrecognized browser).

partner_id

Long

IX publisher identifier.

site_id

Integer

IX site identifier.

creative_type

String

The type of advert being requested (banner or video).

domain

String

Populated by the domain used in the bid request. Returns the top level domain with a public suffix (n/a = not applicable).

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 does not apply to in-app traffic.

app_bundle

String

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

inventory_channel

String

The environment through which the advert is shown:

Web (browser)

AMP (Accelerated Mobile Pages)

In-app

Other

supply_source

String

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

slot_id

String

Identifier for the slot.

size

String

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

Display = Width by height

Video = Player width by height

event_type

String

Denotes the type of event shared in the log file. An impression event is logged when an auction is won in the ad server and a creative is served on a page. A bid event is logged with the DSP's response to the bid request. Possible values in your client audit logs for impression events and bid events are below:

impression = An auction is won in the ad server and a creative is served on a page.

bid_chosen = The highest bid in a given auction that is submitted to the ad server as a candidate to potentially win an impression. This field and the bid_eligible field are mutually exclusive.

bid_eligible = The bid response 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.

bid_below_floor = the bid falls below the floor price set for the auction.

bid_in_review = The bid is associated with a campaign that is currently waiting to be reviewed or audited.

bid_error = The bid is unusable because it is classified as an error, which can be caused by a number of things. For example, the bid falls below the minimum bid of $0.01.

bid_timeout = The bid was returned outside the bidder's designated bid timeout window.

bid_pass = An explicit "no bid" pass response from a downstream partner.

event_opportunity

Double

Bid value/opportunity value for the event type (bid value for bids and impressions).

gross_revenue

Double

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

net_revenue

Double

Net revenue for the publisher. 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.

gross_revenue * pub_rev_share = net_revenue.

dsp_id

Integer

IX DSP identifier.

trading_desk_id

Long

IX Trade Desk identifier.

campaign_id

Long

Identifier for the campaign.

Note: The data in this field may be anonymized in some bid event log types, in which case the value will be -1.

campaign_name

String

Campaign name mapping.

brand_id

Long

Identifier for the brand.

Note: The data in this field may be anonymized in some bid event log types, in which case the value will be -1.

brand_name

String

Brand name mapping.

creative_id

Integer

Identifier for the creative.

creative_name

String

Creative name mapping.

deal_id

String

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

p_id

Key value pairs

Unique identifier for people-based IDs (only available in certain cases).

The format uses key value pairs. The first value is the provider_id, and the second value is the identifier. For example, [1:XYZ12345],[32:ABCDEF],[4:98765432]

audience_id

String

Audience identifier (only available in certain cases).

internal_deal_id

Long

Internal IX deal identifier.

cookie_match_status

String

Cookie match status.

matched = IX has a buyeruid for the corresponding DSP.

unmatched = IX doesn't have a buyeruid for the corresponding DSP.

a_domain

String

Advertiser domain passed to IX from DSPs.

page_url

String

URL of the webpage where the ad call originated.

pub_rev_share

Double

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.

Tip: 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.

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 (XFR) 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 rates types. Please keep this in mind when designing your reporting framework.

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

discount_amount

Double

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.

Bid event CAL files

The columns below are listed in the same order in which they appear in the CAL file:

Field Data type Description

auction_id

String

Unique identifier of associated auction.

Note: The data in this field may be anonymized in some bid event log types, in which case the value will be XXXXX.

timestamp

String

Timestamp in UTC.

country

 

String

 

Two-character ISO country code.

unknown = unrecognized country.

state

String

Code = state and province.

dma

String

Designated market area (DMA).

zip_postal

String

Zip or postal code.

device_type

String

The type of device from which the impression originated (desktop, mobile, or other).

operating_system

String

3-character device operating system (unknown = unrecognized operating system).

browser

String

3-character browser code (unknown = unrecognized browser).

partner_id

Long

IX publisher identifier.

site_id

Integer

IX site identifier.

creative_type

String

The type of ad being requested (banner or video).

domain

String

Populated by the domain used in the bid request. Returns the top level domain with a public suffix (n/a = not applicable).

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 does not apply to in-app traffic.

app_bundle

String

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

inventory_channel

String

The environment through which the advert is shown:

Web (browser)

AMP (Accelerated Mobile Pages)

In-app

Other

supply_source

String

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

slot_id

String

Identifier for the slot.

size

String

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

Display = width by height

Video = player width by height

event_type

String

Denotes the type of event shared in the log file. An impression event is logged when an auction is won in the ad server and a creative is served on a page. A bid event is logged with the DSP's response to the bid request. Possible values in your client audit logs for impression events and bid events are below:

impression = an auction is won in the ad server and a creative is served on a page.

bid_chosen = the highest bid in a given auction that is submitted to the ad server as a candidate to potentially win an impression. This field and the bid_eligible field are mutually exclusive.

bid_eligible = the bid response 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.

bid_below_floor = the bid falls below the floor price set for the auction.

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

bid_error = the bid is unusable because it is classified as an error, which can be caused by a number of things. For example, the bid falls below the minimum bid of $0.01.

bid_timeout = the bid was returned outside the bidder's designated bid timeout window.

bid_pass = an explicit "no bid" pass response from a downstream partner.

event_opportunity

Double

Bid value/opportunity value for the event type (bid value for bids and impressions).

net_revenue

Double

Net revenue for the publisher. 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.

Tip: gross_revenue * pub_rev_share = net_revenue.

dsp_id

Integer

IX DSP identifier.

trading_desk_id

Long

IX Trade Desk identifier.

campaign_id

Long

Identifier for the campaign.

Note: The data in this field may be anonymized in some bid event log types, in which case the value will be -1.

brand_id

Long

Identifier for the brand.

Note: The data in this field may be anonymized in some bid event log types, in which case the value will be -1.

creative_id

Integer

Identifier for the creative.

Note: The data in this field may be anonymized in some bid event log types, in which case the value will be -1.

deal_id

String

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

audience_id

String

Audience identifier (only available in certain cases).

internal_deal_id

Long

Internal IX deal identifier.

cookie_match_status

String

Cookie match status.

matched = IX has a buyeruid for the corresponding DSP.

unmatched = IX doesn't have a buyeruid for the corresponding DSP.

a_domain

String

Advertiser domain passed to IX from DSPs.

Note: The data in this field may be anonymized in some bid event log types, in which case the value will be XXXXX.

bid_stage

String

Granular information about a bid response event, such as bid error or blocked bid. Possible values in your client audit logs are listed below:

rejected_campaign

invalid_dealid

blocked_by_publisher

blocked_brand

exclusive_brand

response_validation

http_error

bid_below_onecent

response_too_large

response_validation_video

internal_error

invalid_encryption

min_bid_to_win

Double

The bid you would have needed to submit in order to surpass all other bidders and seller-wide floors in the IX auction. This field is only included if your bid lost the auction.

Note: This field does not apply to auctions that were won by a deal bid.

pub_rev_share

Double

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.

Tip: 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.