We have 12K pus companies and approx 220K active contact/memberships. Have tried using Company → Contact associations, but unable to even track start/end dates with those. Have asked HubSpot to allow for adding properties to the association “labels” but they don’t seem interested. Have also tried setting up Memberships as a custom object and associating the object to both the company and the contact with association labels (Active/Inactive/Archived Member). We have both private and public companies. Public companies issue membership expiration dates, so I can create a workflow to handle updating those labels when the expiration date hits. Private companies don not have expiration date and we are dependent on our membership platform to notify us via a webhook. All fine, except when you look at the amount of transactions needed to keep these up to date …
New Member takes 5 transactions …
1. Create the Contact Record
2. Search the Companies for the company ID
3. Create the Membership Record.
4. Create the Contact → Membership Association
5. Create the Company → Membership Association
Renewal, Inactivation, Etc takes
1. Contact Search for ID (needed for step 3 and 4)
2. Comany Search for ID (needed to step 3 and 5)
3. Membership Search for ID (need for step 4, 5, 6)
4. Contact → Membership Association Search for ID
5. Contact → Company Association Search for ID
6. Update the Membership Record
7. Potential need to update the Contact → Membership Association Label
8. Potential need to update the Company → Membership Association Label
9. Potential need to update the Contact record
Anyway -- this causes us to constantky run up against the API limits
Thanks again for any advice!