1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Dynamic Key Word [insetion] yea......

Discussion in 'Adwords' started by 77se7en, Sep 4, 2010.

  1. 77se7en

    77se7en Registered Member

    Joined:
    Jan 23, 2009
    Messages:
    66
    Likes Received:
    4
    So I got a list of 2000 top populated cities in USA.
    What I want to do is use them as keywords, and ad
    a word in front of the city name or after.

    For example

    I got
    New york
    Atlanta
    Chicago
    Denver
    Francisco
    List goes on


    I need to convert them to: Example
    Cars in New york
    Cars in Atlanta
    Cars in Chicago
    Cars in Denver
    Cars in Francisco
    List goes on

    or the keyword after the city name.

    I looked all over the place for a tool that would do
    that automatically,
    but no luck.

    If you know how this can be done please enlighten me.

    Thanx alot
     
  2. ukescuba

    ukescuba Jr. VIP Jr. VIP Premium Member

    Joined:
    Feb 24, 2008
    Messages:
    994
    Likes Received:
    634
    Occupation:
    Mobile Marketer & QR Code Junkie
    Location:
    San Antonio, TX
    Home Page:
    you could use excel...

    paste your city names in one column and then in the next column

    type
    Code:
     ="Cars in "&A1
    this would display

    Cars in New York

    providing the first cell was of course New York

    copy and paste the new cell by dragging and it will auto-populate for your full 2000 cities... hope that makes sense

    once you completed this you would select the column and paste it into notepad or whatever you wanted to use the list for....

    i have a tool that does this for you using php but its not quite ready to launch just yet

    i think this would work in google apps too and microsoft works...

    hth

    pm if you still need a hand
     
    Last edited: Sep 4, 2010