企微短剧业务系统

activeFans.php 8.4KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285
  1. <?php
  2. return [
  3. 'basic' => [
  4. [
  5. 'name' => '时间',
  6. 'column' => 'ref_date',
  7. "enable_to_sort"=> false
  8. ],
  9. [
  10. 'name' => '账户',
  11. 'column' => 'account_id',
  12. "enable_to_sort"=> false
  13. ],
  14. [
  15. 'name' => '短剧',
  16. 'column' => 'playlet_name',
  17. "enable_to_sort"=> false
  18. ],
  19. [
  20. 'name' => '消耗',
  21. 'column' => 'paid',
  22. "enable_to_sort"=> true
  23. ],
  24. [
  25. 'name' => '企微关注人数',
  26. 'column' => 'scan_follow_count',
  27. "enable_to_sort"=> true
  28. ],
  29. [
  30. 'name' => '企微关注成本',
  31. 'column' => 'follow_cost',
  32. 'notes' => '当天消耗/企微关注人数',
  33. "enable_to_sort"=> true
  34. ],
  35. [
  36. 'name' => '首日ROI',
  37. 'column' => 'first_roi',
  38. 'notes' => '当日新增用户充值金额/当天消耗',
  39. "enable_to_sort"=> true
  40. ],
  41. [
  42. 'name' => '首日用户充值人数',
  43. 'column' => 'pay_user',
  44. "enable_to_sort"=> true
  45. ],
  46. [
  47. 'name' => '用户累计充值金额',
  48. 'column' => 'pay_money_total',
  49. "enable_to_sort"=> true
  50. ],
  51. [
  52. 'name' => '首日下单成本',
  53. 'column' => 'first_charge_user_cost',
  54. "enable_to_sort"=> true
  55. ],
  56. [
  57. 'name' => '当日新增用户充值金额',
  58. 'column' => 'pay_money',
  59. "enable_to_sort"=> true
  60. ],
  61. [
  62. 'name' => '当天新增用户arpu值',
  63. 'column' => 'day_paid_user_arpu',
  64. 'notes' => '首日新增用户充值金额/首日充值人数',
  65. "enable_to_sort"=> true
  66. ],
  67. [
  68. 'name' => '累计充值人数',
  69. 'column' => 'pay_user_total',
  70. "enable_to_sort"=> true
  71. ],
  72. [
  73. 'name' => '累计充值金额',
  74. 'column' => 'pay_money_total',
  75. "enable_to_sort"=> true
  76. ],
  77. [
  78. 'name' => '总回本率',
  79. 'column' => 'cost_cover_rate',
  80. 'notes' => '用户累计充值金额/当天消耗',
  81. "enable_to_sort"=> true
  82. ],
  83. [
  84. 'name' => '累计付费用户arpu值',
  85. 'column' => 'paid_user_arpu',
  86. 'notes' => '累计回收金额/累计充值人数',
  87. "enable_to_sort"=> true
  88. ]
  89. ],
  90. 'mp_basic' => [
  91. [
  92. 'name' => '时间',
  93. 'column' => 'ref_date',
  94. "enable_to_sort"=> false
  95. ],
  96. [
  97. 'name' => '账户',
  98. 'column' => 'app_name',
  99. "enable_to_sort"=> false
  100. ],
  101. [
  102. 'name' => '短剧',
  103. 'column' => 'playlet_name',
  104. "enable_to_sort"=> false
  105. ],
  106. [
  107. 'name' => '消耗',
  108. 'column' => 'paid',
  109. "enable_to_sort"=> true
  110. ],
  111. [
  112. 'name' => '企微关注人数',
  113. 'column' => 'scan_follow_count',
  114. "enable_to_sort"=> true
  115. ],
  116. [
  117. 'name' => '企微关注成本',
  118. 'column' => 'follow_cost',
  119. 'notes' => '当天消耗/企微关注人数',
  120. "enable_to_sort"=> true
  121. ],
  122. [
  123. 'name' => '首日ROI',
  124. 'column' => 'first_roi',
  125. 'notes' => '当日新增用户充值金额/当天消耗',
  126. "enable_to_sort"=> true
  127. ],
  128. [
  129. 'name' => '首日用户充值人数',
  130. 'column' => 'pay_user',
  131. "enable_to_sort"=> true
  132. ],
  133. [
  134. 'name' => '用户累计充值金额',
  135. 'column' => 'pay_money_total',
  136. "enable_to_sort"=> true
  137. ],
  138. [
  139. 'name' => '首日下单成本',
  140. 'column' => 'first_charge_user_cost',
  141. "enable_to_sort"=> true
  142. ],
  143. [
  144. 'name' => '当日新增用户充值金额',
  145. 'column' => 'pay_money',
  146. "enable_to_sort"=> true
  147. ],
  148. [
  149. 'name' => '当天新增用户arpu值',
  150. 'column' => 'day_paid_user_arpu',
  151. 'notes' => '首日新增用户充值金额/首日充值人数',
  152. "enable_to_sort"=> true
  153. ],
  154. [
  155. 'name' => '累计充值人数',
  156. 'column' => 'pay_user_total',
  157. "enable_to_sort"=> true
  158. ],
  159. [
  160. 'name' => '累计充值金额',
  161. 'column' => 'pay_money_total',
  162. "enable_to_sort"=> true
  163. ],
  164. [
  165. 'name' => '总回本率',
  166. 'column' => 'cost_cover_rate',
  167. 'notes' => '用户累计充值金额/当天消耗',
  168. "enable_to_sort"=> true
  169. ],
  170. [
  171. 'name' => '累计付费用户arpu值',
  172. 'column' => 'paid_user_arpu',
  173. 'notes' => '累计回收金额/累计充值人数',
  174. "enable_to_sort"=> true
  175. ]
  176. ],
  177. 'summary' => [
  178. [
  179. 'name' => '时间',
  180. "enable_to_sort"=> false
  181. ],
  182. [
  183. 'name' => '账户',
  184. "enable_to_sort"=> false
  185. ],
  186. [
  187. 'name' => '短剧',
  188. "enable_to_sort"=> false
  189. ],
  190. [
  191. 'name' => '消耗',
  192. 'column' => 'paid',
  193. "enable_to_sort"=> true
  194. ],
  195. [
  196. 'name' => '企微关注人数',
  197. 'column' => 'scan_follow_count',
  198. "enable_to_sort"=> true
  199. ],
  200. [
  201. 'name' => '企微关注成本',
  202. 'column' => 'follow_cost',
  203. 'notes' => '当天消耗/企微关注人数',
  204. "enable_to_sort"=> true
  205. ],
  206. [
  207. 'name' => '首日ROI',
  208. 'column' => 'first_roi',
  209. 'notes' => '当日新增用户充值金额/当天消耗',
  210. "enable_to_sort"=> true
  211. ],
  212. [
  213. 'name' => '首日用户充值人数',
  214. 'column' => 'pay_user',
  215. "enable_to_sort"=> true
  216. ],
  217. [
  218. 'name' => '用户累计充值金额',
  219. 'column' => 'pay_money_total',
  220. "enable_to_sort"=> true
  221. ],
  222. [
  223. 'name' => '首日下单成本',
  224. 'column' => 'first_charge_user_cost',
  225. "enable_to_sort"=> true
  226. ],
  227. [
  228. 'name' => '当日新增用户充值金额',
  229. 'column' => 'pay_money',
  230. "enable_to_sort"=> true
  231. ],
  232. [
  233. 'name' => '当天新增用户arpu值',
  234. 'column' => 'day_paid_user_arpu',
  235. 'notes' => '首日新增用户充值金额/首日充值人数',
  236. "enable_to_sort"=> true
  237. ],
  238. [
  239. 'name' => '累计充值人数',
  240. 'column' => 'pay_user_total',
  241. "enable_to_sort"=> true
  242. ],
  243. [
  244. 'name' => '累计充值金额',
  245. 'column' => 'pay_money_total',
  246. "enable_to_sort"=> true
  247. ],
  248. [
  249. 'name' => '累计激活下单成本',
  250. 'column' => 'pay_user_cost',
  251. 'notes' => '消耗/累计充值人数',
  252. "enable_to_sort"=> true
  253. ],
  254. [
  255. 'name' => '累计付费用户arpu值',
  256. 'column' => 'paid_user_arpu',
  257. 'notes' => '累计回收金额/累计充值人数',
  258. "enable_to_sort"=> true
  259. ],
  260. [
  261. 'name' => '3天倍率',
  262. 'column' => 'three_days_rate',
  263. 'notes' => '3天累计回收金额/当日新增用户累计充值金额',
  264. "enable_to_sort"=> false
  265. ],
  266. [
  267. 'name' => '7天倍率',
  268. 'column' => 'seven_days_rate',
  269. 'notes' => '7天累计回收金额/当日新增用户累计充值金额',
  270. "enable_to_sort"=> false
  271. ],
  272. [
  273. 'name' => '15天倍率',
  274. 'column' => 'fifteen_days_rate',
  275. 'notes' => '15天累计回收金额/当日新增用户累计充值金额',
  276. "enable_to_sort"=> false
  277. ],
  278. [
  279. 'name' => '30天倍率',
  280. 'column' => 'thirty_days_rate',
  281. 'notes' => '30天累计回收金额/当日新增用户累计充值金额',
  282. "enable_to_sort"=> false
  283. ]
  284. ],
  285. ];