Slackbot
12/17/2022, 2:22 PMJay Yang
12/17/2022, 2:24 PM{
"queryType": "topN",
"dataSource": {
"type": "union",
"dataSources": [
{
"type": "table",
"name": "dsp_perf"
},
{
"type": "table",
"name": "dsp_hha_impressions"
}
]
},
"virtualColumns": [],
"dimension": {
"type": "LegacyDimensionSpec",
"dimension": "line_id",
"outputName": "line_id",
"outputType": "STRING"
},
"metric": {
"type": "numeric",
"metric": "advertiser_cost"
},
"threshold": 10000,
"intervals": {
"type": "LegacySegmentSpec",
"intervals": [
"2022-12-15T05:00:00.000Z/2022-12-16T04:59:59.000Z"
]
},
"filter": {
"type": "and",
"fields": [
{
"type": "or",
"fields": [
{
"type": "selector",
"dimension": "order_id",
"value": "455853",
"extractionFn": null
}
]
},
{
"type": "or",
"fields": [
{
"type": "selector",
"dimension": "valid",
"value": "1",
"extractionFn": null
},
{
"type": "selector",
"dimension": "valid",
"value": null,
"extractionFn": null
},
{
"type": "selector",
"dimension": "valid",
"value": "true",
"extractionFn": null
}
]
},
{
"type": "not",
"field": {
"type": "or",
"fields": [
{
"type": "selector",
"dimension": "event_type",
"value": "4",
"extractionFn": null
}
]
}
},
{
"type": "or",
"fields": [
{
"type": "selector",
"dimension": "seat_id",
"value": "3331",
"extractionFn": null
}
]
}
]
},
"granularity": {
"type": "all"
},
"aggregations": [
{
"type": "doubleSum",
"name": "advertiser_cost",
"fieldName": "advertiser_cost",
"expression": null
}
],
"postAggregations": [],
"context": {
"priority": 0,
"queryId": "topN_union_request_1",
"timeout": 20000
},
"descending": false
}Jay Yang
12/17/2022, 2:27 PM