Integration with Mixpanel

Ideas & Features Integrations
1

I would like to integrate Fibery with a Mixpanel, but I see problems and limitations due to identification of records for it’s deletion and updating. There are two types of integration I would like to create:

  • Cohort Integration
  • Report Integration

Where I see a problem with Cohort Integration?
It’s complexity of such integration in Fibery when a user is not longer present in cohort. Complexity is due to the fact, that I can use only Fibery internal ID to delete records.

Currently, there is an option to sent webhook with users that should be created as a records and with those that should be deleted. So creation of new records is pretty straightforward. However, only option to create a record with my own ID, to identify a user easily, is to use UUID. I do not have user ID (distinct ID in Mixpanel) as UUID. And therefore I’m not able to simply delete it with identification of record ID. And I would need to store mapping table that would map Fibery UUID and user ID. So I would need to have a middleware between Mixpanel webhook and Fibery to handle issues with deleting records, avoiding creation of duplicate records… and bunch of cases and potential problems I was not thinking about.

Where I see a problem with Report Integration?
Deletion of records not present in a report and change of values for specific fields based on change in report.

Imagine a simple report - Feature name, Number of unique users; Time frame - last 30 days = no need to delete anything, just to update number of unique users per feature name. Let’s say, Feature name would be a name of a record. Number of unique users can change every day (even more often, but let’s say I would need to keep it updated once a day). So I would extract report from Mixpanel and I would have name of a feature there, but I need UUID to update a record. The same problem as in issue with cohorts.

And why is UUID even a case with cohorts? Mixpanel allows you feed string as Distinct ID. Therefore, you can use UUID, or you can use just numbers (my case).

If there is an option I haven’t thought of, please share it with me. Or if my assumptions are not correct, feel free correct me.

2

Hello,
If I understand correctly you are trying to integrate with Mixpanel using direct Fibery api calls, right?
If that’s true you might want to try writing your own Custom Integration (. | Fibery). Our integration framework keeps data in sync by records ids and not by internal fibery uuids. And later you can easily build reports using the data from mixpanel and it will be in sync

3

And therefore I’m not able to simply delete it with identification of record ID. And I would need to store mapping table that would map Fibery UUID and user ID.

regarding this: instead of separate mapping table you can always store your Record’s id as a field in Fibery’s entity so later you can query those entities by that field and get their internal ids to delete them. Basically that’s how our integration framework works

4

Hi! Yes, you are correct. I’m looking to use direct calls for Fibery API.
Thank you, I will have a look at custom integration.