Team
I am having some issues trying to get the code to work and download the
data in a csv format
customer_service = client.get_service("CustomerService")
resource_name = customer_service.customer_path(customer_id)
customer = customer_service.get_customer(resource_name=resource_name)
ga_service = client.get_service("GoogleAdsService")
query = """
SELECT
campaign.id,
campaign.name,
campaign.status,
ad_group.campaign,
ad_group.name,
ad_group.status,
ad_group_ad.ad.name,
ad_group_ad.ad.final_urls,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.engagements,
metrics.interactions,
segments.date
FROM ad_group_ad
WHERE segments.date BETWEEN '2021-01-01' AND '2021-07-13'
"""
search_request = client.get_type("SearchGoogleAdsRequest")
search_request.customer_id = customer_id
search_request.query = query
results = ga_service.search(request=search_request)
for row in results:
campaign = row.campaign
ad_group = row.ad_group
ad_group_ad = row.ad_group_ad
metrics = row.metrics
segments = row.segments
df = pd.DataFrame({
'campaignid': [campaign.id],
'campaignname': [campaign.name],
'campaignstatus': [campaign.status],
'AdGroup': [ad_group.name],
'AdGroupStatus': [ad_group.status],
'ad_group_ad.adname': [ad_group_ad.ad.name],
'ad_group_ad.ad_finalurls':
[ad_group_ad.ad.final_urls],
'impressions': [metrics.impressions],
'clicks': [metrics.clicks] ,
'cost': [metrics.cost_micros],
'engagements': [metrics.engagements] ,
'interactions': [metrics.interactions],
'date': [segments.date]
})
I ran the code but it only give me data for 7/13/2021. What am I missing?
Regards
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/4df918d8-19ff-4a6c-af21-0257e7b438b4n%40googlegroups.com.
