企微短剧业务系统

activeFans.php 8.8KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297
  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_name',
  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' => '累计激活下单成本',
  85. 'column' => 'pay_user_cost',
  86. 'notes' => '消耗/累计充值人数',
  87. "enable_to_sort"=> true
  88. ],
  89. [
  90. 'name' => '累计付费用户arpu值',
  91. 'column' => 'paid_user_arpu',
  92. 'notes' => '累计回收金额/累计充值人数',
  93. "enable_to_sort"=> true
  94. ]
  95. ],
  96. 'mp_basic' => [
  97. [
  98. 'name' => '时间',
  99. 'column' => 'ref_date',
  100. "enable_to_sort"=> false
  101. ],
  102. [
  103. 'name' => '账户',
  104. 'column' => 'app_name',
  105. "enable_to_sort"=> false
  106. ],
  107. [
  108. 'name' => '短剧',
  109. 'column' => 'playlet_name',
  110. "enable_to_sort"=> false
  111. ],
  112. [
  113. 'name' => '消耗',
  114. 'column' => 'paid',
  115. "enable_to_sort"=> true
  116. ],
  117. [
  118. 'name' => '企微关注人数',
  119. 'column' => 'scan_follow_count',
  120. "enable_to_sort"=> true
  121. ],
  122. [
  123. 'name' => '企微关注成本',
  124. 'column' => 'follow_cost',
  125. 'notes' => '当天消耗/企微关注人数',
  126. "enable_to_sort"=> true
  127. ],
  128. [
  129. 'name' => '首日ROI',
  130. 'column' => 'first_roi',
  131. 'notes' => '当日新增用户充值金额/当天消耗',
  132. "enable_to_sort"=> true
  133. ],
  134. [
  135. 'name' => '首日用户充值人数',
  136. 'column' => 'pay_user',
  137. "enable_to_sort"=> true
  138. ],
  139. [
  140. 'name' => '用户累计充值金额',
  141. 'column' => 'pay_money_total',
  142. "enable_to_sort"=> true
  143. ],
  144. [
  145. 'name' => '首日下单成本',
  146. 'column' => 'first_charge_user_cost',
  147. "enable_to_sort"=> true
  148. ],
  149. [
  150. 'name' => '当日新增用户充值金额',
  151. 'column' => 'pay_money',
  152. "enable_to_sort"=> true
  153. ],
  154. [
  155. 'name' => '当天新增用户arpu值',
  156. 'column' => 'day_paid_user_arpu',
  157. 'notes' => '首日新增用户充值金额/首日充值人数',
  158. "enable_to_sort"=> true
  159. ],
  160. [
  161. 'name' => '累计充值人数',
  162. 'column' => 'pay_user_total',
  163. "enable_to_sort"=> true
  164. ],
  165. [
  166. 'name' => '累计充值金额',
  167. 'column' => 'pay_money_total',
  168. "enable_to_sort"=> true
  169. ],
  170. [
  171. 'name' => '总回本率',
  172. 'column' => 'cost_cover_rate',
  173. 'notes' => '用户累计充值金额/当天消耗',
  174. "enable_to_sort"=> true
  175. ],
  176. [
  177. 'name' => '累计付费用户arpu值',
  178. 'column' => 'paid_user_arpu',
  179. 'notes' => '累计回收金额/累计充值人数',
  180. "enable_to_sort"=> true
  181. ]
  182. ],
  183. 'summary' => [
  184. [
  185. 'name' => '时间',
  186. "enable_to_sort"=> false
  187. ],
  188. [
  189. 'name' => '账户',
  190. "enable_to_sort"=> false
  191. ],
  192. [
  193. 'name' => '短剧',
  194. "enable_to_sort"=> false
  195. ],
  196. [
  197. 'name' => '消耗',
  198. 'column' => 'paid',
  199. "enable_to_sort"=> true
  200. ],
  201. [
  202. 'name' => '企微关注人数',
  203. 'column' => 'scan_follow_count',
  204. "enable_to_sort"=> true
  205. ],
  206. [
  207. 'name' => '企微关注成本',
  208. 'column' => 'follow_cost',
  209. 'notes' => '当天消耗/企微关注人数',
  210. "enable_to_sort"=> true
  211. ],
  212. [
  213. 'name' => '首日ROI',
  214. 'column' => 'first_roi',
  215. 'notes' => '当日新增用户充值金额/当天消耗',
  216. "enable_to_sort"=> true
  217. ],
  218. [
  219. 'name' => '首日用户充值人数',
  220. 'column' => 'pay_user',
  221. "enable_to_sort"=> true
  222. ],
  223. [
  224. 'name' => '用户累计充值金额',
  225. 'column' => 'pay_money_total',
  226. "enable_to_sort"=> true
  227. ],
  228. [
  229. 'name' => '首日下单成本',
  230. 'column' => 'first_charge_user_cost',
  231. "enable_to_sort"=> true
  232. ],
  233. [
  234. 'name' => '当日新增用户充值金额',
  235. 'column' => 'pay_money',
  236. "enable_to_sort"=> true
  237. ],
  238. [
  239. 'name' => '当天新增用户arpu值',
  240. 'column' => 'day_paid_user_arpu',
  241. 'notes' => '首日新增用户充值金额/首日充值人数',
  242. "enable_to_sort"=> true
  243. ],
  244. [
  245. 'name' => '累计充值人数',
  246. 'column' => 'pay_user_total',
  247. "enable_to_sort"=> true
  248. ],
  249. [
  250. 'name' => '累计充值金额',
  251. 'column' => 'pay_money_total',
  252. "enable_to_sort"=> true
  253. ],
  254. [
  255. 'name' => '总回本率',
  256. 'column' => 'cost_cover_rate',
  257. 'notes' => '用户累计充值金额/当天消耗',
  258. "enable_to_sort"=> true
  259. ],
  260. [
  261. 'name' => '累计激活下单成本',
  262. 'column' => 'pay_user_cost',
  263. 'notes' => '消耗/累计充值人数',
  264. "enable_to_sort"=> true
  265. ],
  266. [
  267. 'name' => '累计付费用户arpu值',
  268. 'column' => 'paid_user_arpu',
  269. 'notes' => '累计回收金额/累计充值人数',
  270. "enable_to_sort"=> true
  271. ],
  272. [
  273. 'name' => '3天倍率',
  274. 'column' => 'three_days_rate',
  275. 'notes' => '3天累计回收金额/当日新增用户累计充值金额',
  276. "enable_to_sort"=> false
  277. ],
  278. [
  279. 'name' => '7天倍率',
  280. 'column' => 'seven_days_rate',
  281. 'notes' => '7天累计回收金额/当日新增用户累计充值金额',
  282. "enable_to_sort"=> false
  283. ],
  284. [
  285. 'name' => '15天倍率',
  286. 'column' => 'fifteen_days_rate',
  287. 'notes' => '15天累计回收金额/当日新增用户累计充值金额',
  288. "enable_to_sort"=> false
  289. ],
  290. [
  291. 'name' => '30天倍率',
  292. 'column' => 'thirty_days_rate',
  293. 'notes' => '30天累计回收金额/当日新增用户累计充值金额',
  294. "enable_to_sort"=> false
  295. ]
  296. ],
  297. ];