1

We have set of journey emails which will be deploying based on subscriber activity. But we have to get complete journey subscriber activity details in one Data Extension. Is it possible to get it by using Query?

  • Do you want a list of all opens, clicks, etc in one data extension? – TCassa Sep 26 '17 at 10:57
2

Yes, we can get the complete journey subscriber activity details in one Data Extension by writing queries on system data views.

SFMS provides data views like _Sent, _Open, _Click, _JourneyActivity, _Journey, _Subscribers. You can join all these data views to get the required data into our data extension.

Here are a few examples for you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.