Business digitalization
Today, even a small business has the ability to quickly launch advertising for any segment of the audience, set up several advertising channels and assess their real effectiveness in selling a product.
End-to-end business intelligence allows you to assess the return on investment in certain advertising channels. With its help, you can track the customer's path from the first advertising touch to the completion of a transaction, as well as repeat transactions.
With end-to-end analytics, the effectiveness of digital advertising increases. Companies that track everything and make data-driven decisions are winning the competition. Therefore, we can say that end-to-end analytics is vital.
Companies spend money on advertising, attract customers, make profits from the sale of their goods and services. It would be logical to apply ROI, or rather, ROMI, to internet marketing.
Return on Marketing Investment or ROMI for short is an indicator of the profitability of advertising campaigns and, in general, investments in marketing activities. Profitability operates with such metrics as payback, profit, return on investment.
Calculating ROMI is not as easy as it seems. Let's look at a simple example.
Report of the company LLC "Romashka" for January 2019:
Advertising costs: 120,000 rubles
Sales 700,000 rubles
Marginal income (excluding advertising investments) 210,000 rubles
ROMI is 75%. The coefficient is higher than 0, i.e. everything seems to be fine. But did we calculate everything correctly?
Imagine that a developer has built a new residential complex, created a website for it, and launched an advertising campaign. Here are the statistics for the first six months:
3 . ROMI , , . . , , , . , , , . .
, , - ROMI :
( )
. , ROMI, ROMI . : , , , .
, , . . 1 .
ROMI
, , , , ROMI. , , . ?
— , ROMI .
, 2 :
ROMI , , .. , . ROMI - « », .
ROMI — , . , ROMI, , , .
? :
: 10 000₽
: 30% (3000₽)
( ): 2,00%
100 10
, — .
, ROMI, . , ROMI , 1 . - , . , ROMI .
ROI ~200%. (LTV), . , 50% . ROI ~140%. , ROI.
? , ROI 100% . , : , . , ROI, .
30% . , . - ( ), , , . Google Analytics , LastClickWins, .. .
() .
1:
. . .
2:
1 . , . , LTV, CRM.
3:
. . , , , .
+ . .
— (ROMI) , , , (LTV).
:
KPI ;
, , ;
, ;
;
, , ;
, , .
(, Google Ads, ., Facebook), ( , - , .) CRM-, (Wikipedia).
, , . , , , . , .
.
. , , ecommerce — .
, 1-2 $ .
, . 1 , 3-5 . , , .
% (.. 100%). -.
• . , , .
• ( , ).
• LTV : .
, , .
. , , :
, . , .
, , , , , . , .
, , . % . Roistat 56%, 30% 200. 60 . .
1:
, , , , .
.. . , CRM-. !
, CRM «». , :
:
- , ;
— ;
;
( , ..) .
(`):
;
;
KPI .
2:
( ) . , . , :
.
. , . , API .
« ». , , . : CRM, .
, . CRM.
: . .
.
. , 1-2 , . , , :
— , ;
;
.
. . API.
( , , DWH), , — , Microsoft Power BI Google Data Studio.
:
;
, , , ;
— ;
— .
, , , , . , .
, . .
, , .
— , . , , .
, -, , , , .
, . , :
, , — ;
, ;
, — ;
— , — .
, Google Analytics, . . 6 .
First Click (FCM)
.
:
, . .
:
, . , .
:
, , . , .
Last Click (LCM)
, , . .
:
. , — , , .
:
, .
:
, .
Last Non-Direct Click (LN-DC)
, Google Analytics, . , , .
, , .
, . , , , .
:
, , .
.
:
, . , , , .
:
, , .
Position Based (PB)
, — , , — , . . .
:
, — .. .
:
, , , .
:
, .
Time Decay (TD)
, , . , — .
:
. , .
:
, .
:
, , — , .
Linear model (LM)
, .
:
, . , .
:
. .
:
. . — B2B-.
, , , LCM. LCM , , .
, , :
, . , , .
, .. , , .
. Google Analytics , , , -, ROPO- . .
, .
, .
, . , .
, , . , , .
3 :
1. « 1»
, :
CRM-
-
landing page
, (-, .)
-
:
LPTracker.ru
Expecto.me
CarrotQuest.io
PrimeGate.io
. 1. .
2.
, . CRM, - -. .
:
Roistat
Alytics
Comagic
Calltouch
. 5-20 . .
3.
. , , .
, :
(ETL, DWH)
( )
(, BI)
, :
-
CRM
, , ( CRM)
:
CRM
, API .
:
24
AmoCRM
RetailCRM
Microsoft Dynamics ( )
:
SalesForce
MicroSoft Dynamics
:
ClientID (Google Analytics), — , UserID ., CoMagic, .
:
:
Google BigQuery
Microsoft Azure Cosmos DB
ClickHouse
Amazon Redshift
, :
MySQL
MSSQL
PostgreSQL
:
;
(, Google Analytics, Google Data Studio, Microsoft Power BI, );
, :
— OWOX BI Pipeline
— Albato.ru
— apix-drive.com
— supermetrics.com.
:
BI-, :
— Google Data Studio
— Microsoft Power BI
— Qlik Sense / View
— Tableau
,
—, D3.js
:
(, Origami, Alytics, K50, Marilyn);
ERP, .
, . , . business analytics, business intelligence, ROMI analytics, LTV analytics. end-to-end analytics cross-cutting analytics, . , , .
, , :
— BI- , CRM , . CRM , . CRM , API. API, CRM.
CRM , , . CRM ERP. 1, , , CRM .
, , « 1 » , API, . . , CRM ( mo), (Roistat), (), SIP-, ( Livetex) — , .
— , , , 3 , . ( CRM, ) ( CRM ). , . ., Google.Ads , .
, . CRM ( ). , user_id. , (, CRM ..), , ROI .
. , - .
, :
. , , 1 .
-. .. — , , , , . .
/ . , . , , . . — , . , , , , - .
, — % . 0 ( ) 100% ( ). , , , , .
k-factor, .. — «». 0,5 , . ROMI LTV .
, BI- . .. -.
, !
Good luck with your end-to-end analytics implementation!