Connecting Google Ads

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 🟠

    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

  • 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.

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

  • nbrx
    nbrx βšͺ️

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

    Β 

    Kind regards.

  • user048760
    user048760 βšͺ️

    @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 Indiana πŸ”΄

    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).

  • user048760
    user048760 βšͺ️

    @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.

  • amehdad
    amehdad 🟒

    Hi @user048760, how did you go with this? What was the issue/error more specifically that you encountered around joining?

    I've used an email forwarding setup with the Google Ads data pull in the past, and the reports I used needed to be built so that the primary key was clear and identifiable before I start any work in Domo. That way, joining and cleaning data steps were easier to carry out.