Skip to main content

business reports
0 followers
0 questions
2 posts

Do you have questions about business reports?

Log in to ask questions about business reports publicly or anonymously.

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

dash/REPORTING Starter Template for Detail Page Sales and Traffic (Business Reports), Advertising, and Operations (MWS) [free for dash subscribers]

dash/REPORTING Starter Template - DPST, Ads, MWS

Merchant Type: Seller (Seller Central Only)

Paid or Free?: Free

Google Data Studio Setup Instructions

STEP 1: Gather your Database Credentials and a SellerID value from the dash platform

1) DATABASE CREDENTIALS:... (More)