Performance report by period

Posted in General by Valentyn Ostakh Wed Aug 02 2017 11:12:03 GMT+0000 (Coordinated Universal Time)·1·Viewed 549 times

Hello beeswax support! I am going to use your service and I do research about performance report. I can't find and understand which format of query I need to use to get performance report by some period. I found article "Query Tool Report Overview" where you wrote : ' Date Select the date range you'd like to run your report for. You can select one of the pre-selected ranges, or create a Custom range. If this field is left blank, data will be pulled from the entire lifespan of your account. ' Unfortunately this is unclear for me how to use date for ranges. I hope you can help me with this question. Best regards Valentine
Aug 4, 2017

The date field for the performance report is called bid_hour. To filter on a range you use the syntax shown below with the start and end dates separated by double ampersands &&. Note, when filtering by a date field there are special "magic" fields like today or last_year that can make your task simpler.

```curl -X POST '[host]/rest/report_queue' -b cookies.txt -d '{"report_id":1,"request_details":{"field":["bid_hour","campaign_id"],"metric":["impression","spend"],"filter":[{"bid_hour":">2015-01-01&&<2017--12-31"}]},"report_name":"foobar"}'

Markdown is allowed