MWS + Ad data monitoring [COMPLETE] - to better track and understand the MWS and Advertising data delivery, we are implementing additional monitoring for proactive issue identification and to define the data deliverability schedule for MWS
- [complete, to be released week of 2020-01-25] Active "3mo" metric tables implemented to not only increase the speed of new data writes to the db but also provide tables that can be connected to for recent data (month to date + the previous 3 months of data) and faster dashboard loading that doesn't require loading the entire historical data set for a given metric table.
- [complete, to be released week of 2020-01-25] "campaign_tracking" table added to enable tracking of day over day Daily Budgets by campaign, along with State, ServingStatus, PlacementModifier values, Creative on SB campaigns, Amazon Budget Recommendations, 7 Day Lost Sales, and more.
Ad Data Latency Measures [complete 12.15.20] - due to increased Latency and Capacity issues occurring in the Advertising API, we are implementing additional procedures to better handle data retrievals that do not generate regularly
- Read Replicas - in September/October, we will also be migrating to a read replica architecture. Nothing will change for you if you have switched over to the "db.mydashapplications.studio" hostname for your db references.
- Sponsored Brands Video data added for campaign, ad group, and keyword + search term record and metric tables. Currently available for the US and CA marketplaces only.
- Sponsored Display Product Targeting data available for additional marketplaces including UK, FR, ES, IT, DE, AE, and JP.
- API pull optimizations to implement retry and back-off mechanisms.
[9.14.20] - Admin
- IP allowlist - an IP address allowlist will be implemented on September 14th, 2020, effectively blocking any unauthorized IP's from accessing the databases
[8.20.20] - Advertising Data
- Currency Conversion record and metric tables available for use in currency conversion equations. We will update the record table every week day for all major currencies and marketplaces and will update the metric table once per week for historical currency exchange rate reference.
- Sponsored Display product targeting (tactic T00020) data available in campaignmetric, adgroupmetric, productadmetric, keywordtargetingmetric. This data is being added to accompany the already available Sponsored Display remarketing (tactic remarketing) data available in the campaignmetric, adgroupmetric, and productadmetric tables (no keywordtargetingmetric data available for the remarketing tactic)
- Sales and Orders fields added to all metric tables that automatically populate with the correct sales and orders values for the given attribution window on the basis of ad type and seller/vendor status. Basically, this means you will never have to write another case statement to get the correct ad sales and orders numbers pulled into your reports. No more wrangling "AttributedSales7day" vs. "AttributedSales14day" again!
- Sponsored Products product targeting and Sponsored Display remarketing data available in asinmetric to accompany the Sponsored Products keyword targeting data already available.
[7.13.20] - MWS data (Beta)
- MWS for Seller Central orders and product catalog data (initially released) available via the mws_orders_metric, mws_orders_list, and mws_items tables