adwords / excel automation

2 replies
  • SEO
  • |
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
#adwords #automation #excel
  • Profile picture of the author Caneman
    Anyway to use vba to interface with the google keywords tool?
    Signature

    {{ DiscussionBoard.errors[1549978].message }}
    • Profile picture of the author tryinhere
      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
      Signature
      | > Choosing to go off the grid for a while to focus on family, work and life in general. Have a great 2020 < |
      {{ DiscussionBoard.errors[1550076].message }}

Trending Topics