0% found this document useful (0 votes)
68 views13 pages

Company OKR Dashboard Overview

Uploaded by

Jessika López
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
68 views13 pages

Company OKR Dashboard Overview

Uploaded by

Jessika López
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

COMPANY INC.

Dashboard Global OKR


Dashboard Global OKR

Dashboard OKR by Department Global Goals Key Result Defined Level of Full Fulfillment
OKR Summary by Department 4 10 85.84%
OKR Inputs

Global OKR Inputs


Dashboard Global OKR
Sales
1200%
Marketing 1000%

Financial 800%

Commercial 600%

400%
HR
200%
Accounting
0%
How To el
s lio rs n
fo io
nn rt ne at
a o s ig liz
Settings ch p
de na
al
s em g io
it in at
Help & Support de nd
it n
g ru er
in te ec nt
rov Ex R I
p
Im

Global Goals January February March Progress %

Improving deals channels 43.14% 39.29% 44.43% 126.86%

Extend item portfolio 15.74% 21.85% 29.44% 67.04%

Recruiting designers 61.43% 20.36% 25.19% 106.98%

Internationalization 11.67% 19.17% 11.67% 42.50%


COMPANY INC.

Dashboard OKR by Department Select Department Financial


Dashboard Global OKR

Dashboard OKR by Department Global Goals Key Result Defined Level of Full Fulfillment
OKR Summary by Department 12 6 58.21%
OKR Inputs

Global OKR Inputs


Dashboard OKR by Department
Sales
1200%
Marketing
1000%
Financial

Commercial 800%
HR
600%
Accounting

How To 400%

Settings
200%
Help & Support

0%
Financial - Financial - Financial - Financial - Financial - Financial -
OKR3 Goal1 OKR3 Goal2 OKR3 Goal3 OKR3 Goal4 OKR3 Goal5 OKR3 Goal6

Global Goals January February March Progress %

Financial - OKR3 Goal1 14.34% 20.34% 18.01% 52.70%

Financial - OKR3 Goal2 11.43% 22.86% 17.62% 51.90%

Financial - OKR3 Goal3 8.00% 24.66% 36.91% 69.57%

Financial - OKR3 Goal4 13.11% 21.50% 20.84% 55.45%

Financial - OKR3 Goal5 11.11% 20.67% 16.11% 47.89%

Financial - OKR3 Goal6 12.40% 21.93% 37.41% 71.74%


COMPANY INC.

OKR Summary By Department


Dashboard Global OKR

Dashboard OKR by Department Sales Goals January February March Progress % Marketing Goals January February March Progress %

OKR Summary by Department Sales - OKR1 Goal1 14.43% 22.86% 24.29% 61.57% Marketing - OKR2 Goal1 12.40% 21.93% 37.41% 71.74%

OKR Inputs Sales - OKR1 Goal2 11.11% 20.67% 16.11% 47.89% Marketing - OKR2 Goal2 11.43% 22.86% 17.62% 51.90%

Global OKR Inputs Sales - OKR1 Goal3 8.93% 17.86% 14.88% 41.67% Marketing - OKR2 Goal3 8.51% 12.68% 20.53% 41.72%

Sales Sales - OKR1 Goal4 14.34% 20.34% 18.01% 52.70% Marketing - OKR2 Goal4 14.34% 20.34% 18.01% 52.70%

Marketing Sales - OKR1 Goal5 11.11% 22.22% 18.52% 51.85% Marketing - OKR2 Goal5 8.66% 23.17% 29.88% 61.71%

Financial Sales - OKR1 Goal6 8.51% 12.68% 20.53% 41.72% Marketing - OKR2 Goal6 8.51% 12.68% 20.53% 41.72%

Commercial

HR Financial Goals January February March Progress % Commercial Goals January February March Progress %

Accounting Financial - OKR3 Goal1 14.34% 20.34% 18.01% 52.70% Commercial - OKR4 GOAL1 11.11% 20.67% 16.11% 47.89%

How To Financial - OKR3 Goal2 11.43% 22.86% 17.62% 51.90% Commercial - OKR4 GOAL2 11.43% 22.86% 17.62% 51.90%

Settings Financial - OKR3 Goal3 8.00% 24.66% 36.91% 69.57% Commercial - OKR4 GOAL3 14.34% 20.34% 18.01% 52.70%

Help & Support Financial - OKR3 Goal4 13.11% 21.50% 20.84% 55.45% Commercial - OKR4 GOAL4 11.43% 22.86% 17.62% 51.90%

