Welcome to WebmasterWorld Guest from 54.224.17.208

Forum Moderators: werty

Message Too Old, No Replies

Converting Adwords bulk sheet into Overture upload sheet

and vice versa

     
8:11 pm on Mar 22, 2005 (gmt 0)

10+ Year Member



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.
9:40 pm on Mar 22, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



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>

10:32 pm on Mar 22, 2005 (gmt 0)

10+ Year Member



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.
5:39 am on Mar 23, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



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.

6:44 pm on Mar 23, 2005 (gmt 0)

10+ Year Member



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. =)
11:16 pm on Mar 24, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



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

4:14 am on Apr 7, 2005 (gmt 0)

10+ Year Member



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

7:28 am on Apr 11, 2005 (gmt 0)

10+ Year Member



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.

10:07 pm on Apr 11, 2005 (gmt 0)

10+ Year Member



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!

10:21 am on Apr 12, 2005 (gmt 0)

10+ Year Member



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.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month