Skip to main content

Release Updates
Release Updates

This thread includes the release updates for all dash solutions. Please follow this topic to stay up-to-date on the latest releases from dash and information related to implementation and usage of new dash features.

To view the detailed Release Notes, please follow the link here to our reference page: dash/REFERENCE.

Definitions:
Category
1 follower
0 questions
18 posts

Do you have questions about Release Updates?

Log in to ask questions about Release Updates publicly or anonymously.

Sam Hager
from the dash team

Business Reports tables for Detail Page Sales and Traffic Report data now available in dash/DATA STUDIO - v1.0 custom data Business Reports release for Seller Central merchants 8.26.21

Business Reports Detail Page Sales & Traffic tables + Uploader Templates & GDS Reporting Templates

Isn't it odd that Amazon fails to include Sessions and Buy Box data in the MWS API? We sure think so. We know how important those data points can be to reporting and understanding Seller Central account performance so we decided to bite the bullet and create our own solution...we have created two new tables you/we can upload the 'Detail Page Sales and Traffic' data to for comprehensive Seller Central reporting directly from your db (instead of having to house the data in a google sheet). 

This v1.0 custom data Business Reports release for dash/DATA STUDIO includes two new tables and two new uploader templates that can be used to populate your db with Seller Central's 'Detail Page Sales and Traffic' (BY DATE) and 'Detail Page Sales and Traffic By Child Item' (BY ASIN) data. If you're unfamiliar, the two reports can be found in Seller Central under Reports > Business Reports.

Click the video below to see how to populate the new Business Reports tables

https://youtu.be/PXcEzPqGNQk

GDS Templates for Business Reports data: With the availability of this important data, dash has built two reporting templates in Google Data Studio to help you get off to a fast start incorporating the Business Reports information into your reporting. Check out the two new templates here: 

dash/REPORTING Starter Template

