ExcelMonthOrderData.java 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
  1. package com.cyksj.model.excel;
  2. import com.alibaba.excel.annotation.ExcelProperty;
  3. import lombok.Getter;
  4. import lombok.Setter;
  5. import lombok.experimental.Accessors;
  6. import java.math.BigDecimal;
  7. /*
  8. *项目名: netflix
  9. *文件名: ExcelMonthOrderData
  10. *创建者: JavaZou
  11. *创建时间:2023/7/26 17:16
  12. */
  13. @Getter
  14. @Setter
  15. @Accessors(chain = true)
  16. public class ExcelMonthOrderData {
  17. @ExcelProperty({"品类数据类", "奈飞续费数据", "A.当月到期所有用户数"})
  18. private Integer monthNfExNumOfUser;
  19. @ExcelProperty({"品类数据类", "奈飞续费数据", "B.A数据中主动续费的用户数"})
  20. private Integer monthNfExRenewNumOfUser;
  21. @ExcelProperty({"品类数据类", "奈飞续费数据", "C.A数据中,没有主动续费,但又购买奈飞的用户数"})
  22. private Integer monthNfExRePayNumOfUser;
  23. @ExcelProperty({"品类数据类", "奈飞续费数据", "D.非当月到期,但续费的用户数"})
  24. private Integer monthNfNoExRenewNumOfUser;
  25. @ExcelProperty({"品类数据类", "AI类续费(gptplus月付)", "A.月付当月到期的所有用户数"})
  26. private Integer monthAiGptExNumOfUser;
  27. @ExcelProperty({"品类数据类", "AI类续费(gptplus月付)", "B.A数据中主动续费的用户数"})
  28. private Integer monthAiGptExRenewNumOfUser;
  29. @ExcelProperty({"品类数据类", "AI类续费(gptplus月付)", "C.A数据中,没有主动续费,但又购买对应品类的用户数"})
  30. private Integer monthAiGptExRePayNumOfUser;
  31. @ExcelProperty({"品类数据类", "AI类续费(gptplus月付)", "D.非当月到期,但续费的用户数"})
  32. private Integer monthAiGptNoExRenewNumOfUser;
  33. @ExcelProperty({"品类数据类", "AI类续费(midjourney月付)", "A.月付当月到期的所有用户数"})
  34. private Integer monthAiMidExNumOfUser;
  35. @ExcelProperty({"品类数据类", "AI类续费(midjourney月付)", "B.A数据中主动续费的用户数"})
  36. private Integer monthAiMidExRenewNumOfUser;
  37. @ExcelProperty({"品类数据类", "AI类续费(midjourney月付)", "C.A数据中,没有主动续费,但又购买对应品类的用户数"})
  38. private Integer monthAiMidExRePayNumOfUser;
  39. @ExcelProperty({"品类数据类", "AI类续费(midjourney月付)", "D.非当月到期,但续费的用户数"})
  40. private Integer monthAiMidNoExRenewNumOfUser;
  41. @ExcelProperty({"品类数据类", "流媒类复购数据", "A.购买流媒体类产品为首单的当月新用户"})
  42. private Integer monthStreamingNewNumOfUser;
  43. @ExcelProperty({"品类数据类", "流媒类复购数据", "B.A用户中购买第二单任何产品的用户数"})
  44. private Integer monthStreamingNewPayOtherNumOfUser;
  45. @ExcelProperty({"品类数据类", "流媒类复购数据", "C.A用户中购买第二单AI产品的用户数"})
  46. private Integer monthStreamingNewPayAiNumOfUser;
  47. @ExcelProperty({"品类数据类", "AI类复购数据", "A.购买AI类产品为首单的当月新用户"})
  48. private Integer monthAiNewNumOfUser;
  49. @ExcelProperty({"品类数据类", "AI类复购数据", "B.A用户中购买第二单任何产品的用户数"})
  50. private Integer monthAiNewPayOtherNumOfUser;
  51. @ExcelProperty({"品类数据类", "AI类复购数据", "C.A用户中购买第二单流媒体产品的用户数"})
  52. private Integer monthAiNewPayStreamingNumOfUser;
  53. @ExcelProperty({"用户维度", "当月新用户", "订单量"})
  54. private Integer monthlyNewUserOrders;
  55. @ExcelProperty({"用户维度", "当月新用户", "金额"})
  56. private BigDecimal monthlyNewUserOrdersMoney;
  57. @ExcelProperty({"用户维度", "当月之前老用户", "订单量"})
  58. private Integer monthlyBeforeUserOrders;
  59. @ExcelProperty({"用户维度", "当月之前老用户", "金额"})
  60. private BigDecimal monthlyBeforeUserOrdersMoney;
  61. // @ExcelProperty({"历史复购","有奈飞车票的人数"})
  62. // private Integer nfTicketNumOfUser;
  63. //
  64. // @ExcelProperty({"历史复购","有AI账号车票人数"})
  65. // private Integer aiTicketNumOfUser;
  66. //
  67. // @ExcelProperty({"历史复购","二者交叉人数"})
  68. // private Integer nfAiTicketNumOfUser;
  69. //
  70. // @ExcelProperty({"私域数据类", "目前私域中,下过单的用户数(以第一次下单类型为准)", "流媒体类用户数"})
  71. // private Integer monthPrivateStreamingNumOfUser;
  72. //
  73. // @ExcelProperty({"私域数据类", "目前私域中,下过单的用户数(以第一次下单类型为准)", "AI类用户数"})
  74. // private Integer monthPrivateAiNumOfUser;
  75. //
  76. // @ExcelProperty({"私域数据类", "目前私域中,下过单的用户数(以第一次下单类型为准)", "设备类用户数"})
  77. // private Integer monthPrivateEqNumOfUser;
  78. }