NOTE: We wrote this article before we changed our consumption-based pricing model on February 1, 2022. If you signed up for a new Fivetran account or renewed your existing account after January 31, 2022, you have an unlimited number of free customer-triggered re-syncs per connector each month. For more information about MAR usage, see our Consumption-Based Pricing page.
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.