{
    "action": "final",
    "content": "**What it is:** This is a web-analytics dataset for the City of Baton Rouge / Parish of East Baton Rouge (brla.gov and the older brgov.com). It has 62,496 rows in one table, `raw.Website_Analytics`, covering about 11 distinct websites and years 2014–2024. The sample rows show properties such as `www.brla.gov`, `data.brla.gov` and the legacy `brgov.com`.\n\n**What one row represents:** One row is the annual traffic summary for one page on one website. The grain is WEBSITE + YEAR + PAGE URL. For example, the sample row for `www.brla.gov` in 2023 is the page `/723/district-7-lamont-cole`, with 99,396 page views and 85,859 unique views. It has 52,341 entrances, a 34.21% bounce rate and a 24.28% exit rate.\n\n**Columns on each row:**\n- **Identity:** `WEBSITE`, `YEAR`, `PAGE PATH` and `PAGE URL`.\n- **Traffic volume:** `PAGE VIEWS`, `UNIQUE VIEWS` and `ENTRANCES`, where entrances count visits that started on that page.\n- **Engagement:** `AVERAGE TIME ON PAGE (SECONDS)`, `BOUNCE RATE (%)` and `EXIT RATE (%)`.\n- **Ingestion metadata:** `_ingestion_timestamp`, `_batch_id`, `_source_file` and `_source_system`.\n\n**Things to know from the samples:**\n- Traffic is very uneven. Some pages have millions-scale-style heavy use (the 2023 district page above has about 99k views), while others have a single view (e.g. `/metro21/stream` on brgov.com in 2017).\n- Some pages have zero entrances and 0% bounce, which means they were only reached from other pages on the site, not entered directly.\n- `PAGE PATH` can be very long. Some data.brla.gov pages are Socrata query URLs with encoded SQL.\n- The 8 rows I looked at are a small sample, so I have not computed totals or trends across the full table.\n\nThe data suits decisions about which pages or sites to invest in, fix or retire, and whether to wind down legacy sites like brgov.com."
}