CPC Search Engine Tracking

[travelmadness]

I'm setting up tracking codes on URLs that I will need to dump into excel for reporting purposes.

the tracking portion of the urls would look something like:

searchengine=google&campaign=dog&keyword=cat

any suggestions on separating something like this into columns?

[cgrantski]

Yep, easy (once you've done it, you'll use it constantly) --- Highlight the column you want to split up, then Data > Text to Columns > Delimiter is "&" --- Just be sure you have enough empty columns to the right because the separated data will overwrite anything that's there.