You want to understand how the functioning of HubSpot connectors affects Monthly Active Rows (MAR).
TIP: Click the links above to view the entity relationship diagrams (ERDs) for the HubSpot Marketing and Sales/CRM tables.
There are four primary actions that contribute to MAR:
- Size of the HubSpot account source data set
- HubSpot API constraints regarding deleted data. Our HubSpot connector re-syncs several tables every day because the HubSpot API does not offer a mechanism to capture deletes. By re-syncing these tables, we can infer deletes. Learn more about the tables we infer deletes from and their update frequency in our HubSpot documentation. These re-syncs increase MAR.
- Syncing the
CONTACT_PROPERTY_HISTORYtable typically contributes to higher MAR because of its size
- Syncing tables that contain data that may not be useful for your analysis
Before you run your initial sync, we recommend that you review the tables included in the standard HubSpot schema that Fivetran will create. You can find this schema on the Schema tab of the Fivetran dashboard. On the Schema tab, you can block any tables containing data that you do not need, which helps you control your MAR.