Managing bulk files when it comes to Amazon PPC Bulk Files Optimization is one area that many people struggles with. Today we are going to learn many cool things and tricks. We have Elizabeth Greene to share her invaluable insights about it with us.
Tomer [00:00:00] I had yesterday an awesome guest, Elizabeth Green from Jungler, she’s an expert in Amazon PPC Bulk Files optimization and especially with Bulc file operations. And this is a topic that not many people are talking about or you have enough information available online.
And I’m very happy to share this information with Elizabeth explaining how to work with both clients and what are the benefits of working with it to be much more efficient, more productive and be ahead of your competitors in Amazon PPC Bulk Files, an area that is super, super important and relevant.
Now, before we’re moving into the video, please make sure that you subscribe to the channel and you click the bell. So for every new video that I upload, you can get yourself notified of an update and also go to sourcing-monster.com to get updated through our newsletters, updates and news that I don’t share here. And let’s start with this awesome video.
Tomer [00:01:07] Let’s welcome our new guest for today, Elizabeth Green from Jungler Dot com. She’s one of the few experts that actually knows a lot about Ebola virus and the area that many people struggle with and actually phoned about there when I was looking for info about Ebola on YouTube. So I’m sure we’re all going to learn many new things today. Welcome again, Elizabeth.
Elizabeth [00:01:32] Yes, thanks for having me. Yes, of course.
Tomer [00:01:35] Could you share a little with yourself about Jungler and how you became an expert in Amazon PPC Bulk Files optimization?
Elizabeth [00:01:43] Yes. So as far as jungler, we are a full service Amazon advertising agency. So if you don’t want to touch your ads, hire us. But we’ve been around as a company over two years now.
And as far as myself, I kind of fell into it, to be honest. And then I found out, weirdly enough, I really, really enjoy spreadsheets and writing formulas and coming up with ways to view data.
Elizabeth [00:02:09] And so through that, I discovered a love of bug files and all the good backend stuff and haven’t looked back.
Tomer [00:02:18] So it’s it’s from trying working with the Amazon interface that you kind of didn’t like it, then try to look for alternatives like how to actually discover the bulk files and working with it.
Elizabeth [00:02:32] Yeah.
Elizabeth [00:02:33] So when you get started on Amazon advertising, your first question is going to be how do I do this? Because you’re still trying to figure out what’s keywords, what are match types.
And then when you finally find your footing and you kind of have your rhythm, you’re not looking for ways to do things. You’re looking for ways to do things faster. And that’s where bulk files come in.
So I was the same way starting out how everyone does. Some people switch on to software and leverage that software can be a great tool. However, it’s a tool and with Amazon PPC Bulk Files because their spreadsheet-based, if you understand spreadsheets and you understand the power of what spreadsheets can do, the things you can do with them are astronomically more than you can do with software.
Elizabeth [00:03:18] There is a learning curve. That’s why I put out a lot of content, because when I first opened up my first book, well, I’m not going to lie. I sat there staring at it and I like it. I can show you guys I have one pulled up. When you first see it, it’s going to freak you out. Don’t let it freak you out. Like I said, there is a learning curve.
But once you once you get the learning curve, you’ll start figuring out ways to do things faster and faster and more efficiently so that they can be very powerful if you know what you’re doing.
Tomer [00:03:50] Yeah, yeah. And including myself. I was just starting to dig into it a couple of months ago and it was very intimidating. And like I told you before the call, I really consider myself as someone with 12 years experience with Amazon PPC Bulk Files.
So working with both not bulk files, what we see in the high spending budget, it’s not something that I’m scared of. But once I downloaded the reports from, you know, with thousands of keywords and search terms and little of number like hit the upload, well, then and then I see all these errors. So it is a little intimidating.
But like like you said, with everything and you the learning, there is a learning curve. And and I’m sure we’re going to learn some new things here.
Now, I do have a couple of questions about the butterflies. Why Amazon seller is that managing their Amazon PPC Bulk Files? Should you use both as mentioned that it’s not about doing new things, it’s about doing the things in maybe faster or more efficient way.
Tomer [00:04:57] Do you think it’s recommended to everyone who is good for.
Elizabeth [00:05:02] I think I would say yes with the caveat of you need to understand the system. You’re working it. So if I was to give like a brief snapshot of what a bulk file is, it’s a 2D look at all of your campaigns in a spreadsheet.
Elizabeth [00:05:20] And so the benefit of this, if you are still managing your advertising manually yourself to go into your account, you see the top line, all your campaigns, and then you have to click into your campaigns. And then if you want to go to the ad group, you have to click on the ad group, click on targeting, and then you can see all the keywords. Then you can make changes.
And then but you start to click into every single one of those boxes. You can select them all if you want to do a straight percentage. There are a couple of things you can do faster in the interface, but it’s still very manual and very tedious.
And when you start to scale up to multiple products and multiple campaigns, it becomes very unmanageable and it’s very, very easy for things to just slip through the cracks.
So that’s the beauty of looking at things in a bulk file because it’s a spreadsheet. You can apply filters you can sort. You can look at all of your keywords condensed and go down the list and then you can actually make changes to those individual keywords.
For instance, if I wanted to change my bids, increase everything by 20 percent, I could probably do that. Maybe in 10 or 15 minutes using a bulk file versus if I tried to do that. And campaign manager, that would get ridiculous.
Now, why I think it’s a good idea to understand the interface is you can quickly change things in a bulk file. But if you don’t understand what everything is and maybe why you’re applying those changes, I wouldn’t recommend going into your campaigns and upping every single bid by 20 percent. I mean, you can, but, you know, it’s not something I would recommend doing.
So if you already have a system and you already kind of know how you want to adjust your bids or maybe you have some basic rules, you go by, you can actually use or even formulas if you want to get completely with it, you can apply formulas, change everything, re upload that and then those changes will be created inside your campaigns.
Elizabeth [00:07:10] And so you can kind of start to see how this really, really speeds up your process.
Tomer [00:07:14] Nice. Nice. So yeah. Yeah. I think also, you know, if you have like one or two products like less than five, so it doesn’t make sense. Yeah but but yeah, you can make things much faster. And you know, sometimes the Amazon interface, you have like 30 complaints per page and we you know, with the bulk files, it’s much more robust, much more responsive than central.
And you just apply the filter and it’s like, bam, very quick. I like the fact that it’s very responsive and fast. Now, you mentioned something about formulas. It’s a part of my question.
Tomer [00:07:51] But I’m really curious now that your expert with with both sides, you know many things and you have so much experience with it, you have like a set of formulas that you save or or apply like like, you know, each each week or each period of time, like how you save yourself time.
Because let’s say, for example, you want to see all the like keywords or search phrases that had 50 clicks in the last 30 days with no conversion and maybe possibly add them as a negative, you know, so instead of having the formula each time.
Is there any like I know in Google Sheets, you can save a macro and then you apply it and then it works. I don’t know how it works with it. So is there anything like that?
More about Amazon PPC Bulk Files tips and hacks
Elizabeth [00:08:34] Well, yeah. So we have Excel macros built out and things that go back into the beauty of working and spreadsheets. And here it’s helpful to have some spreadsheet knowledge.
Elizabeth [00:08:45] So when I first got started I could do like equals this column. I mean that was the extent of you and I realized that a spreadsheet can do additions, but once you start really doing it and to be honest, I find it fun, I will happily create a spreadsheet on it on a Saturday evening and be happy as a clam.
Not everyone’s like that. I get that. So don’t don’t think that if you if you can’t do that, that you’re not fully utilizing things.
Elizabeth [00:09:15] But when I say formulas, I mean, you can write your own formulas if you want to.
Elizabeth [00:09:23] One of the best formulas to get started with a formula and if formula says if this happens, perform this action if this is not happening. So it’s a true or false statement. If you can do this and you can I mean, if you’re really getting into it, you can layer of formulas or I mean, I don’t I don’t want to get a little more advanced.
Tomer [00:09:43] It might get people. Yeah, but. Yeah, yeah. Great. For the bulk files functionalities, it’s something that, you know, it’s open to everyone or you have like roll or like me, it’s open.
Elizabeth [00:09:59] I know, but I wasn’t sure like, yeah, if you are running Amazon advertising, you have access. So the ad council, the left pop out manual, you’ll see something called files. You can go click there and you can generate a profile.
So on the left hand side, you can select a date range, uncheck the little box campaign items with zero impressions if you have that checked. OK, the bulk file that you do you generate will not include any keywords that did not get a single impression within whatever date range you select.
Elizabeth [00:10:35] So if you want to look at keywords that you’re not getting impressions on, you might want to check that request. It it will populate beneath there depending on how much data you have. It could take a second and then you’ll see a little blue download up here. Once it’s ready, click it.
You can download it to your computer, open it up in whatever spreadsheet software you want, Excel Google Docs, Google Docs will break down if you have too much data. So Excel, you know, if you have a very, very large account, go with Excel.
Elizabeth [00:11:05] Google Docs is nice for storing or Google sheets connected to. Drive is good for storing.
Tomer [00:11:14] Yeah, so if you work with, you know, big funds, huge piles, it looks like it’s going to be glitchy.
Elizabeth [00:11:21] It’ll just break down half of them like some of our larger compounds. We can’t even open the file in Google.
Tomer [00:11:27] OK, I know that you prepared to my example of the file. Maybe visually it would be easier to for people to actually see what we’re talking about. Would you like maybe to share the screen so we can take a look on, you know, the basic stuff like how to add negatives out, be bits, some basic functionality that you can do with work?
Elizabeth [00:11:53] Yes. So I will share my screen. And what you’re going to see is if you generate this file, this is what’s going to appear when you download and open it up. So maybe if I walk you through it, you won’t have to freak out like I did. Yeah, but let me go through. So this is what you’re going to be looking at when you download it and you can see why. If you don’t understand what this looks like, it looks like a heck of a lot of numbers and letters.
And you don’t know what’s what. Yeah, I will. I think it would be good to give a basic overview. So like I said before, this is basically your entire advertising account in a spreadsheet. You got access to everything. Now, the one thing you will know is that this data is only going to be for whatever date ranges you selected when you downloaded the report. So it’s a good idea to be specific with your date ranges.
If you just want to take a peek at it, you just want to download it and poke through it. As long as you don’t upload this file with whatever changes you make, you’re not going to hurt anything. So if you just want to download it, click around, nothing’s going to happen.
You could just familiarize yourself with this. But so we’re looking at a 2D version and the way you can tell which level you’re looking at is through this column B, which is called record type.
So depending on what is contained in this record type, we’ll tell you what data is on this line. So each line is going to be a different level. For instance, this one record type says campaign. So this tells me that this is all of the campaign data. Now, I did change the campaign names. This is an actual bulk file with everything changed. So right here, I can see this is my campaign name now.
This one’s been archived. And then so depending on what the row is, that’s what the data. What is going to. Yes. And then the different columns tell you what information this cell contains for this row. Yep. For instance, this is a campaign. So under a campaign, this is campaigning campaign names. So this is campaign one.
Tomer [00:14:11] So that will be different to people that don’t really understand. Like she changed the data because it’s a real file. But when you download it, it will show like different names, not the same ones, of course.
Elizabeth [00:14:22] Correct. Yeah. So it will be for your account, your data in the date ranges you selected. And so I would say the basic thing that is very helpful to know about filtering a bulk file is so I’ve already applied a filter over the top of this so I can go down and I can filter by things. If you wanted, for instance, to see all of your campaigns, you want to know what campaigns am I running, I can clear and then I can only select my campaign rows and if I like.
OK, then now I’m looking at every single one of my campaigns that I have in my account.
Tomer [00:14:59] And then you can also add another field or show me all of those that are active.
Elizabeth [00:15:04] Yes. And so if I go over here now, the status columns are also a good thing to know. So over here, under campaign status, we have the archived, paused and enabled. The two basic ones you’ll probably see is enabled and pause. And the other thing to know about bulk files is the formatting.
And like how you word things is very, very specific. So, for instance, if I wanted to change something here, one thing I can do is I can enable this campaign. If I misspelled enables that it wouldn’t process it when it was is.
Tomer [00:15:44] And you will get an error.
Elizabeth [00:15:46] Yes. And so if you’re trying to make changes and you want to be very specific, what you can do is you can just download a book file and then maybe just copy paste these things, for instance.
Elizabeth [00:16:00] One other thing you can see is the bidding strategy. So if you want to know what bidding started, you’re using under the bidding strategy column, because I’m looking at the campaign row. I’m not going to see this at the ad group with the keyword, because they don’t they don’t need a bidding strategy, but I can see what I’m using here.
Don’t only fix bids and then you have to see how this one has parentheses. It’s very, very specific for things like that. I even just copy paste it. I know what it is. But just to make sure that I’m getting it correct, you can just copy paste in.
Tomer [00:16:34] Is there any like every single column that you have here, you can change even the bidding strategy, the placement. You can just put the new value there. Like, for example, I can see that you have they’re up and down, down, down on the edge. So I can just I can copy, like, the exact term, of course, go up and down there. And when I upload it, it will update the complaint.
Elizabeth [00:17:00] Yes. So the things you can change. For the most part, are things that you can already change in campaign manager. The only thing is you can’t change. I wish you could you cannot change campaign games or you can’t change aid group names, unfortunately, but you can change, for instance, my campaign daily budget.
Elizabeth [00:17:23] If I wanted to change the daily budget, this is 13 dollars and five cents. Maybe I want to put twenty dollars if I change this and then re upload this file. That change will occur on I. Of course the campaign type is already set.
I can’t change it from auto to manual. I can, however, change this end date. French and some of these have end dates. If I wanted to put a specific date, I would like it to end. I can do that. Or these ones that are checked blank. It means there’s no end date forever. Let me see what else would be good to know. And then the other thing you can do is anything on the status. So, for instance, campaign status.
Now, if it’s archived, if you know, this is why it’s helpful to understand how the platform works, because if you understand archive campaigns, you can’t archive a campaign. So that would not process. You can’t get around that through bulk files, but pause and enabled campaigns. I mean, you can turn things off and on and campaign manager. So you can do that as well through a bulk file.
Tomer [00:18:23] I usually just post or enable. I never archive when you actually archive a campaign.
Elizabeth [00:18:29] I don’t I never this is an old account and had a bunch of old campaigns and somebody else archive. I wouldn’t ever archive you.
Tomer [00:18:36] OK, what are the most common things that people do. Adding negative Jingyan to be like the main things that you very powerful doing with it.
Elizabeth [00:18:47] The main thing I would say is big changes. If you’re still doing that manually, the the, the best thing to do is big changes. And the way to find that is if I hit clear here. So what I’m looking to do is I want to condense all of my.
Things I’m betting on, and I want to only take a look at the things that aren’t able. So these are the filters I use so you can look at keyword and product targeting. Keywords are keywords.
Elizabeth [00:19:12] Product targeting is the essence. And I believe it might also be the auto’s, if I remember correctly. Then the other thing I would want to do, because you want to look at anything that’s enabled. So I would go to campaign status, I would uncheck post because I don’t want to look at past campaigns.
Doesn’t matter if I change bets or not. I want to uncheck because this is ad group status. So this applies to all my ad groups. I don’t care about looking at Paul’s ad outgroups status.
This applies to individual keyword or the product I’m advertising on. I want to undo.
Now, the other thing you want to clear would be under here match type, because notice here, there’s campaign negatives here. So if I just go here and this is Google Sheets, it sells a little bit weird about just typing things and deselecting, but I can just hit negative and then just clear, clear everything with a negative adjust because we’re negative, right?
Elizabeth [00:20:11] Correct, yes. So what I’ve done here is I’ve looked at I have now filtered everything I’m bidding on in my account and over here k and I’m going to freeze I like to freeze the top row when you scroll you.
Elizabeth [00:20:30] Yeah. You know what’s what, because I’m in these all the time and I still would have to scroll back up.
Elizabeth [00:20:36] So now I can look at my C impressions, click spend orders, sales and acost. So for instance if I wanted to go into my campaign, everything I’m advertising, what’s my highest accosts. I could go here highest to lowest immediately.
Elizabeth [00:20:52] C And obviously that one needs to be this is like you combine maybe because, you know, sometimes you put your UI cost and you didn’t get enough clicks. So, you know, you can based it on, you know, not enough that you can find mission greater than.
Elizabeth [00:21:13] You can apply all kinds of things, but you’re still condensing everything to all of the keywords that you’re bidding on and you can see things in your max becomes the one weird thing about a book file. This one’s already been formatted, so I don’t think there’s a problem. Sometimes this max speed column, the cell will be blank.
Really? Yes. And when that happens, it is because it’s set to the default that and when it’s only set to the default button, you’ve never changed it then Amazon. It only records it at the ad group level. So what you would have to do is pretend this one was blank.
Elizabeth [00:21:52] I would have to go find add group 11 and say, what’s the default bid on my add grouplove? And that’s what the bid is here.
Tomer [00:22:00] Or you can just update it one time. You just go and see everything you can see and maybe I’ll be the average and then adjust it later.
Elizabeth [00:22:08] Yeah. Or I mean if you want to. I actually have because this problem drove me crazy.
Elizabeth [00:22:13] It’s tough to get around. We have systems that auto check for it and fill it in for us. But I wrote a spreadsheet formula that I have up in my channel. The caveat is it only works for Google Sheets. I made another formula that works in Excel because it works off an array formula and excel super weird about a arrays.
But if you go watch that and then there’s a link to a PDF, it actually has a formula that shows you how to quickly fix all that before you go in and make your bed changes.
Tomer [00:22:47] Yeah, guys, check our channel. It’s junk jungler dotcom when YouTube, I’ll put it, you see.
Elizabeth [00:22:53] Yeah, we can put it somewhere, but yeah. So, so if you see a blank don’t freak out. No that’s normal. And that’s how you would go find that. The other caveat is when you download these files, the any number value is actually stored as text. Yeah, that’s right. So if I went to filter these, it won’t filter properly. So you can you can reformat it in Google and Google sheets. It’s a little bit easier. You just select the row.
Tomer [00:23:23] So it’s a nightmare, right?
Elizabeth [00:23:25] I hate it. No, it’s not that bad. You have to like. So what you’ll do honestly, the easiest way is if I can control down and then I hold shift control over and see basically you just highlight the entire thing at the top of wherever you’ve highlighted, you’ll see like a little. Like an error in you, like click on it and it says, do you want to format this site in one of your videos?
Tomer [00:23:52] But then I tried to replicate this and it didn’t work.
Elizabeth [00:23:55] Sometimes it works. Sometimes it doesn’t. You just have to keep kind of playing with it. Yeah, you can. I think it’s like you can. Right. Click format something as well.
Tomer [00:24:04] Yeah. Is there any formula I can apply like in my car that will just do it. All of them or there reason.
Elizabeth [00:24:10] So if you want to write a macro for it. But the problem is Google says even if you record a macro, it’s recorded native to the sheet.
Tomer [00:24:17] Yeah, I remember, actually. I remember. And then when you upload a new file, you have to like. Yeah, yeah, yeah.
Elizabeth [00:24:25] So I mean, that’s getting into that’s getting into the weeds for sure about programing those not native and all kinds of stuff. Yeah. So it Googoosh it’s it’s not hard. Basically you could just select all of these and you just heard format as. No, no. And then it’ll be kind of weird. So if you want to like decrease the decimal place you could and then just click spend as a dollar sales as a dollar, a cost as a percent. It’s not that tricky to do. Yeah. It just takes a couple more seconds. OK, nice.
Tomer [00:25:04] So what you will check, you will check regularly, like four negatives, what you guys check like and also negatives you would find in disaster reports, the best way to find a negative would be to search through I-Report filters, orders, sorry, clicks highest to lowest and then only look at zero orders. You can do that either by total orders or blank values for the ACost column.
Elizabeth [00:25:34] And that will bring to the top anything that has a lot of clicks and no sales. And then you can go in and add as a negative.
Tomer [00:25:39] What is your recommendation like for a number of clicks? Like, of course it’s not black and white, but like, like above certain keywords, you will get it as a negative, like broad or like how we approach this.
Elizabeth [00:25:53] So I’m more reluctant than some to add negatives, but I don’t avoid adding negatives and it really, really depends on the count. So the way we manage is much more hands on. It takes more effort. It’s not going to be everything with 15 clicks and no sales go at it as a negative. That’s not how we approach it. So we would do and like it depends on the account. So if you have someone who is very, very worried about budget, if you’re super worried about budget, you would be much more likely to add a negative. For instance, if you have your main keyword, like it’s a main keyword, you definitely want to be advertising on this. It’s something very relevant to the product.
Elizabeth [00:26:30] But it may be your product is very new and you don’t have any reviews. Your your performance on that main keyword might be really, really poor.
Elizabeth [00:26:40] And so you might have like 30 clicks, no sales. And you’re looking at the search term report going this this is relevant. Maybe I don’t want to negate it, but if you have a very limited budget, a bunch of your spend is just getting sucked out the window. So maybe, at least for now going in and that negative so you can reallocate that spend to things that work and then revisit it at a later time. So the way we approach the negatives is much more nuanced.
Tomer [00:27:04] There’s a lot more if I’m also like that and with with big adjustments, like, you know, big adjustments is a little tricky for people because sometimes they they just optimize it either too fast or just waiting to too long, like all the way that like how you approach it. Like you wait seven days, a couple of days to get enough data. Sometimes you you have a cure that you’re with maybe in the last 20 days that it’s not performing well. But, you know, someone that really knows the account and the product knows that it’s a good keyword and you might just decrease the beat or something and not get any more impressions. It makes for a good keyword. So how are you kind of find this like fine line on how and when to change? That would be.
Elizabeth [00:27:53] Yeah. So we’re what we do internally is that the level of crazy conspiracy guy. I mean, we are constantly trying to find ways to build systems around scenarios exactly like the one that you just described, because to be honest, human insight into the campaigns at some level it’s just numbers. But if you know the account very well, you’re probably going to come up with much better beat adjustments if you know what you’re doing.
Elizabeth [00:28:23] I mean, if you understand how things work, you’re probably going to do much better. But adjustments than just a straight machine churning through that, I’m sure for sure.
Tomer [00:28:32] We know we have the relevancy. We know what the cure is, what, what, what the intent behind them, what all of this that machine can, you know.
Elizabeth [00:28:43] Right. And so the caveat is going to be, but can you do that at scale?
Elizabeth [00:28:49] So the benefit of using a system like this, a bulk file, is you can look at things at scale because it’s condensed. However, we have 16 accounts and multiple accounts that we have are in multiple different marketplaces. So it’s basically like managing five different accounts. So if I were to try and thousands of Skewes and some of them, so if I were to go through that mentally trying to match the skew to that at some level, your brain, by the end of the day, you’re just not even making good decisions. So that’s where it’s beneficial to have a system that runs through things. And then even after our system runs through things, we have a couple manual checks. We go through that end result lists before we actually OK, those changes.
Tomer [00:29:36] It’s an art.
Tomer [00:29:36] It’s profession that I mean, at the very at the very end of the day, when you’re going to have this, you’re going to have a target at costs and you’re going to say what is above and what is below my target.
Elizabeth [00:29:48] It costs what has multiple clicks and no sales and what has their own impressions. And to be honest, those are the four things, keywords, quality. We honestly have five because we look at things that have upwards of we call it like our top tolerance costs. Most accounts, that’s one hundred percent. So if anything’s running above one hundred percent, we definitely want to dig into that.
Elizabeth [00:30:11] However, we have the ability like I said, we get super into it. So we have the ability to set whatever we want.
Elizabeth [00:30:18] The top talents, for instance, a supplement you might go up to two hundred percent because those are crazy. So we didn’t want that hardcoded. But I mean, and then depending on where it falls into those four categories, then, you know, make your adjustments based on, you know, based on that.
Tomer [00:30:38] Oh, great. So I have a question. So when you when I first downloaded the bulk file and used it for first time, I download, like you said, like the whole thing. And then I did some of the judgments and I just uploaded it. Know what it did? It did try to update everything that I have on my account, which is how you actually and I found a solution for that. But I really like it was kind of like I just want to take specific keywords that I want and just update them, not everything, because it’s a room for mistakes or issues. I don’t know. I don’t like to.
Elizabeth [00:31:23] So what? So what you could do if you only want to do the keywords, you could copy all of this just so we can copy paste the brand new sheet.
Elizabeth [00:31:34] Yes. Oh, yes.
Elizabeth [00:31:36] And you can paste in a brand new sheet. And then only the data that you’ve uploaded is what’s going to be changed. Oh, the only time you need everything is if you’re creating from scratch. For instance, if I’m creating a new campaign, I’m going to have my campaign. I need the outgroup group. I need the products. I need all the keywords.
Elizabeth [00:31:53] Once my campaign is in there, I can reference that campaign by just inputting the campaign name here. So I so for instance, this is a keyword. So if I wanted to add a new keyword, I would need to tell Amazon it’s a keyword. I need to tell Amazon what the campaign name is. I need the ad group name. I need my bid. I need the keyword.
Elizabeth [00:32:15] I need the match type. And then I need to tell Amazon, I want to turn it on, and that’s all I need. So let me go here to a condensed view. This is like a template. This is seen as much cleaner.
Tomer [00:32:32] So I need to get whatever you’re going to update. Right?
Elizabeth [00:32:35] Right. So, for instance, the keyword. Yeah, this is all I need for a keyword. So if you want to add a single keyword to a campaign, I mean, it’s probably faster just to do that manually if I’m being honest. But if you wanted to, you could do that here. Or if you want to update the bit for a single keyword, just go in here.
You say it’s this one. I would just copy this row, make sure you have the headers. The headers tell Amazon what’s contained within this column. So you have to have the headers and you have to have all the data points that Amazon requires to make the change. But as long as you have those, you don’t have to upload the whole sheet.
Tomer [00:33:11] That’s that’s very powerful because, you know, a lot of time what I did is I would go to Sulligent well, I would go to an Oracle complete auto component.
I used to harvest and find new keywords. And I would just go to search terms, find those terms, then compare whether I have them in the manual campaign and then copy one by one and do it like really time consuming task. Yeah, it was fine.
You know, when you manage, like, you know, your campaigns or products. But now that they have like even 10, 15 campaigns for product and you have 30 brothers, it’s great the efforts. And I was finding myself until I got the practice with the board post, like spending that I didn’t have enough time.
So I would just work on it on one product every day and then just get to work like that every day on a new product. So, yeah, it’s very powerful. Yeah. The main things are like, like you said, be the just means maybe adding nuclear words. It’s very powerful negatives.
Elizabeth [00:34:20] Yes. So I mean that’s where I got into the beginning. When I say the power of spreadsheets, if you know how to use spreadsheets, all it is is knowing the formatting. You need to give Amazon the information it needs to make the change. And so the learning curve is understanding the formatting. Once you get the formatting and if you have an understanding of sheets, then your mind starts working on how can I do this faster?
Elizabeth [00:34:45] For instance, I got tired of adding negatives. You can add them very quickly if you know formatting and you can pace things down, but there’s a faster way to do it. So what I did is I created a sheet for myself. I can go in, I can report do that filtering how I told you before, Clixby Solo is zero orders.
I can just copy all the lines that I want to add the negatives on because they contain the campaign name, the group name, the search term that I want to negate and I can paste it into my sheet and it will auto spit out a whole book file for me that I simply copy, download, upload to Amazon.
There’s no sorting of things. And so, I mean, there’s ways you can do things fast, but the tricky part is learning the formatting. And that’s why I put out so much content on our channel about bulk files.
Elizabeth [00:35:36] It’s a lot of here’s how you do this. Here’s the formatting. There’s also some tools that I’ve had just sitting there. They were old tools I created. We have better things now, so you might as well share.
Tomer [00:35:50] Yeah, yeah, that’s that’s good.
Tomer [00:35:52] So so if I explain or to understand it better so that when stock picks and stock, we see something really advanced connecting the formulas and the power of Excel or Google shoot with what we already know. So that’s where the power comes. I, I, you know, I’m going to dig more. I have a lot more to learn about Excel and all of this.
This is an area that I’m not really, you know, strong at, but I’m willing to have this learning curve and learn. And I think that is one of the questions that year was like whether you think that working with ball clubs could give you this advantage over competitors.
So, yes, it’s for sure, because you you move things much faster, you’re much more efficient. And that’s that’s for sure an advantage. So the learning curve definitely worth it. People sometimes scared of new things. But, you know, look at it from a point of view that, you know, it can take you you have better performance than your competitors.
Elizabeth [00:37:03] Yeah, I definitely agree.
Elizabeth [00:37:05] I think I think the main thing most people seek out bulk files for is for the bit adjustments, because at some level it gets tedious if you’re inside of campaigns and very inefficient if you have one or two campaigns, it’s probably more efficient to do it inside. Campaign manager the benefit of doing it inside campaign manager is you can compare date ranges.
Elizabeth [00:37:24] There is more things you can do inside of campaign manager, but this allows you to do things in a much, much larger scale and then you no longer have to be afraid of creating multiple campaigns. I’ve seen so many times worst sellers. They’ll have maybe even a million different groups, which, to be honest, is not very efficient either because you still have to click into each group. But they’re much more reluctant to really leverage what you have in advertising because the amount, the amount of time and effort it takes to manage things.
Tomer [00:37:59] Yeah, I see where even things with the very successful sellers actually. Yes, I know a bigger seller that told me I don’t read a lot like two or three campaigns only for that reason. And I’m not saying it’s wrong and everyone to have their own way of thinking, but I think that it’s a way of limiting.
You are limiting yourself to just learn this new skill and you have this power of all these because why you want to create and you campaign to to have a different tactic, something that is separated. You can measure and adjust quickly. So I’m with you on that. And is there anything else that you suggest to people to learn or dig deeper into Bulc files other than watching your videos?
Because it’s a complex topic for sure. And, you know, you learn by by watching whether others or practicing yourself. But is there anything else that you want to add there about this?
Elizabeth [00:39:03] I would say, yeah, just go ahead and learn and just just download. The other thing you can download is if you go into the bulk files, there is a template, to be honest. Last time I downloaded I think some of the columns are off, so maybe not, although I do have several templates and things you can look at underneath my videos, we have a link to a lot of different Google sheets.
But the main thing, again, is going to be learning the formatting.
What goes where? That’s where most people fail when they get errors. It’s because, I mean, I have quite a few people emailing me this one to go through this one because I know the formatting very well. I can take a look. Oh, you missed this. You missed that. So once you get past the learning curve and you understand what’s where, if you have time to watch a longer video and you don’t need to make the adjustments.
Now, I suggest you go watch my video I have on using a blank bulk file template. I believe I start walking through. This is what this line is. This is what we go through, a campaign creation and it helps you understand in a much cleaner versus having to look at all this mess, what goes where.
To be honest, it’s an old video. I don’t know if I’m super articulate, but the data is correct and good if you need to make quick adjustments. I do have a video on how to quickly make the adjustments in a book file. You know, you can watch that or this will probably give you enough information.
Tomer [00:40:31] Yeah, great. You guys watch these video. I’m going to watch it as well. If I didn’t watch it, I’m not sure. Like, how many videos are you watching your channel. But it’s very informative. For those that want to contact you, learn more about your services and all of that where they can find you and learn more about.
Elizabeth [00:40:50] Yes, so the best way to get in contact, if you’re interested, would be our website, which is jungler, dot com jungle, our dot com. There is an intake form at the bottom of the page and I’m still taking all of those. So i
f you’re interested, I want to be honest, are our client space is getting more limited. So we tend to focus on a little bigger brands because that’s where we can leverage the systems we’ve built. But if you’re really interested in services, I’m more than happy to talk with you. That would be the best way to get in contact.
Tomer [00:41:17] Yeah. And check our YouTube channel.
Elizabeth [00:41:20] Yes. If you want to learn about that or have suggestions, leave a comment. I think just about every comment is answered under the great.
Tomer [00:41:27] It was really awesome video and I appreciate the time you took and the file you prepared and shared with us. I learned quite a few things here with you, and I’m sure, like the rest of the viewers will learn many things. I really appreciate it. I wish you could enjoy the rest of the day. And hopefully we can have another video and you can be a guest again on the job in the future.
Elizabeth [00:41:53] Yeah. Yeah, I’d love to. Any time.
Tomer [00:41:55] Yes. Everybody wants you to.
For more advice on running your Amazon business, read the Sourcing Monster blog or avail of our 1-on-1 coaching!