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.

Overview

This section provides information about exporting event data from CleverTap to the Mixpanel dashboard. CleverTap also offers to import Mixpanel cohorts. To learn more about this feature, refer to Mixpanel Import.

πŸ“˜

Export Limit Per Event

Mixpanel supports exporting only 255 event properties per event. If the number of event properties exceeds the Mixpanel limit, the 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.
2850

Navigate to Partners Page

  1. Hover on the Mixpanel icon and click Integrate.
2372

Integrate Mixpanel

On clicking, Integrate analytics partner - Mixpanel popup opens on the right side of the screen.

  1. Enter the following details and click Integrate:

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 Data Residency is the physical/geographical storage location of data (EU or Standard) for each project.
  • For more information, refer to Data Residency.
Mixpanel Distinct ID MappingThis user property is used as an identifier when sending events data to Mixpanel. For more information, refer to Distinct ID.
2372

Enter Mixpanel Project Details to Integrate

After successful integration, the Integrated tag displays against Mixpanel on the Partner List page.

2224

Mixpanel Integration Successful

Create New Export

To create a new export:

  1. Navigate to Settings > Partners > Exports.
  2. Click + Export and select Mixpanel from the Partners list.
2376

Create Export

On clicking, the Export to Mixpanel popup displays on the right side of the screen.

2346

Enter Export Details

  1. Configure the settings as required.
    • Type: Select the events to export from the available options. For more information, refer to Export Details.
    • Frequency: Select from one of the following options:
      • One time: A single export for the selected export type. You can export data up to the last 60 days. You create an export for a specific day, date range, previous month, current month, and more.
      • 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 Export. On clicking, the popup closes and the following message displays at the top of the Exports page:
2442

Mixpanel Export Initiated

CleverTap processes the export, and you can now see the newly created export for Mixpanel.

2376

New Mixpanel Export Displays on Exports Page

The status for each export is displayed as Pending as soon as the export is created. The status changes to Running after the processing starts. It changes to Done when the export is complete.

Stop Export

You can also stop ta running export. To do so, click the Stop export icon and click Stop to confirm your action.

2376

Stop Mixpanel Export

On clicking, you are navigated back to the Exports page and the Mixpanel data export stopped message displays at the top. The status of export is now displayed as Stopped.

2368

Mixpanel Export Stopped

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 the message.
  • This event is recorded for Email, Mobile Push, SMS, and Web Push campaigns.
  • This event is available on the Event dashboard but not on the User Profile.

Notification Viewed

  • The event is tracked when a user views an email, in-app, or 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 Push Impression is implemented in the SDK, the toggle must be turned on from the CleverTap dashboard.
  • This event is recorded whenever a push notification sent via CleverTap is delivered to the user’s device.
  • The funnels on the Push campaign statistics page reflect 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 users 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 that 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 an unmapped state 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.