Attribution for In-Store Pickup Orders Placed Online
A customer clicks an ad, buys online, and picks up in store. The ad platform sees a purchase with no revenue location, and the store sees a walk-in. Both are wrong.
A customer clicks a paid social ad on her phone, buys a jacket online, and picks it up from the shop on Saturday. The ad platform records a conversion. The store's point of sale records a pickup. The finance report records an online order with no shipping cost and no delivery address. Three systems, three versions of the same sale, and none of them agrees on what the ad actually did.
Buy online, pick up in store is the attribution edge case that breaks the simple story, because the sale happens in one channel and the fulfilment in another, and most attribution setups were built for a world where the two were the same.
Where the credit goes missing
The usual failure is the pickup flag. The order is tagged as online, the ad platform claims the conversion, and the store team, looking at foot traffic, credits the visit. The truth is that the ad drove the order and the store fulfilled it, but the reporting has no field for that, so each team reports the version that flatters its own channel.
The second failure is the return. A pickup order returned in store is often recorded as an in-store return against an online sale, and the attribution report keeps the original conversion while the finance report nets it out. The ad platform never learns the sale was reversed, and the next budget decision is made on gross conversions that no longer exist.
A tagging rule that survives contact with the store
Tag every pickup order with three things at the point of sale: the channel that drove it, the fulfilment method, and the location. The channel tag comes from the online order, carried through to the pickup record. The fulfilment tag is pickup, not delivery. The location tag is the store that handed it over. With those three, the sale can be reported by channel, by fulfilment, or by store, without double counting.
The hard part is the handoff between systems. The online order and the pickup record live in different tools on most stores, and the channel tag is the field that gets dropped in between. Test the handoff with a real order, from ad click to pickup to return, and check that the tag survives each step. If it does not, the attribution is a guess.
What to do with the numbers once they are right
Once pickup orders carry their channel tag, two questions become answerable. First, how much of paid social revenue is actually pickup revenue, which changes the return on ad spend calculation, because a pickup order has no shipping cost and a higher margin. Second, which stores are fulfilling the orders that ads drive, which tells you where to stock the products the ads are pushing.
The answer usually surprises the team that runs the stores. Pickup customers spend more in store on the day they collect, and the ad that drove the online order also drove a walk-in purchase that no attribution model will ever credit to it. The honest report says so, and the budget decision accounts for it.
Related reading: Attribution Playbook, Answers, Glossary.
Frequently asked questions
Why is pickup attribution hard?
The sale happens online and the fulfilment happens in store, and most attribution setups assume the two are the same channel. The order is tagged online, the pickup is recorded in store, and no field connects them, so each team reports the version that flatters its channel.
What should a pickup order be tagged with?
Three things: the channel that drove it, the fulfilment method, and the pickup location. The channel tag must survive the handoff from the online order to the pickup record, which is the step where it usually gets dropped.
Do returns break pickup attribution?
Yes, if the return is recorded in store against an online sale. The attribution report keeps the original conversion while finance nets it out, and the ad platform never learns the sale was reversed. Returns need the same channel tag as the order.
Does pickup change return on ad spend?
It should. A pickup order has no shipping cost and a higher margin than a delivered order, and pickup customers often buy more in store on collection day. Reporting pickup revenue as ordinary online revenue understates the ad's return.