Go Back   WarriorForum - Internet Marketing Forums > The Warrior Forum > Adsense / PPC / SEO Discussion Forum
Register Blogs FAQ Social Groups CalendarHelp Desk

Reply
 
LinkBack Thread Tools
Old 12-28-2009, 09:29 PM   #1
Pete Young
War Room Member
 
Join Date: Aug 2009
Location: downunder
Posts: 2,163
Blog Entries: 1
Thanks: 367
Thanked 518 Times in 354 Posts
Default adwords / excel automation

I am about to start some excel work on automating some adwords tasks, it has been suggested before.

If there are any specific tasks you would like automated please list them and where i can i will see if it can be done

Pete

• - just chillin.
tryinhere is online now   Reply With Quote
Old 12-28-2009, 10:26 PM   #2
Active Warrior
War Room Member
 
Caneman's Avatar
 
Join Date: Dec 2009
Posts: 43
Thanks: 13
Thanked 1 Time in 1 Post
Default Re: adwords / excel automation

Anyway to use vba to interface with the google keywords tool?

Caneman is offline   Reply With Quote
Old 12-28-2009, 11:10 PM   #3
Pete Young
War Room Member
 
Join Date: Aug 2009
Location: downunder
Posts: 2,163
Blog Entries: 1
Thanks: 367
Thanked 518 Times in 354 Posts
Default Re: adwords / excel automation

Quote:
Originally Posted by Caneman View Post
Anyway to use vba to interface with the google keywords tool?
yes thats what i am doing, so any thing at all i can program in, currently i am working on automating a lot of daily tasks i am doing plus adding anything else people can think of

I doubt there will not be anything i cant automate (if it is at all possible)

just drop a request, one thing is i have seen many example where people copy n paste new campaigns to the editor in separate confusing parts. this can be automated with one csv export and uploaded in one shot.

that sort of stuff is easy, i am more now getting it to perform every daily duty in vba, so in effect this will happen

download a csv file from my adwords
run a vba script in excel that performs every task i want automated
upload a new csv to the editor and update my adwords

all within 60 seconds

that is the goal, i just need any other ideas people want automated,that i may not have covered.

so far Dependant on if i can make it work will be

auto re adjustment based on q score , active , pause or delete
auto re assigning max cpc based on variables such as conversion rate / return per sale / and or based on clicks
then auto adjusted into this would be auto adjustment of price to affect ad position based on my settings

this would in basics run any campaign at optimised profit levels

it would also adjust or pause delete any under performing keys or ads based on % and a few other bits as i study this more

these things again re wish list until i can code it up, so yes please yell out, a lot will be beta then as it ages it will settle down

• - just chillin.
tryinhere is online now   Reply With Quote
Reply

  WarriorForum - Internet Marketing Forums > The Warrior Forum > Adsense / PPC / SEO Discussion Forum

Tags
adwords, automation, excel

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -6. The time now is 01:36 PM.