企微短剧业务系统

shortPlayDataTrendHeader.php 6.7KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220
  1. <?php
  2. return [
  3. 'basic' => [
  4. [
  5. 'name' => '时间',
  6. 'column' => 'ref_date',
  7. "enable_to_sort"=> false
  8. ],
  9. [
  10. 'name' => '短剧',
  11. 'column' => 'playlet_name',
  12. "enable_to_sort"=> false
  13. ],
  14. [
  15. 'name' => '当天消耗',
  16. 'column' => 'paid',
  17. "enable_to_sort"=> true
  18. ],
  19. [
  20. 'name' => '企微关注人数',
  21. 'column' => 'scan_follow_count',
  22. "enable_to_sort"=> true
  23. ],
  24. [
  25. 'name' => '企微关注成本',
  26. 'column' => 'follow_cost',
  27. 'notes' => '当天消耗/企微关注人数',
  28. "enable_to_sort"=> false
  29. ],
  30. [
  31. "name" => "企微实际加粉人数",
  32. "column" => "followers_number",
  33. "notes" => "投放账号绑定客服添加粉丝数",
  34. "enable_to_sort" => false,
  35. ],
  36. [
  37. "name" => "企微加粉成本",
  38. "column" => "followers_cost",
  39. 'notes' => '当天消耗/企微实际加粉人数',
  40. "enable_to_sort" => false,
  41. ],
  42. [
  43. 'name' => '首日ROI',
  44. 'column' => 'first_roi',
  45. 'notes' => '当日新增用户充值金额/当天消耗',
  46. "enable_to_sort"=> false
  47. ],
  48. [
  49. 'name' => '首充roi',
  50. 'column' => 'first_pay_roi',
  51. 'notes' => '当日新增用户首次充值金额/当天消耗(数据自2023-12-14日起有效)',
  52. "enable_to_sort"=> false
  53. ],
  54. [
  55. 'name' => '当日新增用户充值金额',
  56. 'column' => 'pay_money',
  57. "enable_to_sort"=> true
  58. ],
  59. [
  60. 'name' => '用户累计充值金额',
  61. 'column' => 'pay_money_total',
  62. "enable_to_sort"=> true
  63. ],
  64. [
  65. 'name' => '首日充值人数',
  66. 'column' => 'active_fans',
  67. "enable_to_sort"=> true
  68. ],
  69. [
  70. 'name' => '总充值人数',
  71. 'column' => 'pay_user_total',
  72. "enable_to_sort"=> true
  73. ],
  74. [
  75. 'name' => '首日充值次数',
  76. 'column' => 'pay_count',
  77. "enable_to_sort"=> true
  78. ],
  79. [
  80. 'name' => '总充值次数',
  81. 'column' => 'pay_count_total',
  82. "enable_to_sort"=> true
  83. ],
  84. [
  85. 'name' => '首日下单成本',
  86. 'column' => 'first_charge_user_cost',
  87. "enable_to_sort"=> false
  88. ],
  89. [
  90. 'name' => '总回本率',
  91. 'column' => 'cost_cover_rate',
  92. 'notes' => '用户累计充值金额/当天消耗',
  93. "enable_to_sort"=> false
  94. ],
  95. [
  96. 'name' => '首日付费用户arpu值',
  97. 'column' => 'day_paid_user_arpu',
  98. 'notes' => '首日新增用户充值金额/首日充值人数',
  99. "enable_to_sort"=> false
  100. ]
  101. ],
  102. 'summary' => [
  103. [
  104. 'name' => '时间',
  105. 'column' => 'ref_date',
  106. "enable_to_sort"=> false
  107. ],
  108. [
  109. 'name' => '短剧',
  110. 'column' => 'playlet_name',
  111. "enable_to_sort"=> false
  112. ],
  113. [
  114. 'name' => '当天消耗',
  115. 'column' => 'paid',
  116. "enable_to_sort"=> false
  117. ],
  118. [
  119. 'name' => '企微关注人数',
  120. 'column' => 'scan_follow_count',
  121. "enable_to_sort"=> false
  122. ],
  123. [
  124. 'name' => '企微关注成本',
  125. 'column' => 'follow_cost',
  126. 'notes' => '当天消耗/企微关注人数',
  127. "enable_to_sort"=> false
  128. ],
  129. [
  130. "name" => "企微实际加粉人数",
  131. "column" => "followers_number",
  132. "notes" => "投放账号绑定客服添加粉丝数",
  133. "enable_to_sort" => false,
  134. ],
  135. [
  136. "name" => "企微加粉成本",
  137. "column" => "followers_cost",
  138. 'notes' => '当天消耗/企微实际加粉人数',
  139. "enable_to_sort" => false,
  140. ],
  141. [
  142. 'name' => '首日ROI',
  143. 'column' => 'first_roi',
  144. 'notes' => '当日新增用户充值金额/当天消耗',
  145. "enable_to_sort"=> false
  146. ],
  147. [
  148. 'name' => '当日新增用户充值金额',
  149. 'column' => 'pay_money',
  150. "enable_to_sort"=> false
  151. ],
  152. [
  153. 'name' => '用户累计充值金额',
  154. 'column' => 'pay_money_total',
  155. "enable_to_sort"=> false
  156. ],
  157. [
  158. 'name' => '首日充值人数',
  159. 'column' => 'active_fans',
  160. "enable_to_sort"=> false
  161. ],
  162. [
  163. 'name' => '总充值人数',
  164. 'column' => 'pay_user_total',
  165. "enable_to_sort"=> false
  166. ],
  167. [
  168. 'name' => '首日充值次数',
  169. 'column' => 'pay_count',
  170. "enable_to_sort"=> false
  171. ],
  172. [
  173. 'name' => '总充值次数',
  174. 'column' => 'pay_count_total',
  175. "enable_to_sort"=> false
  176. ],
  177. [
  178. 'name' => '首日下单成本',
  179. 'column' => 'first_charge_user_cost',
  180. "enable_to_sort"=> false
  181. ],
  182. [
  183. 'name' => '总回本率',
  184. 'column' => 'cost_cover_rate',
  185. 'notes' => '用户累计充值金额/当天消耗',
  186. "enable_to_sort"=> false
  187. ],
  188. [
  189. 'name' => '首日付费用户arpu值',
  190. 'column' => 'day_paid_user_arpu',
  191. 'notes' => '首日新增用户充值金额/首日充值人数',
  192. "enable_to_sort"=> false
  193. ],
  194. [
  195. 'name' => '3天倍率',
  196. 'column' => 'three_days_rate',
  197. 'notes' => '3天累计回收金额/当日新增用户累计充值金额',
  198. "enable_to_sort"=> false
  199. ],
  200. [
  201. 'name' => '7天倍率',
  202. 'column' => 'seven_days_rate',
  203. 'notes' => '7天累计回收金额/当日新增用户累计充值金额',
  204. "enable_to_sort"=> false
  205. ],
  206. [
  207. 'name' => '15天倍率',
  208. 'column' => 'fifteen_days_rate',
  209. 'notes' => '15天累计回收金额/当日新增用户累计充值金额',
  210. "enable_to_sort"=> false
  211. ],
  212. [
  213. 'name' => '30天倍率',
  214. 'column' => 'thirty_days_rate',
  215. 'notes' => '30天累计回收金额/当日新增用户累计充值金额',
  216. "enable_to_sort"=> false
  217. ],
  218. ],
  219. ];