3 powerful ways to use pivot tables

3. Time patterns

A powerful way to explore user engagement over time. Use days or weeks as the columns of your pivot table and individual users or customers as the rows, for example:

• Was Active by User and Days
• Number of Active users by Organization account and Weeks

This gets you a big map of engagement that helps you see a number of different patterns. You can spot if users are active every day in streaks or every other day regularly, if weekends are different than weekdays, and how certain customers are ramping up or down their usage. Use this analysis to understand the underlying patterns that are driving your top-level metrics.