Financial - OKR3 Goal5 11.11% 20.67% 16.11% 47.89% Commercial - OKR4 GOAL5 8.51% 12.68% 20.53% 41.72%

Financial - OKR3 Goal6 12.40% 21.93% 37.41% 71.74% Commercial - OKR4 GOAL6 8.93% 17.86% 14.88% 41.67%

HR Goals January February March Progress % Accounting Goals January February March Progress %

HR - OKR5 GOAL1 8.51% 12.68% 20.53% 41.72% Accounting - OKR6 Goal1 11.43% 22.86% 17.62% 51.90%

HR - OKR5 GOAL2 11.43% 22.86% 17.62% 51.90% Accounting - OKR6 Goal2 8.00% 24.66% 36.91% 69.57%

HR - OKR5 GOAL3 8.93% 17.86% 14.88% 41.67% Accounting - OKR6 Goal3 8.51% 12.68% 20.53% 41.72%

HR - OKR5 GOAL4 11.43% 22.86% 17.62% 51.90% Accounting - OKR6 Goal4 12.40% 21.93% 37.41% 71.74%

HR - OKR5 GOAL5 8.51% 12.68% 20.53% 41.72% Accounting - OKR6 Goal5 8.93% 17.86% 14.88% 41.67%

HR - OKR5 GOAL6 12.40% 21.93% 37.41% 71.74% Accounting - OKR6 Goal6 8.00% 24.66% 36.91% 69.57%
COMPANY INC.

Global OKR
Dashboard Global OKR

Dashboard OKR by Department Goal Improving deals channels

OKR Summary by Department Type Key Result Quarterly Target January February March Progress %

OKR Inputs % Key 1 0.7 0.1 0.2 0.3 85.71%

Global OKR Inputs Number Key 2 500.00 100.00 200.00 50.00 70.00%

Sales $ Key 3 1,250.00 650.00 125.00 450.00 98.00%

Marketing

Financial

Commercial

HR Goal Extend item portfolio

Accounting Type Key Result Quarterly Target January February March Progress %

How To % Key 1 0.9 0.2 0.5 0.12 91.11%

Settings Number Key 2 200.00 50.00 20.00 150.00 110.00%

Help & Support

Goal Recruiting designers

Type Key Result Quarterly Target January February March Progress %

Number Key 1 257 150 25 95 105.06%

Number Key 2 685.00 245.00 124.00 57.00 62.19%

$ Key 3 884.00 254.00 114.00 45.00 46.72%

Goal Internationalization

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.8 0.12 0.14 0.2 57.50%

Number Key 2 500.00 100.00 200.00 50.00 70.00%

Goal

Type Key Result Quarterly Target January February March Progress %

Goal

Type Key Result Quarterly Target January February March Progress %


COMPANY INC.

Sales Department OKR


Dashboard Global OKR

Dashboard OKR by Department Goal OKR1 Goal1

OKR Summary by Department Type Key Result Quarterly Target January February March Progress %

OKR Inputs % Key 1 0.7 0.1 0.2 0.3 85.71%

Global OKR Inputs Number Key 2 500.00 145.00 200.00 150.00 99.00%

Sales

Marketing

Financial

Commercial

HR Goal OKR1 Goal2

Accounting Type Key Result Quarterly Target January February March Progress %

How To % Key 1 0.75 0.1 0.2 0.3 80.00%

Settings Number Key 2 600.00 120.00 212.00 50.00 63.67%

Help & Support

Goal OKR1 Goal3

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.8 0.1 0.2 0.3 75.00%

Number Key 2 700.00 100.00 200.00 50.00 50.00%

Goal OKR1 Goal4

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.85 0.1 0.2 0.3 70.59%

Number Key 2 800.00 250.00 300.00 150.00 87.50%

Goal OKR1 Goal5

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.9 0.1 0.2 0.3 66.67%

Number Key 2 900.00 200.00 400.00 200.00 88.89%

Goal OKR1 Goal6

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.95 0.1 0.2 0.3 63.16%

Number Key 2 1,000.00 150.00 170.00 300.00 62.00%


COMPANY INC.

Marketing Department OKR


Dashboard Global OKR

Dashboard OKR by Department Goal OKR2 Goal1

OKR Summary by Department Type Key Result Quarterly Target January February March Progress %

OKR Inputs % Key 1 0.3 0.05 0.1 0.2 116.67%

Global OKR Inputs Number Key 2 755.00 155.00 245.00 344.00 98.54%

Sales

Marketing

Financial

Commercial

HR Goal OKR2 Goal2

Accounting Type Key Result Quarterly Target January February March Progress %

