I've just noticed that the missing hours can appear anywhere in the results.
In this example, we are missing hours, 0, 6, 14, 21+
SELECT
customer.currency_code,
segments.date,
segments.hour,
metrics.clicks,
metrics.impressions
FROM campaign
WHERE segments.date BETWEEN "2021-06-13" AND "2021-06-13"
AND campaign.id = '12642662800'
LIMIT 50
Daniel
{
"results": [
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "0"
},
"segments": {
"date": "2021-06-13",
"hour": 1
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "0"
},
"segments": {
"date": "2021-06-13",
"hour": 2
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "0"
},
"segments": {
"date": "2021-06-13",
"hour": 3
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "0"
},
"segments": {
"date": "2021-06-13",
"hour": 4
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "0"
},
"segments": {
"date": "2021-06-13",
"hour": 5
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "0"
},
"segments": {
"date": "2021-06-13",
"hour": 7
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "0"
},
"segments": {
"date": "2021-06-13",
"hour": 8
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "1",
"impressions": "3"
},
"segments": {
"date": "2021-06-13",
"hour": 9
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "2"
},
"segments": {
"date": "2021-06-13",
"hour": 10
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "3",
"impressions": "8"
},
"segments": {
"date": "2021-06-13",
"hour": 11
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "1",
"impressions": "3"
},
"segments": {
"date": "2021-06-13",
"hour": 12
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "1",
"impressions": "2"
},
"segments": {
"date": "2021-06-13",
"hour": 13
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "2"
},
"segments": {
"date": "2021-06-13",
"hour": 15
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "2"
},
"segments": {
"date": "2021-06-13",
"hour": 16
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "1",
"impressions": "4"
},
"segments": {
"date": "2021-06-13",
"hour": 17
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "1"
},
"segments": {
"date": "2021-06-13",
"hour": 18
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "1",
"impressions": "2"
},
"segments": {
"date": "2021-06-13",
"hour": 19
}
},
{
"customer": {
"resourceName": "customers/3266544319",
"currencyCode": "GBP"
},
"campaign": {
"resourceName":
"customers/3266544319/campaigns/12642662800"
},
"metrics": {
"clicks": "0",
"impressions": "3"
},
"segments": {
"date": "2021-06-13",
"hour": 20
}
}
],
"fieldMask":
"customer.currencyCode,segments.date,segments.hour,metrics.clicks,metrics.impressions",
"requestId": "mvlx2TaY2b-j5iubCY6Jhw"
}
]
On Wednesday, 16 June 2021 at 11:42:21 UTC+1 Daniel Platt wrote:
> Hi Matt,
>
> I've recently tried the query with rest api and get the same results.
> I have redacted some of the information from the request.
>
> You can see that the hours returned stop after 21.
>
>
> curl --location --request POST '
> https://googleads.googleapis.com/v8/customers/3266544319/googleAds:searchStream?query=%20%20%20SELECT%0A%20%20%20%20%20%20segments.date,%0A%20%20%20%20%20%20segments.hour,%0A%20%20%20%20%20%20metrics.clicks,%0A%20%20%20%20%20%20metrics.impressions%0A%20%20%20%20FROM%20campaign%0A%20%20%20%20WHERE%20segments.date%20DURING%20YESTERDAY%0A%20%20%20%20AND%20campaign.id%20=%20%2712642662797%27%0A%20%20%20%20LIMIT%2050'
>
> \
> --header 'developer-token: TOKEN' \
> --header 'Authorization: Bearer ya29...' \
> --header 'Content-Type: application/json' \
> --header 'login-customer-id: 123456789' \
> --data-raw ''
>
> [
> {
> "results": [
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "0",
> "impressions": "0"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 0
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "0",
> "impressions": "0"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 1
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "0",
> "impressions": "0"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 2
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "0",
> "impressions": "0"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 3
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "0",
> "impressions": "0"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 4
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "0",
> "impressions": "0"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 5
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "0",
> "impressions": "0"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 6
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "0",
> "impressions": "0"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 7
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "6",
> "impressions": "81"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 8
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "17",
> "impressions": "182"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 9
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "16",
> "impressions": "182"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 10
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "18",
> "impressions": "212"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 11
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "25",
> "impressions": "220"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 12
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "17",
> "impressions": "171"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 13
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "18",
> "impressions": "176"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 14
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "15",
> "impressions": "160"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 15
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "9",
> "impressions": "154"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 16
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "8",
> "impressions": "151"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 17
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "13",
> "impressions": "100"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 18
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "7",
> "impressions": "78"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 19
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "6",
> "impressions": "54"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 20
> }
> },
> {
> "campaign": {
> "resourceName": "customers/3266544319
> <(326)%20654-4319>/campaigns/12642662797"
> },
> "metrics": {
> "clicks": "3",
> "impressions": "34"
> },
> "segments": {
> "date": "2021-06-15",
> "hour": 21
> }
> }
> ],
> "fieldMask":
> "segments.date,segments.hour,metrics.clicks,metrics.impressions",
> "requestId": "0En8aQPOTCQDpFn6Ja1SvA"
> }
> ]
>
> On Tuesday, 15 June 2021 at 16:27:28 UTC+1 adsapi wrote:
>
>> Hi Daniel,
>>
>> Thanks for reaching out. Can you please provide us with the complete
>> request and response logs, including the request ID, so that we can have a
>> closer look?
>>
>> Thanks,
>> Matt
>> Google Ads API Team
>>
>> [image: Google Logo]
>> Matt
>> Google Ads API Team
>>
>>
>> ref:_00D1U1174p._5004Q2IvGKh: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 [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/0877e4de-5277-4b54-a8e3-dd79aad6894cn%40googlegroups.com.
