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
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.
André Arnaud de Cal...
292,074
Super User 2025 Season 1
Martin Dráb
230,900
Most Valuable Professional
nmaenpaa
101,156