okay so I’m gonna show you how to optimize publishers it’s a little might seem a little intense but it’s kind of an advanced thing you probably won’t be doing this if you’re just starting out for quite a long time but it’s good to know down the road that you can keep optimizing and improving your campaigns so the first step is to click on reports mmm and there’s actually lots of reports you can do here but the one that we want to focus on is website URL publisher and then you can name the report whatever you want and choose website URL publisher and there’s some different options here let’s go last 30 days the date range and we’re gonna go excel so you’ll need some external way to monitor these just 17 days okay you could choose different options here of different different things to include so up to you filter so I think I might filter by add distribution no no that doesn’t that doesn’t help us okay so I’m going to click I’m actually just going to click run and let it run inside of here and see if it gives it to us sometimes the reports too big and it makes it so that you have to download it into Excel but sometimes it’ll let you just run the report right here okay so it says the mo the report has more data than we can show so I’ll have to download it okay so I’ve opened up the report in Excel I’ve taken out a few columns here but we’ll just look at the important stuff so we can see the website URLs the publishers right here and we could see how many impressions I got clicks click-through rate average cost-per-click spend average position conversions conversion ratings cost per acquisition so let’s see some things that we can find out I’m going to select all of the data and then I’m gonna go to i’m gonna go to data and then i’m going to a sort and then I’m gonna go to sort by and I’m gonna sort by cost per acquisition and largest to smallest click okay so these are showing us remember this is only in the last 17 days so the cost per acquisition is here you can see so a lot of them you know this is lumping in the search and search and syndicated but this is an example of a syndicated placement DuckDuckGo that’s like another search engine that I guess being you know have owns some ad inventory there so the cost per acquisition there was 76 cents that’s pretty good one conversion let’s look at let’s look at I’m gonna go to sort again and I’m gonna sort by the number of conversions largest smallest okay so most of these are paying we’ve got DuckDuckGo here okay so since it’s only in the in the last 17 days and this is a high price thing I’m not I’m not tracking opt-ins I’m tracking sales on this product so they doesn’t get as many conversions is like if you were tracking an opt-in this would these would probably all be in the hundreds but the cost for acquisitions you know these are all these are all great in this case we’re related Web MD topics at WebMD topics that WebMD you could see a lot of these a lot of the syndicated placements here which is what we’re trying to just figure out if any of them are you know wasting money in this report it doesn’t seem too bad let’s go let’s sort by spend largest to smallest okay msn.com msn.com msn.com msn.com none of these you know none of these spins are crazy either all right I’m gonna run a report for a longer period of time so you could see some more stark differences okay we’ve got a report now with more data this is from the past six months so I’m going to do the same thing we go to data sort and first we’ll sort by cost-per-acquisition largest to smallest to see if there are any outliers here and yeah it doesn’t doesn’t look too bad here let’s see if we can sort by spend largest smallest yes so this this account is pretty well optimized it doesn’t I’ve gotten rid of a lot of the early on troublemakers the publishers that were spending a lot of money and not making any conversions I just blocked them so next I’m going to show you so this this will just all be up to you you know it’ll all be up to your numbers what’s your target CPA how much is your budget how much are you willing to test out on experimental places but definitely look in here and specifically know there’s lots of being in Yahoo so let’s get to some of the placements oh okay so there’s here’s a bunch right here search encrypt net find topics dot WebMD answer site DuckDuckGo you know net find so if you find that any of these if you look at the stats and there’s one that’s just spent way more than you want for and it hasn’t gotten any conversions or is way above your target CPA this is what you do and there might be a list of them so let’s say I find that this one this one this one this one this one this one this one and this one and this one are not performing so I would copy the website URL it doesn’t work on multiple selections okay so let’s just say it’s this list right here so I’m gonna copy the URLs in Excel or OpenOffice or Google sheets or however you reading your spreadsheets and then I’m going to go back into Bing and I’ll show you here in a second we’re gonna go to the specific ad group or campaign that you’re looking at and we’re gonna put those URLs into the blocked URLs so I’m gonna go there now all right so this is where we’re gonna look we’re gonna go to the ad group settings and then all the stuff should start looking familiar by now but we’re gonna go down to just like where we found that you could change the ad distribution and change it to either bang or syndicated now we’re gonna look at this exclusions and click website and so if you want to block if you just think there are certain websites publishers that just don’t perform well for you at all you can put them in the campaign levels exclusions otherwise you can put them in the web in the ad group levels of exclusions so these these are the publishers that I copied from the Excel spreadsheet and now if I if I click Save down here then Bing will stop showing ads on these publishers so that’s how you’re gonna eliminate the non performing publishers and you’re going to profit you’re gonna increase the profit of your account more and more so this this can be the difference between a unprofitable account on a profitable one or more likely because this does take some time and some spend to be able to get to this point you know where each each publisher has spent you know maybe $100 or something or $50 or whatever your target CPA is over time you can just you know it’s it’s usually good to do this maybe depending on how much you’re spending once a month or maybe once every few months just just set up a reminder to go in and check your publishers because there might have been one publisher in there that’s been stealing away or your money for a long time and you want to get rid of it so it it’s like pruning it’s like pruning a plant you know you gotta you gotta prune off the dead leaves so that the the other ones can flourish so this is the pruning process so you would just put put all of the dead leaves in there and then click and then Bing will stop showing ads for this ad group on those sites so you’re gonna you’re just gonna grow your profit more and more just like a little little profit tree all right thanks for watching and we’ll see you in the next video