This is a great approach, though I may need a bit of clarification on how can I map the SKU to product name if I'm using Classification Rule builder which uses Regex. Would this be the correct line of thinking:Create a classification rule builder to split the SKU into watch band and watch facePass a...

I have a scenario where we have products grouped together in a single product string. You can imagine a watch store where the watch body and the watch strap have their dedicated SKUs. In an ideal world, our engineers would've split the information in a format as such: product = watch accessory;SKUBA...

I agree - but let's just say engineering messed up on their implementation, I want to make sure we can collect at least the last instance.

Given a product string that may look as such:  s.products=";sandal123;;;;eVar1=sandals|eVar1=internal search|eVar1=non-internal campaign|eVar4=non-browse|eVar5=non-cross-sell"; Where there are three eVar1s with different values, which value would eVar1 record against the product sandal123? Would it ...

Hello!I'm trying to replicate the data from Adobe Workspace based on the data we're ingesting from data feed.Below is the code I've built:SELECT days, COUNT(DISTINCT visitor_id) FROM table WHERE cid = 'campaign_code_example' GROUP BY days ORDER BY days ASC However, despite this, the numbers are diff...