Period-over-Period Analysis: Measuring Change Over Time
Period-over-Period analysis answers 'Are we getting better?' by comparing metrics from consecutive time blocks, like this month's sales vs. last month's. The footgun is ignoring seasonality, which can create false signals of growth or decline.
Why it exists
A single data point, like '$100k in revenue this month,' is meaningless without context. Businesses need to know if that's good or bad, and if the trend is moving in the right direction. Period-over-Period analysis was created to provide this immediate context by comparing performance to the recent past, answering the question: 'How are we doing right now compared to just before?'
The mental model
Think of it like looking at your car's speedometer. Seeing '60 mph' is a snapshot. Knowing you were going '50 mph' a minute ago tells you that you are accelerating. PoP analysis is the business equivalent of checking for acceleration or deceleration by comparing the current period's 'speed' (e.g., revenue) to the previous period's.
How it works
The calculation is simple: (Current Period Value - Previous Period Value) / Previous Period Value. This gives a percentage change. For example, if revenue was 110k this month and 100k last month, the month-over-month growth is (110k - 100k) / $100k, or 10%. The key is using identical, consecutive, non-overlapping time periods, such as full weeks, months, or quarters.
When to use it
Use PoP for short-term trend analysis where you need to understand the immediate impact of actions. It's ideal for tracking the results of a new marketing campaign on weekly signups, a feature launch on daily active users, or a pricing change on monthly revenue. It helps teams react quickly to performance shifts.
When not to use it
Avoid using PoP analysis in highly seasonal businesses without adjusting for it. Comparing December retail sales to November's will always show a huge spike but says little about the business's underlying health. For comparing periods influenced by strong seasonality, a Year-over-Year analysis (comparing this December to last December) is often more insightful.
One canonical example
An e-commerce company launches a new checkout flow. To measure its impact, they track the weekly conversion rate. The week after launch, the rate is 5%. The week before, it was 4%. The week-over-week analysis shows a (5% - 4%) / 4% = 25% increase in conversion, giving a strong, immediate signal that the new flow is effective.
Interview question
To quickly gauge the immediate effect of a new product feature launched last week, which comparison best utilizes Period-over-Period (PoP) analysis?
- a.Comparing this week's user engagement metrics against a predefined target for the feature.
- b.Comparing this week's user engagement metrics to the average of the last four weeks.
- c.Comparing this week's user engagement metrics to the same week last year.
- d.Comparing this week's user engagement metrics to last week's user engagement metrics.Correct
Why? this is the answer
Period-over-Period analysis is specifically designed to measure the immediate impact of recent actions by comparing consecutive time blocks, such as this week versus last week. Comparing to the same period last year (Year-over-Year) is for seasonality, while comparing to an average or a target does not fit the definition of PoP.
Just read this? Test yourself on what you have been reading.
Read the original → hex.tech
- #analytics
- #metrics
- #business intelligence
- #data analysis
You just looked this up. Could you explain it out loud?
That is the part interviews actually test. Tezvyn takes questions like this one and gives you what the interviewer is really checking, the answer that lands, and the mistake that ends the conversation, in the four minutes before your next meeting.
The iPhone app is on the way
We are building it. Until it lands, nothing here is held back from you: every interview card, your saved cards, streaks and the job board all work in Safari, plus hundreds of free practice quizzes of thirty questions each. Sign in and it all carries over to the app the day it arrives.
Want it as an icon? Tap Share at the bottom of Safari, then Add to Home Screen. It opens full screen and the cards you have read stay available offline.
We are hiring for this. Open roles that interview on analytics — each one lists the topics its interview covers.
See open roles