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¶
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. |
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. |
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. |
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 |
bid_context_wrapper.supply.site_id |
Site ID |
Specifies the Site ID, uses the |
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:
|
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. |
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 |
bid_context_wrapper.user.agent.browser.version |
Browser Version |
Specifies the browser name, e.g |
bid_context_wrapper.user.agent.device.maker |
Device Manufacturer |
Specifies the device model, e.g. |
bid_context_wrapper.user.agent.device.model |
Device Model |
Specifies the device model, e.g. |
bid_context_wrapper.user.agent.device.type |
Device Type |
Specifies the device type, e.g. |
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. |
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. |
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. |
content_categories |
IAB Content Categories |
Indicates the content categories, e.g. |
conversion_id |
Conversion ID |
Specifies the conversion ID, e.g. |
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
|
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. |
segments_list |
Pixel Segment |
Indicates the pixel segment ID set in the BidCore UI |
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) |