Mixpanel

Mixpanel is a real-time analytics platform that helps companies measure and optimize user engagement.

For more information about the API, see the Mixpanel Query API and Event Export API.

See the Schema section for a list of objects available for replication.

Mixpanel integration summary

Immagine di alto livello di questo connettore, inclusi collegamenti utili e funzionalità supportate.

Funzionalità/Capacità	Dettagli del supporto
Progetti Qlik Talend Data Integration supportati	Solo i progetti di replica. I progetti delle pipeline di dati non sono supportati.
Metodi di aggiornamento della destinazione	Attività di replica: Applica modifiche Archivia modifiche Trasferimento dei dati nelle attività di un data lake: Change Data Capture (CDC)
Gestione dei metadati	La generazione manuale dei metadati non è richiesta.
Evoluzione dello schema	È supportata solo l'operazione Cambia tipo di dati colonne.
Replica delle colonne LOB (NCLOB, CLOB e BLOB)	Operazione non supportata.
CDC pianificato	Operazione richiesta. In questo modo la destinazione viene aggiornata con le modifiche apportate alla sorgente. Per le attività di replica, vedere Pianificazione delle attività CDC per i processi di replica Per le attività di trasferimento su data lake, vedere Pianificazione delle attività CDC per i processi di trasferimento su data lake
Notifiche	Operazione parzialmente supportata Impostare notifiche quando vengono apportate modifiche al funzionamento
Monitoraggio	Solo attività CDC, in quanto il caricamento completo non è rilevante per questo connettore. Monitoraggio di un'attività dati individuale
Annullamento automatico della nidificazione dei payload nelle colonne JSON	Operazione non supportata. La nidificazione per i payload della colonna JSON nei set di dati di origine non viene annullata automaticamente nella destinazione.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Assicurarsi che l'account utilizzata disponga di accesso di lettura per le tabelle che si desidera recuperare.

To obtain the project timezone and API secret:

Make sure you have the Admin privileges in Mixpanel. You need them to access the API secret.
Log into your Mixpanel account.
In the dropdown menu in the upper left corner of the page, select the project you want to replicate data from.
Hover over the Settings icon in the upper right corner. In the Project Settings section, click the name of your project.
Copy the Project Timezone and API Secret.

Creating the connection

Per ulteriori informazioni, vedere Connessione alle applicazioni SaaS.

Inserire le proprietà di connessione richieste.
Fornire un nome per la connessione in Nome connessione.
Selezionare Apri metadati di connessione per definire i metadati della connessione al momento della creazione.
Fare clic su Crea.

Connection settings
Setting	Description
Data gateway	Selezionare un Data Movement gateway se richiesto dal proprio caso di utilizzo. Nota informatica Questo campo non è disponibile con la sottoscrizione a Avvio Qlik Talend Cloud, poiché non supporta il Data Movement gateway. Se si dispone di un altro livello di sottoscrizione e non si desidera utilizzare il Data Movement gateway, selezionare Nessuno. Per informazioni sui vantaggi del Data Movement gateway e quando è richiesto, vedere Qlik Data Gateway - Data Movement.
Start Date	Inserire la data, nel formato `MM/DD/YYYY`, a partire dalla quale i dati devono essere replicati dalla sorgente alla destinazione.
API Secret	API secret.
Attribution Window (days)	Enter the number of days you want your tables’ attribution window to be.
Project Timezone	Project timezone.
Export Events (optional)	Enter the events separated by a comma. Example: `Page Viewed, Signed Up`.
Select Properties By Default	To capture new properties automatically in the `events` and `engage` tables, select the check box. Otherwise, new properties will be ignored.
EU Residency	To process and store your customers’ personal data in Europe, select the check box.

Schema

Mixpanel free plan

The engage and export tables are not available if you are using the free Mixpanel plan.

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

annotations

The annotations table contains info about annotations.

Replication Method

Full Table

Primary Key

date

Useful links

Mixpanel documentation

Join annotations with	on
cohorts	annotations.project_id = cohorts.project_id

date

DATE-TIME

description

STRING

INTEGER

project_id

INTEGER

cohort_members

The cohort_members table contains info about the cohorts user profiles belong to.

Replication Method

Full Table

Primary Keys

cohort_id

distinct_id

Useful links

Mixpanel documentation

Mixpanel API method

Join cohort_members with	on
cohorts	cohort_members.cohort_id = cohorts.id

cohort_id

INTEGER

distinct_id

STRING

cohorts

