homepage Welcome to WebmasterWorld Guest from 54.198.148.191
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Accredited PayPal World Seller

Home / Forums Index / Yahoo / Yahoo Search Marketing Pay Per Click Advertising
Forum Library, Charter, Moderators: werty

Yahoo Search Marketing Pay Per Click Advertising Forum

    
Converting Adwords bulk sheet into Overture upload sheet
and vice versa
airpal




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

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




msg:807336
 9:40 pm on Mar 22, 2005 (gmt 0)

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




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

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




msg:807338
 5:39 am on Mar 23, 2005 (gmt 0)

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




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

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




msg:807340
 11:16 pm on Mar 24, 2005 (gmt 0)

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




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

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




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

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




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

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




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

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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Yahoo / Yahoo Search Marketing Pay Per Click Advertising
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved