Common API Queries¶
The following common business reports will return the relevant data from slicer when
the POST
payload contains the example query. See the Query Endpoint endpoint
for more details.
Daily spend¶
{
"data_fields": [
"imps",
"payout.actual_pub"
],
"end_date": "2021-02-21",
"include_mappings": 1,
"need_others": 1,
"order_by": {
"direction": "DESC",
"name": "granularity_day"
},
"slicer_name": "<name: ask Account Manager>",
"project_name": "<name: ask Account Manager>",
"token": "<token>",
"split_by": [
"granularity_day",
"bid_context_wrapper.bid.ssp"
],
"start_date": "2021-02-08"
}
Daily spend and imps per Supplier¶
{
"data_fields": [
"payout.actual_pub"
],
"end_date": "2021-02-21",
"include_mappings": 1,
"need_others": 1,
"order_by": {
"direction": "ASC",
"name": "granularity_day"
},
"slicer_name": "<name: ask Account Manager>",
"project_name": "<name: ask Account Manager>",
"token": "<token>",
"split_by": [
"granularity_day"
],
"start_date": "2021-02-08"
}
CTR and Spend Per Campaign¶
{
"data_fields": [
"imps",
"clicks",
"ctr",
"payout.actual_pub"
],
"end_date": "2021-02-21",
"include_mappings": 1,
"need_others": 1,
"order_by": {
"direction": "DESC",
"name": "ctr"
},
"slicer_name": "<name: ask Account Manager>",
"project_name": "<name: ask Account Manager>",
"token": "<token>",
"split_by": [
"bid_context_wrapper.demand.campaign_id",
"bid_context_wrapper.bid.ssp"
],
"start_date": "2021-02-08"
}
Deal Reporting split by Creative¶
{
"data_fields": [
"imps",
"bids",
"win_rate",
"payout.actual_pub"
],
"end_date": "2021-03-09",
"filters": [
{
"case_insensitive": true,
"match": "equals",
"name": "bid_context_wrapper.demand.deal_id",
"search_mappings": true,
"value": [
"DEAL-ID-123"
]
}
],
"include_mappings": 1,
"need_others": 1,
"order_by": {
"direction": "DESC",
"name": "imps"
},
"slicer_name": "<name: ask Account Manager>",
"project_name": "<name: ask Account Manager>",
"token": "<token>",
"split_by": [
"bid_context_wrapper.demand.creative_id"
],
"start_date": "2021-02-24"
}
Line Item Reporting per Campaign¶
{
"data_fields": [
"imps",
"bids",
"win_rate",
"payout.actual_pub"
],
"end_date": "2021-03-09",
"filters": [
{
"case_insensitive": true,
"match": "equals",
"name": "bid_context_wrapper.demand.campaign_id",
"search_mappings": true,
"value": [
"7"
]
}
],
"include_mappings": 1,
"need_others": 1,
"order_by": {
"direction": "DESC",
"name": "imps"
},
"slicer_name": "<name: ask Account Manager>",
"project_name": "<name: ask Account Manager>",
"token": "<token>",
"split_by": [
"bid_context_wrapper.demand.line_item_id"
],
"start_date": "2021-02-24"
}