| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104 |
- package com.cyksj.model.excel;
- import com.alibaba.excel.annotation.ExcelProperty;
- import lombok.Getter;
- import lombok.Setter;
- import lombok.experimental.Accessors;
- import java.math.BigDecimal;
- /*
- *项目名: netflix
- *文件名: ExcelMonthOrderData
- *创建者: JavaZou
- *创建时间:2023/7/26 17:16
- */
- @Getter
- @Setter
- @Accessors(chain = true)
- public class ExcelMonthOrderData {
- @ExcelProperty({"品类数据类", "奈飞续费数据", "A.当月到期所有用户数"})
- private Integer monthNfExNumOfUser;
- @ExcelProperty({"品类数据类", "奈飞续费数据", "B.A数据中主动续费的用户数"})
- private Integer monthNfExRenewNumOfUser;
- @ExcelProperty({"品类数据类", "奈飞续费数据", "C.A数据中,没有主动续费,但又购买奈飞的用户数"})
- private Integer monthNfExRePayNumOfUser;
- @ExcelProperty({"品类数据类", "奈飞续费数据", "D.非当月到期,但续费的用户数"})
- private Integer monthNfNoExRenewNumOfUser;
- @ExcelProperty({"品类数据类", "AI类续费(gptplus月付)", "A.月付当月到期的所有用户数"})
- private Integer monthAiGptExNumOfUser;
- @ExcelProperty({"品类数据类", "AI类续费(gptplus月付)", "B.A数据中主动续费的用户数"})
- private Integer monthAiGptExRenewNumOfUser;
- @ExcelProperty({"品类数据类", "AI类续费(gptplus月付)", "C.A数据中,没有主动续费,但又购买对应品类的用户数"})
- private Integer monthAiGptExRePayNumOfUser;
- @ExcelProperty({"品类数据类", "AI类续费(gptplus月付)", "D.非当月到期,但续费的用户数"})
- private Integer monthAiGptNoExRenewNumOfUser;
- @ExcelProperty({"品类数据类", "AI类续费(midjourney月付)", "A.月付当月到期的所有用户数"})
- private Integer monthAiMidExNumOfUser;
- @ExcelProperty({"品类数据类", "AI类续费(midjourney月付)", "B.A数据中主动续费的用户数"})
- private Integer monthAiMidExRenewNumOfUser;
- @ExcelProperty({"品类数据类", "AI类续费(midjourney月付)", "C.A数据中,没有主动续费,但又购买对应品类的用户数"})
- private Integer monthAiMidExRePayNumOfUser;
- @ExcelProperty({"品类数据类", "AI类续费(midjourney月付)", "D.非当月到期,但续费的用户数"})
- private Integer monthAiMidNoExRenewNumOfUser;
- @ExcelProperty({"品类数据类", "流媒类复购数据", "A.购买流媒体类产品为首单的当月新用户"})
- private Integer monthStreamingNewNumOfUser;
- @ExcelProperty({"品类数据类", "流媒类复购数据", "B.A用户中购买第二单任何产品的用户数"})
- private Integer monthStreamingNewPayOtherNumOfUser;
- @ExcelProperty({"品类数据类", "流媒类复购数据", "C.A用户中购买第二单AI产品的用户数"})
- private Integer monthStreamingNewPayAiNumOfUser;
- @ExcelProperty({"品类数据类", "AI类复购数据", "A.购买AI类产品为首单的当月新用户"})
- private Integer monthAiNewNumOfUser;
- @ExcelProperty({"品类数据类", "AI类复购数据", "B.A用户中购买第二单任何产品的用户数"})
- private Integer monthAiNewPayOtherNumOfUser;
- @ExcelProperty({"品类数据类", "AI类复购数据", "C.A用户中购买第二单流媒体产品的用户数"})
- private Integer monthAiNewPayStreamingNumOfUser;
- @ExcelProperty({"用户维度", "当月新用户", "订单量"})
- private Integer monthlyNewUserOrders;
- @ExcelProperty({"用户维度", "当月新用户", "金额"})
- private BigDecimal monthlyNewUserOrdersMoney;
- @ExcelProperty({"用户维度", "当月之前老用户", "订单量"})
- private Integer monthlyBeforeUserOrders;
- @ExcelProperty({"用户维度", "当月之前老用户", "金额"})
- private BigDecimal monthlyBeforeUserOrdersMoney;
- // @ExcelProperty({"历史复购","有奈飞车票的人数"})
- // private Integer nfTicketNumOfUser;
- //
- // @ExcelProperty({"历史复购","有AI账号车票人数"})
- // private Integer aiTicketNumOfUser;
- //
- // @ExcelProperty({"历史复购","二者交叉人数"})
- // private Integer nfAiTicketNumOfUser;
- //
- // @ExcelProperty({"私域数据类", "目前私域中,下过单的用户数(以第一次下单类型为准)", "流媒体类用户数"})
- // private Integer monthPrivateStreamingNumOfUser;
- //
- // @ExcelProperty({"私域数据类", "目前私域中,下过单的用户数(以第一次下单类型为准)", "AI类用户数"})
- // private Integer monthPrivateAiNumOfUser;
- //
- // @ExcelProperty({"私域数据类", "目前私域中,下过单的用户数(以第一次下单类型为准)", "设备类用户数"})
- // private Integer monthPrivateEqNumOfUser;
- }
|