Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Marketing conversion chart

Hi ,

I have three tables with information as following:

 

tablea

campaigndateemails_sent
AAA21-Feb-22222
BBB01-Mar-223333

 

tableb

campaigndatecontact_id
AAA21-Feb-22123
AAA21-Feb-22456

 

tablec

productpurchase_datecontact_id
abcd22-Feb-22123
bcde30-Mar-22456

 

I want to plot emails_sent and conversion % for each month

Logic for conversion %

A= Count of contact_id for which the purchase date is after date in tableb but within 15 days of that date for the month

B= emails_sent in the month

 

%A/B

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You need join all three tables on common campaign and date tables , Then these just divide or count  rows

     

    divide(countrows(A), countrows(b ) )

     

    analyze against common campaign and a larger date range

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks but how do I take care of the condition that the purchase date is within 15 days of tableb date?