Skip to main content

Configuring your Targets / Business Goals

How to set targets for your key business KPIs — and see a target vs. actual comparison across your Klar reports.

Written by Frank Birzle

tl;dr

Set targets for your most important KPIs and Klar will show you a target vs. actual comparison directly in your reports. Wherever you see a "No Target" badge on a metric card, that metric is waiting for a target.

Targets are entered in a Google Sheet and synced into Klar. Two types of targets:

  • Absolute targets (e.g. Net Revenue, New Customers) — divided by the number of days in the period, shown as a daily target in your reports

  • Percentage targets (e.g. CM1%, MER) — applied as-is for the entire period

Targets appear in: Daily Overview, Profitability report and any report that shows metric cards with the "No Target" / "Set Target" indicator.


Step 1: Create a Targets sheet

  1. In the left sidebar, go to Store ConfiguratorData Sources

  2. Click Add Data SourceAdd New Data Source

  3. Select Targets

4. Enter a name (e.g. Targets DE) and click Create Google Sheet for Targets

5. Klar creates the sheet and connects it to your store. Click on the new datasource to open its detail page, then click Open Google Sheet

⚠️ Important: You can only connect one Targets sheet per store. Because some targets are percentage-based (e.g. CM1%, MER), combining multiple sheets isn't supported — the percentages would conflict. If you need different targets for different periods, add new date rows within the same sheet instead.


Step 2: Enter your targets

  1. Enter the Start Date and End Date for the target period

  2. Fill in your targets for each KPI column. Net Revenue, Marketing Spend, and New Customers are required. All other KPI columns are optional — but we recommend filling them in for the best target-comparison view. Each column header contains a detailed explanation

  3. Enter numbers without currency symbols, using a decimal point not a comma (e.g. 50000.00)

  4. Klar syncs the sheet multiple times per day. To trigger an immediate update, open the datasource detail page and click Sync Data

💡 Tip: You can define multiple date ranges in the same sheet — for example, different targets for Q1 and Q2. Just add a new row with the new Start/End Date and target values.


Where do targets appear?

Once synced, targets show up as a comparison line or indicator in:

  • Daily Overview — metric cards show actual vs. target and a "Set Target" link if not configured

  • Profitability report — target vs. actual comparison for margin metrics

  • Marketing reports — where applicable

Any metric card showing "No Target" means no target has been entered for that KPI yet.

Did this answer your question?