PPC Ad Generator - Creating Ads Quickly Using Excel

Hello Sam,

I will help where I can for you.

First you can use a subdomain , sub directory option in your display url among other combinations.

so first with your question you can indeed use dog training in your sub domain and that could look like this (so long as combo's are at the 35 char limit or less)

DogTraining.PetCare.com

you can use a sub directory style display url which would look like this

PetCare.com/DogTraining

which in many ways can flow a little better / your call

you may also use a www in front if room (35 chars or under)

wxx.PetCare.com/DogTraining
or
wxx.DogTraining.PetCare.com

If you want to paste a range of keys into an excel sheet and have it produce a line of text so you can copy that would be easy to do.

in col A place word 1
in col B place word 2
in col C place this formula =A5&B5 adjust row number to match correct row (this is row 5)

you can drag that formula down the page then if you wish

in col D place this formula =C5&".PetCare.com" or if your doing a sub directory use this formula ="PetCare.com/"&C5

once again place in row 5 and drag to suit

if you wanted to in col E you could place a counter to test the length of the text by adding this =LEN(D5)

from there you can add filters or formatting to sort any oversize (+35 chars) display urls

That should sort most if not any thing that you would need based on your post, if you do this all of the time and need high teck stuff there are probably many people o desk ? that should be able to slap out something or drop a pm and if i get 3 sare seconds i might be able to do some thing for you.

edit

I also forgot to add about your dynamic keys, yes you can do this, if the display url fits per normal you can also add it as a dynamic as it remains the same length

for example

and

remove the gap before the word Dog

you could get excel to also create the dynamic version for you based on extending out and adding to the example i gave

="PetCare.com/"&"{KeyWord:"&C5&"}"

as an example