Question

Bug (?) in funnel through API using where

  • 14 March 2019
  • 1 reply
  • 45 views

Badge
  • New Participant
  • 0 replies

I'm trying to create my own dashboard (so that I will be able to provide each of our customers his own data).

I have a funnel, which I'm trying to filter according to the domain which triggered the events.

I'm using the visual dashboard to show only 'testdomain' results:

This is the visual result I'm getting:


But when I'm using an api call for a funnel with no filter, but with 'where' filter in the url, I'm getting different results. (funnel_id=5628059 points to a clean funnel, with no filters and the above two steps).

This is the url I'm using:

https://mixpanel.com/api/2.0/funnels/?from_date=2019-03-11&to_date=2019-03-11&funnel_id=5628059&where="testdomain" in properties["$referring_domain"]

And this is the results I'm getting:


The numbers (especially for the first step) are totally wrong...

Am I doing something wrong?


Thanks,

EyalS



1 reply

Userlevel 1
Badge

@eyal it seems like the "where" function in your API call is adding an additional filtering. Try this: in your API call, take out everything after your Funnel ID. See if that get's you the same numbers


Reply