ClearPoint migration: turning scorecards and measures into OKRs
Facts checked October 27, 2026
ClearPoint is built around scorecards, measures and the monthly report pack. Moving to an OKR tool changes the shape of the data as well as its home. A ClearPoint objective with six measures and a quarterly status becomes an OKIAR objective with a few key results and a weekly check-in. This guide covers ClearPoint's Excel, PDF and API exports, then how to decide which measures become key results and which become KPIs.
Steps 1 and 2 work for any destination. Steps 3 to 5 explain OKIAR.
Before you start: ClearPoint's data model in brief
ClearPoint's developer docs explain the pieces you'll be exporting:
- Elements. The default types are Scorecard, Category, Objective, Measure, Initiative, Milestone, Action Item and Risk. Your organisation may have renamed them, so "Goal" in your account might be an Objective underneath.
- Edit fields and update fields. Edit fields, like name, definition and owner, rarely change. Update fields, like actuals, targets, statuses and notes, belong to one reporting period.
- Reporting periods. Performance data is stored per period. When an API call names no period, most read endpoints fall back to the scorecard's default period.
That last point catches people out. Pick the period you're migrating before you export anything.
Step 1: Choose your ClearPoint exports
| Export | Where | Format | Holds | Use |
|---|---|---|---|---|
| Grid-style Summary Report | Scorecard & Elements, Manage Reports | Excel | The elements and columns the report shows | The import file |
| Measure data table | Scorecards & Elements, Manage Elements, Measures | Excel | One measure's series by period | Trend history |
| Any page | Menu next to the edit pencil | A formatted page | Archive | |
| Dashboard Summary Report | Report menu | PowerPoint | Charts and dashboards | Archive |
| Briefing Book | Documents, Templates | PDF with links | Several scorecards and reports together | The board pack record |
| REST API | app.clearpointstrategy.com/api/v1 | JSON | Scorecards, objectives, measures, initiatives and period data | Enterprise plan only |
All of these appear in ClearPoint's export guide, apart from the measure tables and the API. Exported files arrive by email, and past exports sit under Documents, Page Exports.
The Excel summary report
Follow the Summary Report export steps: open Scorecard & Elements, then Manage Reports, choose the report, open the menu beside the pencil and pick Export to Excel, then Generate. Pick a grid report whose columns include names, owners and the fields you need. You may need one export for objectives and another for measures. A grid sheet is the closest thing to an OKR file ClearPoint makes.
Measure history
If you want past actuals, export each measure's data table to Excel as well, per the measure data article. It's one file per measure, so pick the ones you'll keep tracking.
The API
The API comes with the Enterprise plan. You can read objectives and measures, then fetch period data per measure. Some endpoints return an error without a periodId. The OpenAPI file at apidoc.clearpointstrategy.com/openapi.json loads into Postman. ClearPoint also lists an MCP server for AI clients and a Zapier app.
Step 2: Separate OKRs from ongoing measures
Before you plan the move, sort the summary report row by row:
- Objectives to keep. Strategic objectives that still matter this year.
- Measures that should move. A measure with a target you want to hit this quarter becomes a key result.
- Measures you only watch. Revenue, headcount or a safety rate you track every month becomes a KPI.
- Leftovers. Flag owners who have left, and initiatives, milestones and action items you no longer need.
ClearPoint's statuses are set per period, so last month's red isn't this month's status. Note the latest one for reference only.
Moving to another strategy tool
If board-pack reporting is the reason you use ClearPoint, an OKR tool may be the wrong swap. Our ClearPoint alternatives page covers tools with more reporting depth. WorkBoard exports scorecards to CSV, PDF or PowerPoint, and our WorkBoard migration guide covers leaving it later.
Step 3: Rebuild the plan in OKIAR
OKIAR's goal import, described in the sign-up guide, reads Excel and CSV, multi-sheet workbooks included, plus PDF, Word, text and Markdown, up to 5 MB. It accepts Convert API output to CSV before upload. Owners, teams and parent links come through into a draft you edit before accepting. A Briefing Book PDF can be uploaded as well, though a clean Excel sheet gives a better draft.
- Sign up free. No card, and the beta has no user cap.
- Upload the trimmed summary report for the period you're starting with.
- Review the draft. Expect to rewrite some measure names as outcome key results.
- Turn scorecards into teams, then invite people as Admin, Manager, Contributor or Viewer.
- Nest department objectives under company ones.
- Give each key result a start value, current value, target, unit and direction.
- Add weights where one key result matters more. OKIAR supports weighting.
- Create KPIs for the measures you only watch, then connect Slack.
Where each ClearPoint field goes in OKIAR
| ClearPoint | OKIAR | Check |
|---|---|---|
| Scorecard | Team | Scorecards that exist only for reporting |
| Category | Description text, or a parent objective | Categories used as themes |
| Objective | Objective | Renamed element types |
| Measure with a target | Key result with start, target, unit and direction | Measures with no end date |
| Measure you only monitor | KPI | Monthly series |
| Actual for the period | Current value | Period you exported |
| Measure series history | Archive | Measure data table files |
| Initiative, Milestone | Key result, or keep in your project tool | Ones that are tasks |
| Action Item, Risk | Archive | Open risks someone owns |
| Owner | Owners; extra owners optional | People who left |
| Linked elements across scorecards | Parent link; pick one parent | Shared measures |
| Status for the period | Status from pacing | Colour scales that differ |
| Period analysis and notes | Archive; new notes go in check-ins | Commentary you'll miss |
| Reporting period | Period: quarter, year or custom | Monthly periods |
All 14 fields shown.
How OKIAR's statuses work
ClearPoint statuses are evaluated per period. OKIAR's, per the objective docs, come from pacing, which compares progress with what's expected by today. You can override them.
| OKIAR status | Pacing rule |
|---|---|
| On track | 0.7 or above |
| Behind | 0.4 to 0.69 |
| At risk | Below 0.4 |
| Not started, Closed, Abandoned | Set directly |
Step 4: Reporting and automation you'll replace
- Data Loader. ClearPoint's Data Loader loads data from Excel, CSV or SQL, and on Professional and Enterprise plans it can run on a schedule. OKIAR has nothing like it. Owners enter numbers in check-ins, or an assistant does through OKIAR's MCP server. It creates objectives, key results and KPIs, updates current values and files check-ins within the person's role and team.
- Teams. ClearPoint reaches Microsoft Teams through ClearBot. OKIAR has no Teams app. It has Slack and Telegram.
- Briefing Books and HTML reports. OKIAR doesn't produce board packs. Keep your last Briefing Book as the record.
Step 5: From monthly reporting to weekly check-ins
- Choose a check-in day and template for each team.
- Owners give progress, a confidence score from 0 to 10 and blockers, by voice or text.
- Leaders read the weekly summary in place of chasing updates before the monthly report.
- After a month, Insights shows pacing and recurring blockers.
Our weekly check-in template has five prompts to adapt.
Run your next quarter in OKIAR
Free during beta, with no credit card.
Frequently asked questions
What's the best ClearPoint export for moving to OKRs?
A grid-style Summary Report exported to Excel. Set it up to list objectives, owners and measures for one period.
Can I keep measure history?
Export each measure's data table to Excel and keep the files. OKIAR starts each key result from its current value.
Does OKIAR replace the Data Loader?
No. OKIAR has no scheduled data feeds. Numbers come in through check-ins or an assistant over MCP.
Will OKIAR rebuild our scorecards and reports?
Migration help is available. It does not recreate ClearPoint reports, charts or Briefing Books.
What does OKIAR cost?
It's free in beta, with no card and no caps on objectives, key results, KPIs or members. The beta has no set end date, and Okiar is already live today. A Pro plan is listed at "TBD/seat/month".
Leaving a Jira-based planning tool as well? Read the Jira Align migration guide, or see the
Quantive migration guide.
Rebuild this quarter's OKRs in OKIAR, free during beta
No credit card, no caps on objectives, key results, KPIs or team members. Goal import reads your ClearPoint Excel export.