AdWords -使用Python下载应用程序参与活动报告

pip install google-ads

developer_token: 'INSERT_YOUR_DEVELOPER_TOKEN_HERE'
client_id: 'INSERT_YOUR_OAUTH2_CLIENT_ID_HERE'
client_secret: 'INSERT_YOUR_OAUTH2_CLIENT_SECRET_HERE'
refresh_token: 'INSERT_YOUR_OAUTH2_REFRESH_TOKEN_HERE'
login_customer_id: 'INSERT_YOUR_LOGIN_CUSTOMER_ID_HERE'  # 可选

import sys
from google.ads.google_ads.client import GoogleAdsClient
from google.ads.google_ads.errors import GoogleAdsException

def main(client, customer_id):
    ga_service = client.get_service("GoogleAdsService", version="v11")

    query = """
        SELECT
            campaign.id,
            campaign.name,
            ad_group.id,
            ad_group.name,
            metrics.impressions,
            metrics.clicks,
            metrics.conversions,
            metrics.cost_micros
        FROM
            ad_group
        WHERE
            segments.date DURING LAST_30_DAYS
        """

    try:
        response = ga_service.search(customer_id=customer_id, query=query)

        for row in response:
            print(f"Campaign ID: {row.campaign.id}")
            print(f"Campaign Name: {row.campaign.name}")
            print(f"Ad Group ID: {row.ad_group.id}")
            print(f"Ad Group Name: {row.ad_group.name}")
            print(f"Impressions: {row.metrics.impressions}")
            print(f"Clicks: {row.metrics.clicks}")
            print(f"Conversions: {row.metrics.conversions}")
            print(f"Cost (micros): {row.metrics.cost_micros}")
            print("\n")

    except GoogleAdsException as ex:
        print(f"Request with ID '{ex.request_id}' failed with status '{ex.error.code().name}' and includes the following errors:")
        for error in ex.failure.errors:
            print(f"\tError with message '{error.message}'.")
            if error.location:
                for field_path_element in error.location.field_path_elements:
                    print(f"\t\tOn field: {field_path_element.field_name}")
        sys.exit(1)

if __name__ == "__main__":
    # 使用 google-ads.yaml 配置文件初始化 Google Ads 客户端
    google_ads_client = GoogleAdsClient.load_from_storage("google-ads.yaml")

    # 替换为你的客户 ID
    customer_id = "INSERT_YOUR_CUSTOMER_ID_HERE"
    main(google_ads_client, customer_id)