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
Push Notification

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

Read More
Rich User Profiles

Rich user profiles are the detailed personas created for every user who interacts with your app. ...

Read More
RFM Analysis

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

Read More
Flows

Flows is a feature in the CleverTap mo...

Read More

8,000+

55 Billion

1 Billion

10 Billion