Build PPC Ads With Excel

By Brandino

Hi Search Engine Watch Readers,

Today, I’ve posted the excel sheet for quickly generating bulk ads for PPC campaigns. The formulas should be pretty easy to understand.
If you didn’t have a chance to read the column, you can check it out here:
Build PPC Ads Using Excel

Also, please let us know if you can think of ways to make this file even better!

The Formulas and Shortcuts

=Lower():

=Proper():

=Concatenate():

=Len():

=Counta():

Find text/Replace:

Using the “Ad Groups” tab

excel1

Using the “Keywords (Raw)”

excel2

Using the “Ads” tab

excel3

Using the “Sitelinks” tab

excel4

Upload Your Campaign To The AdWords Editor

Keywords

excel5

 

excel6

Download here the excel sheet

Leave a Reply

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