Skip to end of metadata
Go to start of metadata

Revenue Report

Group in UI Query UI NameDescriptionEquationAPI fieldsNotes
Date timeDateThe date associated to when the system recorded the event date 
Date timeDay of WeekThe day of the week for the data aggregated in the report day_of_week 
Date timeMonthThe month for the data aggregated in the report month 
Date timeQuarter of YearThe quarter for the data aggregated in the report quarter_of_year 
Date timeWeekThe week for the data aggregated in the report week 
InventoryPlatform ID The id of the channel from the Portal platform_id 
InventoryPlatform Name The name of the platform from the portal (ex. Mobile Web, Android App, iPhone App, etc.) platform_name 
InventoryProperty ID Property ID in ADM. This is ADMs internal list of properties which belong under a publisher property_id 
InventoryProperty Keyword Site Keyword that the campaign delivered on property_keyword 
InventoryProperty Name Property Name in ADM, this refers to the name of the property associated with the publisher. Should be the same as partner name. property_name 
InventoryPublisher ID Publisher ID pulled from ADM. This is Verve's internal id for publishers. publisher_id 
InventoryPublisher Name Publisher name pulled from ADM, should be equivalent to Group Name in SalesForce.  publisher_name 
Revenue BreakoutPartner ClicksClicks from DFP partner_clicksAvailable to Advertisers
Revenue BreakoutPartner CTRPartner Click through RatePartner Clicks/ Partner Impressionspartner_ctrAvailable to Advertisers
Revenue BreakoutPartner Estimated Net eCPMEstimated Net cost per 1000 ImpressionsPartner Estimated Publisher Revenue *1000/Partner Impressionspartner_estimated_net_ecpmAvailable to Advertisers
Revenue BreakoutPartner Estimated Publisher Revenue The estimated amount Verve expects to payout their publishers. Revenue Share partners receive a percentage of Verve's Gross revenue. Fixed Rate partners receive an amount based on their rate and impressions served.  partner_estimated_publisher_payout_by_verveAvailable to Advertisers
Revenue Breakout Partner Fill RatePercentage ofPartner requests that were filled by the system Partner Impressions/Total Requests)*100partner_fill_rateAvailable to Advertisers
Revenue BreakoutPartner ImpressionsImpressions from DFP - Excluded from Internal for Billable Totals partner_impressionsAvailable to Advertisers
Revenue BreakoutVerve ClicksThe sum of Clicks, excluding Partner Clicks verve_clicksAvailable to Advertisers
Revenue BreakoutVerve CTRVerve Click through RateVerve Clicks/ Verve Impressionsverve_ctrAvailable to Advertisers
Revenue Breakout Verve Estimated Net eCPMEstimated Net cost per 1000 Impressions(Verve Estimated Publisher Revenue*1000)/Verve Impressionsverve_estimated_net_ecpmAvailable to Advertisers
Revenue BreakoutVerve Estimated Publisher Revenue The sum of Estimated Publisher Revenue excluding Partner Estimated Publisher Revenue.  verve_estimated_publisher_payout_by_verveAvailable to Advertisers
Revenue BreakoutVerve Fill RatePercentage of Verve requests that were filled by the system Verve Impressions/Total Requests)*100verve_fill_rateAvailable to Advertisers
Revenue BreakoutVerve ImpressionsThe sum of Impressions, excluding Partner Impressions verve_impressionsAvailable to Advertisers
Total RevenueTotal ClicksThe sum of each Business line clicks total_clicks 
Total RevenueTotal CTRClick through rate. Total Clicks/ Total Impressionsctr 
Total RevenueTotal Estimated Net eCPMEstimated Net cost per 1000 Impressions(Total Estimated Publisher Revenue*1000)/Total Impressionsestimated_net_ecpm 
Total RevenueTotal Estimated Publisher RevenueThe estimated amount Verve expects to payout their publishers. Revenue Share partners receive a percentage of Verve's Gross revenue. Fixed Rate partners receive an amount based on their rate and impressions served.  total_estimated_publisher_payout_by_verve 
Total RevenueTotal Fill RatePercentage of Total requests that were filled by the system Total Impressions/Total Requests)*100total_fill_rate 
Total RevenueTotal ImpressionsThe sum of Partner and Verve Impressions total_impressions 
Total RevenueTotal RequestsThe sum of the AdCel requests (Unfilled + Filled) total_requests  

 

Campaign Report

Publishers who Advertise with Verve have access to the Campaign Report