The cohorts table contains info about the cohorts in a Mixpanel project.

Replication Method

Full Table

Primary Key

Useful links

Mixpanel API method

Join cohorts with	on
cohort_members	cohorts.id = cohort_members.cohort_id
annotations	cohorts.project_id = annotations.project_id

count

INTEGER

created

DATE-TIME

description

STRING

INTEGER

is_visible

INTEGER

name

STRING

project_id

INTEGER

engage

The engage table contains info about user profiles.

The schema for this table is dynamic, meaning that the detected columns are dependent upon the properties provided upon upload in Mixpanel. For every property available in Mixpanel for engage records, a column will be displayed in the integration’s Tables to Replicate tab.

Replication Method

Full Table

Primary Key

distinct_id

Useful links

Mixpanel API method

distinct_id

STRING

export

The export table contains “raw data dumps” of tracked events. The API endpoint for EU region servers will return a 200 terminated early error code.

Table schema

The schema for this table is dynamic, meaning that the detected columns are dependent upon the properties provided upon upload in Mixpanel. For every property available in Mixpanel for export records, a column will be displayed in the integration’s Tables to Replicate tab.

Replication with attribution window

This table is replicated using the Attribution Window value defined in the integration’s settings page. Refer to the Replication section for more info.

Distinct events and loading behavior

As a Primary Key is not used for this table, data will be loaded using Append-Only loading. This means you may see duplicate records in your destination, which requires a querying strategy that selects the latest version of each record.

This approach allows to track events without a distinct_id. In Mixpanel, distinct_id is used to identify a unique user:

Mixpanel’s client-side tracking libraries automatically assign a distinct_id to a user when they first visit a website or an application that has Mixpanel installed. Distinct_id should not contain any special characters such as forward slashes, as it will break the URL. Distinct_ids can and often should be sent in server-side implementations as well.

In order to replicate records’ distinct_id attributes, your server-side Mixpanel implementation must send them with tracked events. If the server-side implementation doesn’t do this, this attribute will be null.

Previous versions of Mixpanel integration used distinct_id as part of a composite Primary Key for this table. However, due to the possibility of this attribute being null, a Primary Key is not used for this table, as null values in Primary Key columns will prevent successful Extraction.

When working with exports data in your destination, you’ll need to use a querying strategy that accounts for the Append-Only loading used by this table. We recommend using the following columns to de-duplicate records, along with the approach outlined in the Querying Append-Only tables guide:

distinct_id
event
time

Replication Method	CDC
Loading Behavior	Append-Only
Replication Key	time
Useful links	Mixpanel API method

dataset

STRING

distinct_id

STRING

event

STRING

labels

ARRAY

sampling_factor

INTEGER

time

DATE-TIME

funnels

The funnels table contains data about your Mixpanel funnels, segmented by funnel and day.

Note: This table is replicated using the Attribution Window value defined in the integration’s settings page. Refer to the Replication section for more info.

Replication Method	CDC
Primary Keys	funnel_id date
Replication Key	date
Useful links	Mixpanel API method

analysis

OBJECT

This is a nested data structure:

completion: INTEGER
starting_amount: INTEGER
steps: INTEGER
worst: INTEGER

date

DATE

datetime

DATE-TIME

funnel_id

INTEGER

name

STRING

steps

ARRAY

This is a nested data structure:

avg_time: NUMBER
count: INTEGER
event: STRING
goal: STRING
overall_conv_ratio: NUMBER
step_conv_ratio: NUMBER
step_label: NUMBER
time_buckets_from_prev: OBJECT, which is also a nested data structure.
buckets, ARRAY
- higher: INTEGER
- lower: INTEGER
time_buckets_from_start: OBJECT, which is also a nested data structure.
buckets, ARRAY
- higher: INTEGER
- lower: INTEGER

revenue

The revenue table contains info about revenue, segmented by day. The API endpoint for EU region servers will return a 400 bad requests (Timeout Error) code.

Note: This table is replicated using the Attribution Window value defined in the integration’s settings page. Refer to the Replication section for more info.

Replication Method

CDC

Primary Key

date

Replication Key

date

amount

NUMBER

count

INTEGER

date

DATE

datetime

DATE-TIME

paid_count

INTEGER

Hai trovato utile questa pagina?

Se riscontri problemi con questa pagina o con il suo contenuto – un errore di battitura, un passaggio mancante o un errore tecnico – ti pregiamo di farcelo sapere!

Lascia qui il tuo feedback