![]() ![]() When you have the set of columns that you consider will work best for you then you can download a report of this view to be able to work it on Excel. I for example always use the following set of columns: In order to efficiently use this you need to make sure you have the right set of columns in your AdWords interface in the Keywords tab. Analyzing the Information in Your Keywords Feel free to check the other options to see if perhaps there are elements that you may consider more relevant to your goals with AdWords. You can actually do this same analysis with pretty much all the options available in the segments, but those 2 I mention are the main ones I use. To do this you first drag the Device element and then the Ad group, add the metrics that you deem important for your campaign as values, change any value settings depending on how you want to see them and you will be able to have a well distributed amount of information that will show you how your ad groups are performing depending on the device that is being used to search for your keywords. Same deal as the one mentioned above, segment your ad groups, download the report, delete your totals, and insert a pivot table based on this information. The values will be added as a sum of them and in numerical format as a default, you can change this by clicking on the arrow showing on the value name and then clicking on “Value Field Settings”, here you can change your CTR (or any other metric that normally represents a percentage) to reflect averages and to show as percentages.īy doing all of this you will be analyze your ad groups very granularly by how their performance is based on the time of the day. You first drag the Hour of day element to the Row Labels and then the Ad group element, afterwards you can add any metric that you deem important to the Values (for example you can add Clicks, CTR, Conversions, etc.). This will create the pivot table on a separate sheet by default, you know need to select the proper elements in it. Now what you need to do is select all the data starting from the headers and create a pivot table with it. But the way I use it is combined with the segments option.īy combining the segment’s feature and Excel you can easily see a lot of data at once the main segments I check are: Time » Hour of Day:Īfter you have segmented the Ad Groups, download your report, and then delete the totals as I recommended earlier. This will be like the basic takeaway that you can get out of Excel to be able to see the metrics for your ad groups better. You can do this by clicking on the arrow corresponding to the particular element that you want to interact with (for example that you don’t want to see data for a particular ad group, you can click on the arrow that is on Ad group and then from the list that drops down simply take out the check mark of any ad group that don’t want to see).Īlso if you click on the arrow of any of the metrics you can sort the data from largest to smallest or from smallest to largest depending on what you want to see specifically. What this filter will do to help you is that it will allow you to sort, take away certain items or select only some specific ones. There are many ways to put a filter, but the way I do it is that I select the row where my headers are and then type CTRL+Shift+L.Īfter doing this the headers should look like this: The first step I will advise you to take in this file is to delete any rows that have totals as they may skew your data when you are sorting it or filtering it, second will be to give all the headers a filter. You will need to access your AdWords account and then in your campaign select the Ad Groups tab, now you will need to download a report of this view and then open it using Excel.Īfter you do this you will only need to open the file that was downloaded with Excel. I will divide my tips into checking three aspects of one campaign:Īnalyzing the Information in your Ad Groups Similar to Editor, you can do most of the stuff you can do in Excel by using the AdWords interface, but still I have found a couple of ways to make your job easier and faster with Excel whenever you are optimizing. I will give some quick and easy pointers on how can you manage more data and analyze your campaigns better by simply using Excel. This time however I will concentrate on easy implementations for you to analyze information prior to your optimizations. This time around I will be giving you more tips on how to use Excel for AdWords. Recently, I posted an article about how to do some simple use of Excel to help you create and post your campaign faster on AdWords. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |