Skip to main content

Notifications

Customer Insights - Journeys forum

Extracting a list of Campaign Activites based on an account or contact list.

(0) ShareShare
ReportReport
Posted on by 5

Our Business has just made a small acquisition and there are 200  or so Account that are common between our existing data and the new set of Accounts we have bought.

I've put these "Crossover" Accounts into a marketing List and into a campaign so we have them segmented for communications.

I'd like to run a report based on the list to show all of our Marketing Activities that have been distributed to these Accounts in the past.

Can anyone help me with the structure of the query?

I can get all normal Activities using the string below, how do I alter it to show Campaign Distributed Activites?

Look For Activities:

Activity Contains Data

Select

Regarding (Account) Contains Data

Select

Marketing List Contains data 

Marketing List = "XXXX"

Select

Many thanks 

Tim

Categories:
  • Suggested answer
    RE: Extracting a list of Campaign Activites based on an account or contact list.

    Hello,

    Campaign activities get distributed with the help of records called BulkOperationLog.

    So the best approach would be to select the Bulk operation log entries that had been created for those accounts and are recorded  the lookup field of the regarding account. The bulk operation recorded in the log entry refers to the campaign activity that had been distributed.

    On campaign activities we will be able to show the different audiences in a future release, such that one may see all included and excluded contacts, accounts, leads in the Audiences tab. A new N:N relationship will help then capturing better the audience for campaign activities and quick campaigns. This will then also allow additional ways to identify campaign activities for select audience members.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans