Integration Challenges with Mixpanel and GBQ: Resolving Distinct IDs

We are integrating mixpanel with GBQ and we are considering the unique identifier as resolve distinct id using the below query.

SELECT

 CASE

     WHEN m.resolved_distinct_id IS NOT NULL THEN m.resolved_distinct_id

     WHEN m.resolved_distinct_id IS NULL THEN e.distinct_id

 END as resolved_distinct_id,

COUNT(*) AS count

FROM mixpanel_nessie_day_partitioned_<PROJECT_ID>.mp_master_event e FULL OUTER JOIN mixpanel_nessie_day_partitioned_<PROJECT_ID>.mp_identity_mappings_data_view m

ON e.distinct_id = m.distinct_id

AND mp_city="San Francisco"

AND DATE(e._PARTITIONTIME) <= "2024-12-03"

AND DATE(e._PARTITIONTIME) >= "2024-12-01"

GROUP BY resolved_distinct_id

LIMIT 100

However, there are multiple resolve_distinct_id values for which we need to retrieve the UUID and Email fields. The challenge we are facing is that we are unable to locate the resolve_distinct_id in the Mixpanel interface.Could you kindly let me kn0w why it is happening?

0 comments