Getting Amazon results, Monday morning

When the typical Selling Partner API reports delay is not working for your business

A large CPG company came to us with a request that seemed eminently reasonable and also unbelievable at the same time - they wanted to view prior week sales performance for Amazon, on Monday mornings.  Totally reasonable - we were helping them with 5 other retailers and achieving the same thing.

But the issue was the Selling Partner API that most data partners use has a nearly 2 day delay on weekly results reporting. You get the data - Tuesday night.  

Luckily we were aware of Amazon's other newer real-time APIs meant to display sales and website traffic activity to within 30 minutes of real-time, but the hiccup was you have to roll the data up, and its not just from one API call, it would require combining multiple calls and more.

The opportunity was intriguing though - why shouldn't the largest technology company and  retailer be able to report numbers on Monday morning following a weekly close on Sunday evening?

As is often the case, its not a matter of whether the  data is available, its more about what you have to do technologically to get it from the source provided in the cadence provided, with the fields available, to transform it into a usable result for the customer.

After working through the intricacies of the data and flow, we were ultimately able to provide what the customer wanted - reporting across all their retail accounts, for the prior week, available for meetings on Monday morning.

What was really nice is we explored the details of the new Amazon API and were able to derive a number of real-time metrics to help better catch trends previously not possible for Amazon.

We now offer real-time API access to any of our customer's who wish to have us manage their Amazon data and they can get info on sales less than an hour after the sales occur.  

We also still utilize the traditional API as well to give customers the best of all worlds when selling into Amazon.