The change is here - we have updated the 'mws_inventory_metric' table to now be named the 'mws_inventory_health' table. This DATA STUDIO announcement concerns your MWS data and any dashboard reports that rely on the mws_inventory_metric table.
Related to our emails sent on February 25th and April 2th, we have now changed the 'mws_inventory_metric' table to be a snapshot rather than a historical record, today, Friday, April 30th, and historical data is no longer present in the table. We have also renamed the 'mws_inventory_metric' table as 'mws_inventory_health', which impacts any reporting dashboards relying on the table, including our GDS Operations template.
How does this change impact me?
Any reporting dashboards, charts, or widgets currently relying on data from the mws_inventory_metric table are impacted. This includes any Google Data Studio (GDS) templates that were copied/created from our 'V1 TEMPLATE - dash/DATA STUDIO Amazon Operations Report', specifically impacting the 'Inventory Health' (formerly 'Inventory Summary') page of the report. The template has been updated to reference the new table name and accommodate for the changes required below as of April 30th at 8am MST. So, you can now copy the template or 'Inventory Health' page/widgets again if you'd like the below changes to be 'already done' for you on or after April 30th. You will then want to make sure to 'point' the copied widgets at your own data source(s), which should be updated to reference the 'mws_inventory_health' table name per the prescribed changes outlined below:
What action do I need to take on any reports that rely on the 'mws_inventory_metric' table?
1) You will need to update the impacted items, specifically your GDS data sources, to reference the table name of "mws_inventory_health" instead of "mws_inventory_metric" today and moving forward. You can also remove the 'DateTime' condition from the query as the table will no longer contain historical data. To make the proper data source reference changes, please check out this example shown in GDS:
2) The 'Inventory Health' (formerly 'Inventory Summary') page of the dash GDS template has been affected in that the data shown no longer contains historical data, but rather only contains data as a snapshot from the current day. In particular, this means that the 'Days Out of Stock' field no longer applies and has been removed from the dash template. You are able to track 'Days out of Stock' via the new 'mws_inventory_history' table, which was released on April 23rd per this release note. We also provided a GDS template page that incorporated the new mws_inventory_history data in the linked release note.
3) For those modules and dashboards relying on mws_inventory_metric and including a lookback period such as 'last 30 days', you will want to change the 'Default date range' (i.e. time period of a given widget) to 'Auto' and update any labels or descriptors that describe a lookback period. Additionally, any fields that sum or average numbers over a lookback period can remain, but they will now only reflect one day's worth of data as opposed to a lookback range of data. Here are some examples of the field names that you may want to update:
Detailed Information about the change and why we are doing so (provided on February 25th but including for anyone who missed it):
The MWS report we used to populate our 'mws_inventory_metric' table is a replica of the 'Inventory Health' report you can see in Seller Central under Reports > Fulfillment > Inventory > Inventory Health. However, the Inventory Health report is a "snapshot" and does not allow us to pull historical data. This means we could incur issues of data provision and reliability if MWS happens to be unavailable one day or another....which is highly likely to occur.
If you have grown to enjoy and rely on the inventory data currently seen in the mws_inventory_metric table, fret not as that same data is now shown in the same table under a new name of 'mws_inventory_health'. We have populated the mws_inventory_health table with the same Inventory Health report fields such as Sellable Quantity, Sales Rank, Weeks of Cover, and Inventory Aging to name a few. However, the updated mws_inventory_health table does not track day over day data now that the change has been made; it is rather a snapshot of the current day while historical inventory data is shown in our new inventory history tracking table named 'mws_inventory_history'.
Now that the change is in place, the new inventory history table is populated with information coming from the 'Daily Inventory History' report seen under Reports > Fulfillment > Inventory > Daily Inventory History (this was completed and released as of April 23rd). This allows us to pull historical inventory data not currently available. It also provides us a more consistent and reliable means of tracking day over day inventory amounts, including out of stock instances that we programmatically track (and are not available via any MWS API - out of stock tracking is a dash special).
If you have any questions, please reach out to firstname.lastname@example.org and we will respond right away.
To a little beta bump,