Why Most Amazon DSP Users Are Doing This Wrong

Hi guys, welcome to another video on Amazon advertising. In this video, I will talk about Amazon DSP specifically. By the end of this video, you will know how to quickly update order flights on a massive scale. So, whoever is using DSP through interface knows that it's painfully slow. Sometimes it takes up to 10 to 15 seconds just seconds just to load, which is terrible experience. Um now very often you will have the situation where for whatever reason it is you have to update your budgeting for for example let's say you had you budgeted this year to spend I don't know $10,000 or $1,000 per month and then uh your upper management decided to scale down and now you have to update every single flight to be for example let's say half of that or 20% down or whatever it is. So to come through to to go through all of that one by one and to update I think for for multiple marketplaces if you're selling in EU that can be five six seven um different marketplaces it would take easily an hour to do just that stupid simple task. Now luckily there's something uh in Amazon DSP called bulk file similar to what you have in advertising console for the sponsor ads. So once you're inside the DSP console, you have your orders and you n should navigate on the orders tab and uh here on the right side there's this download and upload button. Hit download and select export order settings. So you don't need export order data at least not for that for this occasion. So hit export order settings. Now, I like to select only uh the orders which are currently delivering, you know, because I know that all of our orders should be delivering and I saw all three of them for this account. So, that's cool. Hit download and wait for a for a few moments for it to for it to load. Then, you will be presented with something like this. Now, it's it's pretty scary once you open it because there are multiple tabs where you can update all kinds of stuff. So you can format the line items, make some adjustments to creatives, to video line items, to audio line items or whatever. For this specific occasion, what we want to do is only update the flights. As I said, you can. Now, because it's possible to make a huge mistake here, what I like to do is I like to cap here and freeze the panes so I can clearly see the orders and then move to this uh column O. Column P is just a read only where you can see the flights. But column O O is where you need to update it. Now, this looks terrifying. All these numbers and letters, but it's actually pretty simple. Each flight here represents the flight that you added into your um orders on your DSP console. And it's called, for example, flight number 13. Uh this is the flight budget €2,450 euros. I think this is the European one. And then this is the start date and the end date with along with the end time. Then after that you can see 600 6,300 for December last year and then we are into January this year. Now how you can approach that you can just copy here all of that and paste it into some kind of a word processing editor. It can be even a notepad. We can do that. Let's select notepad. I think I have it over here. So you can select notepad paste it here and then just look for the values that you need to update. Now you can do it the present way and go one by one. one for example this is February and let's say okay I don't want to have for February 1,600 then I will update it to whatever let's say 200 and then you can go on for example you can also use uh find and replace and say whatever it is 160 I want to update to 200 and then hit replace all and there you go you just copy all of what you updated back to your um self there that's one way to do it and it's pretty effective you can do it probably in a few minutes you can do multiple orders. There's another way which I will show you. I just made it in the cloud. You can use whatever you like. I just pasted the pattern here and said uh analyze this pattern and tell me if you can spot what it is, you know. And there you go. Look at this data. This is clearly an Amazon DSP flight schedule, you know, and goes back and analyzes what uh what's inside pretty easily. And I said, okay, update the pattern. So the flights are at 300 from February until November this year. formatted so I can paste it back into bulk files for DSP. There you go. Just copy paste what you have here and even faster you know it's everything is as it should. So since February where is it February? This is January December January. So since February here you go it's February and onwards every flight is at 300. And then you can quickly upload the the data into the column O. Save the file. Then go back to your Amazon DSP console. Hit download and upload. Go to the upload settings. Just drag or upload the file. Hit upload. And that's it. If everything goes right, you will just see a notification in green over here that everything is uploaded. If there are errors, it will say like one updated out of three, and you would have the ability to download the file with the errors. So it's really you can check it out if you made any mistake. This will save your team a ton of time. I hope it was clear to you. I love this feature. I haven't messed too much with debug files on Amazon DSP because you know uh it takes time to master them but once you do that it's really a timesaver. Thank you for watching and see you tomorrow in the next video. Bye-bye.