| Output |
NR |
NR |
NR is sales made by wholesalers to retailers for and therefore takes in account the price (Frontline PTR) in which the wholesaler sells to retailers and then takes out the promotion amount (that is split between wholesalers and AB). |
Dollars |
VIP Sales |
Daily |
brand x pack x wholesaler |
Raw |
nan |
| Output |
Volume |
Volume |
Volume sold by wholesaler to retailer. (For accounting purposes, volume sold by ABI to wholesaler is almost same as volume sold by wholesaler to retailers). |
Barrels |
VIP Sales |
Daily |
brand x pack x wholesaler |
Raw |
nan |
| Input |
Price |
Price |
Price is calculated as a ratio of NR and Volume from raw data. Price includes discounts as well. |
Dollars/barrel |
VIP Sales |
week |
brand x wholesaler |
Transformed |
nan |
| Execution |
Distribution |
average_distribution |
Average distribution represents the number of PODs bought by an average retailer. It is calculated as the ratio of number of PODs and number of Open Stores. |
Unitless |
VIP Tables |
week |
brand x wholesaler |
Transformed |
nan |
| Execution |
Distribution |
multiple_distribution |
Multiple distribution represents the number of PODs carried by retailers who bought at least one. It is calculated as ratio of number of PODs and number of Sold Stores. |
Unitless |
VIP Tables |
week |
brand x wholesaler |
Transformed |
nan |
| Execution |
Distribution |
simple_distribution |
The percentage of retailers that have purchased at least one product in distribution period (13 weeks). Simple Distribution is equal to the ratio of number of sold stores and number of open stores. |
Percentage |
VIP Tables |
week |
brand x wholesaler |
Transformed |
nan |
| Execution |
Price |
coupons |
Coupons are discounts given by retailers to consumers. These discounts are fully financed by ABI. |
Dollars |
VIP Sales |
monthly |
brand x wholesaler |
Raw |
nan |
| Execution |
Price |
discount |
Discount is equal to ratio of price and baseline price. This is ratio to track how the Selling price changes within a stable time period. |
Unitless |
nan |
week |
brand x wholesaler |
Transformed |
nan |
| Execution |
Price |
discount_me |
It is a calculated field. It represents impact of discount on present, pre and post weeks of the time as a mixed effect. Intent is to check if the impact of discount variable is important only at the same period or before/after |
Unitless |
nan |
week |
brand x wholesaler |
Transformed |
nan |
| Execution |
Price |
pinc_increase_me |
It is calculated as ratio of baseline price of 2 consecutive points on pre and post weeks of the time as a mixed effect. |
Unitless |
nan |
week |
brand x wholesaler |
Transformed |
nan |
| Execution |
Price |
price_ratio_across_brand_products |
Price ratio across brand products is equal to the ratio of Price of a brand to average price of all other brands for that wholesaler. To check how much the price of this brand is deviating in comparison with other brands over time |
Unitless |
nan |
week |
brand x wholesaler |
Transformed |
nan |
| Execution |
Price |
cpi_adjusted_price |
Ratio of price to mean CPI in a stable time period. Intent is to check how price changes with regard to inflation. |
Unitless |
nan |
week |
brand x wholesaler |
Transformed |
nan |
| Execution |
Price |
short term deviation |
Short term deviation is equal to ratio of Instantaneous actual price to smoothed actual price over a certain window size. This is ratio to track as to how much a particular price in a stable region deviates with regard to the smoothed value over a certain period, E.G - how is actual price at T4 varying with regard to smoothened average of actual prices say over a window varying T1 to T7 |
Unitless |
nan |
week |
brand x wholesaler |
Transformed |
nan |
| Execution |
Price |
short term deviation_me |
It is a calculated field. It represents impact of short-term deviation on pre and post weeks of the time as a Mixed effect. |
Unitless |
nan |
week |
brand x wholesaler |
Transformed |
nan |
| Investment |
All Other marketing |
other_cpnl_Brand_Promo_&_Events |
Expenses related to the organization of Brand events and consumer brand themed promotions. This is working money. |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other marketing |
other_cpnl_Influencers |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other marketing |
other_cpnl_Local_Brand_Programming |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other marketing |
other_cpnl_Market_Research |
This includes all expenses made for marketing research such as consumer ethnography, webnography, consumer focus groups, qualitative and quantitative researches, retail panels, market trends surveys and studies, customer satisfaction and trade research surveys, brand-performance tracking, consumer panels, household panels, brand dedicated research (creative, packaging), innovation related research, shopper behavior tests, information library, competitive research, etc. This is non-working money. |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other marketing |
other_cpnl_Other |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other marketing |
other_cpnl_Pack_Separations |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other marketing |
other_cpnl_Sampling |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other sales |
other_cpnl_Activation_Army |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other sales |
other_cpnl_Category_&_Data |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other sales |
other_cpnl_CRM |
Investments made, in compliance with all internal policies and local/international laws, to foster long-term commercial relationships. (non-working money) |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
|
|
|
Includes: Entertainment such as tickets, golf outings, meals hosting POC owner/manager/staff; |
|
|
|
|
|
|
|
|
|
customer’s travel and lodging cost paid by AB InBev; and expense of the ABI employee’s |
|
|
|
|
|
|
|
|
|
drinks/meals while hosting such events for customers. |
|
|
|
|
|
|
| Investment |
All Other sales |
other_cpnl_EDGE/C4/Accelerator |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other sales |
other_cpnl_EDGE/C4/Accelerator/Incentives |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other sales |
other_cpnl_Incentives |
Costs charged to the National Incentives spend category (formerly SRI) are mapped and spread using the National Incentives Payout Table from our CASE team. |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other sales |
other_cpnl_Meetings |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other sales |
other_cpnl_Misc |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other sales |
other_cpnl_POCM |
These refer to Educational Display Pieces. |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
All Other sales |
other_cpnl_Retailer_Programming |
This includes Brand Boosts, Custom Programming, JBPs & Key Accounts, Small & Large |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
|
|
|
Format Operations, On Premise Support, Retail Flex, and X-Merch. |
|
|
|
|
|
|
| Investment |
All Other sales |
other_cpnl_Sales_Events |
All expenses related to the support or sponsorship of local volume generating events and micro events, not related to brand equity building. (working money) |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
|
|
|
Excludes: Brand-related events are covered by the Marketing Package – Sub-package Brand |
|
|
|
|
|
|
|
|
|
Events. |
|
|
|
|
|
|
| Investment |
All Other sales |
other_cpnl_Trade_Marketing |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Addressable_TV |
Investements made in Addressable Tv ads. Addressable TV ads is a type of targeted advertising that enables advertisers to customize the ads based on factors like demographics, interests, etc. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Audience_reports |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Branded_Content |
Investments made in any piece of content marketing to promote local brands |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Cinema |
Investments made in ads which are visible in cinema. (Ads which are shown during interval or before movie starts) |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Audio |
Investments made in audio ads running on a variety of digital partners (example - spotify). The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Display |
Investments made in static ads (no video) running on a variety of digital partners (excludes digital partners for which there is another dedicated signal, e.g. Digital Contextual Display YouTube) in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments are made at national level and spread by population in CP&A data. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Display_MLB |
Investments made in static ads (no video) on MLB website in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments as made at national level and spread by population in CP&A. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Display_NBA |
Investments made in static ads (no video) on NBA website in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments as made at national level and spread by population in CP&A. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Display_NFL |
Investments made in static ads (no video) on NFL website in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments as made at national level and spread by population in CP&A. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Display_PGA |
Investments made in static ads (no video) on PGA website in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments as made at national level and spread by population in CP&A. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Display_Snapchat |
Investments made in static ads (no video) running on Snapchat in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments as made at national level and spread by population in CP&A. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Display_Twitter |
Investments made in static ads (no video) running on Twitter in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments as made at national level and spread by population in CP&A. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Display_YouTube |
Investments made in static ads (no video) running on YouTube in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Video |
Investments made in videos running on a variety of digital partners (excludes digital partners for which there is another dedicated signal, e.g. Digital Contextual Video Hulu) in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments as made at national level and spread by population in CP&A. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Video_Hulu |
Investments made in videos running on Hulu in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Video_MLB |
Investments made in videos on MLB website in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Video_NBA |
Investments made in videos on NBA website in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments as made at national level and spread by population in CP&A. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Video_NFL |
Investments made in videos on NFL website in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments as made at national level and spread by population in CP&A. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Video_Snapchat |
Investments made in videos running on Snapchat in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion) |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Video_Twitter |
Investments made in videos running on Twitter in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments as made at national level and spread by population in CP&A. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Contextual_Video_YouTube |
Investments made in videos running on YouTube in dollars. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion). These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_Media_Buying |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Digital_OOH |
Investments made in e-displaying dynamic OOH (out-of-home) ads (example - digital billboards on streets) |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
E-Commerce |
Investments made in ads linked to e-commerce websites |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
eCommerce_Paid_Ads |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
eCommerce_Paid_Social_Facebook |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
eCommerce_Search_Google |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Experiential_other |
Investments made for an experiential event (events designed to create a memorable and emotional connection between brand and attendee, often through interactive activities) |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Influencers |
Investements made in tie-up with influencers |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Local_Magazines |
Ads on local magazines |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Local_Newspapers |
Investments made in ads on Local Newspapers |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Local_Other |
Other local Investments |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Media_Co-op |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Media_LSSS |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Media_WAP |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Mobile_Marketing |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Music_Festival |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
National_Magazines |
Investments made on ads in national Magazines |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
National_Newspapers |
Investments made on ads in national newspapers |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
National_TV |
Investments made in ads on National TV during the streaming of variety of leagues (excludes leagues for which we have a dedicated signal, e.g. National TV NFL). These investments are made nationally and spread by population in CP&A data. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
National_TV_MLB |
Investments made in ads on National TV during the streaming of MLB. These investments are made nationally and spread by population in CP&A data. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
National_TV_NASCAR |
Investments made in ads on National TV during the streaming of NASCAR. These investments are made nationally and spread by population in CP&A data. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
National_TV_NBA |
Investments made in ads on National TV during the streaming of NBA. These investments are made nationally and spread by population in CP&A data. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
National_TV_NCAA_Basketball |
Investments made in ads on National TV during the streaming of NCAA. These investments are made nationally and spread by population in CP&A data. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
National_TV_NFL |
Investments made on National TV during streaming of NFL. These investments are made nationally and spread by population in CP&A data. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
National_TV_Super_Bowl |
Investments made in ads on National TV during the streaming of Super Bowl. These investments are made nationally and spread by population in CP&A data. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Network_Radio |
Investments made in ads on Radio |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Other_Digital |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Programmatic_Audio |
Investments made in audio ads on a variety of digital partners (example - spotify). This is similar to Contextual audio, but these are bought programmatically (through a thirrd party) or in an automated way through real time bidding. These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Programmatic_Display |
Investments made in static ads on a variety of digital partners in dollars. This is similar to Contextual Display, but these are bought programmatically (through a thirrd party) or in an automated way through real time bidding. These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Programmatic_Native |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Programmatic_OOH |
Investments made in e-displaying dynamic ooh ads. This is similar to Digital OOGH, but these are bought programmatically (through a thirrd party) or in an automated way through real time bidding. These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Programmatic_Video |
Investments made in videos running on a variety of digital partners in dollars. This is similar to Contextual Video, but these are bought programmatically (through a thirrd party) or in an automated way through real time bidding. These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Programmatic_Video_Hulu |
Investments made in videos running on Hulu in dollars. This is similar to Contextual Video Hulu, but these are bought programmatically (through a thirrd party) or in an automated way through real time bidding. These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Search |
nvestments made in ads that show up while searching something on a browser (excludes browsers for which we have a dedicated signal, e.g. Search Google). |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Search_Google |
nvestments made in ads that show up while searching something on google. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Social |
Investments made in ads on social platforms (excludes social platforms for which we have a dedicated signal, e.g. Social Facebook). |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Social_Facebook |
Investments made in ads on Facebook. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Social_Instagram |
Investments made in ads on Instagram. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Social_Snapchat |
Investments made in ads on Snapchat. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Social_Twitter |
Investments made in ads on Twitter. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Social_YouTube |
Investments made in ads on You Tube. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Sponsorship_Fees |
Sponsorship fees includes participation or any other kind of fees paid for the event in dollars. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Sports |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Spot_Radio |
Investments made in ads on local Radio in dollars. These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Spot_TV |
Dollar investments made on TV ads which are run locally. These investments are made locally. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Spotify |
Investments made in audio ads on Spotify |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Trade_Press |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Traditional_Media_Buying |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
Traditional_OOH |
Investments made in physical (printed on paper or formed out of other tangible materials) out of home ads (example - billboards on streets). These ads are static and are shown without pause over a specified amount of time |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
TVR_Contextual |
Investments made on ads on OTT platforms (excludes OTT Platforms for which we have a dedicated signal, e.g. TVR Contextual Hulu). The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion) |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
TVR_Contextual_Hulu |
Investments made on ads on Hulu. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion) |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
TVR_Contextual_YouTube |
Investments made on ads on YouTube TV. The word contextual denotes how the ads were bought and it means that they were bought non-programmatically (or in a non-automated fashion) |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
TVR_Programmatic |
Investments made on ads on OTT platforms (excludes OTT Platforms for which we have a dedicated signal, e.g. TVR Contextual Hulu). This is similar to TVR Contextual, but these are bought programmatically (through a thirrd party) or in an automated way through real time bidding. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
TVR_Programmatic_Hulu |
Investments made on ads on Hulu. This is similar to TVR Contextual Hulu, but these are bought programmatically (through a thirrd party) or in an automated way through real time bidding. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
TVR_Programmatic_YouTube |
Investments made on ads on YouTube TV. This is similar to TVR Contextual YouTube, but these are bought programmatically (through a thirrd party) or in an automated way through real time bidding. |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
TVR_Social |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
TVR_Social_Facebook |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
TVR_Social_Snapchat |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Media |
TVR_Social_YouTube |
TBU |
Dollars |
CP&L |
week |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Combat |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Country_Music |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Event |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_MLB |
Investments made in Major Baseball League |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_MLP |
Sponsorship Investments made in MLP |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Music_Festivals |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_NASCAR |
Investments made in NASCAR |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_NBA |
Investments made in National Basketball Association |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_NCAA |
Investments made in National Collegiate Athletic Association |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_NFL |
Investments made in National Football League |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_NHL |
Investments made in National Hockey League |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Other |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_PGA |
Investments made in professional golfers' association |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Racing |
Sponsorship Investments made in racing related leagues (example – Formula F1) |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Rodeo |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Running |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Soccer |
Sponsorship investments made in soccer related leagues |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Tennis |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Venue |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| Investment |
Sponsorship |
league_Winter_Sports |
TBU |
Dollars |
CP&L |
month |
brand x wholesaler |
Raw |
nan |
| External |
Baseline |
Baseline |
TBU |
TBU |
TBU |
TBU |
TBU |
TBU |
nan |
| External |
Bud Light Event |
bud_light_event |
Indicates how negatively the weekly sales have been impacted due to the bud light crisis sice its start i.e. 1st March 2023. Its effect is learnt at wholesaler-brand level with an overall recovery rate of the crisis's impact for that particular wholesaler. The weekly negative impacts are learnt based on each week's bearing on the crisis. The recovery rate is too applied based on how much time as passed since the start of bud-light crisis. Therefore the overall weekly impact for each wholesaler-brand is learnt by taking into account the particular week of the crisis vis-a-vis the previous weeks as well as the particular wholesaler's recovery rate that is applied on the week. |
nan |
nan |
nan |
nan |
nan |
nan |
| External |
category trend |
trend |
Represents the impact that can be attributed to long running category trend and is modelled as a mixed effect that helps brands to follow industry trends. E.g. spirits increasing improves cutwater) |
nan |
nan |
nan |
nan |
Transformed |
nan |
| External |
COVID |
covid |
TBU |
TBU |
TBU |
TBU |
TBU |
Transformed |
nan |
| External |
Economic |
civilian_labor_force |
Civilian labor Force is the number of people with age 16 and older who are classifies as either employes or unemployed |
No. of Persons |
FRED |
monthly |
state |
Raw |
nan |
| External |
Economic |
consumer_price_index |
The Consumer Price Index measures the overall change in consumer prices based on a representative basket of goods and services over time. |
Index |
FRED |
monthly |
national |
Raw |
nan |
| External |
Economic |
covered_employment |
Covered employment is the number of employees covered by state insurance programs. |
Number of employees |
FRED |
weekly |
state |
Raw |
nan |
| External |
Economic |
employees_information |
Employees information is a measure of the number of U.S. workers in information. |
Thousands of Persons |
FRED |
monthly |
state |
Raw |
nan |
| External |
Economic |
employees_leisure_hospitality |
Employees Leisure Hospitality is a measure of the number of U.S. workers in leisure hospitality |
Thousands of Persons |
FRED |
monthly |
state |
Raw |
nan |
| External |
Economic |
employees_profesional_business |
Employees Professional Business is a measure of the number of U.S. workers in professional businesses |
Thousands of Persons |
FRED |
monthly |
state |
Raw |
nan |
| External |
Economic |
employees_total_nonfarm |
Employees total nonfarm is a measure of the number of U.S. workers in the economy that excludes proprietors, private household employees, unpaid volunteers, farm employees, and the unincorporated self-employed |
Thousands of Persons |
FRED |
monthly |
state |
Raw |
nan |
| External |
Economic |
employess_financial_activities |
Employees financial activities is a measure of the number of U.S. workers in financial activities. |
Thousands of Persons |
FRED |
monthly |
state |
Raw |
nan |
| External |
Economic |
fed_funds_rate |
The federal funds rate is the interest rate at which depository institutions trade federal funds (balances held at Federal Reserve Banks) with each other overnight. |
Percentage |
FRED |
Daily |
national |
Raw |
nan |
| External |
Economic |
Gas_price |
Weekly U.S. State Regular All Formulations Retail Gasoline Prices (Dollars per Gallon): This Price is an average price per gallon of regular gasoline, considering all types of formulations available in the market. The data is collected weekly from a wide sample of gasoline stations across state, then averaged to provide a comprehensive snapshot of gasoline prices in the State. |
Dollars/gallon |
U.S. Energy Information Administration https://www.eia.gov/petroleum/gasdiesel/ |
weekly |
State |
Raw |
nan |
| External |
Economic |
housing_avg_price |
Housing average price is the average listing price in a given market during the specified month. |
US Dollars |
FRED |
monthly |
state |
Raw |
nan |
| External |
Economic |
marginally_attached_workers |
Marginally attached workers are the persons who are not in the labor force, want and are available for work, and had looked for a job sometime in the prior 12 months. |
Persons, 4-Quarter Moving Average |
FRED |
quarterly |
state |
Raw |
nan |
| External |
Economic |
net_earnings_residence |
Net Earnings by Place of Residence |
Thousands of Dollars |
FRED |
quarterly |
state |
Raw |
nan |
| External |
Economic |
per_capita_personal_income |
Per capita personal income is the real personal income divided by midyear population. Real personal income is personal income at RPPs divided by the national PCE price index. It is estimated for states, state metro/nonmetro portions, metropolitan statistical areas, and the combined nonmetropolitan portion of the United States. |
Chained 2017 Dollars |
FRED |
quarterly |
state |
Raw |
nan |
| External |
Economic |
state_unemployment_rate |
The state unemployment rate represents the number of unemployed in a state as a percentage of the labor force in that state. |
Percentage |
FRED |
monthly |
state |
Raw |
nan |
| External |
Economic |
unemployment_rate |
The unemployment rate represents the number of unemployed as a percentage of the labor force. |
Percentage |
FRED |
monthly |
national |
Raw |
nan |
| External |
Economic |
ZHVI_all_homes |
The Zillow Home Value Index or ZHVI is a smoothed, seasonally adjusted measure of the typical home value and market changes across a given region and housing type. It reflects the typical value for homes in the 35th to 65th percentile range. |
Dollars |
FRED |
monthly |
state |
Raw |
nan |
| External |
festivals |
festivals |
TBU |
TBU |
TBU |
TBU |
TBU |
Transformed |
nan |
| External |
Holidays / Seasonality |
Christmas Day |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Open source Library |
yearly |
national |
Transformed |
nan |
| External |
Holidays / Seasonality |
Columbus Day |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Open source Library |
yearly |
national |
Transformed |
nan |
| External |
Holidays / Seasonality |
Independence Day |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Open source Library |
yearly |
national |
Transformed |
nan |
| External |
Holidays / Seasonality |
Labor Day |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Open source Library |
yearly |
national |
Transformed |
nan |
| External |
Holidays / Seasonality |
Mardi Gras |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Custom |
yearly |
State (Louisiana only) |
Transformed |
nan |
| External |
Holidays / Seasonality |
Martin Luther King Jr. Day |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Open source Library |
yearly |
national |
Transformed |
nan |
| External |
Holidays / Seasonality |
Memorial Day |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Open source Library |
yearly |
national |
Transformed |
nan |
| External |
Holidays / Seasonality |
St.Patrick's Day |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Fixed definition, every year - 17th March |
yearly |
national |
Transformed |
nan |
| External |
Holidays / Seasonality |
Superbowl Local |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Custom |
yearly |
State |
Transformed |
nan |
| External |
Holidays / Seasonality |
Superbowl National |
Same Input at Superbowl Local level also considered at National level considering any superbowl event wil have impact from national viewership as well. |
Unitless |
Custom |
yearly |
national |
Transformed |
nan |
| External |
Holidays / Seasonality |
Thanksgiving |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Open source Library |
yearly |
national |
Transformed |
nan |
| External |
Holidays / Seasonality |
Time of Year |
Represents the seasonal behavior of the sales for any wholesaler-brand depending on the week of the year. The seasonality of the cycle is considered to be of 53 weeks. The impact attributed to it is learnt via a generalised sinosoidal representation by learning the starting week of the seasonal cylce as well as the maginitude of the seasonal cylce for any given wholesaler-brand |
nan |
nan |
nan |
nan |
Transformed |
nan |
| External |
Holidays / Seasonality |
Veterans Day |
Indicates how significant the holiday is in the chosen period. The actual holiday date is shifted to the (preceding or succeeding) week (ending on a Saturday) depending on where revenue impact is more and then revenue weighted averaged out for the chosen period - therefore possible values are between 0-1. (Update expected: include lead lag effect in input to denote what actually goes into the model) |
Unitless |
Open source Library |
yearly |
national |
Transformed |
nan |
| External |
Supply Chain Issues |
Supply Chain Issues |
Supply Chain issues represent the impact on sales which can be attributed to supply chain issues faced by a wholesaler-brand for ceratin particular weeks. For any wholesaler-brand, the weeks are identified to have supply chain issues by looking at the difference between the week's sale and average sales over all weeks. We also check if the change in sales from one week to the next is higher than usual by looking at change in sales between two weeks vis-a-vis average sales difference between consecutive weeks. The impact of supply chain issues is then learnt by masking out the those weeks of different wholesaler-brands from model training, and summing up the error between predicted sales and true sales for the masked out weeks of all wholesaler-brands |
nan |
nan |
nan |
nan |
nan |
nan |
| External |
Weather |
avg_weekday_maxtemp |
Average maximum temperature on weekday |
degree F |
Weather Trends International |
Daily |
zipcode |
Transformed |
nan |
| External |
Weather |
avg_weekday_prcp |
Average precipitation on weekday |
inch |
Weather Trends International |
Daily |
zipcode |
Transformed |
nan |
| External |
Weather |
avg_weekday_snow |
Average snowfall on weekday |
inch |
Weather Trends International |
Daily |
zipcode |
Transformed |
nan |
| External |
Weather |
avg_weekday_tmp_diff |
Average difference between maximum and minimum temperature on weekday |
degree F |
Weather Trends International |
Daily |
zipcode |
Transformed |
nan |
| External |
Weather |
avg_weekend_maxtemp |
Average maximum temperature on weekend |
degree F |
Weather Trends International |
Daily |
zipcode |
Transformed |
nan |
| External |
Weather |
avg_weekend_prcp |
Average precipitation on weekend |
inch |
Weather Trends International |
Daily |
zipcode |
Transformed |
nan |
| External |
Weather |
avg_weekend_snow |
Average snowfall on weekend |
inch |
Weather Trends International |
Daily |
zipcode |
Transformed |
nan |
| External |
Weather |
avg_weekend_tmp_diff |
Average difference between maximum and minimum temperature on weekend |
degree F |
Weather Trends International |
Daily |
zipcode |
Transformed |
nan |
| Residual |
Residual |
Residual |
Residual is calculated as Smoothed Sales - Predicted Sales |
Dollars |
nan |
week |
band x wholesaler |
nan |
nan |
| Residual |
Stockup Effect |
Stockup Effect |
stockup effect denotes inventory increase/decrease by wslr and calculated as True Sales - Smoothed Sales |
Dollars |
VIP Sales |
week |
band x wholesaler |
Transformed |
nan |