Reporting Keys and Values

When generating a report, data is usually displayed only for particular key(s) and broken down by data columns to get their values. u-Slicer allows you to select the keys using the filters function, and have this data returned along with its related values. For BidCore partners, the following keys can be queried and the resultant data displayed based on the following values from both the reporting UI and API.

Key Descriptions

u-Slicer Key Descriptions

API

UI

Description

anomaly_segment

Detected Fraud Source

The number of fraudulent clicks caught by impression anomaly and the source of those issues

audience_segments_list

Audience Segment

Indicates the audience segment, see the Audience Segments Overview section for more details.

bid_context.demand.creative_moat_targeted_viewability

Target Prebid VR (Moat)

Indicates the targeted viewability value by Moat

bid_context.demand.creative_predicted_viewabilities_moat

Prebid Viewability (Moat)

Viewability value predicted by Moat

bid_context.demand.creative_viewability_vendors

Viewability Vendor

The provider of the viewability metric

bid_context.demand.extended_tapad_segments

Extended Tapad Segments

Indicates the extended TapAd segment, see the Vendors And Services section for more details on TapAd

bid_context_wrapper.bid.ssp

SSP

The Supplier from whom you bought inventory

bid_context_wrapper.demand.advertiser_id

Advertiser

The advertiser ID matching the ID from the BidCore UI

bid_context_wrapper.demand.campaign_id

Campaign

The campaign ID matching the ID from the BidCore UI

bid_context_wrapper.demand.creative_id

Creative

The creative ID matching the ID from the BidCore UI

bid_context_wrapper.demand.creative_size

Creative Size

The creative size served to the user

bid_context_wrapper.demand.deal_id

Deal ID

The deal ID

bid_context_wrapper.demand.landing_page_domains

Landing Page

The landing page where the Ad took the user, e.g. fancynewshoes.com

bid_context_wrapper.demand.line_item_id

Line Item

The line item matching that in the BidCore UI

bid_context_wrapper.demand.strategy_id

Strategy

The strategy set on the line item

bid_context_wrapper.demand.tag_type

Creative Tag Type

Indicates the creative tag type used, e.g. iframe

bid_context_wrapper.demand.targeted_grapeshot_channels

Oracle Category Targeted (Grapeshot)

All targeted Oracle (Grapeshot) categories. Includes contextual, brand safety and custom categories

bid_context_wrapper.supply.ads_txt_status

Ads.txt Status

Indicates the supplier’s status as per the ads.txt file hosted by publisher

bid_context_wrapper.supply.app_bundle

App Bundle

The app bundle passed in the bid request

bid_context_wrapper.supply.bundle_lists

App Bundle List ID

The app bundle list ID matching the ID from the BidCore UI

bid_context_wrapper.supply.content_type

Content Type

The content time, i.e. native, display, or video.

bid_context_wrapper.supply.country_postcode_lists

Postcode List ID

The postcode list ID matching the ID from the BidCore UI

bid_context_wrapper.supply.dmp_segments.bluekai_segments

Bluekai Audience Segments

Indicates the Bluekai audience segment, see the BlueKai Segments section for details

bid_context_wrapper.supply.dmp_segments.liveramp_segments

Liveramp Audience Segments

Indicates the Liveramp audience segment, see the LiveRamp Data Marketplace section for details

bid_context_wrapper.supply.domain_lists

Domain List ID

The domain list ID matching the ID from the BidCore UI

bid_context_wrapper.supply.ec_domain

Page Domain

Specifies the page domain, e.g. forbes.com

bid_context_wrapper.supply.grapeshot_channels

Oracle Categories (Grapeshot)

Indicates Oracle (Grapeshot) categories: standard contextual, standard brand safety, custom contextual, custom brand safety

bid_context_wrapper.supply.has_predicted_viewability_moat

Bids with Prebid Viewability (Moat)

Bids with Moat viewability measurement applied

bid_context_wrapper.supply.instl

Is Interstitial Ad

