Free AI web copilot to create summaries, insights and extended knowledge, download it at here

2758

Abstract

a high volume of load, and for our purpose most of the calls would be to reporting end points, which are done both in an asynchronous manner. For their Advertising APIs their responses are provided in a Gzip format out of their reporting end points.</p><h1 id="4eb7">End points</h1><h2 id="7a0b">Orders</h2><figure id="a9aa"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*cBMoOVJQl8u4dQYNjhTEQA.png"><figcaption>Amazon MWS documentation</figcaption></figure><p id="5fea">The <a href="http://docs.developer.amazonservices.com/en_US/orders-2013-09-01/Orders_ListOrders.html">Orders</a> end points are composed of multiple subsegments: List Orders, Get Orders and List Order Items.</p> <figure id="c6ae"> <div> <div>

            <iframe class="gist-iframe" src="/gist/linkerzx/8cd4bb89b856c96e6763efaf992361f8.js" allowfullscreen="" frameborder="0" height="undefined" width="undefined">
          </div>
        </div>
    </figure></iframe></div></div></figure><p id="6d06">Getting a list of orders can be achieved using the <a href="http://boto.cloudhackers.com/en/latest/ref/mws.html">MWSConnection</a> Object of the boto API such as as in the example above. It is worth noting that European marketplaces use a different API end point than North American one mws-eu.amazonservices.com.</p><h2 id="f016">Inventory</h2><figure id="5c03"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*ZIMjr-8pdYgPKtEpLusMHw.png"><figcaption></figcaption></figure><p id="0028">The <a href="http://docs.developer.amazonservices.com/en_US/fba_inventory/FBAInventory_ListInventorySupply.html">Inventory</a> end point provides by ASIN the supply quantity of items available in Amazon warehouses, typically for <a href="https://services.amazon.com/fulfillment-by-amazon/benefits.html">FBA</a> purposes. In Europe, Amazon provides a consolidated view of inventory across all their European warehouses and marketplaces.</p>
    <figure id="6026">
        <div>
          <div>
            
            <iframe class="gist-iframe" src="/gist/linkerzx/195ee8f29f1153fcac68c7428d74ca5e.js" allowfullscreen="" frameborder="0" height="undefined" width="undefined">
          </div>
        </div>
    </figure></iframe></div></div></figure><p id="ce06">The output of which is a dataset providing 6 fields of interest:</p><figure id="7bd7"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*hUDonl14nGjbe6d6iYQRpQ.png"><figcaption></figcaption></figure><h2 id="4931">Ads</h2><figure id="c769"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*2SBle2BHL_WuO-NQEzxCBQ.png"><figcaption></figcaption></figure><p id="28f2">Most

Options

of datasets that need to be obtained for performance tracking for Sponsored Products and Headline Search are done through the <a href="https://advertising.amazon.com/API/docs/v2/reference/reports">reporting end</a> point of the amazon ads API.</p><figure id="a5a1"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*A0ES1Nio29P1dBwXbOvTEA.png"><figcaption></figcaption></figure><p id="ec26">The reporting end point works in an async manner, a request must be initiated to generate a report, this providing a reportId, which can then be used to check on the status of the request, once it is finally not <i>IN_PROGRESS</i> anymore the reports a location can be fetched from which to download the report.</p><figure id="8e86"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*OVFDLxCJcltItI81_OBL8Q.png"><figcaption></figcaption></figure><p id="a53e">The list of <a href="https://advertising.amazon.com/API/docs/v2/reference/reports#Campaigns-reports">available metrics and dimensions</a> that can be fetched for each type of reports is provided by the API documentation as shown above.</p><figure id="7dba"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*bI_5nwAWm9NNPw-5dJiegQ.png"><figcaption></figcaption></figure><p id="a9b7">As shown above the key metrics are available either at Ad group or Campaign level.</p><h1 id="3eb7">Wrapping up</h1><p id="f18c">Amazon offers an ecosystem covering marketplace, fulfilment and advertising. It is possible to extract quite some data out of their API for analysis and reporting purposes. There is some limitation in terms of what can be extracted and not everything you would wish available is or at the desired level of granularity. Yet it is still possible to get some understanding of your core metrics.</p><p id="007f">More from me on <a href="https://medium.com/analytics-and-data">Hacking Analytics</a>:</p><ul><li><a href="https://readmedium.com/on-the-evolution-of-data-engineering-c5e56d273e37">One the evolution of Data Engineering</a></li><li><a href="https://readmedium.com/experimental-design-how-to-avoid-blowing-everything-up-c7ec93ad8cc8">Experimental Design and How to Avoid blowing everything up</a></li><li><a href="https://readmedium.com/hacking-up-a-reporting-pipeline-using-python-and-excel-2ffc8be044c">Hacking up a reporting pipeline using Python and Excel</a></li><li><a href="https://readmedium.com/what-is-a-data-layer-what-is-a-tag-management-system-f717dacb1216">What is a data layer? what is a tag management system?</a></li><li><a href="https://readmedium.com/cookies-tracking-and-pixels-where-does-your-web-data-comes-from-ff5d9b8bc8f7">Cookies, tracking and pixels, where does your web data comes from?</a></li></ul></article></body>

