In this document, you will learn how monthly active rows (MAR) are calculated, how to track your MAR, and how to optimize your usage.
Our pricing model is based on consumption. You purchase a block of credits meant to last a year. Each month, we calculate your consumption of credits based on your monthly active rows across all connectors and destinations in your account.
You can use any Fivetran connectors you want and add or remove connectors over time. You can likewise add or remove destinations. Your credits will be consumed based on your MAR, with no difference between connectors. Connectors will use varying MAR based on the data that is being added or changed in the source system and the sync strategy that Fivetran has selected.
As your monthly usage increases, the cost per row declines automatically, so if your usage is higher than you expected, you'll get a better rate without having to renegotiate. Usage can vary depending on the number of re-syncs initiated or connectors added or removed during that period.
We calculate your monthly active rows based on the number of distinct primary keys we sync across all the connectors in your account. We only count a row once per calendar month, even if it syncs multiple times.
To understand what monthly active rows mean, and how they differ from monthly synced rows, consider the following simplified example.
Suppose you have a small table with a primary key id and one attribute, counter:
Suppose you update counter from 3 to 4 in row c:
This operation generates 1 active row. Now suppose you update the same counter again in the same month:
This is still just 1 active row for this month. On the other hand, if you update row a, then you have 2 active rows:
With MAR-based pricing, you don’t pay multiple times for updates on the same row in the same month. It doesn’t matter how many times a row is updated in a month. Other popular row-based pricing models, such as monthly synced rows, would charge you multiple times in that situation. Fivetran does not.
We sync most connectors using incremental updates. Only new or updated rows are updated during each sync. Thus, you only pay for a subset of the data in the source every month. What percentage of a table or a connector is imported per month depends on how you use your source system. Some customers modify only new records. Then, only a small percentage of the table or connector is imported per month. Other customers modify years-old records every sync. That causes a very high percentage of the tables to be monthly active rows.
Initial historical syncs
Initial historical syncs do not count towards monthly active rows. That means when you first create a connector and sync all the historical data in your source, we don’t charge for those syncs. However, if you re-sync all your historical data later, we do charge for that historical re-sync. This does not only apply to trials. We exclude the initial historical sync whenever you add a new connector to your account.
Re-syncs and re-imports
Re-syncs do count towards monthly active rows, including re-syncs that Fivetran initiates. Both table- and connector-level re-syncs count. Monitoring data integrity issues and performing re-syncs to fix them when needed is part of our managed service. We only perform, or ask you to perform, re-syncs when it’s absolutely necessary.
If a connector or table is re-imported, all the rows in the table or connector counts towards monthly active rows. During a re-import, all primary keys for a table pass through Fivetran.
Automated schema migrations
When a new table is added to a connector, every row in that table contributes to your MAR. Likewise, when a new column is added to a table, every row in that table counts as an active row. It counts both if you manually choose to sync a new table or column in a connector, and if Fivetran automatically adds a new table or column to a connector as part of automated schema migration.
Multiples of the same connector type
Each connector in your account contributes towards your monthly active rows. It is not the connector type but the instance of the connector that matters. Even if the connectors sync the same data from the same source (with the same primary keys), they still contribute separately towards your MAR.
Same source, multiple destinations
If you have two or more of the same connector type that sync from one source to multiple destinations, each connector’s active monthly rows are counted separately. For example, if you have two Salesforce connectors, where one syncs to your staging warehouse and the other to production, each of those connectors's MAR is counted separately.
Tables without primary keys
If a table doesn’t have a primary key, we create a synthetic (hash) primary key. The composition of this primary key differs by source. For example, for Facebook Ad Insights, we use the
breakdowns (that is, date, ad_id, and age) to create a synthetic primary key. MAR for these tables is based on their synthetic primary keys.
Changes to primary keys
If the primary key changes type, it doesn't affect MAR. Similarly, in a table without a primary key, if the columns from which we generate synthetic (hash) primary key change data type, it also doesn't affect MAR.
In a table without a primary key, removing or adding columns from which we generate the synthetic primary key does affect MAR. The synthetic primary key is a hash of values of the columns defined for that table, so if those columns change, the primary key changes. Since MAR is based on unique primary keys, each of the rows in the table counts towards MAR. See also Tables without primary keys.
Transformations do not count towards monthly active rows, because transformations happen in your destination after the data is delivered. Monthly active rows only count the rows Fivetran delivers, not events in the destination.
Monitoring MAR and credit consumption
You can monitor your consumption in two ways: using the billing section of your Fivetran dashboard or using the Fivetran Log connector. The Fivetran Log connector loads your MAR data into your destination, where you can run analyses on it just like you do with any other data. The billing section in your Fivetran dashboard offers a visual representation of your usage and is updated daily.
Using your Fivetran dashboard
If you are an account owner, log in to your Fivetran dashboard and go to the billing section.
The bar graph at the top of your billing dashboard shows at a glance how many credits you have used and how many you have left for the duration of your contract.
Underneath the billing overview graph, you can see which plan you are on and an overview of the available billing plans.
Month-to-date active rows and credits used
Following the plan breakdown, you can see how many active rows you have consumed in the current month so far (month-to-date active rows) and how many credits you have used (month-to-date credits used). If you used between 0 and 500,000 monthly active rows, you will see 500 month-to-date credits used, which is the minimum rate. After you use 500,000 active rows, we will charge you at the normal rate for your plan. See the Fivetran Service Consumption Table to learn about MAR and credit consumption rates.
Monthly active rows over time
The chart displays your monthly active rows over time so that you can see trends in your consumption.
Monthly active rows per connector
The table lists monthly active rows per connector across all destinations in your account and the percentage of your MAR that they constitute. You can select the timeframe that you want to view.
Using the Fivetran Log Connector
The Fivetran Log Connector includes table-level MAR across all connectors in your destination in the
ACTIVE_VOLUME table. Review MAR at the table level to understand what is driving the overall MAR within your account.
Optimizing your credit consumption
Higher usage automatically gives you a better rate
Fivetran automatically optimizes certain aspects of your credit consumption. The number of credits per row declines as monthly usage increases. We apply that better rate automatically. See the Fivetran Service Consumption Table to learn about MAR and credit consumption rates.
Replication frequency doesn’t matter
Replication frequency makes no difference to your monthly active rows because MAR is based on how many unique rows are updated, not on how many updates occur. Maintain whatever replication frequency best serves your business needs.
Reducing MAR by blocking schemas or tables
You can reduce your monthly active rows by blocking schemas or tables from syncing if they don’t contain valuable information. The monthly active rows per connector chart in your billing dashboard shows you which connectors have the highest usage. The Fivetran Log Connector shows consumption by table to help guide these decisions. However, not all connectors support blocking schemas or tables.
Reducing MAR by blocking columns in tables without primary keys
This optimization is rare and not relevant to most customers. Column blocking only makes a difference for tables without a primary key. Because we create a synthetic primary key for these tables (see Tables without primary keys), you can reduce your MAR if you block a commonly-changing column which is used as part of the synthetic primary key. However, not all connectors support column blocking.
Connector-specific functional differences
We follow the same base principle across all our connectors to calculate MAR. MAR calculations for some connectors can be a little tricky to understand because the peculiarities of their sources require tailored sync strategies.
Azure Blob Storage and S3
We capture the file's last modified date, which lets us determine if a file has been updated in the source. When we detect an update in the source, we re-sync the entire file. That means each row in the source counts towards monthly active rows. However, if the file is updated multiple times in a month, its rows only count toward monthly active rows once.
When you upload a new file in our browser-based CSV uploader, we count that new data as MAR. There is no concept of a free initial historical sync. However, we do not count monthly active rows twice if the same file is uploaded again. Only the newly added rows contribute to MAR.
File connectors (except S3 and Azure Blob Storage)
These file sources don't provide change-tracking data to help us determine if the file has been updated in the source. As a result, Fivetran re-syncs the entire file every time a sync is scheduled. That means each row in the source counts towards monthly active rows. However, if the file is updated multiple times in a month, its rows only count toward monthly active rows once.
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 in our HubSpot documentation. Thes re-syncs increase consumption for HubSpot.
Netsuite Suite Analytics
We use a hybrid approach to determine the overall MAR for NetSuite:
We incrementally update tables with a modified timestamp. The incrementally updated rows count towards monthly active rows.
We use a checksum to incrementally capture deletes. The data ranges of each table where changes are occurring count towards monthly active rows.
We re-import the tables that can’t be incrementally updated. The entire re-imported table counts towards monthly active rows.
We only sync new records for
SYSTEM_NOTES_CUSTOMtables. Only records created in the calendar month are considered as monthly active rows.
TRANSACTION_LINEStables are incrementally updated. We don't recommend frequently updating the historical records for the
TRANSACTION_LINEStable, as this significantly increases the count of monthly active rows.
When you add a new column to an Oracle table that Fivetran is syncing, we always trigger a table re-sync. Changes to the table structure interfere with LogMiner and force us to re-sync the table.
Using XMIN instead of WAL in your PostgreSQL connector will have negligible impact on MAR consumption. XMIN does not capture deletes, so MAR could be slightly lower in comparison.