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.
The chart
01 / Symptom
Session data was meant to feed a VP-level marketing dashboard, and nobody had checked whether it could.
02 / Tests
Audited 20+ session fields in SAS Studio with frequency tables and summary statistics.
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%.
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.
05 / Outcome
A set of preparation rules for the dashboard. It was an audit, so no business impact is claimed.
How the tests ran
- Ran frequency tables and summary statistics on every field to find high-cardinality categories, missing values and formatting issues.
- Grouped infrequent browsers, metros, operating systems and ISPs into readable categories while keeping useful "Unknown" groups.
- Separated missing order fields from true zeros, and recommended date, hour and weekday fields, cleaner traffic sources and five-character ZIP codes.
- 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.