Interstitial ads are full-screen. They are presented to users as natural transitions during in-app experience. Interstitial ads are deployed to monetize apps without interfering with user experience.

bid_context_wrapper.supply.is_interstitial_video

Is Interstitial Video

Indicates whether the video was interstitial

bid_context_wrapper.supply.is_video_rewarded

Rewarded Video

Rewarded video is a type of video placement specific for in-app that rewards users for watching full-screen ads in exchange for a particular in-app reward.

bid_context_wrapper.supply.pmp_deal_ids

Request Deal IDs

The deal ID send in the bid request

bid_context_wrapper.supply.publisher_id

Publisher ID

The Pub ID, uses the ssp-name_pub-id format, e.g.``emxdigital_855``

bid_context_wrapper.supply.site_id

Site ID

Specifies the Site ID, uses the ssp-name_site-id format, e.g adconductor_1059622079

bid_context_wrapper.supply.url_lists

URL List ID

The URL list ID matching the ID from the BidCore UI

bid_context_wrapper.supply.video_placement_type

Placement Type (Video)

Indicates the video placement type:

  • 1: in-stream

  • 3: in-article

  • 4: in-feed

bid_context_wrapper.supply.video_skip

Skippable Video

Indicated whether the video can be skipped

bid_context_wrapper.supply.video_skipafter

Skip Video After (Seconds)

Indicates the number of seconds after which the video can be skipped, e.g. 5

bid_context_wrapper.supply.visibility

Page Position

Indicated the pages position, e.g. Above the fold

bid_context_wrapper.user.agent.browser.name

Browser

Specifies the browser name, e.g Chrome

bid_context_wrapper.user.agent.browser.version

Browser Version

Specifies the browser name, e.g Chrome_78

bid_context_wrapper.user.agent.device.maker

Device Manufacturer

Specifies the device model, e.g. samsung

bid_context_wrapper.user.agent.device.model

Device Model

Specifies the device model, e.g. Samsung_Nexus_10

bid_context_wrapper.user.agent.device.type

Device Type

Specifies the device type, e.g. phone

bid_context_wrapper.user.agent.os.name

OS

The operating system of the device from where the request originated.

bid_context_wrapper.user.agent.os.version

OS Version

Specifies the Operating System, e.g. Android

bid_context_wrapper.user.ec_geo.digital_element_country

Country (2.0)

Specifies the country in which the impression was displayed, as defined in the bid request using the Digital Element database

bid_context_wrapper.user.ec_geo.digital_element_country_region

Region (2.0)

Specifies the state in which the impression was displayed, as defined in the bid request using the Digital Element database

bid_context_wrapper.user.ec_geo.digital_element_postal_code

Postal code (PcT)

The Postcode, as defined in the bid request using the Digital Element database

bid_context_wrapper.user.ec_geo.digital_element_postal_ext

Postal code extended (PcT)

Extended postcode format, specific to some countries (including the UK), as defined in the bid request using the Digital Element database

bid_context_wrapper.user.geo.city

City (1.0)

Specifies the city in which the impression was displayed

bid_context_wrapper.user.geo.country

Country (1.0)

Specifies the country in which the impression was displayed, as defined in the bid request using the MaxMind database

bid_context_wrapper.user.geo.country_region

Region (1.0)

Specifies the state in which the impression was displayed, as defined in the bid request using the MaxMind database

bid_context_wrapper.user.geo.dma

DMA

Specifies the Designated Market Area (DMA) code, e.g. 501 = New York, you can find a complete listing here: https://help.ooyala.com/video-platform/reference/dma_codes.html

bid_context_wrapper.user.geo.zip

Postal Code

The post code / zip code associated with the user.

blocked_adv_categories

Blocked Content Categories

Specified the blocked advertiser categories, e.g. IAB7-41

content_categories

IAB Content Categories

Indicates the content categories, e.g. IAB14

conversion_id

Conversion ID

Specifies the conversion ID, e.g. 123458

cross_device_source

User ID Source

The source of a unique user identifier (TapAd ID or IP address) used for cross-device conversion tracking

