Activity log report due to no acquisition program?

[Calvin_Pineda]

Hey everyone,

We have many individuals with no acquisition program so I've been given task of searching their activity log. The goal is to pinpoint some activity that may be associated with a specific campaign. However, there's over 800 pages in our database of individuals with no acquisition program, and each individual may have over 20 pages of activity.

Is there way to export everyone's activity so it''ll be somewhat achievable finding a common denominator that can be used to assign them an acquisition program. Ideally, if I was to find a pattern in the activity log, I can set up a campaign like "if acquisition program is empty, give them this value". I understand that's large amount of data, but I can't think of another option. If anyone has other alternatives, it would be very helpful.

Best Regards, Calvin

[SanfordWhiteman · Accepted solution]

The db-wide Activity Log can be exported using the Bulk Extract (preferred) or Bulk Export API. You'll need to be/have a developer for this task.

When done, you'll have a -- potentially gigantic, depending on time range and data volume -- set of files.

Obviously, knowing which activity types you'll be crunching ahead of time will reduce the file size/time to complete accordingly.

[Calvin_Pineda]

Thanks for the response Sanford,

I didn't think about the Bulk Extract, thanks for the heads up. Also, you're correct, I should spend trying to identify what exact activity i'm looking for before getting our developer to perform any large extraction. Thanks again

- Calvin