Yuma 4×4

Media and Communications

How to upload keywords using Google Ads Editor – Google ads tutorial 2019

How to upload keywords using Google Ads Editor – Google ads tutorial 2019


In this video, we are going to learn how you can upload your keywords using Google Ads editor In order to set up your first campaign, you will need to have some basic knowledge of using Microsoft Excel or Google sheets however, don’t worry, if you are not an advanced user at I wasn’t when I first started using this tool I have included the links for you to download your free keyword build template in the description of this video you You can download this template and follow me step by step as I show you how to create your first campaign and upload your keywords using Google ads editor. So let’s get started. Step number one is Prepare your keyword spreadsheet. Before we do anything in Google ads editor, We need to prepare our keyword spreadsheet first. To do that, Download and open your keyword build template spreadsheet either in Excel or you can do that online on Google sheets I’m going to use Excel in this video. On the keyword build spreadsheet, you will have three tabs these include “campaign source info” This is where you include all your tracking parameters to track your campaigns in Google ads and also these details will appear in Google Analytics The second one is the “keyword list”. This is where all the magic happens! You will include all your keywords here. Name the ad type and include a final URL where you want people to go to once they click on your ad. And the third, Tab is the URL list You can use this tab to save a list of all the landing pages that you have built to use in your paid campaigns So first we’ll give our campaign a name Here, it is important to use a specific naming convention for all your campaigns as this makes it so much easier for you to slice and analyze your campaigns performance in the future You can check out my other video on how to use the right campaign name. Link will be in the description below So now we are on the keyword build template and I am on the campaign source info tab As you can see that the green column B here, and we need to enter the campaign name there so I will just go back onto the Campaign name builder that I have on the Google sheets online Where I will just need to copy the campaign name from so I just copy the campaign name go back into my spreadsheet for keyword build template and then paste the campaign name there. Now once you have added the campaign name You can go into the keyword list tab and you can see that the campaign name is appearing against the campaign column On the keyword list spreadsheet Now that we have added the campaign name We will need to enter the keywords that we want to use in this specific campaign So I have already selected the keywords that I want to use so I’ll copy them keywords Go back into my keyword build template and then paste them there Now you can see that once I added the keywords the ad group column has automatically been updated. This is using a formula Concatenate formula and it has a ‘-‘ or a hyphen at the beginning of it Because we are going to create SKAGs, which are single keyword ad groups. What that means is that for every single one of these keywords, we will have just one ad group in this specific campaign Now, we will need to add an ad type here This is most predominantly an identifier for you to identify which specific campaign this keyword or this ad group belongs to. Because in this specific campaign, I am targeting the terms related to threading treatment. I’m just going to enter an identifier called TT And once I enter that there I will just need to scroll this across for all the keywords And you can see that the TT has now been updated in the ad group So whenever I’ll see this ad group online in my campaigns or in the Google ads editor and with an initial of “TT” I can kind of notice that, this specific ad group belongs to the threading terms or threading treatment campaign So now we have added our campaigns or ad group or keywords Now the match type you can change the match type to phrase match or whichever match type that you want to target in this specific campaign and so in this one, I’m going to just leave it to exact match and then maximum CPC is what CPC bid that you want to pay for? The maximum CPC bid that you want for each single one of these keywords And in this case, I’ve just added £0.30 as the maximum CPC for these keywords Now it comes to the final URL So this is the final URL with these keywords when the ads will be clicked on so, this is the final URL where the users will go to so I will need to go back into my Google sheets, copy the final URL from there, go back and Then simply paste my final URL there Now I’ll copy this and then make sure that this final URL is copied against each keyword So, this is our our keyword build template ready So, now we can take this data and use it in our Google Ads Editor to upload our campaigns data In order to do that, I will just need to copy this data from the campaign column onwards just select all of the data until the custom parameters or the labels column. CTRL+C, Go into your Google Ads Editor and here you need to make sure that you are at the “Accounts level” when you are going to add the changes for this specific campaign so you are at the account level and because we are updating the keywords, in the ‘Manage View’, you will need to go to the keywords tab. Simply select keywords so on the account view You are at the very top the account level and you will select keywords here because we will be uploading the keywords. Now click on ‘Make Multiple Changes button’ here in the middle And then simply paste your data here. Now you will notice that, you will have the campaign name attributed to the ad groups, the keyword and the match type and so on and so forth. Just make sure here, that the custom parameters are also updated correctly for each of these keywords. Once you have added the data here. You can simply click on process and What you can see is the final confirmation window that says that we have one campaign added with 10 ad groups and 10 keywords If you are happy with this, click on finish and review so now once you finish your review, You can see that a new campaign name has appeared but this is the campaign that we have just created. Now, in this specific campaign, you can see this red sign here, so don’t worry about it if you see this. This is because we have not added a budget yet to this specific campaign. To do that, we will need to go into the manage section go to the campaign’s tab here and then in the edit view You can select so in the data view, you need to select the right campaign and in the edit view, you will just need to enter a budget. So for this campaign, I’m going to enter a budget of 10 pounds and then hit tab Now you will see that the red error message circle has now disappeared so the second thing that we will need to do, is to go on to the ad groups level and you can see That there is a dark yellow triangle that’s appearing. It’s like an error message that you need to look into. So once I click on the ad group level in the manager view And then go on to the specific campaign that we just created. Select all of the keywords and you can see on the Edit view here on the right-hand side That there is no maximum CPC bid appearing here So what we will need to do is just need to include a maximum CPC bid I’m just going to include £0.01 and then hit tab. So now once I’ve added that, the error has gone, so these are The other warning triangles have actually been gone Now right now the triangles these triangles are appearing because, you can see at the bottom, that this is due to your ad group contains no active ads. This is because we haven’t added any ads yet that we’ll be adding soon So now once you are happy with all the details You can just click on keep the changes and now the keywords have been updated and the new campaign name has been created. One more thing that you need to check is in the locations tab. Sometimes it does provide an error message in the ‘locations tab’. So if it does, then you need to just simply click on the ‘pencil icon’ here in the locations tab and then click If you click on that, you will see the location appearing here. You can just click on to ‘find locations’ Select the location that you want to target and press ok Now that we have successfully added our new campaign and included our keywords, in the next video We are going to learn how to include your ads to your campaign including the tracking parameters for each of these keywords I hope you have learned something new from this video If you have any questions that you need to ask, comment down below and I’ll get back to you. If you like this video, then please give this video a thumbs up and subscribe to my channel. So let’s catch up in the next video!!!! You

Leave comment

Your email address will not be published. Required fields are marked with *.