Skip to content

bigfunctions > explore_funnels

explore_funnels

Signature 

explore_funnels(events_table, event_types)

Description

Show funnels (WORK IN PROGRESS)

See the result as a data visualization in BigQuery Console!

The result of this function can be vizualized as an html report directly in BigQuery Console!

  1. Install this bookmarklet: bigfunctions (it has to be done only once)
  2. Open BigQuery console
  3. Click on the installed bookmarklet.
    • From now on, the bookmarklet code will observe the BigQuery console page.
    • If a BigQuery result appears with a unique cell containing html content, it will be rendered.
  4. You will have to click on the bookmarklet again:
    • If you refresh the Bigquery console page,
    • If you open the BigQuery console in a new tab of your browser.
  5. Run the query of the example and open the result of the latest subquery. The result will be shown as a nice html content.


bookmarklet usage

Examples

call bigfunctions.eu.explore_funnels('compte-nickel-dataprod.TEMP.EVENT_TYPE_SNOWPLOW2', ["UserProfile", "PhoneNumberEditionWorkflowIntroduction", "PhoneNumberEditionForm", "PasswordChallenge", "CodeEmailChallenge", "CodeSMSChallenge"]);
select html from bigfunction_result;

call bigfunctions.us.explore_funnels('compte-nickel-dataprod.TEMP.EVENT_TYPE_SNOWPLOW2', ["UserProfile", "PhoneNumberEditionWorkflowIntroduction", "PhoneNumberEditionForm", "PasswordChallenge", "CodeEmailChallenge", "CodeSMSChallenge"]);
select html from bigfunction_result;

call bigfunctions.europe_west1.explore_funnels('compte-nickel-dataprod.TEMP.EVENT_TYPE_SNOWPLOW2', ["UserProfile", "PhoneNumberEditionWorkflowIntroduction", "PhoneNumberEditionForm", "PasswordChallenge", "CodeEmailChallenge", "CodeSMSChallenge"]);
select html from bigfunction_result;