企微短剧业务系统

accountDataHeader.php 10KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349
  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' => '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"=> true
  29. ],
  30. [
  31. 'name' => '首日ROI',
  32. 'column' => 'first_roi',
  33. 'notes' => '当日新增用户充值金额/当天消耗',
  34. "enable_to_sort"=> true
  35. ],
  36. [
  37. 'name' => '当日新增用户充值金额',
  38. 'column' => 'pay_money',
  39. "enable_to_sort"=> true
  40. ],
  41. [
  42. 'name' => '用户累计充值金额',
  43. 'column' => 'pay_money_total',
  44. "enable_to_sort"=> true
  45. ],
  46. [
  47. 'name' => '首日充值人数',
  48. 'column' => 'pay_user',
  49. "enable_to_sort"=> true
  50. ],
  51. [
  52. 'name' => '总充值人数',
  53. 'column' => 'pay_user_total',
  54. "enable_to_sort"=> true
  55. ],
  56. [
  57. 'name' => '首日充值次数',
  58. 'column' => 'pay_count',
  59. "enable_to_sort"=> true
  60. ],
  61. [
  62. 'name' => '总充值次数',
  63. 'column' => 'pay_count_total',
  64. "enable_to_sort"=> true
  65. ],
  66. [
  67. 'name' => '首日下单成本',
  68. 'column' => 'first_charge_user_cost',
  69. "enable_to_sort"=> true
  70. ],
  71. [
  72. 'name' => '总回本率',
  73. 'column' => 'cost_cover_rate',
  74. 'notes' => '用户累计充值金额/当天消耗',
  75. "enable_to_sort"=> true
  76. ],
  77. [
  78. 'name' => '首日付费用户arpu值',
  79. 'column' => 'day_paid_user_arpu',
  80. 'notes' => '首日新增用户充值金额/首日充值人数',
  81. "enable_to_sort"=> true
  82. ]
  83. ],
  84. 'all' => [
  85. [
  86. 'name' => '时间',
  87. 'column' => 'ref_date',
  88. "enable_to_sort"=> false
  89. ],
  90. [
  91. 'name' => '账户',
  92. 'column' => 'account_name',
  93. "enable_to_sort"=> false
  94. ],
  95. [
  96. 'name' => '当天消耗',
  97. 'column' => 'paid',
  98. "enable_to_sort"=> true
  99. ],
  100. [
  101. 'name' => '企微关注人数',
  102. 'column' => 'scan_follow_count',
  103. "enable_to_sort"=> true
  104. ],
  105. [
  106. 'name' => '企微关注成本',
  107. 'column' => 'follow_cost',
  108. 'notes' => '当天消耗/企微关注人数',
  109. "enable_to_sort"=> false
  110. ],
  111. [
  112. 'name' => '首日ROI',
  113. 'column' => 'first_roi',
  114. 'notes' => '当日新增用户充值金额/当天消耗',
  115. "enable_to_sort"=> false
  116. ],
  117. [
  118. 'name' => '当日新增用户充值金额',
  119. 'column' => 'pay_money',
  120. "enable_to_sort"=> true
  121. ],
  122. [
  123. 'name' => '用户累计充值金额',
  124. 'column' => 'pay_money_total',
  125. "enable_to_sort"=> true
  126. ],
  127. [
  128. 'name' => '首日充值人数',
  129. 'column' => 'pay_user',
  130. "enable_to_sort"=> true
  131. ],
  132. [
  133. 'name' => '总充值人数',
  134. 'column' => 'pay_user_total',
  135. "enable_to_sort"=> true
  136. ],
  137. [
  138. 'name' => '首日充值次数',
  139. 'column' => 'pay_count',
  140. "enable_to_sort"=> true
  141. ],
  142. [
  143. 'name' => '总充值次数',
  144. 'column' => 'pay_count_total',
  145. "enable_to_sort"=> true
  146. ],
  147. [
  148. 'name' => '首日下单成本',
  149. 'column' => 'first_charge_user_cost',
  150. "enable_to_sort"=> false
  151. ],
  152. [
  153. 'name' => '总回本率',
  154. 'column' => 'cost_cover_rate',
  155. 'notes' => '用户累计充值金额/当天消耗',
  156. "enable_to_sort"=> false
  157. ],
  158. [
  159. 'name' => '首日付费用户arpu值',
  160. 'column' => 'day_paid_user_arpu',
  161. 'notes' => '首日新增用户充值金额/首日充值人数',
  162. "enable_to_sort"=> false
  163. ]
  164. ],
  165. 'summary' => [
  166. [
  167. 'name' => '时间',
  168. "enable_to_sort"=> false
  169. ],
  170. [
  171. 'name' => '账户',
  172. "enable_to_sort"=> false
  173. ],
  174. [
  175. 'name' => '当天消耗',
  176. 'column' => 'paid',
  177. "enable_to_sort"=> false
  178. ],
  179. [
  180. 'name' => '企微关注人数',
  181. 'column' => 'scan_follow_count',
  182. "enable_to_sort"=> false
  183. ],
  184. [
  185. 'name' => '企微关注成本',
  186. 'column' => 'follow_cost',
  187. 'notes' => '当天消耗/企微关注人数',
  188. "enable_to_sort"=> false
  189. ],
  190. [
  191. 'name' => '首日ROI',
  192. 'column' => 'first_roi',
  193. 'notes' => '当日新增用户充值金额/当天消耗',
  194. "enable_to_sort"=> false
  195. ],
  196. [
  197. 'name' => '当日新增用户充值金额',
  198. 'column' => 'pay_money',
  199. "enable_to_sort"=> false
  200. ],
  201. [
  202. 'name' => '用户累计充值金额',
  203. 'column' => 'pay_money_total',
  204. "enable_to_sort"=> false
  205. ],
  206. [
  207. 'name' => '首日充值人数',
  208. 'column' => 'pay_user',
  209. "enable_to_sort"=> false
  210. ],
  211. [
  212. 'name' => '总充值人数',
  213. 'column' => 'pay_user_total',
  214. "enable_to_sort"=> false
  215. ],
  216. [
  217. 'name' => '首日充值次数',
  218. 'column' => 'pay_count',
  219. "enable_to_sort"=> false
  220. ],
  221. [
  222. 'name' => '总充值次数',
  223. 'column' => 'pay_count_total',
  224. "enable_to_sort"=> false
  225. ],
  226. [
  227. 'name' => '首日下单成本',
  228. 'column' => 'first_charge_user_cost',
  229. "enable_to_sort"=> false
  230. ],
  231. [
  232. 'name' => '总回本率',
  233. 'column' => 'cost_cover_rate',
  234. 'notes' => '用户累计充值金额/当天消耗',
  235. "enable_to_sort"=> false
  236. ],
  237. [
  238. 'name' => '首日付费用户arpu值',
  239. 'column' => 'day_paid_user_arpu',
  240. 'notes' => '首日新增用户充值金额/首日充值人数',
  241. "enable_to_sort"=> false
  242. ],
  243. [
  244. 'name' => '3天倍率',
  245. 'column' => 'three_days_rate',
  246. 'notes' => '3天累计回收金额/当日新增用户累计充值金额',
  247. "enable_to_sort"=> false
  248. ],
  249. [
  250. 'name' => '7天倍率',
  251. 'column' => 'seven_days_rate',
  252. 'notes' => '7天累计回收金额/当日新增用户累计充值金额',
  253. "enable_to_sort"=> false
  254. ],
  255. [
  256. 'name' => '15天倍率',
  257. 'column' => 'fifteen_days_rate',
  258. 'notes' => '15天累计回收金额/当日新增用户累计充值金额',
  259. "enable_to_sort"=> false
  260. ],
  261. [
  262. 'name' => '30天倍率',
  263. 'column' => 'thirty_days_rate',
  264. 'notes' => '30天累计回收金额/当日新增用户累计充值金额',
  265. "enable_to_sort"=> false
  266. ],
  267. ],
  268. 'mp_basic' => [
  269. [
  270. 'name' => '时间',
  271. 'column' => 'ref_date',
  272. "enable_to_sort"=> false
  273. ],
  274. [
  275. 'name' => '账户',
  276. 'column' => 'app_name',
  277. "enable_to_sort"=> false
  278. ],
  279. [
  280. 'name' => '当天消耗',
  281. 'column' => 'paid',
  282. "enable_to_sort"=> true
  283. ],
  284. [
  285. 'name' => '企微关注人数',
  286. 'column' => 'scan_follow_count',
  287. "enable_to_sort"=> true
  288. ],
  289. [
  290. 'name' => '企微关注成本',
  291. 'column' => 'follow_cost',
  292. 'notes' => '当天消耗/企微关注人数',
  293. "enable_to_sort"=> true
  294. ],
  295. [
  296. 'name' => '首日ROI',
  297. 'column' => 'first_roi',
  298. 'notes' => '当日新增用户充值金额/当天消耗',
  299. "enable_to_sort"=> true
  300. ],
  301. [
  302. 'name' => '当日新增用户充值金额',
  303. 'column' => 'pay_money',
  304. "enable_to_sort"=> true
  305. ],
  306. [
  307. 'name' => '用户累计充值金额',
  308. 'column' => 'pay_money_total',
  309. "enable_to_sort"=> true
  310. ],
  311. [
  312. 'name' => '首日充值人数',
  313. 'column' => 'pay_user',
  314. "enable_to_sort"=> true
  315. ],
  316. [
  317. 'name' => '总充值人数',
  318. 'column' => 'pay_user_total',
  319. "enable_to_sort"=> true
  320. ],
  321. [
  322. 'name' => '首日充值次数',
  323. 'column' => 'pay_count',
  324. "enable_to_sort"=> true
  325. ],
  326. [
  327. 'name' => '总充值次数',
  328. 'column' => 'pay_count_total',
  329. "enable_to_sort"=> true
  330. ],
  331. [
  332. 'name' => '首日下单成本',
  333. 'column' => 'first_charge_user_cost',
  334. "enable_to_sort"=> true
  335. ],
  336. [
  337. 'name' => '总回本率',
  338. 'column' => 'cost_cover_rate',
  339. 'notes' => '用户累计充值金额/当天消耗',
  340. "enable_to_sort"=> true
  341. ],
  342. [
  343. 'name' => '首日付费用户arpu值',
  344. 'column' => 'day_paid_user_arpu',
  345. 'notes' => '首日新增用户充值金额/首日充值人数',
  346. "enable_to_sort"=> true
  347. ]
  348. ],
  349. ];