You may be wondering, what revenue does the MWS data report? It doesn't seem to tie to the Business Reports OPS data. You're right, it doesn't. MWS data is derived from the Orders data seen in Seller Central under Reports... (More)
Sam Hager 251 from the dash team
Do you have questions for Sam Hager?
Log in to ask Sam Hager questions publicly or anonymously.
Great question - for advertising merchants/profiles, the system will automatically identify a new profile (merchant) attached to the account connection (permission) within an hour. You will then receive an email from us saying "New Merchant added" with a link to... (More)
To change the currency, the easiest/best way to do it is to change the field formatting of the data source itself. I recorded a short screenshare below that walks through a few ways to change the currency used in a... (More)
Hey Karan - this is a great question. I don't have much experience with Tableau but have worked with both enough to know some primary differences.
Pros for Tableau: more robust, handles large data sets better, expansive visualization capabilities,... (More)
For a google sheet grid of the suggested pull and extract process, please see this document: dash/EXTRACT PROCESS10
A. Advertising metric tables - Excluding current day, pull the records within the 14-day(pulled Daily) or 60-day(pulled on Monday) lookback... (More)
This is typically due to the Custom Date Ranges applied to certain widgets on a given page of the report to ensure the data shown allows for the comparison period and time series trend indicated in the widget labels. To... (More)
If you'd like the raw data for a certain time range, you could pull the full period of data and configure the comparisons via the report/table afterward. The below MySQL query pulls the last 3 months plus whatever days are... (More)
Here are the Where clauses to pull data for a specific time range via a MySQL query:
Last 30 days (uses "31" since we pull previous day data, not current day):
where DateTime BETWEEN CURDATE() - INTERVAL 31 DAY AND... (More)
The easiest way to use the currency conversion values in your reporting platforms is via a custom query to create a new data source (or you can do it via a blend + calculated field).
To create the data source... (More)
You can use either the mws_orders_list or the mws_orders_metric table to calculate LTV as they both contain the "BuyerEmail" field alongside a revenue field.
For mws_orders_list, LTV = SUM(Amount) / Count_Distinct(BuyerEmail) where OrderStatus = "Shipped" (as a filter).
For mws_orders_metric... (More)
This is typically an issue with your Permissions to View and Edit advertising for a given merchant account in Seller Central and/or Vendor Central. Dash is only able to pull ad data through the API if your linked account has... (More)
The dash application runs a profile list (merchant list) pull every hour so typically you will receive the "New Merchant Added" email from us within an hour to two hours of adding a new account and the merchant will then... (More)
This error is caused by the "0" timestamps that are sometimes stored as values in DateTime fields within the database tables. Basically MySQL can handle "0" timestamps but Google Data Studio can't resolve them using Java. The culprit is typically... (More)
If you're having issues loading data in your reporting platform, it may be due to the dashboard "re-pulling" data every time a change or filter is applied. Google Data Studio in particular pulls data directly from the database for every... (More)
As of 4.15.20, you are now able to updated target bids for Sponsored Brands Product targeting campaigns which includes category, brand, and ASIN targeting.
We have this one t'd up in the backlog to address after some infrastructure updates. In the meantime, if you have "All Campaign Types" selected and then filter to your SB (Headline) campaigns via the Campaign filter, the search term... (More)
If you've deleted an Amazon account connection from dash via the Account Manager, you will need to re-add and re-authenticate the account as you would to add a new account. For security purposes, we do not leave the connection to... (More)
You sure can - we have a historical uploader template available for you to upload Sponsored Product and Sponsored Brands data at the month level for each seller/vendor. We do not yet have the ability to upload campaign/ad group/keyword data... (More)