So, obviously, if you go to a brick-n-mortar store and buy something there, it counts as a sale for the store, with stores that don’t get enough sales often closing. But if I order something online from, say, Best Buy and pick it up in store, how is that tracked? Does it count as a sale for the store, even though I didn’t actually buy it there? If not, do companies use a separate metric (ie this store doesn’t get as many sales, but people still come in to pick up stuff, so we’ll keep it open)?
That’s only from a shipping/logistics matter. However, whether sales are attributed to the e-commerce platform or the brick and mortar store is dependent on the company and their approach to the business. I’ve seen both scenarios and they each have their pros and cons. Ultimately though sometimes places do one or the other depending on what platform they want to show growth or revenue in (like a brick and mortar trying to increase e-commerce sales will count orders shipped to a store as e-commerce).
Correct. It really depends on how the business want do set things up. No one size fits all. Really all boils down to how the technology, data science, and finance teams want to solve the problem.
Ideally, if you can start over from scratch, it’s nice to have one generic data lake, then just run queries to tell you how a specific retail platform or location is performing.