Skip to content

Instantly share code, notes, and snippets.

@Wattenberger
Created November 27, 2017 22:23
Show Gist options
  • Save Wattenberger/8c9b72e737d3bed29fd8ac02e98deaef to your computer and use it in GitHub Desktop.
Save Wattenberger/8c9b72e737d3bed29fd8ac02e98deaef to your computer and use it in GitHub Desktop.
AMP shares query
GET *-5min-*/_search?search_type=count
{
"aggs": {
"by_channel": {
"terms": {
"field": "channel.name",
"size": 10
},
"aggs": {
"by_apikey": {
"terms": {
"field": "apikey",
"size": 50,
"order": {
"shares": "desc"
}
},
"aggs": {
"shares": {
"sum": {
"field": "metrics.$any/$all/shares"
}
},
"fb_shares": {
"sum": {
"field": "metric.fb/$all/shares"
}
},
"tw_shares": {
"sum": {
"field": "metric.tw/$all/shares"
}
},
"pi_shares": {
"sum": {
"field": "metrics.pi/$all/shares"
}
},
"li_shares": {
"sum": {
"field": "metrics.li/$all/shares"
}
}
}
}
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment