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 ATTRIBUTE
Data Type MESSAGE
Type URL google.ads.googleads.v17.resources.OfflineConversionAlert
Filterable False
Selectable True
Sortable False
Repeated True
offline_conversion_upload_client_summary.client
Field description Output only. Client type of the upload event.
Category ATTRIBUTE
Data Type
ENUM
ADS_DATA_CONNECTOR
GOOGLE_ADS_API
GOOGLE_ADS_WEB_CLIENT
UNKNOWN
UNSPECIFIED
Type URL google.ads.googleads.v17.enums.OfflineEventUploadClientEnum.OfflineEventUploadClient
Filterable 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 ATTRIBUTE
Data Type MESSAGE
Type URL google.ads.googleads.v17.resources.OfflineConversionSummary
Filterable 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 ATTRIBUTE
Data Type MESSAGE
Type URL google.ads.googleads.v17.resources.OfflineConversionSummary
Filterable 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 ATTRIBUTE
Data Type DATE
Type URL N/A
Filterable 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 ATTRIBUTE
Data Type INT64
Type URL N/A
Filterable 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 ATTRIBUTE
Data Type DOUBLE
Type URL N/A
Filterable 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 ATTRIBUTE
Data Type RESOURCE_NAME
Type URL N/A
Filterable 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 ATTRIBUTE
Data Type
ENUM
EXCELLENT
GOOD
NEEDS_ATTENTION
NO_RECENT_UPLOAD
UNKNOWN
UNSPECIFIED
Type URL google.ads.googleads.v17.enums.OfflineConversionDiagnosticStatusEnum.OfflineConversionDiagnosticStatus
Filterable True
Selectable True
Sortable True
Repeated False
offline_conversion_upload_client_summary.success_rate
Field description Output only. Successful rate.
Category ATTRIBUTE
Data Type DOUBLE
Type URL N/A
Filterable 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 ATTRIBUTE
Data Type INT64
Type URL N/A
Filterable 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 ATTRIBUTE
Data Type INT64
Type URL N/A
Filterable True
Selectable True
Sortable True
Repeated False