{
  "venue_name": "Trattoria Esempio",
  "venue_type": "Italian restaurant",
  "address": "Esempiostraße 1, 10115 Berlin",
  "rating": "4.6",
  "platforms": "Delivery app A; Delivery app B; Delivery app C",
  "venue-name": "Trattoria Esempio",
  "normalized-name": "trattoria esempio",
  "brand-name": "Esempio Kitchen",
  "venue-description": "Family-run trattoria with homemade pasta.",
  "venue-type": "Restaurant",
  "listing-category": "Italian",
  "primary-cuisine": "Italian",
  "secondary-cuisines": "Pizza, Mediterranean",
  "cuisine-and-dietary-tags": "Pasta, Vegetarian options",
  "concept-format": "Casual dining",
  "service-style": "Table service",
  "price-level": "€€",
  "average-price-per-person": "22 EUR",
  "price-bucket-per-platform": "Platform A: €€, Platform B: €€€",
  "virtual-brand-flag": "No",
  "dark-kitchen-flag": "No",
  "host-kitchen": "Shared kitchen, Berlin Mitte",
  "number-of-brands-in-the-same-kitchen": "3",
  "halal-kosher-flag": "Halal",
  "vegan-vegetarian-focus": "Vegetarian-friendly",
  "alcohol-served": "Yes",
  "breakfast-brunch-served": "Brunch on weekends",
  "late-night-service": "Open until 01:00",
  "kids-menu": "Yes",
  "healthy-bowl-salad-focus": "No",
  "specialty-coffee-flag": "No",
  "franchise-flag": "No",
  "year-opened": "2016",
  "venue-age-bucket": "5-10 years",
  "new-opening-flag": "No",
  "seasonal-temporary-venue-flag": "No",
  "pop-up-flag": "No",
  "latitude-and-longitude": "52.5200, 13.4050",
  "full-address": "Esempiostraße 1, 10115 Berlin",
  "street-and-number": "Esempiostraße 1",
  "postcode": "10115",
  "district": "Mitte",
  "neighbourhood": "Example Quarter",
  "city": "Berlin",
  "region-state": "Berlin",
  "country": "Germany",
  "normalized-geocoded-address": "Esempiostrasse 1, 10115 Berlin, DE",
  "h3-index": "871f1d489ffffff",
  "geohash": "u33dc0",
  "admin-area-codes": "DE-BE",
  "metro-area": "Berlin metropolitan area",
  "urban-suburban-rural": "Urban",
  "mall-station-airport-campus-location-type": "High street",
  "floor-unit": "Ground floor",
  "distance-to-city-centre": "1.2 km",
  "nearest-transit-stop": "Example Platz station, 150 m",
  "delivery-cluster-zone-name": "Berlin Mitte zone",
  "distance-from-a-reference-pin": "800 m from the chosen point",
  "venue-phone": "Available on request",
  "generic-email": "Available on request",
  "website-url": "The venue's own website address",
  "website-status": "Live",
  "online-ordering-link-on-website": "Present",
  "booking-link": "Present",
  "google-business-profile-url": "Link to the Google profile",
  "delivery-app-listing-urls": "One link per platform",
  "tripadvisor-url": "Link to the Tripadvisor page",
  "yelp-url": "Link to the Yelp page",
  "instagram-handle": "trattoria_esempio",
  "facebook-page": "Link to the Facebook page",
  "tiktok-handle": "trattoria.esempio",
  "youtube-channel": "Link to the YouTube channel",
  "x-handle": "trattoria_esempio",
  "linkedin-page": "Link to the LinkedIn page",
  "whatsapp-ordering": "Available",
  "messaging-apps": "WhatsApp, Telegram",
  "chain-franchise-name": "Esempio Group",
  "chain-size": "12",
  "chain-status": "Regional",
  "franchisee-operator-name": "Example Operations GmbH",
  "operator-size": "4",
  "parent-company": "Example Holding AG",
  "holding-group": "Example Holding Group",
  "legal-entity-name": "Trattoria Esempio GmbH",
  "company-registration-number": "HRB 000000",
  "vat-tax-id": "DE000000000",
  "registered-address": "Esempiostraße 1, 10115 Berlin",
  "incorporation-date": "2015-03-12",
  "directors-owners": "Listed in the public registry",
  "ownership-change-date": "2021-06-01",
  "number-of-employees": "10-20",
  "revenue-band": "500k-1M EUR",
  "hiring-activity": "Hiring",
  "open-job-postings": "2",
  "open-temporarily-closed-permanently-closed": "Open",
  "weekly-opening-hours": "Mon-Fri 11:00-22:00, Sat-Sun 12:00-23:00",
  "split-shifts": "12:00-15:00 and 18:00-23:00",
  "holiday-hours": "Closed on 25 Dec",
  "special-hours": "Open until 02:00 on event nights",
  "store-hours-vs-delivery-hours": "Store 11:00-23:00, delivery 12:00-22:00",
  "breakfast-lunch-dinner-dayparts": "Lunch and dinner",
  "live-online-offline-paused-status": "Online",
  "offline-duration": "45 minutes",
  "pause-frequency": "3 times per week",
  "last-status-change": "2026-10-01 18:30",
  "unplanned-downtime-share": "2% of opening hours",
  "opening-hours-change-history": "Closing time moved from 22:00 to 23:00",
  "first-seen-online": "2022-04-10",
  "last-seen-online": "2026-10-27",
  "closure-date": "None recorded",
  "platforms-listed-on": "Delivery app A, Delivery app B",
  "platforms-missing-from": "Delivery app C",
  "exclusive-partnership-flag": "No",
  "number-of-platforms": "2",
  "listing-status-per-platform": "A: active, B: active",
  "time-on-each-platform": "A: 3 years, B: 1 year",
  "listing-created-date": "2023-05-02",
  "listing-removed-date": "None recorded",
  "platform-venue-id": "A-000123",
  "sponsored-boosted-placement": "Yes",
  "ad-promoted-listing-flag": "Yes",
  "search-ranking-position": "7",
  "category-ranking-position": "3",
  "ranking-by-area-zone": "5 in Berlin Mitte",
  "top-rated-popular-badges": "Popular",
  "new-badge": "No",
  "subscription-programme-membership": "Included",
  "subscription-tier": "Free delivery tier",
  "featured-collections-carousels": "Pasta lovers carousel",
  "homepage-placement": "Yes",
  "number-of-photos-on-listing": "14",
  "listing-completeness-score": "85 out of 100",
  "listing-language": "German, English",
  "delivery-available": "Yes",
  "pick-up-available": "Yes",
  "dine-in-table-ordering": "Yes",
  "pre-order-only": "No",
  "scheduled-orders": "Yes",
  "dispatch-type": "Platform couriers",
  "delivery-radius": "3 km",
  "delivery-zone-polygon": "Polygon of 12 points",
  "zone-boundary-changes": "Radius extended from 3 km to 4 km",
  "advertised-eta-min-max": "25-35 min",
  "eta-by-time-of-day": "25 min at lunch, 40 min at dinner",
  "eta-by-distance": "20 min at 1 km, 35 min at 3 km",
  "eta-time-series": "One value every 15 minutes",
  "peak-congestion-periods": "Friday 19:00-21:00",
  "courier-availability-signals": "Limited at peak",
  "vehicle-types": "Bike",
  "contactless-delivery": "Yes",
  "delivery-partner": "Third-party logistics partner",
  "delivery-fee": "2.49 EUR",
  "delivery-fee-by-distance": "1.99 EUR up to 2 km, 3.49 EUR beyond",
  "promotional-delivery-fee": "0.99 EUR",
  "free-delivery-threshold": "Free above 25 EUR",
  "service-fee": "1.00 EUR",
  "small-order-fee": "1.50 EUR below 10 EUR",
  "hard-minimum-order-value": "12 EUR",
  "soft-minimum-order-value": "15 EUR",
  "bag-packaging-fee": "0.30 EUR",
  "surge-busy-fee": "1.00 EUR at peak",
  "fee-type": "Distance",
  "fee-change-history": "Fee raised from 1.99 to 2.49 EUR",
  "subscriber-vs-non-subscriber-fees": "0 EUR vs 2.49 EUR",
  "tips-options": "1, 2, 3 EUR",
  "full-menu": "64 items in 8 sections",
  "menu-sections": "Starters, Pasta, Pizza, Desserts, Drinks",
  "number-of-items": "64",
  "item-name": "Spaghetti Esempio",
  "item-description": "Spaghetti with tomato and basil.",
  "item-ingredients": "Pasta, tomato, basil, olive oil",
  "item-category": "Pasta",
  "item-images": "Photo of the dish",
  "has-image-flag": "Yes",
  "item-size-portion": "Regular, 350 g",
  "item-variants": "Small, medium, large",
  "modifiers-and-add-ons": "Extra cheese, gluten-free pasta",
  "modifier-prices": "Extra cheese 1.50 EUR",
  "combos-meal-deals": "Pasta and drink for 12 EUR",
  "item-availability": "In stock",
  "item-status": "Limited-time",
  "new-items-launched": "3 this month",
  "items-removed": "2 this month",
  "popular-bestseller-items": "Margherita pizza",
  "recommended-items": "Tiramisu",
  "item-calories": "650 kcal",
  "item-allergens": "Gluten, milk",
  "item-dietary-labels": "Vegetarian",
  "spice-level": "Mild",
  "item-rating": "92% positive",
  "item-review-count": "140",
  "item-likes-positive": "92%",
  "menu-languages": "German, English",
  "menu-completeness": "80% with photos, 70% with descriptions",
  "cross-platform-matched-item-id": "ITEM-0001",
  "menu-change-history": "Two items added, one removed",
  "item-price-per-platform": "A: 11.90 EUR, B: 12.50 EUR",
  "dine-in-in-store-price": "10.50 EUR",
  "direct-channel-price": "11.00 EUR",
  "markup-vs-dine-in": "13%",
  "markup-vs-other-platforms": "5%",
  "price-per-size-variant": "Small 9.50 EUR, large 13.50 EUR",
  "time-of-day-price": "Lunch 9.90 EUR, dinner 12.90 EUR",
  "price-change-history": "11.50 EUR in June, 11.90 EUR in September",
  "price-change-frequency": "Twice a year",
  "price-index-vs-local-market": "105",
  "average-item-price": "11.40 EUR",
  "average-main-course-price": "14.20 EUR",
  "typical-basket-price": "26.00 EUR",
  "currency": "EUR",
  "vat-inclusive-flag": "Yes",
  "venue-promo-banner": "20% off your first order",
  "item-level-promotions": "Pizza Margherita 2 for 1",
  "promotion-type": "Percent off",
  "discount-depth": "20%",
  "promo-threshold": "Minimum basket 20 EUR",
  "promo-start-and-end-date": "2026-10-01 to 2026-10-31",
  "promo-duration": "31 days",
  "promo-frequency": "Monthly",
  "new-customer-only-offers": "20% off the first order",
  "returning-customer-offers": "10% off the third order",
  "subscriber-only-offers": "Free delivery for subscribers",
  "platform-funded-vs-venue-funded": "Platform-funded",
  "launch-promotions-for-new-venues": "30% off in the first month",
  "coupon-codes": "Code shown at checkout",
  "loyalty-programme": "Points for every order",
  "stamp-points-programme": "Ten stamps earn a free pizza",
  "gift-cards": "Available from 10 EUR",
  "average-rating-per-platform": "A: 4.6, B: 4.4",
  "rating-count-per-platform": "A: 820, B: 310",
  "google-rating": "4.5",
  "google-review-count": "640",
  "tripadvisor-rating": "4.0",
  "yelp-rating": "4.0",
  "local-review-platforms": "Regional review site, 4.3",
  "rating-trend": "Up 0.2 over six months",
  "review-velocity": "25 new reviews per month",
  "latest-review-date": "2026-10-26",
  "review-text": "Great pasta, quick delivery.",
  "review-language": "German",
  "review-sentiment": "Positive",
  "review-topics": "Food, delivery",
  "complaint-topics": "Late delivery",
  "owner-response-rate": "60%",
  "owner-response-time": "2 days",
  "photo-reviews-count": "85",
  "rating-distribution": "5 stars 70%, 4 stars 20%, 3 stars 5%, below 5%",
  "instagram-followers": "8,400",
  "instagram-posts-count": "320",
  "posting-frequency": "3 posts per week",
  "last-post-date": "2026-10-25",
  "engagement-rate": "3.2%",
  "facebook-followers": "5,100",
  "tiktok-followers": "2,300",
  "tiktok-views": "120,000",
  "youtube-subscribers": "400",
  "influencer-creator-mentions": "6 this quarter",
  "hashtag-mentions": "140 for the venue hashtag",
  "user-generated-photos": "90",
  "social-links-verified": "Yes",
  "social-growth-trend": "Up 4% per month",
  "pos-system": "Example POS",
  "online-ordering-system": "Example ordering tool",
  "booking-reservation-platform": "Example booking tool",
  "loyalty-provider": "Example loyalty tool",
  "payment-terminals": "Card terminals at the counter",
  "payment-methods-accepted": "Card, cash, mobile wallet",
  "cash-only-flag": "No",
  "mobile-wallet-support": "Yes",
  "website-builder-cms": "Example website builder",
  "qr-menu": "Yes",
  "self-order-kiosks": "No",
  "delivery-management-software": "Example dispatch tool",
  "gift-card-provider": "Example gift card tool",
  "email-crm-tool": "Example CRM tool",
  "seating-capacity": "60 seats",
  "terrace-outdoor-seating": "Yes",
  "wi-fi": "Free Wi-Fi",
  "parking": "Street parking nearby",
  "wheelchair-accessible": "Yes",
  "pet-friendly": "Dogs welcome",
  "family-kid-friendly": "Yes",
  "live-music": "Fridays",
  "sports-on-screens": "No",
  "private-dining-events": "Private room for 20",
  "catering": "Yes",
  "takeaway-counter": "Yes",
  "drive-through": "No",
  "reservations-accepted": "Yes",
  "walk-ins-only": "No",
  "dress-code": "Casual",
  "smoking-area": "No",
  "rooftop-view": "No",
  "ambience-tags": "Cozy, romantic",
  "popular-for": "Date night",
  "beverage-brands-on-menu": "Example Cola, Example Juice",
  "beer-brands": "Example Lager",
  "soft-drink-brands": "Example Cola",
  "coffee-brand": "Example Roasters",
  "spirits-brands": "Example Gin",
  "water-brand": "Example Spring Water",
  "ice-cream-dessert-brands": "Example Gelato",
  "snack-brands": "Example Crisps",
  "brand-share-of-menu": "18% of items name a brand",
  "competitor-brand-presence": "Two brands from the same category",
  "branded-vs-unbranded-items": "12 branded, 52 unbranded",
  "pack-sizes-listed": "330 ml can, 500 ml bottle",
  "brand-price-on-menu": "Example Cola 330 ml, 2.90 EUR",
  "brand-listing-changes": "Example Lager replaced by another lager",
  "popular-times-by-hour": "Peak at 19:00",
  "busiest-day": "Saturday",
  "visit-duration": "60-90 minutes",
  "foot-traffic-trend": "Up 5% year on year",
  "nearby-venue-density": "45 venues within 500 m",
  "same-cuisine-competitors-nearby": "6 Italian venues within 1 km",
  "catchment-population": "18,000 within 1 km",
  "catchment-income-band": "Middle income",
  "daytime-vs-residential-population": "1.4 daytime to 1 residential",
  "nearby-offices-campuses-hotels": "8 offices, 1 campus, 2 hotels",
  "tourist-area-flag": "Yes",
  "uptime-share": "96% of opening hours online",
  "availability-during-peak-hours": "92%",
  "eta-reliability": "85% of orders arrive within the advertised time",
  "order-cut-off-times": "22:30",
  "menu-sync-gaps-between-platforms": "4 items differ",
  "price-parity-between-platforms": "90% of items priced the same",
  "out-of-stock-rate-on-items": "4%",
  "rating-stability": "Stable over 12 months",
  "operational-issues-from-reviews": "Late delivery in 6 reviews",
  "food-hygiene-rating": "5 out of 5",
  "last-inspection-date": "2026-03-14",
  "inspection-result-history": "Passed in 2024 and 2026",
  "alcohol-licence": "Held",
  "licence-type": "On-premises license",
  "licence-expiry": "2027-12-31",
  "allergen-information-present": "Yes",
  "required-disclosures-present": "VAT shown, calories missing",
  "rename-events": "Renamed in 2024",
  "rebrand-events": "Rebranded in 2025",
  "ownership-changes": "New owner in 2021",
  "new-platform-added": "Added Delivery app C in 2026",
  "platform-dropped": "Left Delivery app B in 2026",
  "menu-overhaul": "Full menu replaced in 2026",
  "price-increase-events": "Prices raised 5% in 2026",
  "hours-change-events": "Closing time moved in 2026",
  "temporary-closures": "Closed for two weeks in August",
  "reopenings": "Reopened on 2026-09-01",
  "relocations": "Moved to a new address in 2022",
  "cross-platform-group-id": "GRP-000123",
  "platform-source-ids": "A-000123, B-000456",
  "google-place-id": "Google place identifier",
  "google-cid": "Google customer identifier",
  "match-confidence": "High",
  "source-platform": "Delivery app A",
  "first-discovered-timestamp": "2022-04-10 08:00",
  "last-updated-timestamp": "2026-10-27 06:00",
  "data-collection-timestamp": "2026-10-27 06:00",
  "change-flags": "Menu changed",
  "crm-account-id-mapping": "Your CRM account ID",
  "crm-lead-id-mapping": "Your CRM lead ID",
  "is-new-lead-flag": "Yes",
  "custom-tags-segments": "Priority, Berlin"
}