Forum Moderators: open
Can someone provide me with details of how to format the data in this blank excel file. What is this file supposed to look like? Do they want my adwords bulk upload file? Do I format it any way I like and have them figure it out?
I do not approve of Overture's stance on this issue. It would be a lot easier to reach their $6000 minimum if they would actually allow a bulk upload. Do they really think I can possibly spend less than that in a year with 4,000 keywords?
Column headings are:
Account ID
Search Term
URL
Title
Description
Advanced Match Status
Standard Bid ($)
Content Match Status
Content Match Bid ($)
Excluded Words
Category
Not sure if that is still the format, but someone else might be able to confirm that.
Regardless of your account status, all your terms need to be sent through their editorial approval process which checks for unique links and "acceptable" content in your description. They also check the number of impressions delivered for that term to see if it's viable.
Here's a quick guide based on my last submission.
AccountID - Obviously your account number. Must be copied to each row in which you have a term.
Search Term - You terms, one per row.
URL - target URL including tracking strings.
Title - the header displayed for your ad.
Description - text under ad.
Advanced Match Status - Might want to set this to "off" initially. You can find out more before you turn it on.
Standard bid - Your max bid
Content Match - See Advanced Match.
Content Match Bid - See Standard Bid.
Excluded Words - If you sell widgets but not yellow widgets, exclude yellow.
Category - You must create a category in your account first and then place that category name in the appropriate row for each term. I usually create a separate template for each category.
General advice - I usually send in batches of under 5,000 keywords. If you have an error in your spreadsheet, you will know immediately. Submissions take 3-5 days to be approved.
Good luck. Let me know if you need more assistance. Due to time constraints, I'm not on this board as oftern as I would like, so feel free to email me.