Help me build a query
Offline conversion upload summary at conversion action 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_conversion_action_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.v17.resources.OfflineConversionAlertFilterable False Selectable True Sortable False Repeated True
offline_conversion_upload_conversion_action_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.v17.enums.OfflineEventUploadClientEnum.OfflineEventUploadClientFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_conversion_action_summary.conversion_action_id
Field description Output only. Conversion action id. Category ATTRIBUTEData Type INT64Type URL N/AFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_conversion_action_summary.conversion_action_name
Field description Output only. The name of the conversion action. Category ATTRIBUTEData Type STRINGType URL N/AFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_conversion_action_summary.daily_summaries
Field description Output only. Summary of history stats by last N days. Category ATTRIBUTEData Type MESSAGEType URL google.ads.googleads.v17.resources.OfflineConversionSummaryFilterable False Selectable True Sortable False Repeated True
offline_conversion_upload_conversion_action_summary.job_summaries
Field description Output only. Summary of history stats by last N jobs. Category ATTRIBUTEData Type MESSAGEType URL google.ads.googleads.v17.resources.OfflineConversionSummaryFilterable False Selectable True Sortable False Repeated True
offline_conversion_upload_conversion_action_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_conversion_action_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_conversion_action_summary.resource_name
Field description Output only. The resource name of the offline conversion upload summary at conversion action level. Offline conversion upload conversion action summary resource names have the form: customers/{customer_id}/offlineConversionUploadConversionActionSummaries/{conversion_action_id}~{client} Category ATTRIBUTEData Type RESOURCE_NAMEType URL N/AFilterable True Selectable True Sortable False Repeated False
offline_conversion_upload_conversion_action_summary.status
Field description Output only. Overall status for offline conversion upload conversion action 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.v17.enums.OfflineConversionDiagnosticStatusEnum.OfflineConversionDiagnosticStatusFilterable True Selectable True Sortable True Repeated False
offline_conversion_upload_conversion_action_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_conversion_action_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
