Help me build a query
Offline conversion upload summary at customer level.
Fields from the above resources may be selected along with this
resource in your SELECT and WHERE clauses. These fields will not segment
metrics in your SELECT clause.
offline_conversion_upload_client_summary.alerts
Field description Output only. Details for each error code. Alerts are generated from most recent calendar day with upload stats. Category ATTRIBUTEData Type MESSAGEType URL google.ads.googleads.v18.resources.OfflineConversionAlertFilterable False Selectable True Sortable False Repeated True
offline_conversion_upload_client_summary.client
Field description Output only. Client type of the upload event. Category ATTRIBUTEData Type
ENUM
ADS_DATA_CONNECTOR
GOOGLE_ADS_API
GOOGLE_ADS_WEB_CLIENT
UNKNOWN
UNSPECIFIED
Type URL google.ads.googleads.v18.enums.OfflineEventUploadClientEnum.OfflineEventUploadClientFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_client_summary.daily_summaries
Field description Output only. Summary of history stats by last N days. Category ATTRIBUTEData Type MESSAGEType URL google.ads.googleads.v18.resources.OfflineConversionSummaryFilterable False Selectable True Sortable False Repeated True
offline_conversion_upload_client_summary.job_summaries
Field description Output only. Summary of history stats by last N jobs. Category ATTRIBUTEData Type MESSAGEType URL google.ads.googleads.v18.resources.OfflineConversionSummaryFilterable False Selectable True Sortable False Repeated True
offline_conversion_upload_client_summary.last_upload_date_time
Field description Output only. Date for the latest upload batch. The format is "yyyy-mm-dd hh:mm:ss", and it's in the time zone of the Google Ads account. Category ATTRIBUTEData Type DATEType URL N/AFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_client_summary.pending_event_count
Field description Output only. Total count of pending uploaded events. Category ATTRIBUTEData Type INT64Type URL N/AFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_client_summary.pending_rate
Field description Output only. The ratio of total pending events to total events. Category ATTRIBUTEData Type DOUBLEType URL N/AFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_client_summary.resource_name
Field description Output only. The resource name of the offline conversion upload summary at customer level. Offline conversion upload client summary resource names have the form: customers/{customer_id}/offlineConversionUploadClientSummaries/{client} Category ATTRIBUTEData Type RESOURCE_NAMEType URL N/AFilterable True Selectable True Sortable False Repeated False
offline_conversion_upload_client_summary.status
Field description Output only. Overall status for offline conversion client summary. Status is generated from most recent calendar day with upload stats. Category ATTRIBUTEData Type
ENUM
EXCELLENT
GOOD
NEEDS_ATTENTION
NO_RECENT_UPLOAD
UNKNOWN
UNSPECIFIED
Type URL google.ads.googleads.v18.enums.OfflineConversionDiagnosticStatusEnum.OfflineConversionDiagnosticStatusFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_client_summary.success_rate
Field description Output only. Successful rate. Category ATTRIBUTEData Type DOUBLEType URL N/AFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_client_summary.successful_event_count
Field description Output only. Total count of successful uploaded events. Category ATTRIBUTEData Type INT64Type URL N/AFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_client_summary.total_event_count
Field description Output only. Total count of uploaded events. Category ATTRIBUTEData Type INT64Type URL N/AFilterable True Selectable True Sortable True Repeated False
