Google’s Google Adwords strategy has evolved in recent years to make it easier for marketers to find relevant content.
But some marketers still need to remember their keywords.
Now, Google has updated its AdWords templates to make those searches much easier.
The change also applies to the spreadsheets you use to create them, so you don’t need to go through the hassle of manually copying and pasting your own content.
We’ll walk you through how to create your own Google Adword spreadsheet and see if you can find the content you need.
Step 1: Download and install Google AdWord templates on your computerStep 2: Download the template from the Google download site.
Step 3: Launch Google AdSense, click the link that says “Add to cart” and select the file that you downloadedStep 4: You should see a green “Add this ad to cart now” button.
Click that button to begin.
Step 5: Once you’re done, you can close Google Adsense, add the Google Ad Word template to your cart, and begin your search for relevant contentStep 6: After you’ve searched for relevant keywords in the AdWords database, you’ll see a list of relevant articles in your browser.
Step 7: Click on the first article you see and see how the keyword is displayed on the screenStep 8: If it says “Adwords” or “Google AdWords,” you’re ready to start your searchStep 9: The first page of results in the Google search results will have a “top search result” button on it.
Click on that to see more informationStep 10: At the top of the page is a “search term” box with the keyword you just searched for in it.
Type that into that box to see the article’s full title, author, publisher, and publisher date.
If it’s a keyword that you already know, click on that box, too.
Step 11: If you’re looking for an article about a product or service, click “more” to see a menu of more relevant articlesStep 12: Click “Add” to add the article to your spreadsheet.
You can then click on the “+” sign next to the article title to add more information, such as keywords you already found.
Step 13: You can also right-click on the title of the article and choose “Edit” to change it, or right-tap and choose Edit article.
Step 14: You’ll be taken to a new screen where you can change all the columns you want.
If you want to see your entire spreadsheet, click one of the “More” tabs and choose to “Copy dataframe.”
Step 15: You’re now ready to go!
You’ll need to enter the information you want into the column headers and checkboxes to ensure the data is entered correctly.
For example, if you want your column to contain the keyword “Google,” then you’d enter “GOOGLE” in the “keyword” box, not “Google.”
Step 16: The “Add New Column” option should pop up.
Click it to add a new column, or click the “Next” button if it doesn’t.
Step 17: The new column should appear next to your current column, along with the name of the column you want added.
You may need to click the space bar to get the column name to appear.
Step 18: The data will be inserted into the spreadsheet.
If the column doesn’t appear, double-check that you entered the right column name and that the values are correct.
Step 19: If all else fails, you could try clicking on “Clear” to remove the data.
You’ll also need to clear the space between each column to make sure it stays the same size.
Step 20: To create the column, click Edit to edit the column names, add keywords to the columns, and check the “Show in columns” box.
Step 21: You may have to click “Submit” to update your spreadsheet or to view it in Google Analytics.
Step 22: You might also see a “Done” notification that you’ve added the column.
If so, click OK to close the edit.
Step 23: Once your column has been added, you should see the new column title, the column author, the publisher, the title, and the number of items in it (the number on the left).
Step 24: When you’re finished, you’ve saved the spreadsheet in Google Docs or on your desktop.
Step 25: You’ve added a new entry in the dataframe and have a data point.
Step 26: To see the total number of results from the datapoint, click it.
You can view the data for the current week or month by clicking the “Data point” link.
Step 27: When finished, click Done to close this window and return to the Adwords home page.
Step 28: If there’s an