The _JourneyActivity Data View contains inactive versions of activities
Trailblazer Community

The _JourneyActivity Data View contains inactive versions of activities

Marketing Cloud Journey Builder

Last updated 19 days ago ·Reference W-7342597 ·Reported By 0 users

Fixed in version Marketing Cloud Release May 2020

Summary
When writing a SQL query using the _JourneyActivity data view, you may notice more activities than are present on your journey canvas. Each time a draft version of a journey is saved, we create new "active" versions of each of the activities and set all previous activities to "inactive". This is only visible/noticeable in the data view and otherwise has no impact on any other Journey functionality.

Repro
-Create journey with name 'JourneyDataView'
-Configure the entry event
-Configure a random split
-Configure journey settings
-Save the journey 1 time. Run your SQL query and note there are 7 activities in _JourneyActivity for this journey
-Save the journey a second time. There are now 14 activities in _JourneyActivity
-Activate the journey. There are now 21 activities, etc

Workaround
There is no workaround to remove these extra activities.

Reported By (0)

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.