Skip to main content
Topics#Tableau Desktop & Web AuthoringCarl Turner의 질문
Carl Turner (SWIPEBY) 님이 #Tableau Desktop & Web Authoring에 질문했습니다
2019년 8월 2일 오후 6:48

Visualize yield/conversion from Sign-up data to order data

Hi,

 

I am new to tableau and love it. Right now I am trying to figure how I could visualize our yield/conversion.

 

We have data base tracking sign-ups - "creation date" is the date sign-up happened and USER ID, well is the unique user ID.

Then we are having an order table - where we have again the unique user ID and another "Creation date" - this time its the time order was placed.

 

I would like to show

 

1) a funnel showing how many signs-up (count USER ID) in certain time frame 100% -> yield unique orders in the same time frame (count User ID in order table)

 

2) how many people converted to order after sign-up after 7, 14, 30+ days.

 

Help would super appreciated - I am completely lost and just learning. I have attached an excels showing some dummy data.

 

Thanks

Carl

Tablaeu_dummy_conversion.xlsx
답변 2개
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    2019년 8월 2일 오후 11:37

    Hi, Carl

     

    Please find my solution by union your two data sets as shown below

     

    Hi, Carl Please find my solution by union your two data sets as shown below to your 1st question, build the view like below to show how many orders compare to how many sign up for each date And your 2

     

    to your 1st question, build the view like below to show how many orders compare to how many sign up for each date

    pastedImage_1.png

     

    And your 2nd question, you can create a calculation field to calculate the sign up date to their 1st order date

    pastedImage_2.png

    A sample workbook attached for your reference.

     

    Hope this helps

     

    ZZ

답변을 작성하세요...
0/9000