Model based on multiple events

[Laura Madigan]

We are interested in using the Event Propensity objective but based on multiple events. For example, user submitted a form OR started a video OR clicked to view more detail on a product page. Is it possible to do this? Or does each event need to be in a separate model?

[Instant BQML and Vertex Users]

Hi Laura,

Thanks for your email! I understand you're interested in using the Event Propensity objective with multiple events, such as "form submitted," "started a video," or "clicked to view more detail."

This is a great idea! Combining events like this can help consolidate multiple conversion actions into a single, more powerful model. We've seen customers successfully use both combined and siloed approaches for quantifying probability.

While Instant BQML and Vertex pipelines currently optimize for a single event by default, you can easily modify them to include multiple events. Here's how:

1. Modify the Training Pipeline:

   • In the "Event Propensity Training" job, locate the visitors_labeled common table expression (CTE) within the SQL.
   • Within the CASE statement, modify the line WHEN LOWER(event_name) IN (LOWER('{{ EVENT_NAME }}')) to include your additional events, comma-separated and enclosed in single quotes. 
     • For example: WHEN LOWER(event_name) IN (LOWER('{{ EVENT_NAME }}'), 'video_start', 'form_submit', 'product_detail_click')

2. Modify the Prediction Pipeline:

   • In the "Predict" job, locate the same visitors_labeled CTE and make the identical modification to the CASE statement as described above.

Important Notes:

• Disable Scheduling: Before making any changes to your CRMint scripts, remember to disable the "Run on Schedule" toggle for the respective pipelines.
• Testing: Thoroughly test your changes before re-enabling the scheduled runs to ensure everything works as expected.

We appreciate your suggestion and will explore adding native multi-event functionality to future versions. In the meantime, these modifications should allow you to achieve your desired setup.

Need Help with Implementation or More Sophisticated Use Cases?

If you'd prefer expert assistance with implementing these modifications or exploring more sophisticated use cases with Instant BQML, consider working with one of our certified partners. They have extensive experience in deploying and customizing Instant BQML for various business needs. You can find a list of our certified partners here: https://instant-bqml.appspot.com/certified-partners

Feel free to reach out if you have any further questions.