How to add "?=keyword_here" to every keyword?

Using the concatenate function in Excel

[progex]

Can someone sum up a brief tutorial for Excel neophytes like me on how to add a "?=keyword_here" phrase to each keyword in a list of 1000?

[werty]

I had the same question about a year ago, the answers are here:
[webmasterworld.com...]

[progex]

Thanks, got it. :)

=CONCATENATE("http://www.sitename.com/?=",A1)

[rfung]

I'm a bit clueless, but to the original poster- do you control the landing site, or are you doing PPC to merchant? I ask this because I can only see the usefulness of appending the keyword if you can track it once it's on the landing page?

[jogrady]

Rfung,

The value is knowing how searches find your site. Looking at the log file I can see what queries convert and what queries don't convert. Then I can see how closely my keywords matched the quiries. For this to be usefull you need to have access to your web server's log files and some experience with Excel. You can find more info on my post called:

"Notes On Destination URL Keyword Insertion"