SP Ads Not Advertised
Print
Modified on: Thu, 15 Aug, 2019 at 1:16 PM
- Download Amazon Product Advertised Report last 30 days
- download Amazon FBA Inventory Report and add sheet to ad report
- insert column in the FBA inv report for "style number" > =left(a2,9)
- insert column in the FBA inv report for "advertised" > =COUNTIF('Sponsored Product Advertised Pr'!G:G,"*"&B2&"*") [copy paste formula]
- insert column in the FBA inv report for "inventory by style" > =SUMIF(B:B,B2,I:I) [copy paste formula]
- click insert on top > click pivot table > check off the following:
- style > put in rows
- advertised > put in filters > filter for 0 [click dropdown, then 0]
- inventory by style > put in values > filter for greater than 47 pcs [click row label dopdown, value filters, greater than > 47]
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.
