Is there any special reason for why you guys created the oro_tracking_event.user_identifier in this format? User-id + email + visitor-id all concatenated? Any plans to change it in separate fields?1id=464043; firstname.lastname@example.org; visitor-id=24949769
I’m asking because we’re working on some custom reports to get the customer behavior in every magento order. Unfortunately it’s getting slower to filter it using because we have millions of rows on this table;
- What products did the customer visited before bought something based on visitor-id;
- What is the first urfref from the visitor-id to define if he comes from Google, Facebook, etc;
- Did the customer searched for anything before bought it;
- Track all customer events based on user/email;
The forum ‘OroPlatform – Programming Questions’ is closed to new topics and replies.