Attached is the code and response
On Thursday, July 15, 2021 at 4:26:38 PM UTC-4 adsapi wrote:
> Hello,
>
> Thanks for reaching out. Can you please provide us with the complete
> request and response logs so that we can take a closer look?
>
> Thanks,
> Matt
> Google Ads API Team
>
> [image: Google Logo]
> Matt
> Google Ads API Team
>
>
> ref:_00D1U1174p._5004Q2KcQGK:ref
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"AdWords API and Google Ads 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/e42aa395-3e23-40bd-b2b9-27a53d91c23en%40googlegroups.com.
import argparse
import sys
import pandas as pd
import google.ads.googleads
from google.ads.googleads.client import GoogleAdsClient
from google.ads.googleads.errors import GoogleAdsException
client = GoogleAdsClient.load_from_storage("~./google-ads.yaml")
customer_id = 'xxxxxxxxxx'
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]
})
print(results)}
segments { date: "2021-07-11" }
}
results {
campaign { resource_name: "customers/5490136129/campaigns/13005712685"
status: ENABLED
name: "The Farmlink Project 1 Year"
id: 13005712685
}
ad_group { resource_name: "customers/5490136129/adGroups/120723736214"
status: ENABLED
name: "1 Year" campaign: "customers/5490136129/campaigns/13005712685" }
metrics {
clicks: 76 cost_micros: 32829904
engagements: 1147
impressions: 3480
interactions: 1147 }
ad_group_ad {
resource_name: "customers/5490136129/adGroupAds/120723736214~522037559651"
ad { resource_name: "customers/5490136129/ads/522037559651"
final_urls: "http://www.farmlinkproject.org"; name: "Ad #1"
}
}
segments { date: "2021-07-12" }
}
results {
campaign { resource_name: "customers/5490136129/campaigns/13005712685"
status: ENABLED
name: "The Farmlink Project 1 Year"
id: 13005712685
}
ad_group { resource_name: "customers/5490136129/adGroups/120723736214"
status: ENABLED
name: "1 Year" campaign: "customers/5490136129/campaigns/13005712685" }
metrics {
clicks: 78 cost_micros: 35305067
engagements: 1069
impressions: 3159
interactions: 1069 }
ad_group_ad {
resource_name: "customers/5490136129/adGroupAds/120723736214~522037559651"
ad { resource_name: "customers/5490136129/ads/522037559651"
final_urls: "http://www.farmlinkproject.org"; name: "Ad #1"
}
}
segments { date: "2021-07-13" }
}
field_mask { paths: "campaign.id" paths: "campaign.name" paths:
"campaign.status" paths: "ad_group.campaign" paths: "ad_group.name" paths:
"ad_group.status" paths: "ad_group_ad.ad.name" paths:
"ad_group_ad.ad.final_urls" paths: "metrics.impressions" paths:
"metrics.clicks"
paths: "metrics.cost_micros" paths: "metrics.engagements" paths:
"metrics.interactions"
paths: "segments.date"}
>
