{
  "meta": {
    "generated_at": "2026-08-30T18:42:16.772Z",
    "sample": "US businesses appearing in Google Maps results for tracked local search queries; DataForSEO Maps endpoint; aggregates only",
    "corpus": {
      "businesses": 162773,
      "metros": 54,
      "categories": 1781,
      "first_seen": "2026-07-24",
      "last_seen": "2026-08-30"
    },
    "total_observations": 478245,
    "observation_window": {
      "from": "2026-07-24",
      "to": "2026-08-23"
    },
    "sweeps": [
      {
        "date": "2026-07-28",
        "dates": [
          "2026-07-24",
          "2026-07-25",
          "2026-07-26",
          "2026-07-28"
        ],
        "rows": 158079,
        "metros": 32,
        "max_rank": 102
      },
      {
        "date": "2026-08-02",
        "dates": [
          "2026-08-01",
          "2026-08-02"
        ],
        "rows": 61838,
        "metros": 52,
        "max_rank": 102
      },
      {
        "date": "2026-08-08",
        "dates": [
          "2026-08-07",
          "2026-08-08"
        ],
        "rows": 73040,
        "metros": 53,
        "max_rank": 102
      },
      {
        "date": "2026-08-16",
        "dates": [
          "2026-08-15",
          "2026-08-16"
        ],
        "rows": 72728,
        "metros": 54,
        "max_rank": 102
      },
      {
        "date": "2026-08-23",
        "dates": [
          "2026-08-22",
          "2026-08-23"
        ],
        "rows": 73284,
        "metros": 54,
        "max_rank": 102
      },
      {
        "date": "2026-08-30",
        "dates": [
          "2026-08-30"
        ],
        "rows": 39276,
        "metros": 29,
        "max_rank": 102
      }
    ],
    "latest_sweep": {
      "date": "2026-08-23",
      "dates": [
        "2026-08-22",
        "2026-08-23"
      ],
      "rows": 73284,
      "metros": 54,
      "max_rank": 102
    },
    "prev_broad_sweep": {
      "date": "2026-08-16",
      "dates": [
        "2026-08-15",
        "2026-08-16"
      ],
      "rows": 72728,
      "metros": 54,
      "max_rank": 102
    },
    "top_categories_limit": 25
  },
  "overall": {
    "n": 162773,
    "website_pct": 84.4,
    "reviews": {
      "median": 86,
      "p25": 13,
      "p75": 417,
      "mean": 513.6,
      "zero_pct": 8.1,
      "pct_100_plus": 47.8,
      "pct_1000_plus": 12.6
    },
    "rating": {
      "rated_n": 149223,
      "unrated_pct": 8.3,
      "median": 4.6,
      "mean": 4.5,
      "pct_45_plus": 66.3,
      "pct_flat_5": 20.7,
      "pct_under_4": 11.4,
      "pct_under_35": 5.3
    }
  },
  "review_histogram": {
    "bin_width": 25,
    "terminal_bin": 20,
    "n": 162463,
    "bins": [
      {
        "bin": 0,
        "label": "0–24",
        "n": 52631,
        "pct": 32.4,
        "terminal": false
      },
      {
        "bin": 1,
        "label": "25–49",
        "n": 15281,
        "pct": 9.4,
        "terminal": false
      },
      {
        "bin": 2,
        "label": "50–74",
        "n": 9812,
        "pct": 6,
        "terminal": false
      },
      {
        "bin": 3,
        "label": "75–99",
        "n": 7039,
        "pct": 4.3,
        "terminal": false
      },
      {
        "bin": 4,
        "label": "100–124",
        "n": 5735,
        "pct": 3.5,
        "terminal": false
      },
      {
        "bin": 5,
        "label": "125–149",
        "n": 4633,
        "pct": 2.9,
        "terminal": false
      },
      {
        "bin": 6,
        "label": "150–174",
        "n": 4061,
        "pct": 2.5,
        "terminal": false
      },
      {
        "bin": 7,
        "label": "175–199",
        "n": 3387,
        "pct": 2.1,
        "terminal": false
      },
      {
        "bin": 8,
        "label": "200–224",
        "n": 3094,
        "pct": 1.9,
        "terminal": false
      },
      {
        "bin": 9,
        "label": "225–249",
        "n": 2749,
        "pct": 1.7,
        "terminal": false
      },
      {
        "bin": 10,
        "label": "250–274",
        "n": 2535,
        "pct": 1.6,
        "terminal": false
      },
      {
        "bin": 11,
        "label": "275–299",
        "n": 2308,
        "pct": 1.4,
        "terminal": false
      },
      {
        "bin": 12,
        "label": "300–324",
        "n": 2114,
        "pct": 1.3,
        "terminal": false
      },
      {
        "bin": 13,
        "label": "325–349",
        "n": 1993,
        "pct": 1.2,
        "terminal": false
      },
      {
        "bin": 14,
        "label": "350–374",
        "n": 1750,
        "pct": 1.1,
        "terminal": false
      },
      {
        "bin": 15,
        "label": "375–399",
        "n": 1646,
        "pct": 1,
        "terminal": false
      },
      {
        "bin": 16,
        "label": "400–424",
        "n": 1543,
        "pct": 0.9,
        "terminal": false
      },
      {
        "bin": 17,
        "label": "425–449",
        "n": 1429,
        "pct": 0.9,
        "terminal": false
      },
      {
        "bin": 18,
        "label": "450–474",
        "n": 1379,
        "pct": 0.8,
        "terminal": false
      },
      {
        "bin": 19,
        "label": "475–499",
        "n": 1260,
        "pct": 0.8,
        "terminal": false
      },
      {
        "bin": 20,
        "label": "500+",
        "n": 36084,
        "pct": 22.2,
        "terminal": true
      }
    ]
  },
  "category_field": {
    "source": "listing category, falling back to the search query where the listing had none",
    "query_overlap_pct": 32.3,
    "distinct_listing_categories": 1781
  },
  "by_category": [
    {
      "category": "Hotel",
      "n": 2845,
      "website_pct": 91.5,
      "med_reviews": 918,
      "p25_reviews": 376,
      "p75_reviews": 1618,
      "med_rating": 4.2,
      "zero_reviews_pct": 3.9
    },
    {
      "category": "Mexican",
      "n": 2919,
      "website_pct": 82.5,
      "med_reviews": 587,
      "p25_reviews": 187,
      "p75_reviews": 1400,
      "med_rating": 4.4,
      "zero_reviews_pct": 1.2
    },
    {
      "category": "Pizza",
      "n": 5013,
      "website_pct": 94.4,
      "med_reviews": 460,
      "p25_reviews": 214,
      "p75_reviews": 882,
      "med_rating": 4.4,
      "zero_reviews_pct": 1.4
    },
    {
      "category": "Grocery store",
      "n": 2495,
      "website_pct": 70.2,
      "med_reviews": 370,
      "p25_reviews": 45,
      "p75_reviews": 1329,
      "med_rating": 4.2,
      "zero_reviews_pct": 3.3
    },
    {
      "category": "Restaurant",
      "n": 4801,
      "website_pct": 90,
      "med_reviews": 364,
      "p25_reviews": 104,
      "p75_reviews": 948,
      "med_rating": 4.5,
      "zero_reviews_pct": 1.4
    },
    {
      "category": "Bar",
      "n": 2427,
      "website_pct": 82,
      "med_reviews": 266,
      "p25_reviews": 85,
      "p75_reviews": 604,
      "med_rating": 4.5,
      "zero_reviews_pct": 1.6
    },
    {
      "category": "Veterinarian",
      "n": 2470,
      "website_pct": 94.7,
      "med_reviews": 239,
      "p25_reviews": 83,
      "p75_reviews": 471,
      "med_rating": 4.7,
      "zero_reviews_pct": 4.2
    },
    {
      "category": "Dentist",
      "n": 3404,
      "website_pct": 86.9,
      "med_reviews": 224,
      "p25_reviews": 29,
      "p75_reviews": 500,
      "med_rating": 4.8,
      "zero_reviews_pct": 7.5
    },
    {
      "category": "Coffee shop",
      "n": 3800,
      "website_pct": 88,
      "med_reviews": 208,
      "p25_reviews": 73,
      "p75_reviews": 457,
      "med_rating": 4.6,
      "zero_reviews_pct": 1.7
    },
    {
      "category": "Nail salon",
      "n": 2708,
      "website_pct": 78.5,
      "med_reviews": 199,
      "p25_reviews": 74,
      "p75_reviews": 412,
      "med_rating": 4.6,
      "zero_reviews_pct": 3
    },
    {
      "category": "Car wash",
      "n": 2445,
      "website_pct": 64.8,
      "med_reviews": 156,
      "p25_reviews": 27,
      "p75_reviews": 515,
      "med_rating": 4.2,
      "zero_reviews_pct": 5.7
    },
    {
      "category": "Barber shop",
      "n": 2905,
      "website_pct": 70.6,
      "med_reviews": 92,
      "p25_reviews": 29,
      "p75_reviews": 217,
      "med_rating": 4.8,
      "zero_reviews_pct": 7
    },
    {
      "category": "Apartment complex",
      "n": 2183,
      "website_pct": 95.1,
      "med_reviews": 82,
      "p25_reviews": 30,
      "p75_reviews": 186,
      "med_rating": 4.2,
      "zero_reviews_pct": 2.7
    },
    {
      "category": "Locksmith",
      "n": 3034,
      "website_pct": 83.6,
      "med_reviews": 81,
      "p25_reviews": 24,
      "p75_reviews": 216,
      "med_rating": 4.9,
      "zero_reviews_pct": 3.9
    },
    {
      "category": "Pest control service",
      "n": 2754,
      "website_pct": 85.9,
      "med_reviews": 73,
      "p25_reviews": 10,
      "p75_reviews": 373,
      "med_rating": 4.9,
      "zero_reviews_pct": 6.7
    },
    {
      "category": "Plumber",
      "n": 5763,
      "website_pct": 82.6,
      "med_reviews": 72,
      "p25_reviews": 16,
      "p75_reviews": 315,
      "med_rating": 4.9,
      "zero_reviews_pct": 3.5
    },
    {
      "category": "Hair salon",
      "n": 2117,
      "website_pct": 83.9,
      "med_reviews": 68,
      "p25_reviews": 27,
      "p75_reviews": 162,
      "med_rating": 4.9,
      "zero_reviews_pct": 1.4
    },
    {
      "category": "Garage door supplier",
      "n": 1955,
      "website_pct": 87.4,
      "med_reviews": 60,
      "p25_reviews": 16,
      "p75_reviews": 219,
      "med_rating": 5,
      "zero_reviews_pct": 3.7
    },
    {
      "category": "Chiropractor",
      "n": 3024,
      "website_pct": 87.6,
      "med_reviews": 59,
      "p25_reviews": 14,
      "p75_reviews": 192,
      "med_rating": 5,
      "zero_reviews_pct": 6
    },
    {
      "category": "Personal injury attorney",
      "n": 2885,
      "website_pct": 96.4,
      "med_reviews": 59,
      "p25_reviews": 17,
      "p75_reviews": 176,
      "med_rating": 4.9,
      "zero_reviews_pct": 4.4
    },
    {
      "category": "Roofing contractor",
      "n": 1975,
      "website_pct": 86.9,
      "med_reviews": 44,
      "p25_reviews": 10,
      "p75_reviews": 117,
      "med_rating": 4.9,
      "zero_reviews_pct": 7.2
    },
    {
      "category": "Real estate agency",
      "n": 2608,
      "website_pct": 92.2,
      "med_reviews": 30,
      "p25_reviews": 9,
      "p75_reviews": 74,
      "med_rating": 4.9,
      "zero_reviews_pct": 6.3
    },
    {
      "category": "Electrician",
      "n": 2496,
      "website_pct": 74.2,
      "med_reviews": 20,
      "p25_reviews": 5,
      "p75_reviews": 72,
      "med_rating": 4.9,
      "zero_reviews_pct": 7.6
    },
    {
      "category": "Dermatologist",
      "n": 2528,
      "website_pct": 85.2,
      "med_reviews": 15,
      "p25_reviews": 1,
      "p75_reviews": 182,
      "med_rating": 4.8,
      "zero_reviews_pct": 23.9
    },
    {
      "category": "Financial planner",
      "n": 2283,
      "website_pct": 91.9,
      "med_reviews": 0,
      "p25_reviews": 0,
      "p75_reviews": 2,
      "med_rating": 5,
      "zero_reviews_pct": 59.9
    }
  ],
  "by_metro": [
    {
      "metro": "tampa-st-petersburg",
      "name": "Tampa-St. Petersburg",
      "n": 4842,
      "website_pct": 87.2,
      "med_reviews": 134,
      "med_rating": 4.7
    },
    {
      "metro": "raleigh-durham",
      "name": "Raleigh-Durham",
      "n": 4711,
      "website_pct": 90,
      "med_reviews": 83,
      "med_rating": 4.7
    },
    {
      "metro": "atlanta",
      "name": "Atlanta",
      "n": 4709,
      "website_pct": 84.5,
      "med_reviews": 92,
      "med_rating": 4.7
    },
    {
      "metro": "san-diego",
      "name": "San Diego",
      "n": 4657,
      "website_pct": 84.7,
      "med_reviews": 61,
      "med_rating": 4.7
    },
    {
      "metro": "san-antonio",
      "name": "San Antonio",
      "n": 4580,
      "website_pct": 81.7,
      "med_reviews": 86,
      "med_rating": 4.7
    },
    {
      "metro": "houston",
      "name": "Houston",
      "n": 4572,
      "website_pct": 84.3,
      "med_reviews": 89,
      "med_rating": 4.7
    },
    {
      "metro": "denver",
      "name": "Denver",
      "n": 4514,
      "website_pct": 89.1,
      "med_reviews": 117,
      "med_rating": 4.7
    },
    {
      "metro": "philadelphia",
      "name": "Philadelphia",
      "n": 4466,
      "website_pct": 82.7,
      "med_reviews": 64,
      "med_rating": 4.7
    },
    {
      "metro": "portland",
      "name": "Portland",
      "n": 4452,
      "website_pct": 87.5,
      "med_reviews": 77,
      "med_rating": 4.7
    },
    {
      "metro": "austin",
      "name": "Austin",
      "n": 4443,
      "website_pct": 87.5,
      "med_reviews": 102,
      "med_rating": 4.7
    },
    {
      "metro": "las-vegas",
      "name": "Las Vegas",
      "n": 4437,
      "website_pct": 83.1,
      "med_reviews": 103,
      "med_rating": 4.6
    },
    {
      "metro": "phoenix",
      "name": "Phoenix",
      "n": 4434,
      "website_pct": 84.9,
      "med_reviews": 95,
      "med_rating": 4.7
    },
    {
      "metro": "detroit",
      "name": "Detroit",
      "n": 4369,
      "website_pct": 75.2,
      "med_reviews": 49,
      "med_rating": 4.6
    },
    {
      "metro": "salt-lake-city",
      "name": "Salt Lake City",
      "n": 4360,
      "website_pct": 86.2,
      "med_reviews": 80,
      "med_rating": 4.7
    },
    {
      "metro": "columbus",
      "name": "Columbus",
      "n": 4256,
      "website_pct": 85.3,
      "med_reviews": 62,
      "med_rating": 4.7
    },
    {
      "metro": "jacksonville",
      "name": "Jacksonville",
      "n": 4246,
      "website_pct": 80.5,
      "med_reviews": 81,
      "med_rating": 4.7
    },
    {
      "metro": "baltimore",
      "name": "Baltimore",
      "n": 4245,
      "website_pct": 79.1,
      "med_reviews": 43,
      "med_rating": 4.7
    },
    {
      "metro": "los-angeles",
      "name": "Los Angeles",
      "n": 4239,
      "website_pct": 78.9,
      "med_reviews": 60,
      "med_rating": 4.7
    },
    {
      "metro": "charlotte",
      "name": "Charlotte",
      "n": 4221,
      "website_pct": 85.6,
      "med_reviews": 88,
      "med_rating": 4.7
    },
    {
      "metro": "kansas-city",
      "name": "Kansas City",
      "n": 4220,
      "website_pct": 82.4,
      "med_reviews": 60,
      "med_rating": 4.7
    },
    {
      "metro": "pittsburgh",
      "name": "Pittsburgh",
      "n": 4183,
      "website_pct": 84.2,
      "med_reviews": 44,
      "med_rating": 4.7
    },
    {
      "metro": "indianapolis",
      "name": "Indianapolis",
      "n": 4158,
      "website_pct": 84,
      "med_reviews": 55,
      "med_rating": 4.7
    },
    {
      "metro": "oklahoma-city",
      "name": "Oklahoma City",
      "n": 4155,
      "website_pct": 81.6,
      "med_reviews": 67,
      "med_rating": 4.7
    },
    {
      "metro": "nashville",
      "name": "Nashville",
      "n": 4102,
      "website_pct": 85.1,
      "med_reviews": 77,
      "med_rating": 4.7
    },
    {
      "metro": "louisville",
      "name": "Louisville",
      "n": 4089,
      "website_pct": 79.4,
      "med_reviews": 55,
      "med_rating": 4.6
    },
    {
      "metro": "new-york",
      "name": "New York",
      "n": 4084,
      "website_pct": 83.9,
      "med_reviews": 114,
      "med_rating": 4.6
    },
    {
      "metro": "sarasota-bradenton",
      "name": "Sarasota-Bradenton",
      "n": 4053,
      "website_pct": 84.6,
      "med_reviews": 80,
      "med_rating": 4.8
    },
    {
      "metro": "cincinnati",
      "name": "Cincinnati",
      "n": 3996,
      "website_pct": 82.8,
      "med_reviews": 54,
      "med_rating": 4.7
    },
    {
      "metro": "milwaukee",
      "name": "Milwaukee",
      "n": 3924,
      "website_pct": 84,
      "med_reviews": 43,
      "med_rating": 4.6
    },
    {
      "metro": "charleston",
      "name": "Charleston",
      "n": 3875,
      "website_pct": 85.8,
      "med_reviews": 47,
      "med_rating": 4.8
    },
    {
      "metro": "boise",
      "name": "Boise",
      "n": 3726,
      "website_pct": 86.3,
      "med_reviews": 47,
      "med_rating": 4.8
    },
    {
      "metro": "reno",
      "name": "Reno",
      "n": 3612,
      "website_pct": 84.3,
      "med_reviews": 42,
      "med_rating": 4.6
    },
    {
      "metro": "chicago",
      "name": "Chicago",
      "n": 1406,
      "website_pct": 87.7,
      "med_reviews": 315,
      "med_rating": 4.5
    },
    {
      "metro": "dallas-fort-worth",
      "name": "Dallas-Fort Worth",
      "n": 1381,
      "website_pct": 88.1,
      "med_reviews": 260,
      "med_rating": 4.5
    },
    {
      "metro": "san-francisco-bay-area",
      "name": "San Francisco Bay Area",
      "n": 1377,
      "website_pct": 86.8,
      "med_reviews": 240,
      "med_rating": 4.5
    },
    {
      "metro": "miami",
      "name": "Miami",
      "n": 1334,
      "website_pct": 81.6,
      "med_reviews": 218,
      "med_rating": 4.7
    },
    {
      "metro": "washington-dmv",
      "name": "Washington DMV",
      "n": 1327,
      "website_pct": 92.8,
      "med_reviews": 360,
      "med_rating": 4.5
    },
    {
      "metro": "orlando",
      "name": "Orlando",
      "n": 1296,
      "website_pct": 84,
      "med_reviews": 296,
      "med_rating": 4.6
    },
    {
      "metro": "minneapolis-st-paul",
      "name": "Minneapolis-St. Paul",
      "n": 1268,
      "website_pct": 91.5,
      "med_reviews": 295,
      "med_rating": 4.6
    },
    {
      "metro": "boston",
      "name": "Boston",
      "n": 1265,
      "website_pct": 90.9,
      "med_reviews": 302,
      "med_rating": 4.4
    },
    {
      "metro": "sacramento",
      "name": "Sacramento",
      "n": 1221,
      "website_pct": 84.8,
      "med_reviews": 180,
      "med_rating": 4.5
    },
    {
      "metro": "tucson",
      "name": "Tucson",
      "n": 1219,
      "website_pct": 82.3,
      "med_reviews": 197,
      "med_rating": 4.5
    },
    {
      "metro": "albuquerque",
      "name": "Albuquerque",
      "n": 1213,
      "website_pct": 85.7,
      "med_reviews": 228,
      "med_rating": 4.5
    },
    {
      "metro": "seattle",
      "name": "Seattle",
      "n": 1175,
      "website_pct": 92.3,
      "med_reviews": 332,
      "med_rating": 4.5
    },
    {
      "metro": "cleveland",
      "name": "Cleveland",
      "n": 1144,
      "website_pct": 86.2,
      "med_reviews": 238,
      "med_rating": 4.5
    },
    {
      "metro": "richmond",
      "name": "Richmond",
      "n": 1133,
      "website_pct": 88.5,
      "med_reviews": 201,
      "med_rating": 4.5
    },
    {
      "metro": "fort-myers-cape-coral",
      "name": "Fort Myers-Cape Coral",
      "n": 1123,
      "website_pct": 79.3,
      "med_reviews": 189,
      "med_rating": 4.6
    },
    {
      "metro": "tacoma",
      "name": "Tacoma",
      "n": 1116,
      "website_pct": 85.4,
      "med_reviews": 236,
      "med_rating": 4.5
    },
    {
      "metro": "hartford",
      "name": "Hartford",
      "n": 1100,
      "website_pct": 81.5,
      "med_reviews": 170,
      "med_rating": 4.5
    },
    {
      "metro": "providence",
      "name": "Providence",
      "n": 1091,
      "website_pct": 85.2,
      "med_reviews": 177,
      "med_rating": 4.5
    },
    {
      "metro": "greenville",
      "name": "Greenville",
      "n": 1020,
      "website_pct": 84.8,
      "med_reviews": 295,
      "med_rating": 4.6
    },
    {
      "metro": "des-moines",
      "name": "Des Moines",
      "n": 984,
      "website_pct": 86.8,
      "med_reviews": 209,
      "med_rating": 4.5
    },
    {
      "metro": "st-george",
      "name": "St. George",
      "n": 868,
      "website_pct": 86.5,
      "med_reviews": 178,
      "med_rating": 4.6
    },
    {
      "metro": "fargo",
      "name": "Fargo",
      "n": 782,
      "website_pct": 88.4,
      "med_reviews": 115,
      "med_rating": 4.5
    }
  ],
  "by_metro_comparable": {
    "sweep_date": "2026-08-23",
    "max_rank": 20,
    "metros": [
      {
        "metro": "miami",
        "name": "Miami",
        "n": 277,
        "website_pct": 87.4,
        "med_reviews": 707,
        "med_rating": 4.7
      },
      {
        "metro": "chicago",
        "name": "Chicago",
        "n": 278,
        "website_pct": 93.5,
        "med_reviews": 572,
        "med_rating": 4.5
      },
      {
        "metro": "orlando",
        "name": "Orlando",
        "n": 280,
        "website_pct": 86.4,
        "med_reviews": 567,
        "med_rating": 4.6
      },
      {
        "metro": "greenville",
        "name": "Greenville",
        "n": 264,
        "website_pct": 91.3,
        "med_reviews": 551,
        "med_rating": 4.6
      },
      {
        "metro": "st-george",
        "name": "St. George",
        "n": 280,
        "website_pct": 91.1,
        "med_reviews": 508,
        "med_rating": 4.7
      },
      {
        "metro": "boston",
        "name": "Boston",
        "n": 280,
        "website_pct": 92.5,
        "med_reviews": 477,
        "med_rating": 4.4
      },
      {
        "metro": "new-york",
        "name": "New York",
        "n": 280,
        "website_pct": 91.8,
        "med_reviews": 468,
        "med_rating": 4.6
      },
      {
        "metro": "washington-dmv",
        "name": "Washington DMV",
        "n": 280,
        "website_pct": 95,
        "med_reviews": 462,
        "med_rating": 4.6
      },
      {
        "metro": "tacoma",
        "name": "Tacoma",
        "n": 280,
        "website_pct": 89.6,
        "med_reviews": 439,
        "med_rating": 4.6
      },
      {
        "metro": "richmond",
        "name": "Richmond",
        "n": 280,
        "website_pct": 93.6,
        "med_reviews": 434,
        "med_rating": 4.6
      },
      {
        "metro": "seattle",
        "name": "Seattle",
        "n": 277,
        "website_pct": 93.1,
        "med_reviews": 419,
        "med_rating": 4.5
      },
      {
        "metro": "cleveland",
        "name": "Cleveland",
        "n": 280,
        "website_pct": 89.3,
        "med_reviews": 417,
        "med_rating": 4.5
      },
      {
        "metro": "dallas-fort-worth",
        "name": "Dallas-Fort Worth",
        "n": 280,
        "website_pct": 92.1,
        "med_reviews": 372,
        "med_rating": 4.6
      },
      {
        "metro": "albuquerque",
        "name": "Albuquerque",
        "n": 280,
        "website_pct": 87.9,
        "med_reviews": 356,
        "med_rating": 4.5
      },
      {
        "metro": "tucson",
        "name": "Tucson",
        "n": 280,
        "website_pct": 91.1,
        "med_reviews": 351,
        "med_rating": 4.5
      },
      {
        "metro": "tampa-st-petersburg",
        "name": "Tampa-St. Petersburg",
        "n": 279,
        "website_pct": 90,
        "med_reviews": 335,
        "med_rating": 4.6
      },
      {
        "metro": "salt-lake-city",
        "name": "Salt Lake City",
        "n": 280,
        "website_pct": 88.2,
        "med_reviews": 334,
        "med_rating": 4.6
      },
      {
        "metro": "san-francisco-bay-area",
        "name": "San Francisco Bay Area",
        "n": 280,
        "website_pct": 90,
        "med_reviews": 331,
        "med_rating": 4.6
      },
      {
        "metro": "fargo",
        "name": "Fargo",
        "n": 273,
        "website_pct": 93.8,
        "med_reviews": 325,
        "med_rating": 4.6
      },
      {
        "metro": "minneapolis-st-paul",
        "name": "Minneapolis-St. Paul",
        "n": 280,
        "website_pct": 92.9,
        "med_reviews": 319,
        "med_rating": 4.6
      },
      {
        "metro": "sacramento",
        "name": "Sacramento",
        "n": 280,
        "website_pct": 91.4,
        "med_reviews": 319,
        "med_rating": 4.5
      },
      {
        "metro": "denver",
        "name": "Denver",
        "n": 279,
        "website_pct": 90,
        "med_reviews": 313,
        "med_rating": 4.6
      },
      {
        "metro": "austin",
        "name": "Austin",
        "n": 280,
        "website_pct": 84.3,
        "med_reviews": 307,
        "med_rating": 4.6
      },
      {
        "metro": "des-moines",
        "name": "Des Moines",
        "n": 279,
        "website_pct": 90,
        "med_reviews": 294,
        "med_rating": 4.6
      },
      {
        "metro": "phoenix",
        "name": "Phoenix",
        "n": 280,
        "website_pct": 88.6,
        "med_reviews": 290,
        "med_rating": 4.5
      },
      {
        "metro": "los-angeles",
        "name": "Los Angeles",
        "n": 283,
        "website_pct": 87.6,
        "med_reviews": 272,
        "med_rating": 4.6
      },
      {
        "metro": "providence",
        "name": "Providence",
        "n": 280,
        "website_pct": 91.8,
        "med_reviews": 262,
        "med_rating": 4.6
      },
      {
        "metro": "las-vegas",
        "name": "Las Vegas",
        "n": 280,
        "website_pct": 87.1,
        "med_reviews": 254,
        "med_rating": 4.6
      },
      {
        "metro": "nashville",
        "name": "Nashville",
        "n": 278,
        "website_pct": 88.5,
        "med_reviews": 235,
        "med_rating": 4.6
      },
      {
        "metro": "oklahoma-city",
        "name": "Oklahoma City",
        "n": 280,
        "website_pct": 88.2,
        "med_reviews": 228,
        "med_rating": 4.6
      },
      {
        "metro": "houston",
        "name": "Houston",
        "n": 278,
        "website_pct": 89.9,
        "med_reviews": 221,
        "med_rating": 4.7
      },
      {
        "metro": "boise",
        "name": "Boise",
        "n": 275,
        "website_pct": 95.3,
        "med_reviews": 219,
        "med_rating": 4.7
      },
      {
        "metro": "reno",
        "name": "Reno",
        "n": 280,
        "website_pct": 92.9,
        "med_reviews": 219,
        "med_rating": 4.5
      },
      {
        "metro": "charlotte",
        "name": "Charlotte",
        "n": 280,
        "website_pct": 90,
        "med_reviews": 213,
        "med_rating": 4.7
      },
      {
        "metro": "jacksonville",
        "name": "Jacksonville",
        "n": 279,
        "website_pct": 87.5,
        "med_reviews": 210,
        "med_rating": 4.7
      },
      {
        "metro": "philadelphia",
        "name": "Philadelphia",
        "n": 280,
        "website_pct": 89.6,
        "med_reviews": 207,
        "med_rating": 4.6
      },
      {
        "metro": "portland",
        "name": "Portland",
        "n": 280,
        "website_pct": 86.8,
        "med_reviews": 200,
        "med_rating": 4.6
      },
      {
        "metro": "fort-myers-cape-coral",
        "name": "Fort Myers-Cape Coral",
        "n": 280,
        "website_pct": 80.7,
        "med_reviews": 194,
        "med_rating": 4.7
      },
      {
        "metro": "kansas-city",
        "name": "Kansas City",
        "n": 278,
        "website_pct": 83.1,
        "med_reviews": 178,
        "med_rating": 4.6
      },
      {
        "metro": "hartford",
        "name": "Hartford",
        "n": 271,
        "website_pct": 86,
        "med_reviews": 160,
        "med_rating": 4.5
      },
      {
        "metro": "atlanta",
        "name": "Atlanta",
        "n": 280,
        "website_pct": 84.6,
        "med_reviews": 159,
        "med_rating": 4.7
      },
      {
        "metro": "san-diego",
        "name": "San Diego",
        "n": 280,
        "website_pct": 87.9,
        "med_reviews": 158,
        "med_rating": 4.5
      },
      {
        "metro": "raleigh-durham",
        "name": "Raleigh-Durham",
        "n": 280,
        "website_pct": 87.9,
        "med_reviews": 154,
        "med_rating": 4.7
      },
      {
        "metro": "louisville",
        "name": "Louisville",
        "n": 272,
        "website_pct": 80.5,
        "med_reviews": 147,
        "med_rating": 4.5
      },
      {
        "metro": "san-antonio",
        "name": "San Antonio",
        "n": 276,
        "website_pct": 81.9,
        "med_reviews": 136,
        "med_rating": 4.6
      },
      {
        "metro": "sarasota-bradenton",
        "name": "Sarasota-Bradenton",
        "n": 280,
        "website_pct": 84.6,
        "med_reviews": 136,
        "med_rating": 4.8
      },
      {
        "metro": "columbus",
        "name": "Columbus",
        "n": 280,
        "website_pct": 86.1,
        "med_reviews": 132,
        "med_rating": 4.6
      },
      {
        "metro": "indianapolis",
        "name": "Indianapolis",
        "n": 280,
        "website_pct": 87.1,
        "med_reviews": 131,
        "med_rating": 4.7
      },
      {
        "metro": "milwaukee",
        "name": "Milwaukee",
        "n": 263,
        "website_pct": 90.5,
        "med_reviews": 127,
        "med_rating": 4.6
      },
      {
        "metro": "detroit",
        "name": "Detroit",
        "n": 279,
        "website_pct": 79.2,
        "med_reviews": 125,
        "med_rating": 4.6
      },
      {
        "metro": "cincinnati",
        "name": "Cincinnati",
        "n": 280,
        "website_pct": 87.1,
        "med_reviews": 123,
        "med_rating": 4.6
      },
      {
        "metro": "charleston",
        "name": "Charleston",
        "n": 270,
        "website_pct": 93.3,
        "med_reviews": 118,
        "med_rating": 4.8
      },
      {
        "metro": "baltimore",
        "name": "Baltimore",
        "n": 279,
        "website_pct": 86,
        "med_reviews": 117,
        "med_rating": 4.6
      },
      {
        "metro": "pittsburgh",
        "name": "Pittsburgh",
        "n": 278,
        "website_pct": 86,
        "med_reviews": 108,
        "med_rating": 4.5
      }
    ]
  },
  "rank_cuts": {
    "sweep_date": "2026-08-23",
    "buckets": [
      {
        "bucket": "1-3",
        "n": 2243,
        "med_reviews": 318,
        "med_rating": 4.6,
        "website_pct": 90.8
      },
      {
        "bucket": "4-10",
        "n": 5279,
        "med_reviews": 258,
        "med_rating": 4.6,
        "website_pct": 88.3
      },
      {
        "bucket": "11-20",
        "n": 7503,
        "med_reviews": 234,
        "med_rating": 4.6,
        "website_pct": 88.4
      },
      {
        "bucket": "21+",
        "n": 58259,
        "med_reviews": 176,
        "med_rating": 4.5,
        "website_pct": 85.6
      }
    ]
  },
  "week_over_week": {
    "from": "2026-08-16",
    "to": "2026-08-23",
    "pairs": 67607,
    "mean_review_delta": 1.94,
    "pct_gained_reviews": 44.1,
    "pct_lost_reviews": 2.7,
    "med_abs_rank_delta": 4,
    "pct_rank_moved_3_plus": 62.6,
    "pct_entered_top3": 0.7,
    "pct_exited_top3": 0.7,
    "gained_website": 39,
    "lost_website": 10,
    "top3_retention_pct": 78.4,
    "top10_retention_pct": 83.5,
    "top10_new_entrant_pct": 1.7
  }
}