Create conversion rate per product & type of customer

Hello all,

I’m trying to figure out how to build a query that would allow me to measure the conversion rate by product and by type of customer.

I have the following data that I’m trying to join/aggregate:

CustomMsisdnCheck
with the following fields: msisdn, type

CustomOrderedProduct
with the following fields: msisdn, sku

There are two things I’m trying to do:

  1. Display product sales per type of customer

My initial idea was:
SELECT uniqueCount(msisdn) from CustomOrderedProduct,CustomMsisdnCheck where CustomMsisdnCheck.type=‘XX’ facet CustomOrderedProduct.sku
But I don’t get any data in my graphs

  1. Display conversion rate per type of customer and type of product
    For this one, I don’t even know where to start because I need to count the number of unique msisdn of CustomMsisdnCheck and divide it by the number of common msisdn in CustomOrderedProduct that would then be filtered by sku.

Do you have any idea of how I could build this?

Thanks

@laurent.willen Sorry you have been waiting awhile for a response from our community. I’m going to bring this back to the attention of our support team. Thanks for your patience!

Neal Mc

Glad to read. Thanks Neal!

Hi @laurent.willen, It looks like you’re trying to achieve something thats described in the docs here- Simulate SQL JOIN functions in Insights

For your second use case, I believe using filter may be helpful - filter