Industry Best Practices & Top Insights delivered to your Inbox.
Blog Product

Announcing Pivots for Advanced Data Insights

Subharun Mukherjee 18+ years of experience leading product strategy, Go-To-Market (GTM), new market entry, value-based sales, analyst relations, and customer experience programs. Expertise in Financial Services, eCommerce, on-demand services, and the SaaS industry.
Announcing Pivots for Advanced Data Insights

We at CleverTap, strongly believe that your marketing engagement strategy needs to be backed by powerful, real-time and actionable analytics. This is why we built a platform that unifies analytics and engagement under one roof. Thriving from the same ethos, we are extremely excited to roll out our brand new analytics feature ‘Pivots’ – the champion of insights!

What are Pivots?

Pivots is an industry first data-exploration tool that summarizes your data and helps you slice it and dice it with the help of tables and other meaningful data visualizations.
Historically, event analysis has been used by marketers and product owners to look at event counts and how they trend over time, or to explore the values of a single event property. With Pivots, you can now correlate data across multiple properties and get additional insights that can help them to make better business decisions.
Pivots with CleverTap
Your analysis can be pivoted on any event or user property, demographics, technographics, session fields, etc. This data can be viewed in multiple different visualizations, with each visualization having it’s own significance. While being completely exploratory, it enables data to speak to you directly, without any assumptions or biases!
Pivot Visualizations

What makes Pivots cool?

Let’s say that you own a flight booking travel business. You have your tickets purchase data (Charged event) flowing into CleverTap. With Pivots, you will be able to get instant answers to:

  1. The most active window for transactions

  2. By pivoting on day of the week and on time of the day, you can spot the golden window for the highest number of transactions on your platform.
    Pivoting on Day of the Week
    Thus, based on the heatmap above, you can infer that Thursdays between 3 pm and 6 pm in the evenings is when your users convert the most. Based on this insight, you can act faster on cart abandonments in this period to ensure conversions.

  3. Popular booking class in various cities

  4. Pivoting on Cities & Class
    By pivoting on cities and booking class, you can infer that the economy class is popular in New York City, whereas the business class is not.

  5. Revenue made across cities with various booking class

  6. You can pivot the results on the sum of a particular integer property of an event (price in case of Charged event)
    Pivoting on Revenue
    Albeit having higher transactions in New York City overall, San Francisco has generated higher revenue even with lesser number of business class bookings.

  7. Trend of revenue from different cities

  8. You can view the trend of revenue from different cities over time by pivoting on cities and time of the week.
    Pivoting on Time of the Week

  9. Popular category of flight bookings made from the app

  10. Pivoting on Device
    By pivoting on category of the booking, and the device used for the booking, you can analyse whether international bookings are made from the app or website.

You can do all this, in less than 10 minutes with CleverTap Pivots (no more formulas and no more offline data crunching!)
We want to help our clients ease their workload and increase their efficiency. Pivots allow product managers and marketers with a reporting tool for drilling down large volumes of data by creating and viewing custom reports that help glean valuable insights. And oh, did we mention that all of the above data can be directly exported into a .csv file if you wish to do you own analysis?
But here’s the best part: Pivots, with all its beauty and dynamism, is completely horizontal. Whether you are an ecommerce store or a food tech company, Pivots empower all marketers to make decisions based on insights and visualisations.
We hope you play around with this feature and love it as much as we do! We’d love to hear what you think about this. It is available in beta for all our clients for a limited duration.
Meanwhile, go ahead and play with your data, let it speak to you and get to know those essential truths about your app users that really matter!
Read more on our docs.

The Intelligent Mobile Marketing Platform

See how today’s top brands use CleverTap to drive long-term growth and retention.

Schedule a Demo Now!

Last updated on March 13, 2024