Tips on Uploading Google Campaigns into Yahoo
July 29, 2008
A while back I wrote on how to take an export of your Google Adwords campaigns and use the Yahoo Third Party Converter Tool to bulk upload into Yahoo. While the process itself is fairly simple, a lot of people are still running into problems. In order to be successful at bulk uploading your Google Adwords campaigns into Yahoo, first you must have the import feature in Yahoo before you can use the Convert third party campaigns tool. In order to get the import feature simply call your Yahoo rep and ask for it. Below I have described some tips along with common errors I have run into in the past and how I got around them:
1. Delete negative keywords
a. Because you can add negative keywords within Google in the keywords tab of your ad group, you can’t do this in yahoo. Therefore you must remove all negative keywords from your spreadsheet before uploading them into Yahoo.
2. You cannot edit actual keywords in bulk form then upload into yahoo
a. Yahoo only allows you to delete and add keywords in your spreadsheet. You cannot modify an existing keyword then upload the file.
3. Fill in columns if adding ad text or additional keywords
a. Before submitting your spreadsheet, be sure to copy down all campaign and ad group id columns so Yahoo knows which ad or keyword should be under which campaign and ad group.
4. Be sure start date is listed
a. If you are uploading a brand new spreadsheet into a new yahoo account, be sure to fill in the yahoo start date column before uploading your spreadsheet.
Types of Errors and how to fix them:
If you get this error:
Error: “Can’t determine parent ad group or parent campaign.”
Fix: This means you haven’t copied all column data with your new additions. (See #3 from above)
Error: “Cannot add keyword because it already exists within the campaign.”
Fix: While Google allows you to add singular and plural versions of your keywords separately, Yahoo takes both plural and singular as one. It’s okay, you don’t have to do anything at this point. Yahoo will kick out the duplicate keywords for you.
If there are any other errors you are running into while bulk uploading your Google campaigns into Yahoo, please feel free to let me know and I will research how to get around it!
Road Trip - 5 Tips For Creating International Campaigns
International markets can add complexity to any account, but here are a few settings and opportunities to make your global ad strategy stand out in non-US markets.
Discover 3 Levels Of Geo Targeting For Beginners, Intermediates, & Experts
Setting geographic targets is day one. Whether it’s to exclude places you cannot sell or serve or to specifically target your primary customer base, the implementation of geo-targets is on the must-do list.
[New Webinar!] What You Need To Know About New AdWords Features
In this new live webinar, Hanapin Associate Director of Services Jeff Baum and Optmyzr’s CEO Frederick Vallaeys will walk you through the new AdWords tools and show how you can use them to optimize your accounts.
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
The Social Strategies You Need To Know For App Promotion
Create social strategies to promote app awareness and leverage geographic and demographic data reported by these platforms to refine audiences.
Guide the Industry and Take the 2016 State of PPC Survey!
Each year, Hanapin Marketing manages extensive research into the State of PPC Report, which provides a statistical breakdown of the digital ad industry and guides expectations.
What's In A Name? Building Powerful Product Titles For Ecommerce
Over the years, we've tested a variety of different product title alterations in hopes of finding the perfect title. Did we? Yes, and no. The fact of the matter is, it depends.
What Upgraded Bing URLs Mean For You
Bing is continuing its effort to catch up with Adwords. Upgraded URLs, which isolate tracking parameters from final URLs, are now available to Bing advertisers.
Where Does Your Hero Conf Dollar (or Pound) Go?
5 Common Excel Issues And How To Fix
Excel, while a fabulous tool for PPC, is not without its occasional hang-ups. In this post, we’ll go through some common problems, and how to fix them.
[New Whitepaper!] Guide to Google AdWords: Advanced Edition
In this whitepaper, you will gain a greater understanding of the distinction between e-commerce and lead generation PPC strategies, learn the effective use of Remarketing, how to utilize advanced segmentation for improved targeting, cross-device attribution, and how to use automated rules in your accounts.
Google Announces Controversial Updates To The Keyword Planner Tool
Google updated the AdWords Community on the state of the Keyword Planner tool and the response from several advertisers was quite dramatic.
7 Overlooked Facebook Power Editor Features That Will Save You Time
I will be sharing often overlooked time-saving features for Facebook Power Editor so you can spend more energy on the tactics and strategy.
Ecommerce Secrets with Google, Bing, & Hanapin - New Webinar Panel!
This Thursday, August 18th at noon EST, we'll be hosting a webinar called "Supercharge Holiday Sales With These Must-Have PPC Tactics." Presenters include Carrie Albright, Jose Rodriguez, Purna Virji, and Matt Umbro.