# Retail Price/Promo Extraction

Access real-time pricing and promotions from key grocery competitors — automated insights that outpace manual tracking.

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

Build this in Jsonify: https://factory.jsonify.com/setup?q=i+want+to+get+real-time%2C+comprehensive+retail+pricing+and+promotional+data+for+key+product+categories+from+the+e-commerce+sites+and+digital+circulars+of+major+national+and+regional+grocery+competitors.

## Goal

i want to get real-time, comprehensive retail pricing and promotional data for key product categories from the e-commerce sites and digital circulars of major national and regional grocery competitors.

## Sources

- walmart.com

- target.com

- aldi.com

- costco.com

- publix.com

- instacart.com

- shoprite.com

- meijer.com

- groceryoutlet.com

- circularhub.com

- retailer.com

## Sample data

id | Source | Product | Category | Unit | Price | Promotion

1 | https://www.walmart.com | Marketside Fresh Organic Bananas | Produce | each (bunch) | $1.71 | 

2 | https://www.walmart.com | Jimmy Dean Bacon Breakfast Bowl | Frozen Breakfast | 7 oz bowl | $2.24 | Sale (was $2.68)

3 | https://www.walmart.com | Kodiak Protein-Packed Chocolate Chip Instant Oatmeal Cup | Breakfast Foods | 2.12 oz cup | $2.18 | 

4 | https://www.walmart.com | Great Value Chocolate Chip Mini Muffins (5 ct) | Bakery | 8.25 oz pack | $2.78 | 

5 | https://www.walmart.com | Great Value Original Cherry Low-Fat Yogurt | Dairy | 6 oz x4 | $2.48 | 

6 | https://www.walmart.com | Fresh Strawberries | Produce | 23.4 oz container | $5.22 | 

7 | https://www.target.com | Boulder Canyon Kettle Style (Mike's Hot Honey) Potato Chips | Snacks | 5.25 oz bag | $4.69 | 

8 | https://www.target.com | Good & Gather Queso Blanco | Dairy | 15 oz tub | $3.19 | 

9 | https://www.target.com | Tostitos Mexican Street Corn Chips | Snacks | 11 oz bag | $4.99 | 2 for $8 deal

10 | https://www.target.com | Good & Gather Spaghetti | Pantry | 16 oz box | $0.99 | 

11 | https://www.target.com | Market Pantry Macaroni & Cheese | Pantry | 7.25 oz box | $0.59 | 

12 | https://www.aldi.us | Specially Selected Heart-Shaped Macarons (6 ct) | Bakery | 6 ct box | $3.89 | 

13 | https://www.aldi.us | Sundae Shoppe Italian Gelato Cups | Frozen Grocery | 2 x 5.3 oz cups | $3.99 | 

14 | https://www.aldi.us | Season's Choice Green Dream Smoothie Blend | Frozen Grocery | 32 oz bag | $6.99 | 

15 | https://www.aldi.us | Emporium Selection Mature Cheddar Cheese | Dairy | 8 oz | $3.99 | 

16 | https://www.aldi.us | Tuscan Garden Muffuletta Olive Salad Mix | Pantry | 16 oz jar | $4.99 | 

17 | https://www.aldi.us | Tuscan Garden Scallop & Shrimp in Shellfish Bisque | Frozen Seafood | 16 oz bag | $8.99 | 

18 | https://www.costco.com | Oral-B CrossAction Toothbrushes (8 pack) | Household | 8 ct | $10.99 | 

19 | https://www.costco.com | Tide PODS 3-in-1 Laundry Detergent (152 ct) | Household | 152 ct tub | $24.99 | 

20 | https://www.costco.com | Kirkland Signature Peanut Butter Monster Cookies | Snacks | 20 oz box | $12.47 | 

21 | https://www.costco.com | Heinz Baked Beans in Tomato Sauce (6 pk) | Pantry | 6 cans | $8.99 | 

22 | https://www.costco.com | Frito-Lay Snack Flavor Variety Pack | Snacks | 56 ct box | $23.99 | 

23 | https://www.publix.com | Hellmann's Real Mayonnaise | Condiments | 30 oz jar | $7.75 | Buy 1 Get 1 Free

24 | https://www.publix.com | Oscar Mayer Original Bacon | Meat | 16 oz pack | $9.33 | Buy 1 Get 1 Free

25 | https://www.publix.com | Sweet Baby Ray's Barbecue Sauce | Condiments | 28 oz bottle | $3.99 | Buy 1 Get 1 Free

26 | https://www.publix.com | TGI Fridays Mozzarella Cheese Sticks | Frozen Foods | 11 oz box | $5.99 | Buy 1 Get 1 Free

27 | https://www.meijer.com | Meijer Green Seedless Grapes | Produce | per lb | $1.99 | 

28 | https://www.meijer.com | Meijer Family Pack Chicken Wings | Meat | per lb | $2.99 | 

29 | https://www.meijer.com | Daisy Sour Cream | Dairy | 16 oz tub | $2.49 | 

30 | https://www.meijer.com | Red Baron Deep Dish Pepperoni Pizza Singles | Frozen Foods | 12 ct box | $11.98 | 

## Additional fields

## Dashboard widgets

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

- {"id": "64a3699f", "size": "medium", "type": "pie", "title": "Market Share by Retailer"}

- {"id": "a618f5d4", "size": "large", "type": "line", "title": "Average Price Trend by Category"}

- {"id": "4448451c", "size": "medium", "type": "bar", "title": "Top 10 Products by Price Decrease"}

- {"id": "88c70d75", "size": "medium", "type": "horizontal_bar", "title": "Promotional Offers by Retailer"}

- {"id": "eff76c61", "size": "large", "type": "area", "title": "Cumulative Price Changes Over Time"}

- {"id": "b62c7263", "size": "large", "type": "table", "title": "Price Comparison of Key Products"}

- {"id": "feec5cd0", "size": "medium", "type": "donut", "title": "Distribution of Promotions by Type"}

- {"id": "d2b7c33c", "size": "small", "type": "metric", "title": "Lowest Price Today"}

- {"id": "1433bcc2", "size": "medium", "type": "insights", "title": "Key Pricing Insights"}

- {"id": "9365303f", "size": "large", "type": "table", "title": "Latest Promotions from Competitors"}

- {"id": "7b7095be", "size": "medium", "type": "line", "title": "Price Change Frequency by Retailer"}

## Alerts

- {"id": "price_change", "icon": "bi-tag-fill", "item": "Organic Avocados", "title": "Price Change Detected", "source": "walmart.com", "enabled": true, "send_to": "email", "severity": "warning", "subtitle": "is now $1.50 (+$0.30)"}

- {"id": "new_listing", "icon": "bi-plus-circle-fill", "item": "Gluten-Free Bread", "title": "New Listing Appears", "source": "target.com", "enabled": false, "send_to": "slack", "severity": "success", "subtitle": "now available"}

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

- {"id": "coverage_gap", "icon": "bi-shield-fill", "item": "Frozen Berries", "title": "Coverage Gap Found", "source": "instacart.com", "enabled": false, "send_to": "webhook", "severity": "info", "subtitle": "missing from catalog"}

- {"id": "promotion_update", "icon": "bi-megaphone-fill", "item": "Buy 1 Get 1 Free", "title": "Promotion Update Detected", "source": "costco.com", "enabled": false, "send_to": "email", "severity": "info", "subtitle": "on selected snacks"}

## Integrations

- api

- webhooks

- snowflake

- databricks