Pivot Analysis

July 9, 2018

A pivot analysis is a data-exploration tool that summarizes your user data. It helps you make meaningful data visualizations.

What are Pivots & How Do They Help?

Pivots are a way to look at and analyze your data using specific filters.

Typically, marketers will analyze a campaign by looking at event counts and how these numbers trend over time. For example: you may want to look at the success of an email campaign by looking at the open rates or the click-through rates (event counts) and how these numbers trend as the campaign progresses.

Your analysis can be pivoted on any user property (e.g. all users who opened the email from mobile), demographics (e.g. UK users who opened the email), psychographics (e.g. users who opened the email who like shoes), session fields, and much more.

Pivot Analysis in CleverTap

In CleverTap, Pivots is a powerful data summarization tool that compares performance of a given event across all its properties over time. In other words, Pivots allows you to view all of your data in many different ways so you can find the insights you need.

One way Pivots can help: you can dive into a single event that is critical to your mobile app. In a familiar spreadsheet-like view, you can look at an event’s session properties, geographical properties, technographics, demographics, and custom properties to rapidly isolate a unique trend that may be difficult to pinpoint otherwise.

An example for an entertainment app: compare average revenue per movie across cities to analyze ticket revenue by geographic area.

How CleverTap Does Pivot Analysis

This 1:41 minute video explains CleverTap’s Pivots feature and how it allows mobile marketers to get at advanced data insights.

Read More About Pivot Analysis

In today’s crowded App Store, users rely heavily on app reviews to choose whether or not to download your mobile ...
We at CleverTap, strongly believe that your marketing engagement strategy needs to be backed by powerful, real-time and actionable analytics. ...
At CleverTap, we maintain ongoing conversations with our customers to discuss how we can better help them solve their mobile ...
Back to Glossary
Related Keywords
Funnel Analysis

Funnel analysis is the study of funnels in your website or app. A funnel can be defined as a chro...

Read More
Push Notification

Push notifications are messages sent to users encouraging them to undertake specific actions in y...

Read More
RFM Analysis

RFM analysis (Recency, Frequency, and Monetary Analysis) is the process of figuring out which use...

Read More

SMS, also known as text messages or text messaging, is a staple of mobile communication around th...

Read More


$2 Billion

1 Billion

20 Million