Adwords mass submission?

[airpal]

Hi, I apologize in advance if this subject was discussed before (I did some searching on WebmasterWorld and google but found no relevant information).

Does Google Adwords have a mass submission spreadsheet template or email address that you can send your own spreadsheet to? I have a few hundred keywords with different URL's, titles and descriptions to submit. Thanks in advance for your help and advice in this matter.

[shady]

Sorry, this is another question, not an answer!

In addition to this, is there a method for using a variable in the adword title which will be substituted with the keywords used? I seem to remember this being mentioned at an adwords user group but cannot find the facility.

Thanks in advance!

[shady]

I have the following information from google, which may be of interest to those, like myself, not fully conversant with google adwords functionality!

You can use our keyword insertion tool to automatically populate a search
term from your keyword list into your ad text. This tool automates the ad
text creation process and minimises the manual edits required to create
unique ad text for accounts with large amounts of keywords.

Please use keyword insertion with the requirements detailed below. If your
ad(s) and/or keyword(s) are not in compliance with all requirements, they
will be disapproved.

KEYWORD INSERTION

Place {squiggly brackets} around one of the following, as shown, into your
ad text:

{Keyword:Default Ad Text Here}
{KeyWord:Default Ad Text Here}
{keyword:Default Ad Text Here}

SPECIFICATIONS

- Default Ad Text: You must include default ad text in case your keyword
exceeds ad text character limits. If you do not include default ad text,
and your keyword exceeds character limits, your ad(s) and/or keyword(s)
will be disapproved. The default ad text you choose must be 15 characters
or less for the title and 25 characters or less for the description line.

- Editorial Guidelines: Ad text using this tool is still subject to our
Editorial Guidelines (http://adwords.google.co.uk/select/guidelines.html).
Therefore, if your inserted keywords are not in compliance, your ad(s)
and/or keyword(s) will be disapproved.

- Character Limits: If an inserted keyword makes your ad text exceed the
character limit and you have not included default ad text, your ad(s)
and/or keyword(s) will be disapproved. Please be sure that the final ad
text (including inserted keywords) does not exceed the character limits
for each line (1st line = 25; 2nd line = 35; 3rd line = 35).

EXAMPLE

Keywords: amazon jungle, travel to the amazon jungle (all lowercase)

Ad text created:

{KeyWord: See the Amazon} <- 'Keyword' shown with initial capitalisation
Gorgeous vacations for the
entire family; try us out!
theamazonjungle.com

Ad text seen on keyword: amazon jungle

Amazon Jungle <- Keyword shown with initial capitalisation
Gorgeous vacations for the
entire family; try us out!
amazonjungle.com

Ad text seen on keyword: travel to the amazon jungle (27 characters)

See the Amazon<- Keyword too long, default ad text shown
Gorgeous vacations for the
entire family; try us out!
theamazonjungle.com

[airpal]

Would anyone who's an expert with adwords or perhaps even an adwords representative (hehe) care to comment on the mass submission procedure. :)

[AdWordsAdvisor]

That sounded almost like a hint, airpal ;)

Very briefly, this is a tool that was developed for use in managed accounts. The reason for this careful release, as you can probably imagine, was the potential for problems if the tool was not used by more sophisticated advertisers who could anticipate the results.

If the tool is not used with finesse, it can result in ads that must be disapproved, headlines that don't 'fit', ad text that makes no sense, and so forth.

Bottom line: A great tool, and please use with care and expertise.

[airpal]

First of all, thanks for the responses. However, I have two small followup questions:

1. Although shady's excellent post shed some light on the process, it still remains unclear whether the "keyword insertion tool" is a method that you use to format text when populating the ad forms, or a tool in the google adwords account management screen, or a downloadable script (which I highly doubt)?

2. A very important function for me is to be able to specify different landing pages/URLs (product pages, to be exact) for every keyword, and I didn't see how this is possible with the tool. It's a painfully intensive process to do by hand, and every other PPC I have dealt with (tier 1 and 2) has an email address where you can send a customized feed/spreadsheet/or text file according to the exact specifications provided by the company. I was hoping there's something similar to the custom spreadsheet upload concept with Adwords.

