企微短剧业务系统

accountDataHeader.php 13KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428
  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" => "企微实际加粉人数",
  113. "column" => "followers_number",
  114. "notes" => "投放账号绑定客服添加粉丝数",
  115. "enable_to_sort" => false,
  116. ],
  117. [
  118. "name" => "复粉人数(全)",
  119. "column" => "repeat_user",
  120. "notes" => "重复客户(只要关注过就算重复客户)",
  121. "enable_to_sort" => false,
  122. ],
  123. [
  124. "name" => "复粉人数(留存)",
  125. "column" => "repeat_user_no_loss",
  126. "notes" => "重复客户(关注过且当前留存才算重复客户)",
  127. "enable_to_sort" => false,
  128. ],
  129. [
  130. "name" => "企微实际加粉成本",
  131. "column" => "followers_cost",
  132. 'notes' => '当天消耗/企微实际加粉人数',
  133. "enable_to_sort" => false,
  134. ],
  135. [
  136. "name" => "复粉率(全)",
  137. "column" => "repeat_user_rate",
  138. 'notes' => '重复客户(只要关注过就算重复客户)/企微实际加粉人数',
  139. "enable_to_sort" => false,
  140. ],
  141. [
  142. "name" => "复粉率(留存)",
  143. "column" => "repeat_user_no_loss_rate",
  144. 'notes' => '重复客户(关注过且当前留存才算重复客户)/企微实际加粉人数',
  145. "enable_to_sort" => false,
  146. ],
  147. [
  148. 'name' => '首充roi',
  149. 'column' => 'first_pay_roi',
  150. 'notes' => '当日新增用户首次充值金额/当天消耗(数据自2023-12-11日起有效)',
  151. "enable_to_sort"=> false
  152. ],
  153. [
  154. 'name' => '首日ROI',
  155. 'column' => 'first_roi',
  156. 'notes' => '当日新增用户充值金额/当天消耗',
  157. "enable_to_sort"=> false
  158. ],
  159. [
  160. 'name' => '当日新增用户充值金额',
  161. 'column' => 'pay_money',
  162. "enable_to_sort"=> true
  163. ],
  164. [
  165. 'name' => '用户累计充值金额',
  166. 'column' => 'pay_money_total',
  167. "enable_to_sort"=> true
  168. ],
  169. [
  170. 'name' => '首日充值人数',
  171. 'column' => 'pay_user',
  172. "enable_to_sort"=> true
  173. ],
  174. [
  175. 'name' => '总充值人数',
  176. 'column' => 'pay_user_total',
  177. "enable_to_sort"=> true
  178. ],
  179. [
  180. 'name' => '首日充值次数',
  181. 'column' => 'pay_count',
  182. "enable_to_sort"=> true
  183. ],
  184. [
  185. 'name' => '总充值次数',
  186. 'column' => 'pay_count_total',
  187. "enable_to_sort"=> true
  188. ],
  189. [
  190. 'name' => '首日下单成本',
  191. 'column' => 'first_charge_user_cost',
  192. "enable_to_sort"=> false
  193. ],
  194. [
  195. 'name' => '总回本率',
  196. 'column' => 'cost_cover_rate',
  197. 'notes' => '用户累计充值金额/当天消耗',
  198. "enable_to_sort"=> false
  199. ],
  200. [
  201. 'name' => '首日付费用户arpu值',
  202. 'column' => 'day_paid_user_arpu',
  203. 'notes' => '首日新增用户充值金额/首日充值人数',
  204. "enable_to_sort"=> false
  205. ]
  206. ],
  207. 'summary' => [
  208. [
  209. 'name' => '时间',
  210. "enable_to_sort"=> false
  211. ],
  212. [
  213. 'name' => '账户',
  214. "enable_to_sort"=> false
  215. ],
  216. [
  217. 'name' => '当天消耗',
  218. 'column' => 'paid',
  219. "enable_to_sort"=> false
  220. ],
  221. [
  222. 'name' => '企微关注人数',
  223. 'column' => 'scan_follow_count',
  224. "notes" => "投放后台投放账号的关注人数",
  225. "enable_to_sort"=> false
  226. ],
  227. [
  228. 'name' => '企微关注成本',
  229. 'column' => 'follow_cost',
  230. 'notes' => '当天消耗/企微关注人数',
  231. "enable_to_sort"=> false
  232. ],
  233. [
  234. "name" => "企微实际加粉人数",
  235. "column" => "followers_number",
  236. "notes" => "投放账号绑定客服添加粉丝数",
  237. "enable_to_sort" => false,
  238. ],
  239. [
  240. "name" => "企微实际加粉成本",
  241. "column" => "followers_cost",
  242. 'notes' => '当天消耗/企微实际加粉人数',
  243. "enable_to_sort" => false,
  244. ],
  245. [
  246. "name" => "复粉人数(全)",
  247. "column" => "repeat_user",
  248. "notes" => "重复客户(只要关注过就算重复客户)",
  249. "enable_to_sort" => false,
  250. ],
  251. [
  252. "name" => "复粉人数(留存)",
  253. "column" => "repeat_user_no_loss",
  254. "notes" => "重复客户(关注过且当前留存才算重复客户)",
  255. "enable_to_sort" => false,
  256. ],
  257. [
  258. 'name' => '首日ROI',
  259. 'column' => 'first_roi',
  260. 'notes' => '当日新增用户充值金额/当天消耗',
  261. "enable_to_sort"=> false
  262. ],
  263. [
  264. "name" => "复粉率(全)",
  265. "column" => "repeat_user_rate",
  266. 'notes' => '重复客户(只要关注过就算重复客户)/企微实际加粉人数',
  267. "enable_to_sort" => false,
  268. ],
  269. [
  270. "name" => "复粉率(留存)",
  271. "column" => "repeat_user_no_loss_rate",
  272. 'notes' => '重复客户(关注过且当前留存才算重复客户)/企微实际加粉人数',
  273. "enable_to_sort" => false,
  274. ],
  275. [
  276. 'name' => '当日新增用户充值金额',
  277. 'column' => 'pay_money',
  278. "enable_to_sort"=> false
  279. ],
  280. [
  281. 'name' => '用户累计充值金额',
  282. 'column' => 'pay_money_total',
  283. "enable_to_sort"=> false
  284. ],
  285. [
  286. 'name' => '首日充值人数',
  287. 'column' => 'pay_user',
  288. "enable_to_sort"=> false
  289. ],
  290. [
  291. 'name' => '总充值人数',
  292. 'column' => 'pay_user_total',
  293. "enable_to_sort"=> false
  294. ],
  295. [
  296. 'name' => '首日充值次数',
  297. 'column' => 'pay_count',
  298. "enable_to_sort"=> false
  299. ],
  300. [
  301. 'name' => '总充值次数',
  302. 'column' => 'pay_count_total',
  303. "enable_to_sort"=> false
  304. ],
  305. [
  306. 'name' => '首日下单成本',
  307. 'column' => 'first_charge_user_cost',
  308. "enable_to_sort"=> false
  309. ],
  310. [
  311. 'name' => '总回本率',
  312. 'column' => 'cost_cover_rate',
  313. 'notes' => '用户累计充值金额/当天消耗',
  314. "enable_to_sort"=> false
  315. ],
  316. [
  317. 'name' => '首日付费用户arpu值',
  318. 'column' => 'day_paid_user_arpu',
  319. 'notes' => '首日新增用户充值金额/首日充值人数',
  320. "enable_to_sort"=> false
  321. ],
  322. [
  323. 'name' => '3天倍率',
  324. 'column' => 'three_days_rate',
  325. 'notes' => '3天累计回收金额/当日新增用户累计充值金额',
  326. "enable_to_sort"=> false
  327. ],
  328. [
  329. 'name' => '7天倍率',
  330. 'column' => 'seven_days_rate',
  331. 'notes' => '7天累计回收金额/当日新增用户累计充值金额',
  332. "enable_to_sort"=> false
  333. ],
  334. [
  335. 'name' => '15天倍率',
  336. 'column' => 'fifteen_days_rate',
  337. 'notes' => '15天累计回收金额/当日新增用户累计充值金额',
  338. "enable_to_sort"=> false
  339. ],
  340. [
  341. 'name' => '30天倍率',
  342. 'column' => 'thirty_days_rate',
  343. 'notes' => '30天累计回收金额/当日新增用户累计充值金额',
  344. "enable_to_sort"=> false
  345. ],
  346. ],
  347. 'mp_basic' => [
  348. [
  349. 'name' => '时间',
  350. 'column' => 'ref_date',
  351. "enable_to_sort"=> false
  352. ],
  353. [
  354. 'name' => '账户',
  355. 'column' => 'app_name',
  356. "enable_to_sort"=> false
  357. ],
  358. [
  359. 'name' => '当天消耗',
  360. 'column' => 'paid',
  361. "enable_to_sort"=> true
  362. ],
  363. [
  364. 'name' => '企微关注人数',
  365. 'column' => 'scan_follow_count',
  366. "enable_to_sort"=> true
  367. ],
  368. [
  369. 'name' => '企微关注成本',
  370. 'column' => 'follow_cost',
  371. 'notes' => '当天消耗/企微关注人数',
  372. "enable_to_sort"=> true
  373. ],
  374. [
  375. 'name' => '首日ROI',
  376. 'column' => 'first_roi',
  377. 'notes' => '当日新增用户充值金额/当天消耗',
  378. "enable_to_sort"=> true
  379. ],
  380. [
  381. 'name' => '当日新增用户充值金额',
  382. 'column' => 'pay_money',
  383. "enable_to_sort"=> true
  384. ],
  385. [
  386. 'name' => '用户累计充值金额',
  387. 'column' => 'pay_money_total',
  388. "enable_to_sort"=> true
  389. ],
  390. [
  391. 'name' => '首日充值人数',
  392. 'column' => 'pay_user',
  393. "enable_to_sort"=> true
  394. ],
  395. [
  396. 'name' => '总充值人数',
  397. 'column' => 'pay_user_total',
  398. "enable_to_sort"=> true
  399. ],
  400. [
  401. 'name' => '首日充值次数',
  402. 'column' => 'pay_count',
  403. "enable_to_sort"=> true
  404. ],
  405. [
  406. 'name' => '总充值次数',
  407. 'column' => 'pay_count_total',
  408. "enable_to_sort"=> true
  409. ],
  410. [
  411. 'name' => '首日下单成本',
  412. 'column' => 'first_charge_user_cost',
  413. "enable_to_sort"=> true
  414. ],
  415. [
  416. 'name' => '总回本率',
  417. 'column' => 'cost_cover_rate',
  418. 'notes' => '用户累计充值金额/当天消耗',
  419. "enable_to_sort"=> true
  420. ],
  421. [
  422. 'name' => '首日付费用户arpu值',
  423. 'column' => 'day_paid_user_arpu',
  424. 'notes' => '首日新增用户充值金额/首日充值人数',
  425. "enable_to_sort"=> true
  426. ]
  427. ],
  428. ];