E-Commerce on Amazon — Leveraging APIs to measure performance

“black Samsung Galaxy smartphone displaying Amazon logo” by Christian Wiediger on Unsplash

As part of an e-commerce initiative, we are running a stand-alone e-commerce web-shop coupled with a connector to different marketplaces. One of which is Amazon, where we are running both Amazon Fulfilled and Merchant fulfilled programs. We are also using their advertising platforms to advertise our products using the headline search and sponsored product features.

APIs and SDKs Overviews

Given that we are using python to perform data transformation, it made sense to look at what was available into existing SDK that could support our use case and on Python boto is the de-facto SDK to use to perform API calls towards Amazon, typically AWS.

The first issue with using boto as an SDK for e-commerce purpose is that the marketplace web-service, which handles orders, order items and inventory is only available as an end point as of boto v2.49 and is not yet supported within the boto 3 release.
The second issue comes from the advertising side, headline search and sponsored products now fall under a different API setup, the Amazon Advertising API which is not supported in any boto release. The Ads API has its own documentation and uses the login with amazon for authentication. This is in contrast with the setup with Amazon MWS which requires to register as a developer under the platform AWS MWS platform.

One of the first thing that you must consider when dealing with Amazon MWS end points, is that there is quite some severe throttling limits, these limits apply per end point, depending on the type of usage and the scale that you would like handle with the API it might be worth looking into the reporting end point and/or setting up a subscription web-hook.

The Amazon Advertising API is setup in a very different way, it can handle a high volume of load, and for our purpose most of the calls would be to reporting end points, which are done both in an asynchronous manner. For their Advertising APIs their responses are provided in a Gzip format out of their reporting end points.

End points

Orders

The Orders end points are composed of multiple subsegments: List Orders, Get Orders and List Order Items.

Getting a list of orders can be achieved using the MWSConnection Object of the boto API such as as in the example above. It is worth noting that European marketplaces use a different API end point than North American one mws-eu.amazonservices.com.

Inventory

The Inventory end point provides by ASIN the supply quantity of items available in Amazon warehouses, typically for FBA purposes. In Europe, Amazon provides a consolidated view of inventory across all their European warehouses and marketplaces.

The output of which is a dataset providing 6 fields of interest:

Most of datasets that need to be obtained for performance tracking for Sponsored Products and Headline Search are done through the reporting end point of the amazon ads API.

The reporting end point works in an async manner, a request must be initiated to generate a report, this providing a reportId, which can then be used to check on the status of the request, once it is finally not IN_PROGRESS anymore the reports a location can be fetched from which to download the report.

The list of available metrics and dimensions that can be fetched for each type of reports is provided by the API documentation as shown above.

As shown above the key metrics are available either at Ad group or Campaign level.

Wrapping up

Amazon offers an ecosystem covering marketplace, fulfilment and advertising. It is possible to extract quite some data out of their API for analysis and reporting purposes. There is some limitation in terms of what can be extracted and not everything you would wish available is or at the desired level of granularity. Yet it is still possible to get some understanding of your core metrics.