Water Pricing & Promotion Tracking
Access real-time pricing and promotions for bottled water products across channels — automated insights without tedious manual checks
A saved example of what you can collect and monitor with Jsonify. Create your own version in Jsonify.
Build this in JsonifyYour original goal is prefilled.
Goal
i want to get continuous, comprehensive, channel-specific pricing, discount, and promotional data for all key bottled and dispenser water product SKUs from competitor e-commerce websites and major retail online portals.
Source coverage
- amazon.com
- walmart.com
- target.com
- costco.com
- instacart.com
- bevmo.com
- groceryoutlet.com
- thespruceeats.com
- nielsen.com
- marketresearch.com
- statista.com
Sample data
Illustrative sample data from the original configuration, not live or verified results.
| id | Source | Brand | PackSize | Price | OriginalPrice | DiscountPct | Promotion |
|---|---|---|---|---|---|---|---|
| 1 | https://www.walmart.com/ | Great Value | 24x16.9 fl oz | 3.68 | 0 | ||
| 2 | https://www.walmart.com/ | Pure Life | 24x16.9 fl oz | 14.27 | 0 | ||
| 3 | https://www.walmart.com/ | Niagara | 24x16.9 fl oz | 20.4 | 0 | ||
| 4 | https://www.target.com/ | FIJI | 6x16.9 fl oz | 6.39 | 7.99 | 20 | Sale |
| 5 | https://www.target.com/ | DASANI | 24x16.9 fl oz | 4.99 | 5.29 | 6 | Sale |
| 6 | https://www.amazon.com/ | Nestle Pure Life | 24x16.9 fl oz | 4.99 | 5.55 | 10 | Subscribe & Save 10% |
| 7 | https://www.amazon.com/ | Evian | 6x1 L | 8.99 | 0 | ||
| 8 | https://www.amazon.com/ | DASANI | 24x16.9 fl oz | 7.99 | 8.96 | 11 | Sale |
| 9 | https://www.costco.com/ | Kirkland Signature | 40x16.9 fl oz | 3.99 | 8.79 | 55 | Member Price |
| 10 | https://www.instacart.com/store/costco/ | Poland Spring | 35x16.9 fl oz | 10.99 | 0 | Member Price | |
| 11 | https://www.instacart.com/store/costco/ | Kirkland Signature | 12x1gal | 18.99 | 0 | Member Price | |
| 12 | https://www.instacart.com/store/safeway/ | Crystal Geyser | 1x1gal | 2.99 | 0 | ||
| 13 | https://www.instacart.com/store/shoprite/ | Mountain Valley | 24x16.9 fl oz | 52.49 | 0 | ||
| 14 | https://www.bevmo.com/ | Basically | 3x1.5 L | 6.9 | 7.47 | 8 | Sale |
| 15 | https://www.bevmo.com/ | FLOW Alkaline Water | 1x1 L | 3.5 | 0 | ||
| 16 | https://www.groceryoutlet.com/ | Assorted Bottled Water | 1x16.9 fl oz | 0.25 | 0 | ||
| 17 | https://www.amazon.com/ | Liquid Death | 12x16.9 fl oz | 19.99 | 0 | ||
| 18 | https://www.walmart.com/ | Ice Mountain | 24x16.9 fl oz | 26.49 | 0 | ||
| 19 | https://www.walmart.com/ | Mountain Valley | 24x16.9 fl oz | 40.5 | 0 | ||
| 20 | https://www.walmart.com/ | Nature's Crystal | 24x16.9 fl oz | 22.79 | 0 | ||
| 21 | https://www.walmart.com/ | FIJI | 24x16.9 fl oz | 34.4 | 0 | ||
| 22 | https://www.walmart.com/ | Deer Park | 24x16.9 fl oz | 9.97 | 15.79 | 37 | Sale |
| 23 | https://www.walmart.com/ | DASANI | 24x16.9 fl oz | 12.98 | 0 | ||
| 24 | https://www.walmart.com/ | Great Value | 1x128oz | 1.37 | 0 | ||
| 25 | https://www.walmart.com/ | Great Value | 6x1gal | 8.22 | 0 | ||
| 26 | https://www.walmart.com/ | Crystal Geyser | 2x1gal | 23.95 | 0 | ||
| 27 | https://www.target.com/ | up&up | 1x1gal | 1.29 | 0 | ||
| 28 | https://www.target.com/ | Pure Life | 1x1gal | 2.49 | 0 | ||
| 29 | https://www.target.com/ | Ice Mountain | 1x2.5gal | 3.69 | 0 | ||
| 30 | https://www.target.com/ | Poland Spring | 1x2.5gal | 4.99 | 0 |
Insights and analytics
- Total Products Tracked (metric)
- Market Share by Retailer (pie)
- Average Price Trend for Key SKUs (line)
- Top 10 Most Expensive Products (bar)
- Price Comparison Among Competitors (horizontal_bar)
- Current Promotions and Discounts (table)
- Cumulative Price Changes Over Time (area)
- Discount Distribution by Retailer (donut)
- Lowest Price Today (metric)
- Key Pricing Insights (insights)
- Stock Availability by Retailer (table)
- Promotional Activity Over Time (line)
Change notifications
- Price Change Detected — is now $15.99 (+$2.00) walmart.com
- New Listing Appears — now available amazon.com
- Product Unavailable — is out of stock costco.com
- Coverage Gap Found — missing from catalog target.com
- Promotion Updated — now has 20% off! bevmo.com
Integrations and delivery
- api
- snowflake
- google-sheets
Make this your own
Start with this goal in Jsonify, then choose the sources and data you need.
Build this in Jsonify