# Retail Beer Pricing Data

Gain real-time visibility into retail pricing and promotions for beer SKUs — streamline RGM strategy without manual effort.

Archived sample configuration. Sample data is illustrative, not live data.

Build this in Jsonify: https://factory.jsonify.com/setup?q=i+want+to+get+continuous%2C+localized+retail+pricing%2C+discount%2C+and+promotional+data+for+Constellation+Brands%27+and+key+competitors%27+beer+SKUs+across+all+major+e-commerce+and+national+grocery+chain+websites+to+inform+national+Revenue+Growth+Management+%28RGM%29+strategy.

## Goal

i want to get continuous, localized retail pricing, discount, and promotional data for Constellation Brands' and key competitors' beer SKUs across all major e-commerce and national grocery chain websites to inform national Revenue Growth Management (RGM) strategy.

## Sources

- walmart.com

- target.com

- amazon.com

- costco.com

- bevmo.com

- instacart.com

- meijer.com

- safeway.com

- beeradvocate.com

- nielsen.com

## Sample data

id | Source | Product | Pack | Price | Promotion | Availability | Location

1 | https://walmart.com | Modelo Especial Mexican Lager | 24pk/12 oz Cans | $26.77 |  | In Stock | Chicago, IL

2 | https://walmart.com | Modelo Especial Mexican Lager | 12pk/12 oz Bottles | $15.84 |  | In Stock | Dallas, TX

3 | https://walmart.com | Modelo Especial Mexican Lager | 6pk/12 oz Bottles | $9.52 |  | In Stock | Miami, FL

4 | https://walmart.com | Corona Extra Mexican Lager | 24pk/12 oz Bottles | $27.27 |  | In Stock | Denver, CO

5 | https://walmart.com | Corona Extra Mexican Lager | 12pk/12 oz Bottles | $16.99 |  | In Stock | Orlando, FL

6 | https://walmart.com | Budweiser American Lager | 12pk/12 oz Cans | $11.53 |  | In Stock | Atlanta, GA

7 | https://target.com | Modelo Especial Mexican Lager | 12pk/12 oz Bottles | $15.99 | Sale (Reg $16.99) | In Stock | New York, NY

8 | https://target.com | Modelo Especial Mexican Lager | 12pk/12 oz Cans | $14.99 | Sale (Reg $16.99) | In Stock | Los Angeles, CA

9 | https://target.com | Modelo Especial Mexican Lager | 24pk/12 oz Cans | $27.99 |  | In Stock | Houston, TX

10 | https://target.com | Corona Extra Coronita Lager | 24pk/7 oz Bottles | $22.99 |  | In Stock | Chicago, IL

11 | https://target.com | Guinness Draught Stout | 8pk/14.9 oz Cans | $15.99 |  | Limited Stock | San Francisco, CA

12 | https://target.com | Heineken Original Lager | 12pk/12 oz Bottles | $14.99 | Sale (Reg $16.99) | In Stock | Seattle, WA

13 | https://costco.com | Corona Extra Mexican Lager | 24pk/12 oz Bottles | $30.39 | Online Exclusive | Pickup Only | Arlington, TX

14 | https://costco.com | Modelo Especial Mexican Lager | 24pk/12 oz Cans | $22.29 | Club Member Price | In Stock | Eden Prairie, MN

15 | https://costco.com | Modelo Negra Amber Lager | 24pk/12 oz Bottles | $24.97 | Club Member Price | In Stock | Sunnyvale, CA

16 | https://costco.com | Guinness Draught Stout | 24pk/14.9 oz Cans | $29.99 | Club Price | In Stock | Seattle, WA

17 | https://amazon.com | Corona Extra Mexican Lager | 12pk/12 oz Bottles | $19.99 | Prime Delivery | In Stock | USA

18 | https://amazon.com | Modelo Especial Mexican Lager | 12pk/12 oz Cans | $18.49 |  | In Stock | USA

19 | https://amazon.com | Modelo Negra Amber Lager | 6pk/12 oz Bottles | $9.99 |  | In Stock | USA

20 | https://amazon.com | Heineken Original Lager | 6pk/12 oz Bottles | $8.49 |  | In Stock | USA

21 | https://bevmo.com | Modelo Especial Mexican Lager | 12pk/12 oz Cans | $19.99 |  | In Stock | Los Angeles, CA

