Syncing Instantly Statuses from Master to Analytics Table Efficiently
I have a master prospecting table with ~11k rows that is currently connected to Instantly via the 'Find Leads' enrichment (with Auto-update enabled). To keep my master table clean, I want to create a separate Analytics/Reporting Table that only contains contacts enrolled in an active Instantly sequence. What is the most credit-efficient way to sync specific rows from my master table to this analytics table as soon as they are pushed to Instantly? Should I use a 'Lookup' column in the analytics table to pull live status integers from the master table, or is it better to use a 'Write to Other Table' automation from the master table? How can I ensure that the 'Auto-update' functionality for Instantly statuses continues to reflect in my separate analytics table without running duplicate enrichments?"
