Wishing you could do away with those bulkfile templates you have to recreate every time you want to do search term negations? Wish no longer because search term negations have come to stay in the dash platform.

With our main goal of providing the critical levers you need to manage your Amazon advertising accounts, we just launched the ability to pause/enable/archive keywords and targets, negate search terms, and manage your negated keywords and targets right from the dash platform. To see the full release notes, please check out this link as it contains additional information related to this Advertising Studio release: dash/RELEASE NOTES

Combined with the ability to push bulk bid changes to Amazon from the dash platform (v1.1 release), you can now manage your keyword and target statuses, negate search terms including the newly released Auto campaign product targets, and see all of your negated keywords and targets in one simple view.

Keyword status changes - find poor performing keywords via the custom performance filters in the Keywords & Targets view and pause keywords that are no longer up to snuff. If you're sure you don't want to target a given keyword or product target moving forward, you can also archive records in bulk. Conversely, if you're coming back into a solid seasonal period, you can enable paused keywords so they begin spending and generating sales for you once again.

*Pro tip: to see paused keywords or product targets, just toggle on the "Include paused" filter for Targets seen above the data table.

To see a video showing the status change functionality, check out this link: dash Keyword & Target Status changes

Search Term negations - ready to rid your accounts of the tiny little holes that lead to a leaky ACOS? Quickly negate search terms across your entire account by applying custom filters showing you search terms that are not performing the way you'd like in the Keywords & Targets (Search Terms tab) or Tasks & Workflows (Search Terms tab) views. As an example, you can see all search terms that have at least 15 clicks and no sales by applying the pre-built "Non-converting" Optimization filter on the Search Terms tab of either view. If you want to ratchet down your criteria, just click the already applied filters or add your own custom filters across any time range to negate search terms that are not performing up to your standards.

To see videos showing the search term negation functionality in each view, check out this link: dash Search Term Negations

Negative keywords and targets - see all of your negative keywords and targets in one simple view. Just navigate to the "Negative Targeting" tab of the Keywords & Targets view to see and manage your negative keywords and targets, including the ability to archive negatives that no longer apply. With the Negation Type, Status, and Date Negated (available for SP ads only) contextual fields, you'll never have to guess which negatives you have applied to a campaign or ad group again.

To see a video showing the Negative Targeting tab and functionality, check out this link: dash Negative Targeting view

Questions or issues? 

Although we always do extensive quality assurance, these are new views that may include a bug here and there. Please let us know if you see any issues via the blue "Feedback" tab hovering along the right side of each platform view. Alternatively, please send support@dashapplications.com a note if you are experiencing any issues or have questions about the platform updates.

As always, thank you for being a dash partner. We can't wait to hear what you think of the new features!

To quicker optimizations and personalized search term analysis,
The dash team

While we have been grinding away to provide the first few tables of MWS data, we did not hit pause on our Advertising data updates. If you haven't heard about the new MWS data, be sure to reach out so we can get an account connected for you for free during the beta period!

This Advertising data release concerns your database and DATA STUDIO subscription with updates for new data points now available. In particular, this update includes:

• Sponsored Display Product Targeting Tactic data added to the sellermonthmetric, campaignmetric, adgroupmetric, productadmetric, and keywordtargetingmetric tables. This update is available for merchants in the United States and Canada marketplaces only (unfortunately). The Remarketing tactic SD campaign data was previously incorporated into your db per release v1.2, but keywordtargetingmetric data is not available for that tactic. So please note that the keywordtargetingmetric table includes the new SD Product Targeting (T00020 tactic) data but is understated/missing activity for SD Remarketing tactic campaigns.
• A "Sales" field and "Orders" field was added to all metric tables. The fields automatically populate with the correct sales and orders values for the given attribution window on the basis of CampaignType and MerchantType (seller or vendor). By referencing these fields for your sales and orders figures in your reporting dashboards, you will be showing the sales and orders as reported in the Amazon Advertising Console (Amazon interface) for each respective campaign type and merchant type. 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" via a calculated field again!
• SP Product Targeting and SD Remarketing data added to the asinmetric table. Data for Sponsored Products Product Targeting was not previously included in the asinmetric table and has been incorporated with this release. Amazon has also recently made Sponsored Display Remarketing tactic data available for this report and we have incorporated it as well. This means you can now see "Other SKU Sales" for your SP product targeting and SD remarketing initiatives alongside the already available keyword targeting records.
• Currency Exchange Rate tables were added to your db for easy currency translation across marketplaces. We have created a "currency" record table and a "currency_metric" table showing current exchange rates for all major marketplaces and currencies available in your db. We also added a "CurrencyCode" field to all metric tables on the basis of Marketplace that can be used to join/reference the new currency tables for easy currency conversions. We will update the record table every business day of the week for all major currencies and marketplaces and will update the metric table once per week for historical currency exchange rate reference. To see how the currency exchange rates can be used in a reporting platform like Google Data Studio, please reference this post on our Community Forum: Currency conversion example

To view the complete list of updates and related release notes (which we recommend checking out), things you can now do, and items to watch out for concerning the update, just click here: dash/release notes

And don't forget to check out the dash Community Forum for additional info, access to the release notes, the current product roadmap, and a place to ask any questions you have about the update. Community Forum: dash/community forum 

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. Let us know how you're using the new data!

To expanded data sets and exchange rates galore,
The dash team

Soooo Amazon threw a bit of a wrench our way. After further testing and monitoring our status updates, we confirmed that Amazon is not yet delivering Sponsored Display data for any marketplaces other than the United States. The Amazon-issued API release notes do not state that SD data availability is limited to the US, but we have confirmed as much in our testing and monitoring of the API. Talk about a false start...

We have a case opened with Amazon to clarify this point and will pass along any updates or timelines we receive. In the meantime, please let us know if you see any irregularities in your data.

Once the SD data is available for all active marketplaces, we will notify everyone as well as incorporate the data into the dash platform. To clarify, SD data for US merchants is available in your database and can be relied upon for reporting, but you'll have gaps in the SD data for merchants operating in other Amazon marketplaces. (Thanks a lot Amazon.)

Our apologies for this inconvenience but we will keep hammering on Amazon to get it right so we can deliver all the SD data you need. Thank you to everyone as we continue to improve and expand your data sets!

As always, thank you for being a dash partner. Please let us know if you have any questions at support@dashapplications.com.

To dealing with Amazon failed starts, restarts, and false starts,
The dash team