7 replies
Anyone know where can I find a script that uses Google Adword API for keyword information from GKT.

I have list of keyword in a text file. Using Google Adword API I want to get Exact Global Searches, Ave CPC, CPC Competion and save this data as CSV file so column would be

Column 1
Keyword
Column 2
Exact Match Global Searches
Column 3
Ave CPC
Column 4
CPC Competion

So Initial Input would be Google API details and location of keyword list file, and location of where to save the file.

Please let me know if anyone is help or interested in this project.

Thanks
#adword #api #google
  • Profile picture of the author tryinhere
    you would not need the g api to do that, a simple excel macro would pull the data from the text file sort what you want and save to file in a csv format.
    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[3883331].message }}
    • Profile picture of the author kStarDacTeam
      Originally Posted by tryinhere View Post

      you would not need the g api to do that, a simple excel macro would pull the data from the text file sort what you want and save to file in a csv format.
      well, so how he get the values (local montly searches, average cpc, ...) then ?

      EDIT:
      @blackjack, I could help if you need.
      {{ DiscussionBoard.errors[3883578].message }}
      • Profile picture of the author tryinhere
        Originally Posted by kStarDacTeam View Post

        well, so how he get the values (local montly searches, average cpc, ...) then ?

        EDIT:
        @blackjack, I could help if you need.
        ? ar i see i read the text file with keys, i read that as being a text export with the data included from the gkwt.

        after re reading it i see thats not what was written so my apologies, given that if you took the keys and added them to the kwt then yes excel would run it all.

        leave it with you to sort buddy.
        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[3883620].message }}
      • Profile picture of the author blackjack
        Originally Posted by kStarDacTeam View Post

        well, so how he get the values (local montly searches, average cpc, ...) then ?

        EDIT:
        @blackjack, I could help if you need.
        Hi

        I would appreciate any help. Can you please let me know if there is script or software that does this.
        {{ DiscussionBoard.errors[3883623].message }}
    • Profile picture of the author blackjack
      Originally Posted by tryinhere View Post

      you would not need the g api to do that, a simple excel macro would pull the data from the text file sort what you want and save to file in a csv format.
      Not sure what you mean here, I need to get monthly search volume, ave cpc which is Adword Keyword Tool Data.
      {{ DiscussionBoard.errors[3883619].message }}
      • Profile picture of the author tryinhere
        Originally Posted by blackjack View Post

        Not sure what you mean here, I need to get monthly search volume, ave cpc which is Adword Keyword Tool Data.
        yes the gkwt will export all of that in a text file for you. ( just check the export function ) and im sure it would also export in csv as well.

        let me check
        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[3883628].message }}
        • Profile picture of the author tryinhere
          Originally Posted by tryinhere View Post

          let me check
          yes just go to the gkwt add the keys you want and you can select the columns you want, run the query then export in csv format.
          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[3883643].message }}

Trending Topics