This Data View will get you more insights in the specific activities performed by your automations. If you want to analyze the performance of the individual activities, this is the Data View you want.
Combined with the Automation Instance Data View, you will be able to perfect your automations and prevent long running jobs or failing steps.
This Data View holds data about the activities in recently ran automations, their status, when and how long it ran and why a run failed. The data in Automation Activity Instance is available for automations that ran in the past 31 days and has a 24-hour delay.
You can query the data in the data view from an automation, from the Query Studio or from an API.
Fields
Field name | Type | Nullable | Options | Description |
---|---|---|---|---|
MemberID | Number | No | ID of the Business Unit. | |
AutomationName | Text | No | Name of the automation. | |
AutomationCustomerKey | Text | No | ID of the automation. | |
AutomationInstanceID | Text | No | ID of the specific automation run. | |
ActivityType | Number | No | See list ↓ | Type of the activity. |
ActivityName | Text | No | Name of the activity. | |
ActivityDescription | Text | Yes | Description of the activity. | |
ActivityCustomerKey | Text | No | ID of the activity. | |
ActivityInstanceStep | Text | No | Step/location of the activity within the automation. | |
ActivityInstanceID | Text | No | ID of the specific activity run. | |
ActivityInstanceStartTime_UTC | Date | Yes | Datetime the activity started. If run was skipped, value is null. | |
ActivityInstanceEndTime_UTC | Date | Yes | Datetime the activity finished. If run was skipped or still running, value is null. | |
ActivityInstanceStatus | Text | No | – Initialized – Executing – Complete – Error – NotSelected | Status of the activity at time of query. |
ActivityInstanceStatusDetails | Text | Yes | Error message from log. |
Activity Type IDs
Type ID | Name |
---|---|
33 | SMS Activity |
42 | Send Email |
43 | Import File |
45 | Refresh Group |
53 | File Transfer |
73 | Data Extract |
84 | Report Definition |
300 | SQL Query |
303 | Filter |
423 | Script |
425 | Data Factory Utility Activity |
426 | Refresh Segment Template |
427 | Publish Audience |
467 | Wait |
724 | Refresh Mobile Filtered List |
725 | Send SMS |
726 | Import Mobile Contacts |
733 | Journey Builder Event Activity |
736 | Send Push |
749 | Fire Event |
771 | Salesforce Email Send |
772 | Mobile Connect Send Salesforce Sync Subscriber |
783 | Send GroupConnect |
952 | Journey Builder Event Activity |
1000 | Verification |
1010 | Interaction Studio Data |
1101 | Interactions |
1701 | Batch Personalization |
3700 | Contact to Business Unit Mapping |
Sample queries
Activity duration
Monitor activities to spot long running queries or scripts.
SELECT ActivityCustomerKey AS [ID]
, AutomationName AS [Automation Name]
, ActivityName AS [Activity Name]
, AVG(Datediff(minute, ActivityInstanceStartTime_UTC, ActivityInstanceEndTime_UTC)) AS [AvgDuration]
, MIN(Datediff(minute, ActivityInstanceStartTime_UTC, ActivityInstanceEndTime_UTC)) AS [MinDuration]
, MAX(Datediff(minute, ActivityInstanceStartTime_UTC, ActivityInstanceEndTime_UTC)) AS [MaxDuration]
FROM [_AutomationActivityInstance]
GROUP BY ActivityCustomerKey,AutomationName,ActivityName