Mixpanel Connector > Mappings for Mixpanel > Mixpanel sources in mappings
  

Mixpanel sources in mappings

To read data from Mixpanel, configure a Mixpanel object as the Source transformation in a mapping.
Specify the name and description of the Mixpanel source.
The following table describes the source properties that you can configure for a Mixpanel source:
Property
Description
Connection
Name of the Mixpanel source connection.
You can select an existing connection or create a new connection. You can also click New Parameter to define a parameter for the source connection.
Source Type
Type of the source object.
Select one of the following options:
  • - Single Object
  • - Multiple Objects
  • - Parameter
Related objects appear based on simple primary key-foreign key relationship. You can use the Advanced Relationship option to define the relationship for objects that you want to join.
Object
Name of the Mixpanel source object based on the source type selected.
Select the source object for a single source. When you select the multiple source option, you can add source objects and configure a relationship between them.
The following table describes the advanced source properties that you can configure in a Source transformation:
Property
Description
Project ID
Required. The ID of the project in Mixpanel.
The project ID is the number at the end of the access URL of the project.
Bookmark ID
The bookmark ID of the report.
Funnel ID
Required for the FunnelsQuerySavedReport object.
The Funnel ID in Mixpanel.
From Date
The start date from which you want to read the data for an object.
Specify the date in yyyy-mm-dd format.
To Date
The end date till which you want to read the data for an object.
Specify the date in yyyy-mm-dd format.
Retention Type
Required for the RetentionQueryretentionReport object.
The retention type of the users.
Select one of the following options:
  • - birth. To read data that corresponds to first time retention.
  • - compounded. To read data that corresponds to recurring retention.
Default is compounded.
Addiction Unit
Required for the RetentionQueryfrequencyReport object.
The frequency of the events.
Select one of the following options:
  • - hour
  • - day
Default is day.
Event
Required for the NumericallySum, NumericallyAverage, and QuerySegmentationReport objects.
The name of the event for which you want to get the data.
Format
The format of the source data.
Select one of the following options:
  • - json
  • - csv
Default is json.
On
Required for the NumericallySum and NumericallyAverage objects.
The expression to sum per unit time.
Distinct ID
Required for the ProfileEventActivity and TopEvents objects.
The distinct ID of the user profile.
Unit
Required for the RetentionQueryfrequencyReport object.
The overall time period to return frequency of actions.
Select one of the following options:
  • - day
  • - week
  • - month
Default is day.
Type
Required for the TodaysTopEvents object.
The analysis type for the event.
Select one of the following options:
  • - general
  • - unique
  • - average
Default is general.
Tracing Level
Sets the amount of detail that appears in the log file.
Select one of the following options:
  • - terse
  • - normal
  • - verbose initialization
  • - verbose data
Default is normal.