google_ads_api_list_customer_accounts_with_streaming_search.py

1import sys
2from google.ads.googleads.client import GoogleAdsClient
3from google.ads.googleads.errors import GoogleAdsException
4
5def main(client, customer_id):
6    googleads_service = client.get_service("GoogleAdsService")
7
8    query = """
9        SELECT
10          customer_client.client_customer,
11          customer_client.level,
12          customer_client.status,
13          customer_client.descriptive_name
14        FROM customer_client
15        WHERE customer_client.level <= 1"""
16
17    # Issues a search request using streaming.
18    search_request = client.get_type("SearchGoogleAdsStreamRequest")
19    search_request.customer_id = customer_id
20    search_request.query = query
21    stream = googleads_service.search_stream(request=search_request)
22
23    try:
24        for batch in stream:
25            for row in batch.results:
26                print(
27                    f"Customer with ID {row.customer_client.client_customer} "
28                    f"and name '{row.customer_client.descriptive_name}' was found."
29                )
30    except GoogleAdsException as ex:
31        print(
32            f'Request with ID "{ex.request_id}" failed with status '
33            f'"{ex.error.code().name}" and includes the following errors:'
34        )
35        for error in ex.failure.errors:
36            print(f'\tError with message "{error.message}".')
37            if error.location:
38                for field_path_element in error.location.field_path_elements:
39                    print(f"\t\tOn field: {field_path_element.field_name}")
40        sys.exit(1)
41
42if __name__ == "__main__":
43    # GoogleAdsClient will read the google-ads.yaml configuration file in the
44    # current directory if no path is specified.
45    googleads_client = GoogleAdsClient.load_from_storage(version="v18")
46
47    # The Google Ads customer ID to be used for the request.
48    # This can be passed as a command line argument or hardcoded.
49    CUSTOMER_ID = "INSERT_CUSTOMER_ID_HERE"
50
51    main(googleads_client, CUSTOMER_ID)