Modeling Conversion Rate

  • 11 October 2017
  • 1 reply

Hi - New to Looker here and seeking help with modeling fact over fact math for a conversion rate.

I have a table for clicks and a table for orders. I need to calculate the conversion rate = orders per day/clicks per day. The only commonality between clicks and orders is date. Clicks is calculated count of id, & orders is calculated count of id.

I understand I can create a derived view to accomplish this by writing the query itself. Are there any other alternatives or ideas? Can I theoretically create a derived view with view extensions?


1 reply

Userlevel 6

Hi Steph,

Here is a great article on how to model different transactions based on date.

Also, in Looker 5.0 there is a way to do this by combining the output of two explores via data merge.