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

(0) Share

Report

Posted on by Tim T

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:

Activity Feeds

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Christian Abeln Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No