Understanding how the Google Sheets connector affects MAR
Google Sheets Connector Overview
- Google Sheets is a file connector.
- A named range is required to sync data in the Google Sheet
- Upon each subsequent incremental sync the entire named range is scanned and any changes are reflected in the destination
What Contributes Towards MAR?
The following actions contribute to MAR:
- The first sync of a new month activates all records
- A new record is inserted into the Google Sheet
Managing MAR for this Connector
- The first sync will not incur any MAR, but any subsequent sync after a new row is inserted or a row is updated, will cause all rows to become active
- Initial sync with 100 rows, MAR: 0
- Subsequent sync with the same 100 rows, MAR: 0
- Subsequent sync with 1 new row, MAR: 101
- This implies that an initial MAR spike will occur towards the beginning of the month, where all records in the sheet become active. This means only net new rows will contribute to any additional MAR.
- You can control over which portion of the Google Sheet to sync via a named range.
- Choose the data that is the most valuable to you analytically and exclude any data that frequently changes and doesn’t serve your analytical needs