Group in UI QueryUI NameDescriptionEquationAPI fields
Date timeDateThe date assocated to when the system recorded the event date
Date timeDay of WeekThe day of the week for the data aggregated in the report day_of_week
Date timeMonthThe month for the data aggregated in the report month
Date timeQuarter of YearThe quarter for the data aggregated in the report quarter_of_year
Date timeWeekThe week for the data aggregated in the report week
AdvertiserAdvertiser Category IDAdvertiser Category ID in ADM (Art & Entertianment, Health & Fitness, Sports, Business, Education, etc.) advertiser_category_id
AdvertiserAdvertiser Category NameAdvertiser Category Name in ADM (Art & Entertianment, Health & Fitness, Sports, Business, Education, etc.) advertiser_category_name
Advertiser Advertiser EmailThe email contact for the advertiser advertiser_email
Advertiser Advertiser IDAdvertiser ID in ADM advertiser_id
Advertiser Advertiser IOExternal client's internal Advertiser innsertion order reference number advertiser_io
Advertiser Advertiser NameAdvertiser Name in ADM advertiser_name
OrderOrder End DateThe date and time at which the Order and its associated line items stop being served.  order_end_date
OrderOrder IDThe ID of the Order in ADM order_id
OrderOrder NameOrder name in ADM order_name
OrderOrder Start DateThe date and time at which the Order and its associated line items are eligible to begin serving order_start_date
FlightEstimated RateUsing 1 tier below the actual tier rate in ADM that we used to bill customer last month estimated_rate
FlightFlight Booked QuantityThe amount of impressions or clicks which have been booked for flight. Based on the Flight Metric then it is either impressions (CPM) or clicks (CPC) flight_quantity
FlightFlight Booked Rate The cost, either per 1,000 impressions or per click (Booked rate). Booked opperational rate flight_rate
FlightFlight BudgetThe Line Item budget entered in ADM in Dollars to support the opperational management of the contract.  flight_budget
FlightFlight IDThe ADM flight ID. The flight ID is currently manually put into the creative by the Ad ops team flight_id
FlightFlight Kind ADM Flight's Kind (CPM, RTB, National …) How we internally categorize flights. flight_kind
FlightFlight MetricADM Flight's Metric (CPM, CPC, Sponsorship) The ability in ADM to chose the way a flight will be measured  flight_metric
FlightFlight NameThe name of the flight in ADM flight_name
FlightFlight PacingADM Flight Pacing (Life time ad server impressions divided by the amount of impressions or clicks which have been booked) flight_pacing
FlightFlight Start DateAdm Flight Start Date flight_start_date
FlightFlight StatusThe status from ADM about status of the flight. This gets updated once per day. (Compliant, Expired, Finished, Incomplete, Insufficient, Live, Overbooked, Paused, Pending Approval, Scheduled, Under Delivery, Unlinked) flight_status
Flight TargetingAudienceADM Flight Audience Targeting audience 
Flight TargetingBehavioral AudiencesADM Flight/Line Item Behavioral Audience Targeting (Sports Enthusiasts, Affluent Customers, Moms with Childre in a househould). Behavioral Audiences derived from behavioral inferences - always Verve custom built behavioral_audiences
Flight TargetingCarrierMobile carriers targeted for Line Items in ADM carrier_name
Flight TargetingContent CategoriesADM Flight/Line Item Inventory Content Category Targeting (Business, Sport, Arts and Entertainmnet, etc.) content_categories
Flight TargetingExcluded CarriersExcluded mobile carriers from Targetting in ADM excluded_carrier_ids
Flight TargetingExcluded Content CategoriesExcluded inventory content categories from Targetting in ADM (Business, Sport, Arts and Entertainmnet, etc.) excluded_content_categories
Flight TargetingExcluded MetrosExcluded metro id's from Targetting in ADM excluded_metro_ids
Flight TargetingExcluded Operating SystemsExcluded opperating systems from Targetting in ADM excluded_os_ids
Flight TargetingExcluded SegmentsExcluded segments from Targetting in ADM. Excluding cutom geographical segments excluded_segment_ids
Flight TargetingExcluded StatesExcluded states/regions from Targetting in ADM. Geo-political region as provided in ad request. In US, this is state. In CAN is province. In UK is regions.  excluded_region_ids
Flight TargetingExcluded Zip CodesExcluded zip/postal codes from Targetting in ADM excluded_postal_code_ids 
Flight TargetingGeo AddressFlight targeting in ADM of geographical addresses. geo_address
Flight TargetingGeo RadiusFlight targeting in ADM of a radius amount dependent on geo address. geo_radius
Flight TargetingMetroFlight's Metro Targeting (Metropolitan area associated to the Flights) metro
Flight TargetingOperating SystemsThe targeted Operating System Names. Software opperating system for a mobile phone os_name/os
Flight TargetingSegment NamesThe flight targeting segments  segment_ids
Flight TargetingStateFlight State Targeting in ADM. Geo-political region as provided in ad request. In US, this is state. In CAN is province. In UK is regions.  region
Flight TargetingZip CodesIndicates the zipcode of a user. It should be used when a user enters a zipcode as a source of location and logged with the loc event. postal_codes
CreativeCreative Click Through URLAsecondary action within the creative to drive the user to the URL for the advertisers webpage  creative_click_through_url
CreativeCreative IDADM Creative ID Creative_id
CreativeCreative KindThe type of Creative.
Can be either Creative::ThirdParty, Creative::Redirect or Creative::Display
 creative_kind
CreativeCreative NameADM Creative Name creative_name
InventoryPlatform NameThe name of the platform from the portal (ex. Mobile Web, Android App, iPhone App, etc.) platform_name
InventoryProperty IDProperty ID in ADM. This is ADMs internal list of properties which belong under a publisher property_id
InventoryProperty KeywordSite Keyword that the campaign delivered on property_keyword
InventoryProperty NameProperty Name in ADM, this refers to the name of the property associated with the publisher. Should be the same as partner name. property_name
InventoryPublisher NamePublisher name pulled from ADM, should be equivalent to Group Name in SalesForce.  publisher_name
StandardAdvertiser CostThis field is exposed to external. Re-seller will use this field to collect money from their advertiser(Impressions/1000)* flight booked rateadvertiser_cost
StandardAdvertiser eCPMAdvertiser eCPM - which uses the Advertiser cost in calculations. This field should be defaulted as hidden, and available in "show columns" if the user wants to view.advertiser_cost / impressionsadvertiser_ecpm
StandardClicksNumber of clicks delivered. If the flight is a DFP flight: Clicks come from DFP, If the flight is an Otas flight: Clicks come from Event Clicks clicks
StandardCTRClick through rate. (clicks/impressions)clicks/impressionsctr
StandardEstimated Publisher RevenueThe estimated amount Verve expects to payout their publishers. Revenue Share partners receive a percentage of Verve's Gross revenue. Fixed Rate partners receive an amount based on their rate and impressions served.  estimated_publisher_payout_by_verve
StandardImpressionsNumber of Impressions delivered. impressions
  • No labels