Connecting Google Ads

user17479
user17479 Member
in Connectors

I am trying to connect Google Ads via Google BigQuery DataSet but my project name is not showing up in the dropdown for "Project ID" even though it has been created and thus, I am getting an error and not being able to generate the script or connect.

Any help/suggestions will be appreciated.

Comments

  • Jarvis
    Jarvis Domo Employee

    Hey user17479!

    If you are not seeing a Project ID within your drop-down, I would advise checking that API permissions have been granted where necessary for this account. Also, are you seeing other Project IDs populate?

     

    - Jarvis

  • user17479
    user17479 Member

    Thank you for your reply!

    I have the necessary authorization and to answer your question no, I'm not seeing any project's in the dropdown.

  • Unknown
    Unknown

    I am getting the same error mentioned here. Does anyone have further insights?

  • nbrx
    nbrx Member

    Does anyone know a better way to get information from Google Ads into DOMO?

     

    Kind regards.

  • Golfoholic
    Golfoholic Member

    @nbrx I came across your question likely in search of a similar answer you were looking for. I have tried to use the Google ads connector, and trying to pull in the Campaign report, but when I run it it fails and says it cannot pull in the selected metrics from the campaign report. Did you find a better way to pull in google ads? Not being able to utilize the API is extremely discouraging.

  • GrantSmith
    GrantSmith Coach

    Hi @user048760


    Since Domo doesn't support direct connection with Google Ads it's a bit tricky to get the data ingested. I ended up writing a python script to interface with the Google Ads API to pull the data and ingest the data using the Domo API (via the pydomo Python package).

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Golfoholic
    Golfoholic Member

    @GrantSmith That's good info. Thank you. One more question, is there a primary key that gets pulled in through the different performance reports in the google connector that can make it easy to join those reports? I was able to pull in all the reports needed and the data looks good but the next step would be able to combine the different reports, but when using this google data joining can get tricky.

  • HowDoIDomo
    HowDoIDomo Contributor
    https://community-forums.domo.com/main/discussion/comment/52909#Comment_52909

    Are you still using this python script to connect Google Ads to DOMO? Or, were you able to set up one of the connectors?

  • GrantSmith
    GrantSmith Coach

    @HowDoIDomo - Domo's Google Ads connector works for me now and I've had success utilizing it.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories