Adding Data Manually

Manual data entry provides a straightforward way to collect data from your users, enabling you to quickly populate Dashboards, Reports, and Analytics.

Contents

Entering Data

Entering KPI data in SimpleKPI is designed to be intuitive and efficient. The data entry page features a clean, spreadsheet-style layout that allows you to quickly input information and seamlessly tab between fields.

Spreadsheet-style data entry interface in SimpleKPI
  1. Select KPIs by frequency, such as Daily, Weekly, or Monthly, using the corresponding tabs.
  2. Each KPI displays its name, target (if applicable), target %, trend, and any associated notes.
  3. Enter data in the "Actual" column to record values for your KPIs.

The Target % and Trend are calculated automatically, and data is saved in real-time without requiring manual saves.

Use the KPI category drop-down filter to organize KPIs by category.

To update historic data, navigate using the calendar control and adjust the entries as needed.

Selecting Dates

Dates are determined by the frequency of your KPIs (e.g., daily, weekly, monthly). The interface includes tabs to organize KPIs based on these frequencies.

Date selection control in SimpleKPI data entry interface
  1. To select a date, click the calendar control.
  2. The default date is set to today’s date.
  3. To change the date, use the arrow and drop-down controls to navigate through months and years, then select a specific date.
Calendar control in SimpleKPI for selecting dates

Use the navigation arrows before and after the date to move between entry periods.

Choosing Other Users' KPIs

Managers, Directors, Admins, and Owners can select another user's KPI sheet and enter data on their behalf.

Dropdown menu for selecting other users' KPIs in SimpleKPI
  1. Select the user’s name from the drop-down menu.
  2. Choose the user you want to view or edit.
  3. The selected user’s KPIs will appear in the KPI list.
  4. To switch users, repeat the process using the drop-down menu.

Adding Notes

Notes can be added to any data entry and will appear in reports and certain dashboard views.

  1. Click the note icon next to the KPI to add a note.
  2. Enter your note and click Done.
  3. The note icon will highlight, indicating a note has been added.
  4. To delete a note, click the note icon, clear the contents, and click Done.

Changing Targets

Certain user roles allow targets to be updated directly from the KPI entry sheet, which is useful for seasonal or changing targets.

  1. Click the target field and enter a new value.
  2. The updated target is automatically saved and applied to the KPI.

Importing Data from Excel

You can import data directly from Excel via the KPI Entry screen.

Learn more about importing data from Excel here.

Multiple Entry View

The data entry page layout can be switched to a multi-entry view, allowing you to input data for multiple time periods simultaneously.

Multi-period data entry view in SimpleKPI

To enable the multi-entry view, click the view toggle button.

View toggle button for multi-period data entry in SimpleKPI

Data entry functions similarly to the single view, but you can input values for several periods at once. Target information is displayed below the actual entry data.

Changing dates, scrolling through periods, and selecting KPI categories work the same way as in single view.

Note: The notes feature is disabled in multi-entry view. To add notes, toggle back to single view.