granularity_day

Day

Returns data broken down by day.

granularity_hour

Day & Hour

Returns data hourly

granularity_month

Month

Returns data broken down by month.

granularity_quarter

Quarter

Returns data broken down by quarter.

granularity_week

Week

Returns data broken down by week.

granularity_year

Year

Returns data broken down by year.

hour_str

Time of Day

Returns data hourly

is_app

Traffic Type

Indicates whether the impression was app or site, returns the following values application, website

is_secure_request

Protocol

Indicates whether the ads was served over HTTP or HTTPS

languages_list

Browser Language

The browser language

liveramp_first_party_segments_list

Liveramp First Party Segments

Indicates the Liveramp first party audience segment, see the LiveRamp First Party Audiences section for more details

requested_sizes

Requested Creative Size

Specifies the requested creative size e.g. 728x90

segments_list

Pixel Segment

Indicates the pixel segment ID set in the BidCore UI

Value Descriptions

u-Slicer Value Descriptions

API

UI

Description

adv_ecpc

Advertiser CPC

The CPC (cost per click) calculated using the Advertiser Spend. If you have margin and/or fees in place, this CPC would be higher than eCPC (calculated using Actual Media Cost)

adv_ecpm

Advertiser CPM

The CPM (cost per thousand impressions) calculated using the Advertiser Spend. If you have margin and/or fees in place, this CPM would be higher than eCPM (calculated using Actual Media Cost)

adv_ecpv_complete

Target CPV (completed view)

Videos which were viewed to 30 seconds

adv_ecpv_progress_30

Target CPV (30 seconds)

Videos which were viewed to 30 seconds

anomaly_clicks_filtered

Fraudulent Clicks Filtered

Clicks detected as fraud. They are not included into Clicks value

attributed_pc_convs

Attributed PCC

Post click conversions

attributed_pv_convs

Attributed PVC

Post view conversions

audience

Audience

Calculated audience based on user IDs approximation

avails

Bid Requests

The total number of bid requests received by this key. Consists of Yes Bids and No Bids combined

bid_amount

Bid Amount

Every bid made in the auctions contains a CPM price. Bid Amount is the sum of all CPMs in all the bids made (Yes Bids). Calculated in the advertiser currency

bid_amount_usd

Bid Amount (USD)

Every bid made in the auctions contains a CPM price in USD. Bid Amount is the sum of all CPMs in all the bids made (Yes Bids). Calculated in USD

bid_rate

Bid Rate

The percentage of Yes Bids in all Bid Requests: shows how often BidCore bids on incoming requests for a particular key

bids

Yes Bids

When BidCore receives a Bid Request that matches any ads, it tries to win the auction by placing a bid. Yes Bids is the number of Bid Requests that BidCore did bid on. When placing a bid, BidCore bids with a CPM price in USD$. The sum of all CPMs in all Yes Bids comprises Bid Amount

clicks

Clicks

The number of click through events generated

complete_view_rate

Video Completed View Rate

Videos which were viewed to 30 seconds

ctr

CTR

Click through rate is calculated as the number of Clicks divided by the number of Impressions. A higher CTR means users click on ads more often

custom_viewable

Viewable Imps (custom)

Indicates the number of impressions deemed viewable by Moat

custom_measurable

Measurable Imps (custom)

The number of impressions which could be measured against a performance metric (Moat)

fees.bluekai

Bluekai Fee

The Bluekai fee applied for the use of Bluekai 3rd party segments, see BlueKai Segments section for more details. Calculated in the advertiser currency

fees.bluekai_usd

Bluekai Fee (USD)

The Bluekai fee applied for the use of Bluekai 3rd party segments, see BlueKai Segments section for more details. Calculated in USD

fees.custom_1

Custom Fee

The first Custom Fee set in the Custom Fee section of Line Item settings. Calculated in the advertiser currency

fees.custom_1_usd

Custom Fee (USD)

The first Custom Fee set in the Custom Fee section of Line Item settings. Calculated in USD

fees.custom_2

