Hi,

I am trying to run a sample code in Python to use google query language but 
I'm getting the error as above. However, I've already managed to do a 
script that returns all of my campaigns.

*The current script that I'm trying to run is this:*

import google.auth
from google.auth.transport.requests import Request
from google.oauth2 import service_account
from google.ads.googleads.client import GoogleAdsClient

# Configuração
DEVELOPER_TOKEN = "xxxxxxx-xxxxxxxxxxxxx"
PATH_TO_CREDENTIALS = "caminhoParaCredenciais.json"
CUSTOMER_ID = "xxxxxxxxxx" (*I've already tried with a -*)

def get_google_ads_data(credentials_path, developer_token, customer_id):
    try:
        # Autenticação
        credentials = 
service_account.Credentials.from_service_account_file(credentials_path)
        credentiaels = 
credentials.with_scopes(['https://www.googleapis.com/auth/adwords'])

        # Criar cliente do Google Ads
        google_ads_client = GoogleAdsClient(credentials=credentials, 
developer_token=developer_token)

        # Construir a consulta
        query = f"""
            SELECT
                campaign.id
                # ad_group.id,
                # ad.id,
                # ad.type,
                # ad.headline,
                # ad.description,
                # metrics.impressions,
                # metrics.clicks,
                # metrics.average_cpc
            FROM
                ad
            WHERE
                segments.date DURING LAST_7_DAYS
                AND metrics.impressions > 0
        """

        ga_service = google_ads_client.get_service("GoogleAdsService")
        
        # Executar a consulta
        response = ga_service.search_stream(customer_id=customer_id, 
query=query)

        # Exibir resultados
        for batch in response:
            for row in batch.results:
                print(f"Ad ID: {row.ad.id.value}, Headline: 
{row.ad.headline.value}, Impressions: {row.metrics.impressions.value}")

    except Exception as e:
        print(f"An error occurred: {e}")
        return None

if __name__ == "__main__":
    get_google_ads_data(PATH_TO_CREDENTIALS, DEVELOPER_TOKEN, CUSTOMER_ID)

*But I'm getting this return:*
Request made: ClientCustomerId: xxxxxxxxx, Host: googleads.googleapis.com, 
Method: /google.ads.googleads.v13.services.GoogleAdsService/SearchStream, 
RequestId: rAdWhFeZYtpdmODskp5SVQ, IsFault: True, FaultMessage: User in the 
cookie is not a valid Ads user.
An error occurred: (<_SingleThreadedRendezvous of RPC that terminated with:
status = StatusCode.UNAUTHENTICATED
details = "Request is missing required authentication credential. Expected 
OAuth 2 access token, login cookie or other valid authentication 
credential. See 
https://developers.google.com/identity/sign-in/web/devconsole-project.";
debug_error_string = "UNKNOWN:Error received from peer 
ipv4:142.250.219.10:443 {grpc_message:"Request is missing required 
authentication credential. Expected OAuth 2 access token, login cookie or 
other valid authentication credential. See 
https://developers.google.com/identity/sign-in/web/devconsole-project.";, 
grpc_status:16, created_time:"2023-05-03T17:28:14.912279934+00:00"}"
>, <_SingleThreadedRendezvous of RPC that terminated with:
status = StatusCode.UNAUTHENTICATED
details = "Request is missing required authentication credential. Expected 
OAuth 2 access token, login cookie or other valid authentication 
credential. See 
https://developers.google.com/identity/sign-in/web/devconsole-project.";
debug_error_string = "UNKNOWN:Error received from peer 
ipv4:142.250.219.10:443 {grpc_message:"Request is missing required 
authentication credential. Expected OAuth 2 access token, login cookie or 
other valid authentication credential. See 
https://developers.google.com/identity/sign-in/web/devconsole-project.";, 
grpc_status:16, created_time:"2023-05-03T17:28:14.912279934+00:00"}"
>, errors {
  error_code {
    authentication_error: NOT_ADS_USER
  }
  message: "User in the cookie is not a valid Ads user."
}
request_id: "rAdWhFeZYtpdmODskp5SVQ"
, 'rAdWhFeZYtpdmODskp5SVQ')

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/ef68d48c-b24c-4925-8000-83b128584264n%40googlegroups.com.
  • &q... Enzo Pucci
    • ... 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum

Reply via email to