SSIS Components for SendGrid

Build 24.0.8963

AutomationStats

Get All Automation Stats

View-Specific Information

Select

The following is an example to query the AutomationStats view:

 
SELECT * FROM AutomationStats

Columns

Name Type References Description
Id String This is the ID of the Automation you are requesting stats for.
Aggregation String This describes the time unit to which the stat is rolled up. It is based on the aggregated_by parameter included in the request. It can be
StepId String This is the ID of the step if the stats were requested to be grouped by step_id.
BounceDrops Integer BounceDrops
Bounces Integer Bounces
Clicks Integer Clicks
Delivered Integer Delivered
InvalidEmails Integer InvalidEmails
Opens Integer Opens
Requests Integer Requests
SpamReportDrops Integer SpamReportDrops
SpamReports Integer SpamReports
UniqueClicks Integer UniqueClicks
UniqueOpens Integer UniqueOpens
Unsubscribes Integer Unsubscribes

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963