Custom Fee 2

The second Custom Fee set in the Custom Fee section of Line Item settings. Calculated in the advertiser currency

fees.custom_2_usd

Custom Fee 2 (USD)

The second Custom Fee set in the Custom Fee section of Line Item settings. Calculated in USD

fees.custom_3

Custom Fee 3

The third Custom Fee set in the Custom Fee section of Line Item settings. Calculated in the advertiser currency

fees.custom_3_usd

Custom Fee 3 (USD)

The third Custom Fee set in the Custom Fee section of Line Item settings. Calculated in USD

fees.custom_4

Custom Fee 4

The fourth Custom Fee set in the Custom Fee section of Line Item settings. Calculated in the advertiser currency

fees.custom_4_usd

Custom Fee 4 (USD)

The fourth Custom Fee set in the Custom Fee section of Line Item settings. Calculated in USD

fees.custom_5

Custom Fee 5

The fifth Custom Fee set in the Custom Fee section of Line Item settings. Calculated in USD

fees.custom_5_usd

Custom Fee 5 (USD)

The fifth Custom Fee set in the Custom Fee section of Line Item settings. Calculated in USD

fees.grapeshot_brandsafety

Oracle Brand Safety Fee (Grapeshot)

The Oracle fee applied for targeting based on Grapeshot brand safety categories, see the Line Item Management section for more details. Calculated in the advertiser currency

fees.grapeshot_brandsafety_usd

Oracle Brand Safety Fee (Grapeshot) (USD)

The Oracle fee applied for targeting based on Grapeshot brand safety categories, see the Line Item Management section for more details. Calculated in USD

fees.grapeshot_contextual

Oracle Contextual Fee (Grapeshot)

The Oracle fee applied for targeting based on Grapeshot content categories, see the Line Item Management section for more details. Calculated in the advertiser currency

fees.grapeshot_contextual_usd

Oracle Contextual Fee (Grapeshot) (USD)

The Oracle fee applied for targeting based on Grapeshot content categories, see the Line Item Management section for more details. Calculated in USD

fees.grapeshot_custom

Oracle Custom Categories Fee (Grapeshot)

The Oracle fee applied for targeting based on custom contextual and brand safety categories, see the Line Item Management section for more details. Calculated in the advertiser currency

fees.grapeshot_custom_usd

Oracle Custom Categories Fee (Grapeshot) (USD)

The Oracle fee applied for targeting based on custom contextual and brand safety categories, see the Line Item Management section for more details. Calculated in USD

fees.liveramp

Liveramp Fee

The Liveramp fee applied for the use of Liveramp 3rd party segments, see LiveRamp Data Marketplace section for more details. Calculated in the advertiser currency

fees.liveramp_usd

Liveramp Fee (USD)

The Liveramp fee in USD, applied for the use of Liveramp 3rd party segments, see LiveRamp Data Marketplace section for more details. Calculated in USD

fees.moat

Moat Prebid Fee

The Moat prebid fee applied for targeting content which has historically met a specific viewability threshold (i.e. “at least 80% viewable) based on the Moat viewability. Calculated in the advertiser currency

fees.moat_usd

Moat Prebid Fee (USD)

The Moat prebid fee applied for targeting content which has historically met a specific viewability threshold (i.e. “at least 80% viewable) based on the Moat viewability. Calculated in USD

fees.tapad

Tapad Fee

The Tapad fee applied for the use of Tapad Audience Extension graph targeting individual users cross-device or all users in a household location. Calculated in the advertiser currency

fees.tapad_usd

Tapad Fee (USD)

The Tapad fee applied for the use of Tapad Audience Extension graph targeting individual users cross-device or all users in a household location. Calculated in USD

imps

Impressions

The total number of impressions served to users

installs

Installs

The total number of installs

landings

Landings

The number of landing pixel events

margin

Media Margin

If you have the Margin percentage specified in buying strategies (when applicable), this value represents the amount of margin on media in USD$. It is calculated as the Advertiser Spend minus Actual Media Cost

