API tools faq
paste
Advertisement
MedvedkovIgor

Untitled

MedvedkovIgor
Oct 12th, 2018
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.94 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "size": 0,
  3. "query": {
  4. "terms":{
  5. "uuid":["0fef66c39b07247f70350cfaba5a6b85"]
  6. }
  7. },
  8. "aggregations": {
  9. "group_by": {
  10. "terms": {
  11. "field": "uuid",
  12. "include": {
  13. "partition": 0,
  14. "num_partitions": 100
  15. },
  16. "size": 10000,
  17. "order": [
  18. {
  19. "_count": "desc"
  20. },
  21. {
  22. "_key": "asc"
  23. }
  24. ]
  25. },
  26. "aggregations": {
  27. "children": {
  28. "children": {
  29. "type": "action"
  30. },
  31. "aggregations": {
  32. "google_actions_a1": {
  33. "filter": {
  34. "bool": {
  35. "filter": [
  36. {
  37. "bool": {
  38. "should": [
  39. {
  40. "match_phrase": {
  41. "GoogleSearch.keyword": {
  42. "query": "youtube",
  43. "slop": 0,
  44. "boost": 1
  45. }
  46. }
  47. }
  48. ],
  49. "adjust_pure_negative": true,
  50. "boost": 1
  51. }
  52. }
  53. ],
  54. "adjust_pure_negative": true,
  55. "boost": 1
  56. }
  57. },
  58. "aggregations": {
  59. "group_by_timestamp": {
  60. "terms": {
  61. "field": "timestamp",
  62. "size": 1000
  63. }
  64. },
  65. "actions": {
  66. "terms": {
  67. "field": "GoogleSearch.keyword.raw",
  68. "size": 1000,
  69. "min_doc_count": 1,
  70. "shard_min_doc_count": 0,
  71. "show_term_doc_count_error": false,
  72. "order": [
  73. {
  74. "_count": "desc"
  75. },
  76. {
  77. "_key": "asc"
  78. }
  79. ]
  80. },
  81. "aggregations": {
  82. "uniqueIds": {
  83. "cardinality": {
  84. "field": "join_field#uuid"
  85. }
  86. }
  87. }
  88. },
  89. "landingPages": {
  90. "terms": {
  91. "field": "GoogleSearch.landing_domain",
  92. "size": 1000,
  93. "min_doc_count": 1,
  94. "shard_min_doc_count": 0,
  95. "show_term_doc_count_error": false,
  96. "order": [
  97. {
  98. "_count": "desc"
  99. },
  100. {
  101. "_key": "asc"
  102. }
  103. ]
  104. },
  105. "aggregations": {
  106. "counts": {
  107. "terms": {
  108. "field": "GoogleSearch.click_type",
  109. "size": 10,
  110. "min_doc_count": 1,
  111. "shard_min_doc_count": 0,
  112. "show_term_doc_count_error": false,
  113. "order": [
  114. {
  115. "_count": "desc"
  116. },
  117. {
  118. "_key": "asc"
  119. }
  120. ]
  121. }
  122. },
  123. "uniqueIds": {
  124. "cardinality": {
  125. "field": "join_field#uuid"
  126. }
  127. }
  128. }
  129. }
  130. }
  131. },
  132. "amazon_actions_a1": {
  133. "filter": {
  134. "bool": {
  135. "should": [
  136. {
  137. "match_phrase": {
  138. "AmazonOnSiteSearch.keyword.raw": {
  139. "query": "hand spinner",
  140. "slop": 0,
  141. "boost": 1
  142. }
  143. }
  144. }
  145. ],
  146. "adjust_pure_negative": true,
  147. "boost": 1
  148. }
  149. },
  150. "aggs": {
  151. "group_by_timestamp": {
  152. "terms": {
  153. "field": "timestamp",
  154. "size": 1000
  155. }
  156. },
  157. "actions": {
  158. "terms": {
  159. "field": "AmazonOnSiteSearch.keyword.raw",
  160. "size": 1000,
  161. "min_doc_count": 1,
  162. "shard_min_doc_count": 0,
  163. "show_term_doc_count_error": false,
  164. "order": [
  165. {
  166. "_count": "desc"
  167. },
  168. {
  169. "_key": "asc"
  170. }
  171. ]
  172. },
  173. "aggregations": {
  174. "uniqueIds": {
  175. "cardinality": {
  176. "field": "join_field#uuid"
  177. }
  178. }
  179. }
  180. },
  181. "landingPages": {
  182. "terms": {
  183. "field": "GoogleSearch.landing_domain",
  184. "size": 1000,
  185. "min_doc_count": 1,
  186. "shard_min_doc_count": 0,
  187. "show_term_doc_count_error": false,
  188. "order": [
  189. {
  190. "_count": "desc"
  191. },
  192. {
  193. "_key": "asc"
  194. }
  195. ]
  196. },
  197. "aggregations": {
  198. "counts": {
  199. "terms": {
  200. "field": "GoogleSearch.click_type",
  201. "size": 10,
  202. "min_doc_count": 1,
  203. "shard_min_doc_count": 0,
  204. "show_term_doc_count_error": false,
  205. "order": [
  206. {
  207. "_count": "desc"
  208. },
  209. {
  210. "_key": "asc"
  211. }
  212. ]
  213. }
  214. },
  215. "uniqueIds": {
  216. "cardinality": {
  217. "field": "join_field#uuid"
  218. }
  219. }
  220. }
  221. }
  222. }
  223. },
  224. "google_actions_a2": {
  225. "filter": {
  226. "bool": {
  227. "filter": [
  228. {
  229. "bool": {
  230. "should": [
  231. {
  232. "match_phrase": {
  233. "GoogleSearch.keyword": {
  234. "query": "facebook",
  235. "slop": 0,
  236. "boost": 1
  237. }
  238. }
  239. }
  240. ],
  241. "adjust_pure_negative": true,
  242. "boost": 1
  243. }
  244. }
  245. ],
  246. "adjust_pure_negative": true,
  247. "boost": 1
  248. }
  249. },
  250. "aggregations": {
  251. "group_by_timestamp": {
  252. "terms": {
  253. "field": "timestamp",
  254. "size": 1000
  255. }
  256. },
  257. "actions": {
  258. "terms": {
  259. "field": "GoogleSearch.keyword.raw",
  260. "size": 1000,
  261. "min_doc_count": 1,
  262. "shard_min_doc_count": 0,
  263. "show_term_doc_count_error": false,
  264. "order": [
  265. {
  266. "_count": "desc"
  267. },
  268. {
  269. "_key": "asc"
  270. }
  271. ]
  272. },
  273. "aggregations": {
  274. "uniqueIds": {
  275. "cardinality": {
  276. "field": "join_field#uuid"
  277. }
  278. }
  279. }
  280. },
  281. "landingPages": {
  282. "terms": {
  283. "field": "GoogleSearch.landing_domain",
  284. "size": 1000,
  285. "min_doc_count": 1,
  286. "shard_min_doc_count": 0,
  287. "show_term_doc_count_error": false,
  288. "order": [
  289. {
  290. "_count": "desc"
  291. },
  292. {
  293. "_key": "asc"
  294. }
  295. ]
  296. },
  297. "aggregations": {
  298. "counts": {
  299. "terms": {
  300. "field": "GoogleSearch.click_type",
  301. "size": 10,
  302. "min_doc_count": 1,
  303. "shard_min_doc_count": 0,
  304. "show_term_doc_count_error": false,
  305. "order": [
  306. {
  307. "_count": "desc"
  308. },
  309. {
  310. "_key": "asc"
  311. }
  312. ]
  313. }
  314. },
  315. "uniqueIds": {
  316. "cardinality": {
  317. "field": "join_field#uuid"
  318. }
  319. }
  320. }
  321. }
  322. }
  323. },
  324. "amazon_actions_a2": {
  325. "filter": {
  326. "bool": {
  327. "should": [
  328. {
  329. "match_phrase": {
  330. "AmazonOnSiteSearch.keyword.raw": {
  331. "query": "spinner",
  332. "slop": 0,
  333. "boost": 1
  334. }
  335. }
  336. }
  337. ],
  338. "adjust_pure_negative": true,
  339. "boost": 1
  340. }
  341. },
  342. "aggs": {
  343. "group_by_timestamp": {
  344. "terms": {
  345. "field": "timestamp",
  346. "size": 1000
  347. }
  348. },
  349. "actions": {
  350. "terms": {
  351. "field": "AmazonOnSiteSearch.keyword.raw",
  352. "size": 1000,
  353. "min_doc_count": 1,
  354. "shard_min_doc_count": 0,
  355. "show_term_doc_count_error": false,
  356. "order": [
  357. {
  358. "_count": "desc"
  359. },
  360. {
  361. "_key": "asc"
  362. }
  363. ]
  364. },
  365. "aggregations": {
  366. "uniqueIds": {
  367. "cardinality": {
  368. "field": "join_field#uuid"
  369. }
  370. }
  371. }
  372. },
  373. "landingPages": {
  374. "terms": {
  375. "field": "GoogleSearch.landing_domain",
  376. "size": 1000,
  377. "min_doc_count": 1,
  378. "shard_min_doc_count": 0,
  379. "show_term_doc_count_error": false,
  380. "order": [
  381. {
  382. "_count": "desc"
  383. },
  384. {
  385. "_key": "asc"
  386. }
  387. ]
  388. },
  389. "aggregations": {
  390. "counts": {
  391. "terms": {
  392. "field": "GoogleSearch.click_type",
  393. "size": 10,
  394. "min_doc_count": 1,
  395. "shard_min_doc_count": 0,
  396. "show_term_doc_count_error": false,
  397. "order": [
  398. {
  399. "_count": "desc"
  400. },
  401. {
  402. "_key": "asc"
  403. }
  404. ]
  405. }
  406. },
  407. "uniqueIds": {
  408. "cardinality": {
  409. "field": "join_field#uuid"
  410. }
  411. }
  412. }
  413. }
  414. }
  415. },
  416. "TopGoogleSearch": {
  417. "terms": {
  418. "field": "GoogleSearch.keyword.raw",
  419. "size": 10,
  420. "min_doc_count": 1,
  421. "shard_min_doc_count": 0,
  422. "show_term_doc_count_error": false,
  423. "order": [
  424. {
  425. "_count": "desc"
  426. },
  427. {
  428. "_key": "asc"
  429. }
  430. ]
  431. }
  432. }
  433. }
  434. },
  435. "zeroAmazonActionsFiltering": {
  436. "bucket_selector": {
  437. "buckets_path": {
  438. "googleNumOfActionsA1": "children>google_actions_a1._count",
  439. "amazonNumOfActionsA1": "children>amazon_actions_a1._count",
  440. "googleNumOfActionsA2": "children>google_actions_a2._count",
  441. "amazonNumOfActionsA2": "children>amazon_actions_a2._count"
  442. },
  443. "script": "(params.googleNumOfActionsA1>0&&params.amazonNumOfActionsA1>0)&&(params.googleNumOfActionsA2>0&&params.amazonNumOfActionsA2>0)"
  444. }
  445. }
  446. }
  447. }
  448. }
  449. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!