Want to build ads from keyword|url pairs - Looking for good tool

Discussion in 'Google AdWords' started by Pryda, Jan 23, 2011.

  1. #1
    I have a ton of keyword|url pairs in a csv file and I want to import these into my Adwords. I have SpeedPPC, but I don't think I can use it to generate the ads I want.

    I have pairs like
    product|http://www.mysite.com/product/productname

    And I want to build ads that look like
    Interested in (product)?
    Cheap (product) available at ...

    Buy (product) online
    Good quality (product) on our site

    All ads should lead to the url indicated in the csv file for that pair.
    Since I have hundreds and hundreds of these pairs, I'm looking for a way to automate things. Any suggestions?
     
    Pryda, Jan 23, 2011 IP
  2. Natively

    Natively Active Member

    Messages:
    163
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #2
    "In AdWords Editor you can Bulk-upload entire sheets prepared on Excel (or Google Desktop or whatever).
    Editor: Data --> Text Ads --> Add/update multiple text ads

    On Excel use the ""&"" parameter (or ""concatenate"" function) to create multiple keyword/ad variations, like:

    =""Interested in ""&(Product's cell)&""?""
    "
     
    Natively, Jan 24, 2011 IP
    Pryda likes this.
  3. Pryda

    Pryda Peon

    Messages:
    506
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    That looks like it might do the trick, I'll give it a shot. Thanks for your help!
     
    Pryda, Jan 24, 2011 IP