Hello everyone I m trying to set up a Google Ads extractor o Meltano #troubleshooting

Hello everyone, I'm trying to set up a Google Ads ...

valentin_vidal

08/30/2023, 3:22 PM

Hello everyone, I'm trying to set up a Google Ads extractor on Matatika variant. Once everything is configured, Oauth Client ID, Secret, Refresh Token, Developer Token, Start Date and End Date, I run a "Invoke" command, logs tells me:

Copy code

"OAuth authorization attempt was successful."

and then I get this error:

Copy code

singer_sdk.exceptions.FatalAPIError: 403 Client Error: Forbidden for path: /v12/customers:listAccessibleCustomers

I've seen someone struggling with the customer-id earlier on slack but It seems I can't fix it by myself. I think I configured the OAuth Client correctly on GCP so, I don't really understand where I could be wrong on this one. Any Idea ? Many thanks !

Andy Carter

08/30/2023, 3:24 PM

which variant are you using? Can you share your meltano.yml with secrets redacted?

Andy Carter

08/30/2023, 3:24 PM

You need an Ads account ID too

Andy Carter

08/30/2023, 3:26 PM

The mistake I made was to use my manager account id as the account id, whereas it needs to be the child account that has the ads running

valentin_vidal

08/30/2023, 3:26 PM

Hello @Andy Carter Thanks for your answer. I'm using Matatika variant. I can share my meltano.yml yes !

valentin_vidal

08/30/2023, 3:26 PM

Well, I also tried the account ID, does not work : (

valentin_vidal

08/30/2023, 3:29 PM

here @Andy Carter

Copy code

- name: tap-googleads
    variant: matatika
    pip_url: git+<https://github.com/Matatika/tap-googleads.git>
    config:
      customer_id: '3988079423'
      start_date: '2023-08-20T00:00:00Z'
      end_date: '2023-08-30T00:00:00Z'

Andy Carter

08/30/2023, 3:31 PM

I found specifying this in my .yml helped:

Copy code

config:
      oauth_credentials.client_id: ${TAP_GOOGLEADS_CLIENT_ID}
      oauth_credentials.client_secret: ${TAP_GOOGLEADS_CLIENT_SECRET}
      oauth_credentials.refresh_token: ${TAP_GOOGLEADS_REFRESH_TOKEN}
      customer_id: ${TAP_GOOGLEADS_CUSTOMER_ID}
      developer_token: ${TAP_GOOGLEADS_DEVELOPER_TOKEN}
      start_date: '2023-08-01T00:00:00Z'

Andy Carter

08/30/2023, 3:31 PM

Also, check your developer token is enabled for basic access, and not just test access?

valentin_vidal

08/30/2023, 3:32 PM

everything you mentioned is filled in .env on my part

Andy Carter

08/30/2023, 3:33 PM

Yes, but I found I needed to state the oauth keys and env references explicitly in .yml too

Reuben (Matatika)

08/30/2023, 3:34 PM

Yes, because Meltano will otherwise try and resolve a value from

TAP_GOOGLEADS_OAUTH_CREDENTIALS_CLIENT_ID

I'm pretty sure. So you probably need the explicit mapping in this case.

valentin_vidal

08/30/2023, 3:34 PM

Alright, I will try, thank you.

Andy Carter

08/30/2023, 3:37 PM

@Reuben (Matatika) I didn't try the full

TAP_GOOGLEADS_OAUTH_CREDENTIALS_CLIENT_ID

but you're right that would have been the normal way to do it. I added a couple issues into the repo mostly just troubleshooting things with postgres for future folks reference. I have the pipeline working now.

valentin_vidal

08/30/2023, 3:38 PM

I modified my .yml, it didnt change anything 😞

Reuben (Matatika)

08/30/2023, 3:40 PM

@Andy Carter Thanks! Will pass on to the team and hopefully get around to addressing at some point. 🙂

Reuben (Matatika)

08/30/2023, 3:43 PM

@valentin_vidal FWIW we do test this tap every day, and I can see it passed this morning with no issues. Maybe a typo somewhere or something not quite right in GCP? Hard to say unfortunately...

Andy Carter

08/30/2023, 3:46 PM

A couple steps that helped me: • running a

meltano compile

and checking the output matches expected in the config • checking the APIs page in Google cloud and seeing if any API calls are being received to the Ads API

valentin_vidal

08/31/2023, 8:39 AM

Alright, thank you very much for your help ! I'll take a look at the issue with my team today

ryan_bell

11/20/2023, 9:56 PM

Any updates on this issue? I’m running into the same thing currently

ryan_bell

11/20/2023, 10:03 PM

Actually, I think I’ve narrowed it down. The documentation says that a Basic Access Developer Token allows “requests against both test accounts and production accounts. Production accounts are any accounts that serve real, live Google ads—test accounts don’t serve ads.” So maybe it’s because the customer ID I’m using belongs to a production account, but my dev token is only test access. Any tips for applying for Basic Access? In my experience it’s usually really tedious to send in whatever information they want on my “app” just so I can pull ads performance data into our warehosue

Andy Carter

11/20/2023, 10:41 PM

I just downloaded the example docs and made some modifications. Make sure you include a diagram. Doesn't look like there's a way around it. It's a shame there is only a single ads permission that allows full access, a analytics/reporting permission would make much more sense. if you don't get a reply in a reasonable timescale then you can request a followup here: https://groups.google.com/g/adwords-api

ryan_bell

01/04/2024, 1:23 PM

Thanks for this! I’m still waiting on a reply so I’ll try resubmitting with a diagram

ryan_bell

01/04/2024, 2:57 PM

I am curious, what kind of diagram did you include? Just a simple flow of the data?

Andy Carter

01/04/2024, 3:33 PM

In the end I googled for a screenshot of a google data studio dashboard using the ads data, and I supplied that.

😂 1

Open in Slack

Previous Next