# Water Pricing & Promotion Tracking Access real-time pricing and promotions for bottled water products across channels — automated insights without tedious manual checks 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+comprehensive%2C+channel-specific+pricing%2C+discount%2C+and+promotional+data+for+all+key+bottled+and+dispenser+water+product+SKUs+from+competitor+e-commerce+websites+and+major+retail+online+portals. ## 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. ## Sources - amazon.com - walmart.com - target.com - costco.com - instacart.com - bevmo.com - groceryoutlet.com - thespruceeats.com - nielsen.com - marketresearch.com - statista.com ## Sample data 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 | ## Additional fields ## Dashboard widgets - {"id": "d98f3c13", "size": "small", "type": "metric", "title": "Total Products Tracked"} - {"id": "30a1063a", "size": "medium", "type": "pie", "title": "Market Share by Retailer"} - {"id": "c75881a3", "size": "large", "type": "line", "title": "Average Price Trend for Key SKUs"} - {"id": "b5fc3932", "size": "medium", "type": "bar", "title": "Top 10 Most Expensive Products"} - {"id": "92de808a", "size": "medium", "type": "horizontal_bar", "title": "Price Comparison Among Competitors"} - {"id": "d646d27c", "size": "large", "type": "table", "title": "Current Promotions and Discounts"} - {"id": "5fc942b3", "size": "large", "type": "area", "title": "Cumulative Price Changes Over Time"} - {"id": "962d23b3", "size": "medium", "type": "donut", "title": "Discount Distribution by Retailer"} - {"id": "fb332271", "size": "small", "type": "metric", "title": "Lowest Price Today"} - {"id": "b1efe233", "size": "medium", "type": "insights", "title": "Key Pricing Insights"} - {"id": "8c77d736", "size": "large", "type": "table", "title": "Stock Availability by Retailer"} - {"id": "ef3dd49e", "size": "large", "type": "line", "title": "Promotional Activity Over Time"} ## Alerts - {"id": "price_change", "icon": "bi-tag-fill", "item": "Crystal Geyser Water 24-Pack", "title": "Price Change Detected", "source": "walmart.com", "enabled": true, "send_to": "email", "severity": "warning", "subtitle": "is now $15.99 (+$2.00)"} - {"id": "new_listing", "icon": "bi-plus-circle-fill", "item": "Poland Spring 1-Gallon", "title": "New Listing Appears", "source": "amazon.com", "enabled": false, "send_to": "slack", "severity": "success", "subtitle": "now available"} - {"id": "availability_change", "icon": "bi-exclamation-triangle-fill", "item": "Nestle Pure Life 35-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": "Smartwater 12-Pack", "title": "Coverage Gap Found", "source": "target.com", "enabled": false, "send_to": "webhook", "severity": "info", "subtitle": "missing from catalog"} - {"id": "promotion_updated", "icon": "bi-box-seam", "item": "Aquafina 24-Pack", "title": "Promotion Updated", "source": "bevmo.com", "enabled": false, "send_to": "email", "severity": "success", "subtitle": "now has 20% off!"} ## Integrations - api - snowflake - google-sheets