Skip to content
Chayan Aggarwal Résumé
All case files
Case 03AcademicCourse projectMKTG-525 marketing analytics, Red Ventures telecom session data, University of Bridgeport

Is this data ready for the VP's dashboard?

An audit of website-session data in SAS before any of it reached a VP-level marketing dashboard.

Desktop70.45%Mobile23.83%Tablet5.72%
Share of visits by device type, from the SAS frequency output.

The chart

  1. 01 / Symptom

    Session data was meant to feed a VP-level marketing dashboard, and nobody had checked whether it could.

  2. 02 / Tests

    Audited 20+ session fields in SAS Studio with frequency tables and summary statistics.

  3. 03 / Diagnosis

    Desktop 70.45%, mobile 23.83%, tablet 5.72% of visits; 89.20% of visits saw one page; manufacturer unknown for 53.24%.

  4. 04 / Prescription

    Group long-tail browsers and ISPs, check session IDs for duplicates before counting visits, and treat a blank order as zero only once confirmed.

  5. 05 / Outcome

    A set of preparation rules for the dashboard. It was an audit, so no business impact is claimed.

How the tests ran

  1. Ran frequency tables and summary statistics on every field to find high-cardinality categories, missing values and formatting issues.
  2. Grouped infrequent browsers, metros, operating systems and ISPs into readable categories while keeping useful "Unknown" groups.
  3. Separated missing order fields from true zeros, and recommended date, hour and weekday fields, cleaner traffic sources and five-character ZIP codes.
  4. Flagged fields with no dashboard value, such as Country, which had no variation.

Tools

  • SAS Studio
  • Excel
  • Data profiling

Findings

  • 97.04%

    of visits came from the six most common browsers

  • 89.20%

    of visits viewed one distinct page

  • 53.24%

    of manufacturer values were unknown, so brand-level findings need a caveat

Limits

  • The analysis prepares a dashboard; it is not evidence that one was built or deployed.
Next case / 04The forecast that barely beat yesterday