Hey Team,
May I ask you for support about Ad level data extraction? I have following GAQL:
SELECT ad.resource_name, ad.name FROM ad limit 10 just for testing purposes and when I am running the workflow to get any data I see following:
[2024-07-05 09:22:22,647 - INFO] Received command c on object id p0
2024-07-05 09:22:22,653 - google_ads_source - DEBUG - Writing table
2024-07-05 09:22:22,654 - google_ads_source - DEBUG - Getting DataFrame for table
[2024-07-05 09:22:22,916 - INFO] Request
-------
Method: /google.ads.googleads.v16.services.GoogleAdsService/SearchStream
Host: googleads.googleapis.com
Headers: {
"developer-token": "REDACTED",
"login-customer-id": "
REDACTED ",
"x-goog-api-client": "gl-python/3.10.12 grpc/1.64.1 gax/2.19.1 gccl/24.0.0 pb/4.25.3",
"x-goog-request-params": "customer_id=
REDACTED "
}
Request: customer_id: "
REDACTED "
query: "SELECT ad.resource_name, ad.name FROM ad limit 10"
Response
-------
Headers: {
"google.ads.googleads.v16.errors.googleadsfailure-bin": "\nF\n\u0002( \u0012@Unrecognized fields in the query: 'ad.resource_name', 'ad.name'.\u0012\u0016x9q7FlflftYNacPW-mSfnA",
"grpc-status-details-bin": "\b\u0003\u0012%Request contains an invalid argument.\u001a\u0001\nDtype.googleapis.com/google.ads.googleads.v16.errors.GoogleAdsFailure\u0012`\nF\n\u0002( \u0012@Unrecognized fields in the query: 'ad.resource_name', 'ad.name'.\u0012\u0016x9q7FlflftYNacPW-mSfnA",
"request-id": "
REDACTED -
REDACTED "
}
Fault: errors {
error_code {
query_error: UNRECOGNIZED_FIELD
}
message: "Unrecognized fields in the query: \'ad.resource_name\', \'ad.name\'."
}
request_id: "
REDACTED -
REDACTED "
[2024-07-05 09:22:22,918 - WARNING] Request made: ClientCustomerId:
REDACTED , Host: googleads.googleapis.com, Method: /google.ads.googleads.v16.services.GoogleAdsService/SearchStream, RequestId:
REDACTED -
REDACTED , IsFault: True, FaultMessage: Unrecognized fields in the query: 'ad.resource_name', 'ad.name'.
Other GAQL are working flawlessly. Can you, please, let me know why can't I extract data directly from "Ad" entity?