inhouse_measurable

Measurable Imps

The number of impressions which could be measured against a performance metric

nobids

No Bids

The number of Bid Requests BidCore didn’t bid on, as there were no ads matching these requests

original_media_cost

SSP Original Media Cost

The pure cost of purchased media without any fees, i.e. the money BidCore owes to publishers on your behalf for placing your ads. Together with Custom Fee (if present) it makes the Actual Media Cost. Calculated in the advertiser currency

original_media_cost_usd

SSP Original Media Cost (USD)

The pure cost of purchased media without any fees, i.e. the money BidCore owes to publishers on your behalf for placing your ads. Together with Custom Fee (if present) it makes the Actual Media Cost. Calculated in USD

payout.actual_pub

Actual Media Cost

Consists of the SSP Original Media Cost (the cost of purchased media = what BidCore owes to the publishers), all vendor fees applied and the Custom Fee if you set any and activated “Include in total media cost” checkbox. Calculated in the advertiser currency

payout.actual_pub_usd

Actual Media Cost (USD)

Consists of the SSP Original Media Cost (the cost of purchased media = what BidCore owes to the publishers), all vendor fees applied and the Custom Fee if you set any and activated “Include in total media cost” checkbox. Calculated in USD

payout.adv_payout

Advertiser Spend

If you use the Margin field in buying strategies (if applicable), it means you include some margin into Actual Media Cost. The sum of Actual Media Cost and Margin becomes “Advertiser Spend”, i.e. the money you would ultimately charge your advertisers. With 0% margin, Advertiser Spends equals Actual Media Cost. Calculated in the advertiser currency

payout.adv_payout_usd

Advertiser Spend (USD)

If you use the Margin field in buying strategies (if applicable), it means you include some margin into Actual Media Cost. The sum of Actual Media Cost and Margin becomes “Advertiser Spend”, i.e. the money you would ultimately charge your advertisers. With 0% margin, Advertiser Spends equals Actual Media Cost. Calculated in USD

pc_convs

Post-Click Conversions (PCC)

Post click conversion

pcc_rate

PCC Rate

Post-click conversion / impressions

progress_30_view_rate

Video 30 Second View Rate

Videos which were viewed to 30 seconds

pub_ecpc

eCPC

The effective Cost Per Click, calculated as Actual Media Cost divided by the number of Clicks

pub_ecpm

eCPM

The effective CPM (cost per thousand impressions), calculated as Actual Media Cost divided by the number of Impressions and multiplied by 1000

pub_ecpv_complete

eCPV (completed view)

Advertiser spend / vast_complete

pub_ecpv_progress_30

eCPV (30 seconds)

Advertiser spend / vast_progress_30

pv_convs

Post-View Conversions (PVC)

Post-view conversions

pvc_rate

PVC Rate

Post-view conversions / impressions

vast_25

VAST Events (25% complete)

Videos which triggered the VAST firstQuartile event

vast_50

VAST Events (50% complete)

Videos which triggered the VAST midPoint event

vast_75

VAST Events (75% complete)

Videos which triggered the VAST thirdQuartile event

vast_complete

VAST Events (100% complete)

The rate of videos viewed which triggered the VAST complete event

vast_error

Vast Events (errors)

Videos which triggered VAST errors

vast_imp

VAST Impressions

The total number of VAST impressions

vast_progress_30

Vast Events (30 seconds)

Videos which were viewed to 30 seconds

vast_start

VAST Events (video start)

Videos which triggered the VAST start event

inhouse_viewable

Viewable Imps

Indicates the number of impressions deemed viewable

win_bid_amount

Winning Bid

This is Bid Amount for all your winning bids. If a Yes Bid wins the auction, that bid’s CPM becomes “winning CPM“. So the sum of all CPMs in all winning Yes Bids is “Winning Bid” value

win_rate

Win Rate

Сalculated as the number of Impressions divided by the number of Yes Bids. Shows how often you win impression opportunities and have impressions served (when BidCore responds with Yes Bids on your behalf)