Analytics Data Analyzer
Drop in a CSV export and get the story behind the numbers: what moved, what is unusual and where the traffic concentrates.
About this tool
Raw exports are hard to read. This analyzer works out what kind of data you pasted. With a date column it plots the trend with a moving average, compares the two halves of the period, flags days that are statistically unusual and shows which weekdays perform best.
Without dates, it treats the first text column as the item (page, source, campaign) and shows how concentrated your traffic is, which rows drive 80 percent of it and which busy rows fail to convert.
Why use this tool
Trend and smoothing
Daily values with a 7-day average so real movement stands out from noise.
Anomalies
Days more than two standard deviations from normal, with a check for spikes that did not convert.
Concentration
How many rows deliver most of the traffic.
How it works
- Export a report from your analytics tool as CSV.
- Paste it. A header row is required.
- Read the highlights, then look at the chart and the summary table.