22 | https://bevmo.com | Corona Extra Mexican Lager | 12pk/12 oz Bottles | $19.49 | Member Price $17.99 | In Stock | Phoenix, AZ

23 | https://bevmo.com | Guinness Draught Stout | 6pk/14.9 oz Cans | $9.99 |  | Limited Stock | Las Vegas, NV

24 | https://instacart.com | Corona Extra Mexican Lager | 24pk/12 oz Bottles | $28.99 | Local Pricing | In Stock | Brooklyn, NY

25 | https://instacart.com | Modelo Especial Mexican Lager | 24pk/12 oz Cans | $25.99 | Instacart Fee Applies | In Stock | Jersey City, NJ

26 | https://instacart.com | Corona Extra Mexican Lager | 12pk/12 oz Bottles | $17.49 | Club Price | In Stock | San Francisco, CA

27 | https://meijer.com | Corona Extra Mexican Lager | 12pk/12 oz Bottles | $17.49 |  | In Stock | Detroit, MI

28 | https://meijer.com | Modelo Especial Mexican Lager | 12pk/12 oz Cans | $16.49 | Instant Savings | In Stock | Grand Rapids, MI

29 | https://safeway.com | Corona Extra Mexican Lager | 12pk/12 oz Bottles | $18.99 | Club Price $17.99 | In Stock | San Diego, CA

30 | https://safeway.com | Heineken Premium Light Lager | 12pk/12 oz Bottles | $15.99 |  | In Stock | Phoenix, AZ

## Additional fields

## Dashboard widgets

- {"id": "344bae7c", "size": "small", "type": "metric", "title": "Total Products Tracked"}

- {"id": "262c8ccc", "size": "large", "type": "line", "title": "Average Price Trend for Constellation Brands"}

- {"id": "f4ffb28e", "size": "medium", "type": "bar", "title": "Current Prices of Key Competitors"}

- {"id": "1335a010", "size": "medium", "type": "donut", "title": "Price Distribution by Retailer"}

- {"id": "ec2608ef", "size": "large", "type": "table", "title": "Top 10 Most Discounted SKUs"}

- {"id": "21efd0be", "size": "large", "type": "area", "title": "Promotional Activity Over Time"}

- {"id": "38af41af", "size": "medium", "type": "horizontal_bar", "title": "Best-Selling Beer SKUs"}

- {"id": "b74ec7ed", "size": "medium", "type": "line", "title": "Price Change Frequency by SKU"}

- {"id": "128781ef", "size": "medium", "type": "pie", "title": "Market Share by Competitor"}

- {"id": "11c11c60", "size": "small", "type": "metric", "title": "Total Promotions Active"}

- {"id": "504f540d", "size": "medium", "type": "insights", "title": "Key Observations in Retail Pricing"}

- {"id": "51e41af8", "size": "large", "type": "table", "title": "Retailer Price Comparison Today"}

## Alerts

- {"id": "price_change", "icon": "bi-tag-fill", "item": "Budweiser 12-Pack", "title": "Price Change Detected", "source": "walmart.com", "enabled": true, "send_to": "email", "severity": "warning", "subtitle": "is now $14.99 (-$2.00)"}

- {"id": "new_listing", "icon": "bi-plus-circle-fill", "item": "Corona Extra 6-Pack", "title": "New Listing Appears", "source": "amazon.com", "enabled": false, "send_to": "slack", "severity": "success", "subtitle": "now available"}

- {"id": "availability_change", "icon": "bi-exclamation-circle-fill", "item": "Heineken 12-Pack", "title": "Product Unavailable", "source": "costco.com", "enabled": false, "send_to": "teams", "severity": "danger", "subtitle": "is out of stock"}

- {"id": "coverage_gap", "icon": "bi-shield-fill", "item": "Modelo Especial 12-Pack", "title": "Coverage Gap Found", "source": "target.com", "enabled": false, "send_to": "webhook", "severity": "info", "subtitle": "missing from catalog"}

- {"id": "promotion_change", "icon": "bi-megaphone-fill", "item": "Coors Light 24-Pack", "title": "Promotion Updated", "source": "bevmo.com", "enabled": false, "send_to": "email", "severity": "success", "subtitle": "now 20% off!"}

## Integrations

- snowflake

- api

- email