How To % Key 1 0.7 0.1 0.2 0.3 85.71%

Settings Number Key 2 500.00 100.00 200.00 50.00 70.00%

Help & Support

Goal OKR2 Goal3

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.95 0.1 0.2 0.3 63.16%

Number Key 2 1,000.00 150.00 170.00 300.00 62.00%

Goal OKR2 Goal4

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.85 0.1 0.2 0.3 70.59%

Number Key 2 800.00 250.00 300.00 150.00 87.50%

Goal OKR2 Goal5

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.7 0.1 0.2 0.3 85.71%

Number Key 2 855.00 100.00 350.00 400.00 99.42%

Goal OKR2 Goal6

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.95 0.1 0.2 0.3 63.16%

Number Key 2 1,000.00 150.00 170.00 300.00 62.00%


COMPANY INC.

Global OKR
Dashboard Global OKR

Dashboard OKR by Department Goal OKR3 Goal1

OKR Summary by Department Type Key Result Quarterly Target January February March Progress %

OKR Inputs % Key 1 0.85 0.1 0.2 0.3 70.59%

Global OKR Inputs Number Key 2 800.00 250.00 300.00 150.00 87.50%

Sales

Marketing

Financial

Commercial

HR Goal OKR3 Goal2

Accounting Type Key Result Quarterly Target January February March Progress %

How To % Key 1 0.7 0.1 0.2 0.3 85.71%

Settings Number Key 2 500.00 100.00 200.00 50.00 70.00%

Help & Support

Goal OKR3 Goal3

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.65 0.08 0.23 0.3 93.85%

Number Key 2 855.00 100.00 330.00 552.00 114.85%

Goal OKR3 Goal4

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.95 0.1 0.3 0.5 94.74%

Number Key 2 1,215.00 350.00 400.00 120.00 71.60%

Goal OKR3 Goal5

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.75 0.1 0.2 0.3 80.00%

Number Key 2 600.00 120.00 212.00 50.00 63.67%

Goal OKR3 Goal6

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.3 0.05 0.1 0.2 116.67%

Number Key 2 755.00 155.00 245.00 344.00 98.54%


COMPANY INC.

Commercial Department OKR


Dashboard Global OKR

Dashboard OKR by Department Goal OKR4 GOAL1

OKR Summary by Department Type Key Result Quarterly Target January February March Progress %

OKR Inputs % Key 1 0.75 0.1 0.2 0.3 80.00%

Global OKR Inputs Number Key 2 600.00 120.00 212.00 50.00 63.67%

Sales

Marketing

Financial

Commercial

HR Goal OKR4 GOAL2

Accounting Type Key Result Quarterly Target January February March Progress %

How To % Key 1 0.7 0.1 0.2 0.3 85.71%

Settings Number Key 2 500.00 100.00 200.00 50.00 70.00%

Help & Support

Goal OKR4 GOAL3

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.85 0.1 0.2 0.3 70.59%

Number Key 2 800.00 250.00 300.00 150.00 87.50%

Goal OKR4 GOAL4

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.7 0.1 0.2 0.3 85.71%

Number Key 2 500.00 100.00 200.00 50.00 70.00%

Goal OKR4 GOAL5

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.95 0.1 0.2 0.3 63.16%

Number Key 2 1,000.00 150.00 170.00 300.00 62.00%

Goal OKR4 GOAL6

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.8 0.1 0.2 0.3 75.00%

Number Key 2 700.00 100.00 200.00 50.00 50.00%


COMPANY INC.

HR Department OKR
Dashboard Global OKR

Dashboard OKR by Department Goal OKR5 GOAL1

OKR Summary by Department Type Key Result Quarterly Target January February March Progress %

OKR Inputs % Key 1 0.95 0.1 0.2 0.3 63.16%

Global OKR Inputs Number Key 2 1,000.00 150.00 170.00 300.00 62.00%

Sales

Marketing

Financial

Commercial

HR Goal OKR5 GOAL2

Accounting Type Key Result Quarterly Target January February March Progress %

How To % Key 1 0.7 0.1 0.2 0.3 85.71%

Settings Number Key 2 500.00 100.00 200.00 50.00 70.00%

Help & Support

Goal OKR5 GOAL3

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.8 0.1 0.2 0.3 75.00%

Number Key 2 700.00 100.00 200.00 50.00 50.00%

Goal OKR5 GOAL4

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.7 0.1 0.2 0.3 85.71%

Number Key 2 500.00 100.00 200.00 50.00 70.00%

Goal OKR5 GOAL5

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.95 0.1 0.2 0.3 63.16%

