Credit-Efficient Syncing to Analytics Table
Recommended Approach: Write to Other Table
Use Write to Other Table from your master table instead of Lookup columns. This is the most credit-efficient method.
Setup Steps
- Configure Write to Other Table with conditional triggers using "Only run if"
- Set the condition to trigger when contacts are successfully enrolled (e.g., when status changes to "enrolled")
- Enable Auto-update to automatically process new rows
Why This Works
- Avoids duplicate enrichments since you're copying existing data rather than re-enriching
- Analytics table receives updates automatically whenever master table statuses change
- No credit consumption on repeated runs
Why Not Lookup Columns
Lookup columns consume credits each time they run and aren't suitable for real-time syncing to analytics tables.
Additional Resource
Use Sculptor (top-right corner) to help build this workflow at no additional cost—it can quickly set up the automation for you.
Documentation