Please enable JavaScript.
Coggle requires JavaScript to display documents.
New Owner Reconciliation. xlsx (New Acquisition (Own Channels Sheet: …
New Owner Reconciliation. xlsx
New Acquisition
Own Channels Sheet:
Total Kit offtake;1/2 kit purchase(EC, FSS, YD, DQ); Registered kit, User linked Registration & 1st Registration
(Source: Tableau-Data Tank)
EC (EC, Tele, LINE)
(Source: For New Owner Calc - First reg analysis.twb; For New Owner Calc - FSS_Sales Volume and Distribution.twb)
F2F
(Source: Nishimura-san)
LAMP
(Source: Nishimura-san)
FSS(Source: Morita-san)
YD
(Source: Kina-san)
DQ
(Source: Moo-san, Minamoto-san)
CVS
Estimated
Chain Split of
effective
offtake
FM kit offtake
(Source: Kito-san)
Estimated New owners (T-point)
"Active" effective owners (T-point)
Effective offtake (Total Est.)
Effective Offtake (T-point)
Offtake(T-point)
Total Kit offtake by device version
(Source: ACR_RRP Estimated Offtake Tracking_Week XX_2019.xlsx)
By Chains
By Device Version
Estimated
Chain Split of
ineffective
offtake
Estimated
New owners from CVS
Estimated
New owners % of total offtake (CVS)
New Owner per channel(2) Sheet
(
Source: ACR_RRP Estimated Offtake Tracking_Week XX_2019.xlsx
)
Linked with:
by Channel _Discount Own Channel Sheet
Est. New Owner Acquisition
Est. Kit Offtake
Est. Ineffective Purchases
Owner Acquisition % vs. Kit Offtake
Ineffective % vs. Kit Offtake
Effective Offtake
by Program(2) Sheet
: By Program.xlsx (Only cares about how many kits are sold in different programs/promotions)
Linked with:
By Program Sheet
FSS
(Source: Morita-san)
EC
(Source: For New Owner Calc - EC for Offtake by Program.twb)
CSC
(Source: Hara-san)
Self-lending
(Source: Hara-san)
RAF
(Source: Isomura-san)
Other Programs
(Source: Santo Maria-san)
YD
(Source: Kina-san)
FSF
(Source: Nishimura-san)
Upgraders
(3&M sheet)
Device Ownership
(PMI methodology - Registration Rate)
Registration data- Device Ownership_modified by BP&A.xlsx
(From Confluence SQL (new item names needed to discuss)
IQOS Pricing Offtake
(Bottom-up Approach - 3&M Bundles Offtake)
Own Channel Sheet
(Working file: Pricing offtake working file MMYY. xlsx)
EC
(Source: EC Order base_delivered and ongoing Weekly.twb, Santo-san)
FSS
(Source: Morita-san)
YD
(Source: Kina-san)
Price Master
(Source: Reports above and IQOS website)
Total Offtake Tracking by Channel and by Device versions
(Source:ACR_RRP Estimated Offtake Tracking_Week XX_2019.xlsx)