Contents:
💡Pro Tip: This article is about updating non-financial data in Fathom. For more information on importing non-financial data for the first time, please see our ‘Non-financial KPIs’ article.
Updating from Google Sheets
By default, automatic updates are turned off for non-financial KPIs sourced from Google Sheets. If automatic updates are turned on, then the non-financial results will be updated once every 24 hours.
If changes have been made to the non-financial data in Google Sheets recently, then a manual sync is needed to bring the changes over.
|
You’re also able to manually type data entries into Fathom for KPIs sourced from Google Sheets for any periods that do not already have values. Any manual entries will only exist in Fathom and will not be sent to the connected Google Sheet.
If you have manually entered in results for KPIs sourced from Google Sheets, this data will be written over once the Google Sheet contains data for the period. Any empty cells in Google Sheets will write over data manually entered in Fathom as long as there is data entered anywhere in the period column.
How we handle empty period columns
For period columns in Google Sheets that are completely empty of non-financial data, then Fathom will import the results only if there are results on either side of the period.
Example: In Google Sheets, you have entered KPI results for April and June. There are no entries for May. Because null results are valid results, Fathom will assume all results for May are null and will import them. |
For empty periods on either end of a data set, Fathom will not import null results and instead assumes that there is no data for those periods rather than null results.
Turning automatic updates on or off
Automatic updates for KPI results sourced from a Google Sheet are not on by default.
To turn on automatic updates,
|
Sync schedules are set on a connection-by-connection basis. Meaning you can have some Google Sheet connections scheduled to update automatically and others set for manual syncing only.
Updating from Excel
Because Fathom does not maintain a connection with an Excel file like it does with a Google Sheet, it is not possible to have automatic updates for non-financial results imported from Excel. Manual updates must be performed.
To update non-financial results from Excel,
|
Your KPI results will be updated in Fathom.
Updating results manually
Fathom enables you to manually update results for non-financial KPIs created in Fathom or for KPIs with results sourced from Excel or Google Sheets.
To update non-financial results from Excel,
|
❗Note: Results sourced from Google Sheets can only have data entered manually for periods that have not already been synced from Google Sheets. These data will be overwritten once the period is synced from the connected Google Sheet(s).
Additional knowledge & common questions: