Line 15, missing comma at the end of the line.
metrics.impression
在2025年2月28日星期五 UTC+8 17:21:44<Ahmet Buğra Buğa> 写道：
> Hi team,
>
> I am using Google Ads API to get report from Google Ads. I am running the
> same code on GCP but when I try to run it locally I get an error. The error
> says Invalid Customer ID. I am sure everything is correct, I am using
> Python 3.12 version and using latest version of Google Ads API. But I get
> the same error every time. I am sending my code script and error message:
>
> def get_campaign(date_start, date_end, customer_id):
> ca_query = f"""
> SELECT
> campaign.id,
> campaign.name,
> customer.id,
> customer.descriptive_name,
> customer.currency_code,
> segments.date,
> segments.product_brand,
> segments.product_title,
> segments.product_item_id,
> metrics.clicks,
> metrics.cost_micros,
> metrics.impressions
> metrics.conversions,
> metrics.conversion_value,
> metrics.revenue_micros,
> metrics.gross_profit_micros,
> metrics.product_category_level1,
> metrics.product_category_level2,
> metrics.product_category_level3,
> metrics.product_category_level4,
> metrics.product_category_level5
>
> FROM campaign
> WHERE
> segments.date BETWEEN {"'" + date_start + "'"} AND {"'" + date_end +
> "'"}"""
>
> search_request = gads_client.get_type("SearchGoogleAdsStreamRequest")
> search_request.customer_id = f"{customer_id}"
> search_request.query = ca_query
> gads_stream = gads_ga_service.search_stream(search_request)
> print("Google Ads Client OK")
>
> data_list = []
> for batch in gads_stream:
> for row in batch.results:
> data_dict = {
> 'campaign_id': row.campaign.id,
> 'campaign.name': row.campaign.name,
> 'customer_id': row.customer.id,
> 'customer_name': row.customer.descriptive_name,
> 'product_brand': row.segments.product_brand,
> 'product_title': row.segments.product_title,
> 'product_item_id': row.segments.product_item_id,
> 'currency_code': row.customer.currency_code,
> 'ad_group_id': row.ad_group.id,
> 'ad_group_name': row.ad_group.name,
> 'date': row.segments.date,
> 'clicks': row.metrics.clicks,
> 'cost_micros': row.metrics.cost_micros,
> 'impressions': row.metrics.impressions,
> 'conversions': row.metrics.conversions,
> 'conversion_value': row.metrics.conversion_value,
> 'revenue_micros': row.metrics.revenue_micros,
> 'gross_profit_micros': row.metrics.gross_profit_micros,
> 'product_category_level1': row.metrics.product_category_level1,
> 'product_category_level2': row.metrics.product_category_level2,
> 'product_category_level3': row.metrics.product_category_level3,
> 'product_category_level4': row.metrics.product_category_level4,
> 'product_category_level5': row.metrics.product_category_level5
>
> }
> data_list.append(data_dict)
>
> df = pd.DataFrame(data_list)
> print("Dataframe read is OK!")
> try:
> df[['cost_micros']] = df[['cost_micros']] / 1000000
>
> df['date'] = df['date'].astype('datetime64[ns]')
> except:
> print("Columns has not found")
>
> return df
>
> I forward to API my customer_id like below:
>
> "2852897198"
>
> Can you help me about this ?
>
>
> Best,
> Bugra
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/adwords-api/c2d6cf76-9adb-4b81-89e5-ddc33ccf838bn%40googlegroups.com.
