Matt L.

Commented on How to Get Period-to-Date Comparisons for Specific...·Posted inCommunity Questions

Thanks. Can you confirm that the comparison is period to date? My understanding from the documentation is that it will compare the current month to the entirety of the previous month meaning comparisons in the beginning of the month will look lopsided.

Posted in Community Questions·

Matt L.

How to Get Period-to-Date Comparisons for Specific Dates in Mixpanel?

Is there a way to get period to date comparisons in Mixpanel? Mixpanel will show the current month as an incomplete month which is helpful but what I want is to see how a metric on April 20th compares to the same metric on March 20th* *acknowledging some calendar wonkiness when months are different lengths or leap years yadda yadda.

5Comments

Posted in Community Questions·

Matt L.

How to Sync HubSpot Contact Data with Mixpanel Profiles via Segment

Hi - I have what I hope is a simple question but I have been unable to find a good answer. Here's the context:

We use Segment to track user events in our app
Mixpanel reads data from Segment. This is all working great.
We use HubSpot as our CRM. HubSpot is the source of truth for several key static customer details.

Goal: I want to enrich and update user profiles in Mixpanel using data from HubSpot contacts. For example, our HubSpot contacts holds our lead scoring category. I want that attribute available to me in Mixpanel for analysis and disaggregation. What I have looked into:

Using a data warehouse as an intermediary - I'm unclear if this is necessary or simply one way to do it. I want to avoid paying for the warehouse tool and the ETL tool to get the data in the warehouse.
Segment Unify (paying for more Segment) - use Unify to model customer profiles and then send them to Mixpanel. I'm pretty sure Mixpanel will accept outputs from Segment Unify but would like confirmation before paying up for those services

I appreciate the clarifications!

3Comments