Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: AdWords Integration best way?

  1. #1
    Join Date
    Mar 2011
    Posts
    4

    Smile AdWords Integration best way?

    Folks,
    Could you suggest the best way of pulling campaing stats from google's adwords. i see some people tried using wsdl transformation but i am not sure if this is still possible since you have to get google auth token first plus setting required soap headers does not make it easy.

    So I thought about writting command line tool that dumps data into csv or some local table and have kettle/spoon poll it.

    Is there a better way? Plugin? Could you share your experiences?

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Look at the annotated SOAP sample in the samples/transformations folder.
    That one explains how to create the SOAP request. You can use the Google docs to do it according to their specs.

  3. #3
    Join Date
    Mar 2011
    Posts
    4

    Default

    Matt,
    Thank you for your reply. I have looked into that. I think it would work as long as I add a http client call to get the auth token. However, this is not Google's recommended way because their api/wsdl frequently change. Instead they strongly recommend using their client libraries. So I was thinking wrapping their client api call in a shell script and executing it as part of my job (using Shell Scripting step). Would you do it this way?

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    I didn't know that there was a Java client API but obviously that makes things a lot easier indeed.

  5. #5
    Join Date
    May 2009
    Posts
    2

    Default

    Hi,

    I managed to create a transformation which gets Google Adwords account graph and stats by using the lastest Adwords API.
    Can you tell me where I can post this transformation to make it available for people who can need it?

    thanks.
    tym

  6. #6
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    I would attach it to a JIRA case for inclusion in the set of samples.

    http://jira.pentaho.com/browse/PDI

    Thanks a lot in advance!

    Matt

  7. #7
    Join Date
    May 2009
    Posts
    2

    Default

    Hi Matt,

    Thanks for your reply.

    I'm not comfortable with JIRA usage. Could you please guide me to post this transformation in JIRA?

    Thanks.
    Tym

  8. #8
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It's easy. You just create a new free account. Then you log in and use the create new issue option.
    If you don't want to bother, just send the file to mcasters at pentaho dot com and I'll do it for you.

  9. #9
    Join Date
    Feb 2014
    Posts
    14

    Default

    Hi tym003,
    i tried your example to get account from adwords.
    The adwords_account.csv file is created and there is no error message.
    But i i have some missing input in the first step: the userAgent and developperToken.

    I cannot find them in my adwords account.

    Thank you

  10. #10

    Default Dimensions tab by HourOfDay for an adgroup

    Quote Originally Posted by 20140217 View Post
    Hi tym003,
    i tried your example to get account from adwords.
    The adwords_account.csv file is created and there is no error message.
    But i i have some missing input in the first step: the userAgent and developperToken.

    I cannot find them in my adwords account.

    Thank you
    I need to get the data from the dimensions tab by HourOfDay for an adgroup, how can i achieve this?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.