Forum Discussion
Problem with connections or something. Need help! Thanks
I'm attaching headers and some rows of raw tables that i have. IDs are raw indexes.
3068 distinct user_id in orders are clients. 5028 users who visited site and made a call (target action). I'm struggling to calculate CR for each campaign (distinct clients/ distinct site users who made a call). I'm sitting two days on this task, and nothing good happened, always some errors etc. I tried to make separated tables for each campaign based on sessions tables. I tried to make good connections and nothing works with many to many relations. Will be very grateful for any help!
3 Replies
CR formulawrong CR calculationsessions tableorders table
As i made many to many relations and tried to make merged queries (add date column from sessions to orders) and filter [date]=[sessions.date] to delete wrong excess rows. It also didn't work out good.
Also it turned out that id in sessions are 1-1 related to session.id in orders!
