Hi,
I saw in post https://groups.google.com/g/adwords-api/c/FoT9MHlROSI?pli=1.
That the demand gen should be able to be fetched. So I tried that for
client 3825534427. However the campaign with id 20754350559, which is a
demand gen campaign is not coming through.
The complete logs and the UI screen shots are in the attachment.
The query I am using is below.
Thanks for helping
SELECT
campaign.id,
ad_group.id,
ad_group_ad.ad.id,
segments.date,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.video_views,
segments.date,
segments.ad_network_type
FROM
ad_group_ad
WHERE
segments.date BETWEEN '{start_date}' AND '{end_date}'
ORDER BY
campaign.id
SELECT
campaign.id,
campaign.name,
campaign.campaign_budget,
campaign.status,
campaign.advertising_channel_type,
segments.date,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.video_views,
segments.date,
segments.ad_network_type
FROM
campaign
WHERE
segments.date BETWEEN '{start_date}' AND '{end_date}' AND
campaign.advertising_channel_type = 'PERFORMANCE_MAX'
ORDER BY
campaign.id
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 on the web visit
https://groups.google.com/d/msgid/adwords-api/1c2e6359-5609-4fc1-a6cf-5ef4cb73a9can%40googlegroups.com.
{\rtf1\ansi\ansicpg1252\cocoartf2706
\cocoatextscaling0\cocoaplatform0{\fonttbl\f0\fnil\fcharset0 Menlo-Regular;}
{\colortbl;\red255\green255\blue255;\red67\green67\blue67;\red255\green255\blue255;}
{\*\expandedcolortbl;;\cssrgb\c33333\c33333\c33333;\cssrgb\c100000\c100000\c100000;}
\paperw11900\paperh16840\margl1440\margr1440\vieww28600\viewh15180\viewkind0
\deftab720
\pard\pardeftab720\partightenfactor0
\f0\fs26 \cf2 \cb3 \expnd0\expndtw0\kerning0
\outl0\strokewidth0 \strokec2 [2024-01-16 11:00:04,686 - INFO] Received command c on object id p0\
[2024-01-16 11:00:05,677 - INFO] Received command c on object id p0\
[2024-01-16 11:00:06,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:07,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:08,684 - INFO] Received command c on object id p0\
[2024-01-16 11:00:09,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:10,680 - INFO] Received command c on object id p0\
[2024-01-16 11:00:11,685 - INFO] Received command c on object id p0\
[2024-01-16 11:00:12,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:13,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:14,683 - INFO] Received command c on object id p0\
[2024-01-16 11:00:15,684 - INFO] Received command c on object id p0\
[2024-01-16 11:00:16,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:17,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:18,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:19,683 - INFO] Received command c on object id p0\
[2024-01-16 11:00:20,687 - INFO] Received command c on object id p0\
[2024-01-16 11:00:21,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:22,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:23,682 - INFO] Received command c on object id p0\
[2024-01-16 11:00:24,391 - DEBUG] Request\
-------\
Method: /google.ads.googleads.v15.services.GoogleAdsService/SearchStream\
Host: googleads.googleapis.com\
Headers: \{\
"developer-token": "REDACTED",\
"x-goog-api-client": "gl-python/3.10.12 grpc/1.48.1 gax/2.8.2 gccl/22.1.0 pb/4.25.2",\
"x-goog-request-params": "customer_id=3825534427"\
\}\
Request: customer_id: "3825534427"\
query: "\\n SELECT\\n campaign.id,\\n ad_group.id,\\n ad_group_ad.ad.id,\\n segments.date,\\n metrics.impressions,\\n metrics.clicks,\\n metrics.cost_micros,\\n metrics.video_views,\\n segments.date,\\n segments.ad_network_type\\n FROM\\n ad_group_ad\\n WHERE\\n segments.date BETWEEN \\'2021-01-01\\' AND \\'2024-01-15\\'\\n ORDER BY\\n campaign.id"\
\
\
Response\
-------\
Headers: \{\
"content-disposition": "attachment",\
"request-id": "HbTvMjVcuBYwGnDBUuRMFg"\
\}\
Response: results \{\
ad_group \{\
resource_name: "customers/3825534427/adGroups/6791769442"\
id: 6791769442\
\}\
ad_group_ad \{\
resource_name: "customers/3825534427/adGroupAds/6791769442~256587835837"\
ad \{\
resource_name: "customers/3825534427/ads/256587835837"\
id: 256587835837\
\}\
\}\
campaign \{\
resource_name: "customers/3825534427/campaigns/56963842"\
id: 56963842\
\}\
metrics \{\
clicks: 5\
cost_micros: 800000\
impressions: 11\
video_views: 0\
\}\
segments \{\
ad_network_type: SEARCH\
date: "2021-01-01"\
\}\
\}\
results \{\
ad_group \{\
resource_name: "customers/3825534427/adGroups/6791769442"\
id: 6791769442\
\}\
ad_group_ad \{\
resource_name: "customers/3825534427/adGroupAds/6791769442~256587835840"\
ad \{\
resource_name: "customers/3825534427/ads/256587835840"\
id: 256587835840\
\}\
\}\
campaign \{\
resource_name: "customers/3825534427/campaigns/56963842"\
id: 56963842\
\}\
metrics \{\
clicks: 0\
cost_micros: 0\
impressions: 3\
video_views: 0\
\}\
segments \{\
ad_network_type: SEARCH\
date: "2021-01-01"\
\}\
\}\
results \{\
ad_group \{\
resource_name: "customers/3825534427/adGroups/6791769442"\
id: 6791769442\
\}\
ad_group_ad \{\
resource_name: "customers/3825534427/adGroupAds/6791769442~401445583183"\
ad \{\
resource_name: "customers/3825534427/ads/401445583183"\
id: 401445583183\
\}\
\}\
campaign \{\
resource_name: "customers/3825534427/campaigns/56963842"\
id: 56963842\
\}\
metrics \{\
clicks: 0\
cost_micros: 0\
impressions: 1\
video_views: 0\
\}\
segments \{\
ad_network_type: SEARCH\
date: "2021-01-01"\
\}\
\}\
results \{\
ad_group \{\
resource_name: "customers/3825534427/adGroups/6791769442"\
id: 6791769442\
\}\
ad_group_ad \{\
resource_name: "customers/3825534427/adGroupAds/6791769442~256587835837"\
ad \{\
resource_name: "customers/3825534427/ads/256587835837"\
id: 256587835837\
\}\
\}\
campaign \{\
resource_name: "customers/3825534427/campaigns/56963842"\
id: 56963842\
\}\
metrics \{\
clicks: 7\
cost_micros: 380000\
impressions: 26\
video_views: 0\
\}\
segments \{\
ad_network_type: SEARCH\
date: "2021-01-02"\
\}\
\}\
results \{\
ad_group \{\
resource_name: "customers/3825534427/adGroups/6791769442"\
id: 6791769442\
\}\
ad_group_ad \{\
resource_name: "customers/3825534427/adGroupAds/6791769442~256587835840"\
ad \{\
resource_name: "customers/3825534427/ads/256587835840"\
id: 256587835840\
\}\
\}\
campaign \{\
resource_name: "customers/3825534427/campaigns/56963842"\
id: 56963842\
\}\
metrics \{\
clicks: 0\
cost_micros: 0\
impressions: 4\
video_views: 0\
\}\
segments \{\
ad_network_type: SEARCH\
date: "2021-01-02"\
\}\
\}\
results \{\
ad_group \{\
resource_name: "customers/3825534427/adGroups/48865858477"\
id: 48865858477\
\}\
ad_group_ad \{\
resource_name: "customers/3825534427/adGroupAds/48865858477~256587835669"\
ad \{\
resource_name: "customers/3825534427/ads/256587835669"\
id: 256587835669\
\}\
\}\
campaign \{\
resource_name: "customers/3825534427/campaigns/56963842"\
id: 56963842\
\}\
metrics \{\
clicks: 0\
cost_micros: 0\
impressions: 1\
video_views: 0\
\}\
segments \{\
ad_network_type: SEARCH\
date: "2021-01-02"\
\}\
\}\
results \{\
ad_group \{\
resource_name: "customers/3825534427/adGroups/6791769442"\
id: 6791769442\
\}\
ad_group_ad \{\
resource_name: "customers/3825534427/adGroupAds/6791769442~256587835837"\
ad \{\
resource_name: "customers/3825534427/ads/256587835837"\
id: 256587835837\
\}\
\}\
campaign \{\
resource_name: "customers/3825534427/campaigns/56963842"\
id: 56963842\
\}\
metrics \{\
clicks: 8\
cost_micros: 1190000\
impressions: 31\
video_views: 0\
\}\
segments \{\
ad_network_type: SEARCH\
date: "2021-01-03"\
\}\
\}\
results \{\
ad_group \{\
resource_name: "customers/3825534427/adGroups/6791769442"\
id: 6791769442\
\}\
ad_group_ad \{\
resource_name: "customers/3825534427/adGroupAds/6791769442~256587835840"\
ad \{\
resource_name: "customers/38255344\
[2024-01-16 11:00:24,395 - INFO] Request made: ClientCustomerId: 3825534427, Host: googleads.googleapis.com, Method: /google.ads.googleads.v15.services.GoogleAdsService/SearchStream, RequestId: HbTvMjVcuBYwGnDBUuRMFg, IsFault: False, FaultMessage: None\
[2024-01-16 11:00:24,727 - INFO] Received command c on object id p0\
[2024-01-16 11:00:25,677 - INFO] Received command c on object id p0\
[2024-01-16 11:00:26,059 - DEBUG] Request\
-------\
Method: /google.ads.googleads.v15.services.GoogleAdsService/SearchStream\
Host: googleads.googleapis.com\
Headers: \{\
"developer-token": "REDACTED",\
"x-goog-api-client": "gl-python/3.10.12 grpc/1.48.1 gax/2.8.2 gccl/22.1.0 pb/4.25.2",\
"x-goog-request-params": "customer_id=3825534427"\
\}\
Request: customer_id: "3825534427"\
query: "\\n SELECT\\n campaign.id,\\n campaign.name,\\n campaign.campaign_budget,\\n campaign.status,\\n campaign.advertising_channel_type,\\n segments.date,\\n metrics.impressions,\\n metrics.clicks,\\n metrics.cost_micros,\\n metrics.video_views,\\n segments.date,\\n segments.ad_network_type\\n FROM\\n campaign\\n WHERE\\n segments.date BETWEEN \\'2021-01-01\\' AND \\'2024-01-15\\' AND\\n campaign.advertising_channel_type = \\'PERFORMANCE_MAX\\'\\n ORDER BY\\n campaign.id\\n "\
\
\
Response\
-------\
Headers: \{\
"content-disposition": "attachment",\
"request-id": "4Bvpa5TJzBKge4I9kkEsjA"\
\}\
Response: results \{\
campaign \{\
resource_name: "customers/3825534427/campaigns/17373200112"\
id: 17373200112\
name: "Performance Max - NL - SS22"\
status: PAUSED\
advertising_channel_type: PERFORMANCE_MAX\
campaign_budget: "customers/3825534427/campaignBudgets/10993709695"\
\}\
metrics \{\
clicks: 3\
cost_micros: 470000\
impressions: 356\
video_views: 0\
\}\
segments \{\
ad_network_type: MIXED\
date: "2022-06-01"\
\}\
\}\
results \{\
campaign \{\
resource_name: "customers/3825534427/campaigns/17373200112"\
id: 17373200112\
name: "Performance Max - NL - SS22"\
status: PAUSED\
advertising_channel_type: PERFORMANCE_MAX\
campaign_budget: "customers/3825534427/campaignBudgets/10993709695"\
\}\
metrics \{\
clicks: 6\
cost_micros: 1770000\
impressions: 1096\
video_views: 0\
\}\
segments \{\
ad_network_type: MIXED\
date: "2022-06-02"\
\}\
\}\
results \{\
campaign \{\
resource_name: "customers/3825534427/campaigns/17373200112"\
id: 17373200112\
name: "Performance Max - NL - SS22"\
status: PAUSED\
advertising_channel_type: PERFORMANCE_MAX\
campaign_budget: "customers/3825534427/campaignBudgets/10993709695"\
\}\
metrics \{\
clicks: 10\
cost_micros: 2310000\
impressions: 1398\
video_views: 0\
\}\
segments \{\
ad_network_type: MIXED\
date: "2022-06-03"\
\}\
\}\
results \{\
campaign \{\
resource_name: "customers/3825534427/campaigns/17373200112"\
id: 17373200112\
name: "Performance Max - NL - SS22"\
status: PAUSED\
advertising_channel_type: PERFORMANCE_MAX\
campaign_budget: "customers/3825534427/campaignBudgets/10993709695"\
\}\
metrics \{\
clicks: 7\
cost_micros: 1500000\
impressions: 1144\
video_views: 0\
\}\
segments \{\
ad_network_type: MIXED\
date: "2022-06-04"\
\}\
\}\
results \{\
campaign \{\
resource_name: "customers/3825534427/campaigns/17373200112"\
id: 17373200112\
name: "Performance Max - NL - SS22"\
status: PAUSED\
advertising_channel_type: PERFORMANCE_MAX\
campaign_budget: "customers/3825534427/campaignBudgets/10993709695"\
\}\
metrics \{\
clicks: 10\
cost_micros: 4900000\
impressions: 1280\
video_views: 0\
\}\
segments \{\
ad_network_type: MIXED\
date: "2022-06-05"\
\}\
\}\
results \{\
campaign \{\
resource_name: "customers/3825534427/campaigns/17373200112"\
id: 17373200112\
name: "Performance Max - NL - SS22"\
status: PAUSED\
advertising_channel_type: PERFORMANCE_MAX\
campaign_budget: "customers/3825534427/campaignBudgets/10993709695"\
\}\
metrics \{\
clicks: 10\
cost_micros: 3450000\
impressions: 1312\
video_views: 0\
\}\
segments \{\
ad_network_type: MIXED\
date: "2022-06-06"\
\}\
\}\
results \{\
campaign \{\
resource_name: "customers/3825534427/campaigns/17373200112"\
id: 17373200112\
name: "Performance Max - NL - SS22"\
status: PAUSED\
advertising_channel_type: PERFORMANCE_MAX\
campaign_budget: "customers/3825534427/campaignBudgets/10993709695"\
\}\
metrics \{\
clicks: 6\
cost_micros: 590000\
impressions: 1026\
video_views: 0\
\}\
segments \{\
ad_network_type: MIXED\
date: "2022-06-07"\
\}\
\}\
results \{\
campaign \{\
resource_name: "customers/3825534427/campaigns/17373200112"\
id: 17373200112\
name: "Performance Max - NL - SS22"\
status: PAUSED\
advertising_channel_type: PERFORMANCE_MAX\
campaign_budget: "customers/3825534427/campaignBudgets/10993709695"\
\}\
metrics \{\
clicks: 41\
cost_micros: 27840000\
impressions: 6844\
video_views: 0\
\}\
segments \{\
ad_network_type: MIXED\
date: "2022-06-08"\
\}\
\}\
results \{\
campaign \{\
resource_name: "customers/3825534427/campaigns/17373200112"\
id: 17373200112\
name: "Performance Max - NL - SS22"\
status: PAUSED\
advertising_channel_type: PERFORMANCE_MAX\
campaign_budget: "customers/3825534427/campaignBudgets/10993709695"\
\}\
metrics \{\
clicks: 72\
cost_micros: 39791793\
impressions: 104\
[2024-01-16 11:00:26,060 - INFO] Request made: ClientCustomerId: 3825534427, Host: googleads.googleapis.com, Method: /google.ads.googleads.v15.services.GoogleAdsService/SearchStream, RequestId: 4Bvpa5TJzBKge4I9kkEsjA, IsFault: False, FaultMessage: None}