Number Key 2 1,000.00 150.00 170.00 300.00 62.00%

Goal OKR5 GOAL6

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.3 0.05 0.1 0.2 116.67%

Number Key 2 755.00 155.00 245.00 344.00 98.54%


COMPANY INC.

Accounting Department OKR


Dashboard Global OKR

Dashboard OKR by Department Goal OKR6 Goal1

OKR Summary by Department Type Key Result Quarterly Target January February March Progress %

OKR Inputs % Key 1 0.7 0.1 0.2 0.3 85.71%

Global OKR Inputs Number Key 2 500.00 100.00 200.00 50.00 70.00%

Sales

Marketing

Financial

Commercial

HR Goal OKR6 Goal2

Accounting Type Key Result Quarterly Target January February March Progress %

How To % Key 1 0.65 0.08 0.23 0.3 93.85%

Settings Number Key 2 855.00 100.00 330.00 552.00 114.85%

Help & Support

Goal OKR6 Goal3

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.95 0.1 0.2 0.3 63.16%

Number Key 2 1,000.00 150.00 170.00 300.00 62.00%

Goal OKR6 Goal4

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.3 0.05 0.1 0.2 116.67%

Number Key 2 755.00 155.00 245.00 344.00 98.54%

Goal OKR6 Goal5

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.8 0.1 0.2 0.3 75.00%

Number Key 2 700.00 100.00 200.00 50.00 50.00%

Goal OKR6 Goal6

Type Key Result Quarterly Target January February March Progress %

% Key 1 0.65 0.08 0.23 0.3 93.85%

Number Key 2 855.00 100.00 330.00 552.00 114.85%


COMPANY INC.

How it Works
Dashboard Global OKR Step1: --> Settings Enter Company name (Optional)
Dashboard OKR by Department Enter Departments*
OKR Summary by Department Step2: --> OKR Inputs Enter Information for Global OKR and Departments* (all values are examples, you should delete and add your new values)
OKR Inputs (We do not recommend make changes in these cells)
Global OKR Inputs Step3: --> Dashboard Global OKR Will Show Global OKR result
Sales

Marketing Step4: --> Dashboard OKR By Departments Will OKR result by Departments
Financial

Commercial Step5: --> OKR Summary by Departments Will Show Summary OKR Result by Departments
HR

Accounting * - These values are important for calculations

How To

Settings Key Features


With this worksheet you will actually want to put together all the objectives and key aftereffects of your business as indicated by the approach Objectives and Key Results (OKR), which is an objective
Help & Support
administration structure created by Intel and later advocated by Google.
OKR Global

Decide by and large objectives for your business and what the key outcomes are for a quarter. At that point simply follow-up step by step and see the level of consummation of these objectives.

Key Objectives and Results of Areas


Notwithstanding the general business examination, it is important to characterize the OKRs for every one of the significant regions of your business. The thought is that these activities assist you with arriving at
the worldwide objectives.
OKR Areas Report

See the fulfillment level of the objectives set for every territory of ​your business with a shading design that encourages you see which ones are better and which ones are more awful.
Dashboard
OKR
Control board with the fundamental pointers and diagrams to follow the targets and objectives characterized. Here of ​the worksheet you will actually want to see the general finish level of your OKR.

OKR Methodology

We additionally carry a glossary with clarifications of the fundamental terms of the OKR and tips on the best way to make this philosophy work in your business.
COMPANY INC.

General Settings
Dashboard Global OKR

Dashboard OKR by Department Company Name: COMPANY INC.

OKR Summary by Department Quarter First Month: January

OKR Inputs

Global OKR Inputs Departments

Sales Sales

Marketing Marketing

Financial Financial

Commercial Commercial

HR HR

Accounting Accounting

How To

Settings

Help & Support


COMPANY INC.

Need assistance?
Dashboard Global OKR

Dashboard OKR by Department For support questions, email [email protected] anytime.

OKR Summary by Department For assistance in leveraging the models for individualized, personalized models to fit your business questions,

OKR Inputs details at https://finmodelslab.com/financial-modeling-forecasting/

Global OKR Inputs

Sales WARRANTIES & TERMS OF USE

Marketing Terms of Use and Warranties are located at https://finmodelslab.com/terms-of-service/

Financial Purchase, download, or use of this model signifies acceptance of terms specified at https://finmodelslab.com/terms-of-service/

Commercial Copyright 2021 Finmodelslab, LLC

HR

Accounting Questions, comments, ideas, email [email protected]

How To

Settings Finmodelslab, LLC

Help & Support https://finmodelslab.com

You might also like