DE_501

SaaS Revenue Model
Input 1 workflow

Properties source
Sources: prospetto

Code
DE_501
Description
SaaS Revenue Model
Web opening
NV
Type flags
Input
Groups
25 SaaS Model

Structure source
Sources: prospetto_xml

Form parameters
2
▾
Dimension Hierarchy Parameter
AZIENDA
Entity;fr=Entité 		› 010
All Entities 		› 03
Choose an Entity
SCENARIO
Scenario 		› $
Scenarios 		› SCE_BDG
Scenario for Budget
Form filters
5 dims
▾
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 03 param
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_045 Sales fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 055 SaaS fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
User Growth Model
Template00 · 3 matrices
▾
User Assumptions CPM
▾
Filters
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
040 SaaS Customers › CM_500 Generic Customer fixed
Rows
CONTOAccount;fr=Compte 5
▾
Hierarchy / FST Item Type TGKML
$ Account - Default view › ST_1300 Organic Growth fixed
$ Account - Default view › ST_1305 Customer Churn Rate fixed
$ Account - Default view › ST_1310 Social Media Driven Growth fixed
$ Account - Default view › ST_1315 Partner Driven Growth fixed
$ Account - Default view › ST_1320 Internal Incentivized Growth fixed
DEST2Products;fr=Produit 4
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
— › SAAS_02 Basic Solution fixed
— › SAAS_03 Advanced Solution fixed
— › SAAS_01 Freemium Solution fixed
Cols
LUNPER 1
▾
LUN_3
PERIODOPeriod 4
▾
03, 06, 09, 12
Growth Strategy CPM
▾
Filters
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
$ Account - Default view › ST_980 # of Contracts fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
040 SaaS Customers › CM_500 Generic Customer fixed
Rows
DEST2Products;fr=Produit 3
▾
Hierarchy / FST Item Type TGKML
— › SAAS_01 Freemium Solution fixed
— › SAAS_02 Basic Solution fixed
— › SAAS_03 Advanced Solution fixed
DEST5Miscellaneous;it=Miscellaneous 7
▾
Hierarchy / FST Item Type TGKML
SA_10 SaaS Contracts › SA_010 Moving Average Model fixed
SA_10 SaaS Contracts › SA_015 Regression Model fixed
SA_10 SaaS Contracts › ST_01 Baseline fixed
SA_10 SaaS Contracts › SA_020 Manual Adjustment fixed
SA_10 SaaS Contracts › LI_010 1 fixed
SA_10 SaaS Contracts › LI_015 2 fixed
SA_10 SaaS Contracts › LI_020 3 fixed
Cols
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
PERIODOPeriod 1
▾
12
TIP 2
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed
— › TIP_O fixed
CustomerBase CPM
▾
Filters
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
$ Account - Default view › ST_980 # of Contracts fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
040 SaaS Customers › CM_500 Generic Customer fixed
Rows
DEST2Products;fr=Produit 3
▾
Hierarchy / FST Item Type TGKML
— › SAAS_01 Freemium Solution fixed
— › SAAS_02 Basic Solution fixed
— › SAAS_03 Advanced Solution fixed
DEST5Miscellaneous;it=Miscellaneous 8
▾
Hierarchy / FST Item Type TGKML
SA_10 SaaS Contracts › SA_010 Moving Average Model fixed
SA_10 SaaS Contracts › SA_015 Regression Model fixed
SA_10 SaaS Contracts › ST_01 Baseline fixed
SA_10 SaaS Contracts › SA_020 Manual Adjustment fixed
SA_10 SaaS Contracts › LI_010 1 fixed
SA_10 SaaS Contracts › LI_015 2 fixed
SA_10 SaaS Contracts › LI_020 3 fixed
SA_10 SaaS Contracts › SA_101 fixed
Cols
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
LUNPER 1
▾
LUN_1
PERIODOPeriod 12
▾
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12
Revenue Growth Plan
Template01 · 6 matrices
▾
Setup Fees CPM
▾
Filters
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
— › ST_1325 Fixed Setup Fee fixed
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
040 SaaS Customers › CM_500 Generic Customer fixed
Rows
DEST2Products;fr=Produit 3
▾
Hierarchy / FST Item Type TGKML
— › SAAS_01 Freemium Solution fixed
— › SAAS_02 Basic Solution fixed
— › SAAS_03 Advanced Solution fixed
Cols
LUNPER 1
▾
LUN_3
PERIODOPeriod 4
▾
03, 06, 09, 12
Historical Accuracy CPM
▾
Filters
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
$ Account - Default view › ST_1330 Historical Accuracy fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
040 SaaS Customers › CM_500 Generic Customer fixed
Rows
SCENARIOScenario 2
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
$ Scenarios › 2017ACT 2017 Actuals fixed
DEST5Miscellaneous;it=Miscellaneous 3
▾
Hierarchy / FST Item Type TGKML
SA_10 SaaS Contracts › SA_101 fixed
SA_10 SaaS Contracts › SA_010 Moving Average Model fixed
SA_10 SaaS Contracts › SA_015 Regression Model fixed
Cols
LUNPER 1
▾
LUN_3
PERIODOPeriod 4
▾
03, 06, 09, 12
Monthly Revenue per User CPM
▾
Filters
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
— › ST_100 Purchase Price fixed
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
040 SaaS Customers › CM_500 Generic Customer fixed
Rows
DEST2Products;fr=Produit 3
▾
Hierarchy / FST Item Type TGKML
— › SAAS_01 Freemium Solution fixed
— › SAAS_02 Basic Solution fixed
— › SAAS_03 Advanced Solution fixed
Cols
LUNPER 1
▾
LUN_3
PERIODOPeriod 4
▾
03, 06, 09, 12
Revenues by Model CPM
▾
Filters
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › 50010 Product Sales fixed
LUNPER 1
▾
LUN_1
Rows
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
SCENARIOScenario 2
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
$ Scenarios › 2017ACT 2017 Actuals fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
040 SaaS Customers › CM_500 Generic Customer fixed
DEST5Miscellaneous;it=Miscellaneous 4
▾
Hierarchy / FST Item Type TGKML
SA_10 SaaS Contracts › NA NA fixed
SA_10 SaaS Contracts › SA_010 Moving Average Model fixed
SA_10 SaaS Contracts › SA_015 Regression Model fixed
SA_10 SaaS Contracts › SA_101 fixed
Cols
TIP 2
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed
— › TIP_O fixed
PERIODOPeriod 12
▾
12, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11
Customer Split CPM
▾
Filters
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
$ Account - Default view › ST_1000 Geo Split fixed
Rows
DEST3Customers;fr=Clients 3
▾
Hierarchy / FST Item Type TGKML
040 SaaS Customers › SA_01 General Public fixed
040 SaaS Customers › SA_02 Corporate fixed
040 SaaS Customers › SA_03 Government fixed
Cols
LUNPER 1
▾
LUN_3
PERIODOPeriod 1
▾
12
Break Back CPM
▾
Filters
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › 50010 Product Sales fixed
LUNPER 1
▾
LUN_1
Rows
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
DEST3Customers;fr=Clients 3
▾
Hierarchy / FST Item Type TGKML
040 SaaS Customers › SA_01 General Public fixed
040 SaaS Customers › SA_02 Corporate fixed
040 SaaS Customers › SA_03 Government fixed
Cols
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
PERIODOPeriod 12
▾
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12
Operational Details
Template02 · 0 matrices
▾

Used in Workflows 1 source
Sources: RACCOLTA_AZIENDA_WFM, WFM task list

Workflow Phase Task list Task description
BDG Annual Budget Workflow 10_RV Revenue / COGS Plan REVP Revenue Planning Subscription Based