Converting Adwords bulk sheet into Overture upload sheet

and vice versa

[airpal]

Anybody know of a tool/service that automatically takes fields (keywords, bid prices, urls) from an Adwords bulk spreadsheet and moves them into the appropriate fields in an Overture bulk upload sheet? And maybe from an Overture bulk sheet to a Google bulk sheet as well? I'm willing to pay a decent sum for such a tool.

[werty]

There is nothing available that I know of. I also think the translation process would be difficult due to the variance in ad copy size mainly in the description, and also the different type of categories - categories on O and campaign and ad group on G.

The good old fashioned cut and paste may be the way to go.

<edited spelling>

[airpal]

The part that I see which might require a manual adjustment is the ad title, and that's only if you want to make it longer for Overture. The adgroup name would just become the category name in Overture. The ad description would just combine description lines 1 and 2 from an adgroup, and become one line for Overture. Cut and paste is becoming very time-consuming with the number of adgroups we have and plan to eventually add, that's why I'm looking for this type of script/software.

[werty]

You could combine line one of the ad and line two by using the concatenate feature in excel.

Or do =A1&" "&B1 in the C1 where A1=line one and B1 = line two.

[airpal]

Exactly, now I just need someone to code that into a program that will take my adwords bulk sheet as input, and spit out an Overture formatted bulk sheet with the same data. =)

[werty]

You could just write the formulas into one page of a spreadsheet, and pull the data from another page (adwords info)

Then you would just have to paste the data in, pull the formulas down and cut this info and paste it into a new sheet and save and send to O

[nigelt74]

Hi all
Was looking for help with an overture problem and came across this post, which may help out with an Adwords problem

"Adwords bulk sheet" what is it? where is it?, I regularly use the overture bulk upload thingie, but haven't seen a similar thing on google

anyhelp would be much appreciated

Thanks
Nigel

[running scared]

Nigel,

The bulk upload for AdWords is not available to all. If you have a rep, then the best bet is to ask them about it.

[farside847]

Hmmm, I emailed support at Yahoo/Overture and asked them if I could provide them a bulk feed/spreadsheet and I was told no. Do you have any more info on it?

Thanks!

[running scared]

I believe you need to spend the equivalent of $6000 a year for US Overture. In the UK they actually have a bulk upload facility available to all. It would be nice to see this extended to all countries.