How would I find all contact that have moved to or from Canada?

Troy Wolbrink — Fri, 13 May 2022 16:17:14 GMT

Current revision posted to Frequently Asked Questions by Troy Wolbrink on 5/13/2022 4:17:14 PM

On the Contacts view, under the "Change Log" tab, you can see an audit trail of all changes made to a contact, when they were made, and by whom.

You can use this information in a custom lookup to find contacts that had a field change relating a state or country, for example.

To lookup all contacts that have moved to or from Canada, under the "Lookup" menu, click on "General" and then "Custom".

Enter this custom lookup:

ContactID IN (Select ContactID FROM ContactChangeLog

WHERE OldValue like '%Canada%')