dash/REPORTING Pro Template (see #4 in the list)

The two new database tables - These two tables are not connected to any API, but rather can be populated via the uploader templates described below the table definitions (i.e. you can upload the data regularly or have dash do this as a service):

  • business_reports_dpst_total: This table is intended to house the 'Detail Page Sales and Traffic' (BY DATE) Seller Central report data. You can consider this table the 'overview' data that is rolled up for an account as a whole. With our uploader template, you are able to upload data on a daily, weekly, monthly, quarterly, and yearly basis, using the TimeSegment field to upload any date ranges you'd like.
  • business_reports_dpst_item: This table is intended to house the 'Detail Page Sales and Traffic By Child Item' (BY ASIN) Seller Central report data. With the new table, you can upload your Child ASIN performance data across any time frame. With our uploader template, you are able to upload data on a daily, weekly, monthly, quarterly, and yearly basis, using the TimeSegment field to upload any date ranges you'd like.

The two new uploader templates -  We have created two new uploader templates to populate the two new tables with data on a regular basis. To find the new uploader templates, simply navigate to the Settings > Import Data screen in your dash platform instance and select the template you would like to download. Of note, the templates currently match the exact fields shown in each of the respective Seller Central reports. 

*Pro Tip: Make sure you 'Show' (select) all columns available for each of the Detail Page Sales and Traffic reports to easily line up the export with our uploader template fields.

As mentioned, if you'd like dash to do this regular data upload on your behalf, just ping us at reporting@dashapplications.com and we can talk about your upload needs.

  • Seller Central Business Reports - Detail Page Sales and Traffic Total uploader template for BY DATE data : This template, when uploaded through the dash platform, populates the 'business_reports_dpst_total' table and is intended to ingest the 'Detail Page Sales and Traffic' (BY DATE) Seller Central report data. Just download the template, enter the Seller ID of the merchant you're uploading for, set the time range by designating the 'TimeSegment', and add the date of the first day of the period you're uploading for (i.e. 9/1/2021). Then upload the data and it will populate in the table immediately.
  • Seller Central Business Reports - Detail Page Sales and Traffic by Child Item uploader template for BY ASIN data: This template, when uploaded through the dash platform, populates the 'business_reports_dpst_item' table and is intended to ingest the 'Detail Page Sales and Traffic By Child Item' (BY ASIN) Seller Central report data. Just download the template, enter the Seller ID of the merchant you're uploading for, set the time range by designating the 'TimeSegment', add the date of the first day of the period you're uploading for (i.e. 9/1/2021), and enter both the Parent ASIN and Child ASIN values for a given item. Then upload the data and it will populate in the table immediately.

Navigate to the Settings > Import Data screen in the dash/PLATFORM, then select the template you'd like to use to upload the corresponding data

Pricing for Business Reports data - since this is static data and relatively small compared to the programmatic data, we are offering this new solution for FREE. Seriously, no strings attached so upload the Detail Page Sales and Traffic data to your heart's content.

Questions or issues? 

Although we always do extensive quality assurance, new data sets may include a bug here and there. Please let us know if you see any issues by posting in the Community Forum or sending a note to support@dashapplications.com.

As always, thank you for being a dash partner. Please let us know how the new tables, uploader templates, and reporting templates are working for you...any feedback you have is appreciated as always!

To closing the Sessions and Buy Box gap,

The dash team

Release Note
Release Updates

Amazon DSP data now available in dash/DATA STUDIO - v1.7 amazon ads release 8.5.21

For all of you dabbling in DSP, we are happy to announce you can now pull DSP data into your db for your reporting and analytics purposes. You should see a number of tables in your database prefixed with 'dsp',... (More)

Release Note
Release Updates

Adding MWS accounts directly in dash - v1.5 dash/PLATFORM release 7.30.21

Tired of sending us those screenshots and copied MWS credentials? Same here. With this v1.5 platform release, we have added the ability to enter your own MWS accounts and activate related merchants for MWS data flow directly in the dash platform. No more manual emails, +1 for that! We will continue improving the workflow to add status alerts and error alerts in the near future. If you see something that isn't working correctly or identify an opportunity to improve the workflow, please leave your feedback via the platform or email support@dashapplications.com directly.

To see the new workflow in action, check out this video: 

https://youtu.be/e7S8KSq3Rvs

How to add an MWS Account: To add an MWS account to dash, navigate to the Account Manager view and select the 'MWS Merchants' tab. Then, click the 'Add MWS Auth Token' button and enter the required MWS credentials for a given Seller Central merchant. FYI, the credentials you provide allow MWS access for all marketplaces within a given region. The established regions are America, Europe, and the Far East. If you're not sure which region the credentials allow access to, don't worry, we will figure out the appropriate region even if you select the wrong one. 

How to activate or inactivate an MWS merchant marketplace: Once you've added an MWS account in the step above, you will be able to view the merchant marketplaces related to the auth token provided. Here, you can decide which merchant marketplaces to activate. You can also choose to inactivate + purge any MWS merchant marketplaces you no longer need data for from the same view.

Not sure where to get MWS credentials?: MWS access credentials are provided by the admin of a Seller Central account. For information on how to authorize dash as a developer for a Seller Central merchant, please check out the 'MWS Instructions' tab seen on our training page here:

dash/TRAINING - MWS Instructions

Need help getting started using MWS data?: With MWS data, you can now use our Operations Template in Google Data Studio for free. If you need some extra help, let us know. Our fledgling reporting division is happy to assist so please ping us at reporting@dashapplications.com to find out more!

dash/TRAINING - GDS Operations Report Template

Questions or issues? 

Although we always do extensive quality assurance, new feature releases may include a bug here and there. Please let us know if you see any issues by posting in the Community Forum or sending a note to support@dashapplications.com.

As always, thank you for being a dash partner. Please let us know what you think of the new workflow...any feedback you have is appreciated as always!

To making MWS merchant marketplace activations more manageable,
The dash team

mws_inventory_metric table changed to mws_inventory_health 4/30/21 - MWS dashboard reports affected

Hi , 

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:

How to update the table reference 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 support@dashapplications.com and we will respond right away.

To a little beta bump,
the dash team