Thanks in advance for clarification on these issues as I hope to be launching quite a large campaign soon. :) (inside joke: i remain a "saaaad panda" regarding the delayed calculation of PR for a site of mine).

[jkwilson78]

Airpal,

The keyword insertion method posted above is used when formatting the text of your ad. It is not a tool you can download or a feature in the adwords interface.

As far as adding unique URL's you can go here for more info.

[adwords.google.com...]

I do wish there was a spreadsheet option like you mentioned but I don't think it exists at least not for normal accounts but maybe for managed accounts.

Maybe AWA can shed some light :-)

[airpal]

Thanks shady and jkwilson for the excellent tips.
However, even with those great tips, I can still only do half of the process I want to complete. (Adwords irregular interface coupled with the CPC/CPM bidding with no keyword search data, leaves a lot to be desired, even compared to tier 2 companies).

Using:
widgets ** 1.00 ** [widgets.com...]
I am specifying a specific keyword/cost/URL, but there's no information about how to add the title of the ad, and the description also.

Using:
{Keyword:Default Ad Text Here}
I can't specify the cost/URL.

... I simply can't believe it's so hard to submit a lot of ads in this basic format which is accepted by all other companies:

keyword: blue widgets
ad text: quality blue widgets here
url: widgets.com/bluewidgets.html
cost: 1.00

keyword: green widgets
ad text: quality green widgets here
url: widgets.com/greenwidgets.html
cost: 1.05

[jkwilson78]

Airpal,

I'm right there with you. Every other major PPC allows for mass upload.

My theory is that the feature is available but you have to be one of the big spenders. This will change one day but it doesn't do us any good in the mean time.

[harvey_moon]

this option is not available to bid spenders either.

but I find if you can use access you can split keywords to their ads and just upload 750 at a time, I agree it would be nice to have title option but i get around this with carefully queries.

it works for me but i am fortunate to have a lot of keywords with same ad text, if you needed to add a title to each keyword i can see how that would be a nightmare.

[airpal]

Thanks jk and harvey! You have cleared up a lot of questions I had. Unfortunately, I'm leaning away from actually starting the fairly large ad campaign I was hoping to launch, because of the inability to specify many targeted descriptions and landing pages (which are for the purpose of providing the visitor with exactly what they searched for). Nowadays, even some main keywords of niches have prices that are laughable when looking at the copy/design of some of the fly-by night bidding sites, so that is pretty much out of the question unless we want to be a loss-leader. Out of 10 different PPC accounts, even the smallest, struggling, tier 3 (if it exists) PPC companies have a very clear, concise, and easy to use mass submission guideline compared to almost no information provided by Adwords. One of the smallest companies that has no specific mass submission guidelines, asks you to send your spreadsheet in any format, and an actual human being will sort and review it for you! Yes, contact with an actual human being via email or over the phone ....

And harvey, I agree with you, even high-end clients probably can't customize their URLs, just look at ebay, netflix, and amazon showing up for absolutely irrelevant un-targeted keywords. I hope their account managers know their keyword listings are set to ultra-mega-broad match! :)

[airpal]

I have confirmed over the phone with an adwords representative, that (unless I spend over $10,000 a month/"premium" advertisers) I will manually have to create a separate ad group for every single unique keyword/landing page I have on a website. Besides the fact that it will take days to create ad groups for thousands of keywords/products... I am now starting to feel sympathetic towards the companies that have extremely broad match campaigns on a billion generic keywords since Google makes it almost impossible for those companies to create highly targeted marketing campaigns for specific niches/keywords.

Any veterans care to comment on this (what I find to be ridiculous) issue, which mind you... not a single other PPC company has problems with when it comes to accepting mass submissions!?

[Webo_Dave]

There are spreadsheets out there that Google uses. I just got one for a Premium partner that we're overseeing an account for. I could have added specifics URLs but at that level of spending, Google has maximizers who help clients get the right ad and the title, along with the correct negatives. Don't know if Google will allow the spreadsheet submission for the other accounts we oversee that aren't spending $10K a month.