Cross-Sell Rate from Online Store Data

[TE271203]

Hello All,

I have one requirement, and I need your help figure out if I am missing anything. 

Basic need is to get below requests answered with a data set I received where I have TIME Clicked, IP Address, Part Number Searched, Manufacture Name, Cost per Click.

1. How long do users take to buy? (time_to_purchase)
2. Do they buy the clicked part? (cross_sell_flag)
3. Are they new or existing? (customer_type)
4. Who should we target? (non_converter_flag).

i have prepared an Alteryx flow. Below is the list of activities performed.

1. Aug (attached sample data file), Sep & Oct data files (TIME, IP Address, Manufactured Part Number, Manufacture Name & CPC)
2. Joined step 1 data with Sales table (direct_sales_details_segment_1_without_cost_view) and Customer Table (dimension_contacts_master_cur_pii) & Digital Table (adobe40_activities) to get IP Address (a. evar14_internet_protocol_address) and contact information and Order amount and Sales amount from Sales table.
3. Join is based on IP Address & part number columns.
4. Till this, i can get time_to_purchase, customer_type & non-conversion flag and so on.
5. But i need to calculate Cross-Sell data. Below is the formula i am using to calculate this in Alteryx.
6. After 5th step, what should be the flow to merge/join above data set with cross-sell data set in Alteryx?
7. I have attached flow for now but its crashing. from the left join data set, i have again used Sales table to get any sales happened from cross-sell parts list. Not sure what went wrong. Please assist.
   Clicked Part Count - Countd(IP Address)

• Cross-Sell Flag - IF ISNULL([Manufacturer Part Number]) OR [part_number] != [Manufacturer Part Number]
  THEN "Cross-Sell"
  ELSE "Clicked Part"
  ENDIF
• Cross-Sell Count - if [Cross-Sell Flag] = "Cross-Sell" then 1 else 0 endif
• Cross-Sell Rate - [Cross-Sell Count] / ([Cross-Sell Count] + [Clicked Part Count]) * 100;

Thank you.