Mixpanel Export

Understand how you can export event data from CleverTap to the Mixpanel dashboard. To learn more about the import feature, refer to Mixpanel Import.

📘

Feature in Beta

This is a pre-release feature. If you are an Enterprise user and have any queries about the feature, contact CleverTap Customer Success Team. If you are a CleverTap for Startups user and have any queries about the feature, raise a ticket.

Overview

Mixpanel data export enables exporting your CleverTap event data to the Mixpanel dashboard.

📘

Export Limit Per Event

Mixpanel supports the export of only 255 event properties per event. If the limit exceeds, CleverTap exports the first 255 event properties.

Setup

The setup involves adding Mixpanel project details to the CleverTap dashboard. To add the project details:

  1. Log in to your CleverTap account.
  2. Navigate to Settings > Partners > Exports.
  1. Click the Mixpanel icon under the Unconnected partners section. The Mixpanel page displays.
  2. Enter the Mixpanel project details.

Field

Description

Mixpanel Project ID

The Project token is used to send event data to Mixpanel. For more information, refer to Project ID.

Service Account Username

A descriptive name for the service account in Mixpanel. For more information, refer to Service Account Username.

Service Account Secret

The secret API is the key that corresponds to your project. For more information, refer to Service Account Secret.

Data Residency

The physical/geographical storage location of a project's data (EU or Standard) at a project level (per project).
For more information, refer to Data Residency.

Mixpanel Distinct ID Mapping

This user property is used as an identifier when sending events data to Mixpanel. For more information, refer to Distinct ID.

  1. Click Save credentials. On clicking, the following popup displays:

Mixpanel is now displayed under Connected partners when you navigate to Settings > Partners > Exports.

Create New Export

To create a new export:

  1. Navigate to Settings > Partners > Exports.
  2. Navigate to the Activity log tab and then click + Create Export.

On clicking, the Create new board popup displays.

  1. Configure the settings as required.
    • Choose an export partner: Select Mixpanel from the Choose an export partner list.
    • Export details: Select the events to export from the available options. For more information, refer to Export Details.
    • Choose export frequency: Select from one of the following options:
      • One time: Single export for the export type selected. You can export data up to the last 60 days.
      • Recurring: Set up a recurring export that exports all the new events captured in the last window. You can export data as frequently as every 4 hours and up to once every 24 hours.

📘

Rate Limits

If you are a Mixpanel enterprise customer and require a higher limit for a one-time backfill, contact [email protected] with your project_id and use-case.

  1. Click Create export.

On successful creation of export, the following message is displayed:

  1. Click Ok to return to the Exports page.

Stop Export

You can also stop the export that you have created. To stop the current export:

  1. Click the ellipsesellipses icon for the export request you want to stop and then click stopstop.

You are prompted to confirm your action.

  1. Click Yes, stop export to stop the export request. On clicking, the following message displays:
  1. Click Ok to return to the Exports page.

Export Details

Select from one of the following options to export events from CleverTap to the Mixpanel dashboard:

All events

Export data for all defined events including System and Custom events.

Selected events

Select the specific events to export.

Engagement Events

Export the following engagement events:

CleverTap Event Name

Description

Notification Sent

  • The event is tracked when the notification is successfully sent from CleverTap to the communication channel you select for your campaign.
  • This event is always recorded, even if the user does not open or click on the message.
  • This event is recorded for email, mobile push, SMS and web push campaigns.
  • The event is available on the Event dashboard but it is not displayed on the User Profile.

Notification Viewed

  • The event is tracked when a user views an email, in-app notification, or a web notification sent from CleverTap.
  • The event is available for email, web push, in-app, web popup, and app inbox.

Notification Clicked

The event is tracked when a user clicks on a mobile push, in-app, email, web-popup, or web push message sent via the CleverTap dashboard or through the campaign API.

Push Impressions

  • After the toggle for Push Impressions is turned on/setup from settings, the CleverTap SDK starts recording an event whenever a push notification sent via CleverTap is delivered to the user’s device.
  • The funnels on the Push campaign statistics page reflects the count for this event.

Notification Replied

This event is tracked when the brand receives a reply from the user for WhatsApp.

Push Unregistered

  • This debug event is tracked when an existing mobile push token is removed for a profile.

  • The event is tracked for a profile when:

    • A user logs out of the device and another user logs in. Applicable only if the onUserLogin() method is implemented.
    • When a push token is removed using the pushFcmRegisterationId("token",false) method. Applicable only for Android.

Control Group

The event is tracked when a campaign is activated with a Control group.

Channel Unsubscribed

  • The event is raised when an email is not acknowledged.

  • The following are the event properties:

    • Campaign ID: This is the ID of
      the campaign from which user are updating subscriptions.
      Campaign Type: Currently only email.
    • Group: Group name from which the user unsubscribed/resubscribed.
    • Identity: The user identity/email address.
    • Variant Type: Valid values are bounced, dropped, and spam. Email IDs which bounce, drop or marked as spam are opted out from future emails
    • Subscription Type: Account level and profile level. Profile level signifies that the user who qualified for the communication is opted out. Account level signifies that all users with the email address are opted out from future communications.
    • Reason: Reason which was given by the email provider for the type of the error. For example: "smtp;550 5.1.1 The email account that you tried to reach does not exist. Please try double-checking the recipient's email address for typos or unnecessary spaces."

Reachable By

The event is tracked for a profile when:

  • Push token is added/changed.
  • Email ID is added/changed.
  • Phone number is added/changed.

Notification Delivered

The event is tracked when the WhatsApp provider confirms that the notification has reached the end user (double-tick of WhatsApp).

AB Experiment Rendered

The event is tracked when you are using the Product A/B Tests feature and the variant reaches the device.

AB Experiment Stopped

The event is tracked when you are using the Product A/B Tests feature and the AB experiment is stopped.

AB Experiment Rolled Out

The event is tracked when you are using the Product A/B Tests feature and the winner variant is sent to all the devices.

Geocluster Entered

The event is tracked when you enable the geofence feature and your device enters a geofence.

Geocluster Exited

The event is tracked when you enable the geofence feature and your device exits a geofence.

Reply Sent

The event is tracked against the user profile of the end user when an agent (CleverTap user) replies to a WhatsApp message from the end user.

App Uninstalled

  • The event is tracked when the user uninstalls the application.

  • There are three cases when this event is tracked multiple times for a single user:

    • The first case is when a user installs your app, uninstalls it, and then reinstalls it.
    • The second case is when a user clears the app's memory.
    • The third case is when a user installs your app on multiple devices.

Webhook Delivered

The event is tracked when a webhook campaign is delivered successfully.

State Transitioned

  • The event is tracked whenever a user transitions from one state to another or from unmapped to one of the states in the lifecycle optimization framework.

UTM Visited

  • The event is tracked when a user clicks on a link from a marketing campaign that has a UTM parameter defined on it.
  • The event is also tracked when a CleverTap-integrated attribution platform, such as Branch or Apsalar, sends this information to CleverTap.

📘

Availability of Feature

This feature is available only for the Enterprise plan. Contact your sales account manager to activate it.


Did this page help you?