Thank you for this info❤.. I learned so much. I was doing pivot table like what you did few days ago but I wasn't sure if I was doing it right. Lol. 🤣Glad I saw your video today.
I really can't seem to find this report on Amazon - I went to reports - > Advertising Reports and all that was available is sponsored products search term report. Any help? Thanks
Hey Jacob! I believe that is the correct report Naiò is referencing in this video :) Are you seeing different columns or another issue related to this?
After seeing you, I literally thought that you are Leighton Meester in spectacles or maybe you are her sister. P.S. Great Video with lots of knowledge!!
average of ACoS does not make much sense sometimes. For example you have 1 click for a KW with 10% ACoS, and 1000 clicks for the same KW with 70% ACoS or another campaign. Based on your way of doing, average of ACoS is %40, but it should not be considered same, since one KW has 1, other one has 1000 clicks (their spends and sales might be way different). Weighted average should be applied, or instead of having average of ACoS through Pivot table, ACoS should be calculated separately for each KW after Pivot Table generated. Does this make sense?
If they are from different products, we add that as an additional later to filter by (since we run single ASIN campaigns, this is easy). If they are from different campaigns but same products, then we don't want multiple duplicates running in new campaigns.
Quick Quesion about Display ads: Suppose we have been running Display Ads for a while and we just download a search term report, how can we differentiate which ASIN's come from Sponsored Product Detail Page and which ASIN's come from Sponsored Display Ads? Thanks in Advance
Add 'campaign name' in the rows section of the pivot table, it will create a multi-level row within each row. Expand the row and you can see the details.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
I love the BetterAms content Thank you Nai
Wow this was incredibly helpful. Thank you so much this clear and informative video. Really appreciate it!
Thanks Naio! Really helpful.
Very hel[ful video. Thanks
Wonderful way of managing data to save time
Thank you for this info❤.. I learned so much. I was doing pivot table like what you did few days ago but I wasn't sure if I was doing it right. Lol. 🤣Glad I saw your video today.
Very helpful tips!
Thanks for sharing. This is helpful.
It was very informative.
Thank you for the information, It is helpful !!!
Thanks for this helpful material :)
I really can't seem to find this report on Amazon - I went to reports - > Advertising Reports and all that was available is sponsored products search term report. Any help? Thanks
Hey Jacob! I believe that is the correct report Naiò is referencing in this video :) Are you seeing different columns or another issue related to this?
@@wearebtrmedia I think it's because I am not a A+ content seller. Thanks
How you calc the %, ACoS for example, in the pivto table is not correct, cannot take the avg
thanks:)
thank you so much!!
After seeing you, I literally thought that you are Leighton Meester in spectacles or maybe you are her sister. P.S. Great Video with lots of knowledge!!
average of ACoS does not make much sense sometimes. For example you have 1 click for a KW with 10% ACoS, and 1000 clicks for the same KW with 70% ACoS or another campaign. Based on your way of doing, average of ACoS is %40, but it should not be considered same, since one KW has 1, other one has 1000 clicks (their spends and sales might be way different). Weighted average should be applied, or instead of having average of ACoS through Pivot table, ACoS should be calculated separately for each KW after Pivot Table generated. Does this make sense?
Just what I was about to say
What is the point of merging customer search terms if they are for different campaigns/products?
If they are from different products, we add that as an additional later to filter by (since we run single ASIN campaigns, this is easy). If they are from different campaigns but same products, then we don't want multiple duplicates running in new campaigns.
Quick Quesion about Display ads:
Suppose we have been running Display Ads for a while and we just download a search term report, how can we differentiate which ASIN's come from Sponsored Product Detail Page and which ASIN's come from Sponsored Display Ads? Thanks in Advance
Add 'campaign name' in the rows section of the pivot table, it will create a multi-level row within each row. Expand the row and you can see the details.
I'm in love with you and my wife approves