The new global routes provide you with much more flexibility than the normal static routes on how you can query data. You can now mix and match the dimensions you wish to query, filter and group by.<\/p>\n
See:\u00a0https:\/\/api.exoclick.com\/v2\/manual\/global-statistics-api\/#parameter-filter<\/a><\/p>\n <\/p>\n Grouping:<\/strong><\/p>\n Grouping now allows you to group with more than one dimension (* maximum of two).<\/p>\n See:\u00a0https:\/\/api.exoclick.com\/v2\/manual\/global-statistics-api\/#parameter-group-by<\/a><\/p>\n <\/p>\n Ordering:<\/strong><\/p>\n Ordering now allows you to pull out the data by a dimension in ascending or descending mode.<\/p>\n <\/p>\n Projections:<\/strong><\/p>\n The projection feature allows you to control what specific data is returned in the response, for example, if you do not require RTB data you can exclude this in the returned payload by projecting what you actually need. This defaults to all.<\/p>\n See:\u00a0https:\/\/api.exoclick.com\/v2\/manual\/global-statistics-api\/#parameter-projection<\/a><\/p>\n <\/p>\n Detailed:<\/strong><\/p>\n The detailed flag is not a new feature per se as this is already available in some existing routes. See:\u00a0https:\/\/api.exoclick.com\/v2\/manual\/global-statistics-api\/#parameter-detailed<\/a><\/p>\n <\/p>\n Advertiser multi-filtering example<\/strong><\/p>\n Complete Body Request:\u00a0https:\/\/api.exoclick.com\/v2\/docs\/#!\/47statistics\/post_statistics_advertiser_global<\/a><\/p>\n Example:<\/p>\n In this example we are making a request where we are filtering by campaignId, country, language, browser and zoneId and then grouping the results by date and zoneId and ordering by impressions descending for a specific time period:<\/p>\n Example of body request code:<\/p>\n Result:<\/p>\n <\/p>\n Publisher multi-filtering example<\/strong><\/p>\n Complete Body Request:\u00a0https:\/\/api.exoclick.com\/v2\/docs\/#!\/47statistics\/post_statistics_publisher_global<\/a><\/p>\n Example:<\/p>\n In this example, we are making a request where we are filtering by zoneId, country, language, browser, and deviceId and grouping the results by date and order by impressions descending for a specific time period:<\/p>\n Ex Body request:<\/p>\n Result:<\/p>\n <\/p>\n We hope that you find these examples useful to get you started on trying out the new API features.<\/p>\n Click here<\/a> for more general information about our API for additional reading<\/p>\n <\/p>\n More blog posts about the API:<\/p>\n How to use ExoClick\u2019s Platform API v2<\/a><\/p>\n API Masterclass #1: Data Collection<\/a><\/p>\n![\"\"](\"https:\/\/www.exoclick.com\/wp-content\/uploads\/2019\/05\/api1.png\")
<\/p>\n![\"\"](\"https:\/\/www.exoclick.com\/wp-content\/uploads\/2019\/05\/api2.png\")
<\/p>\n![\"\"](\"https:\/\/www.exoclick.com\/wp-content\/uploads\/2019\/05\/ap3.png\")
<\/p>\n![\"\"](\"https:\/\/www.exoclick.com\/wp-content\/uploads\/2019\/05\/api3.png\")
<\/p>\n
\nAgain this gives you the power to control what data is returned in the response either as a summary or extended data.<\/p>\n![\"\"](\"https:\/\/www.exoclick.com\/wp-content\/uploads\/2019\/05\/image-4.png\")
<\/p>\n{\r\n "count": 0, "detailed": 0, "timezone": "Europe\/Dublin", "totals": 1, \r\n "filter": {\r\n "exclude_deleted": 0, "browser_id": [12345], "campaign_calculated_status": \r\n [12345], "campaign_id": [12345], "campaign_group_id": [12345], \r\n "carrier_id": [12345], "category_id": [12345], "country_iso": ["USA"], \r\n "date_from": "2019-01-01", "date_to": "2019-01-14", "device_id": [12345],\r\n "hour": [1,2], "language_id": [12345], "offer_id": [12345], \r\n "offer_landing_page_id": [12345], "operating_system_id": [12345], \r\n "region_id": [12345], "site_hostname": ["www.example.com"],\r\n "site_id": [12345], "variation_id": [12345], "zone_id": [12345]\r\n },\r\n "group_by": ["date"],\r\n "order_by": [{"field": "impressions", "order": "desc"}],\r\n "projection": ["video"], \r\n "limit": 25,\r\n "offset": 0\r\n}\r\n<\/pre>\n\t\t\t<\/div>\n{\r\n "count": 0, "detailed": 1, "timezone": "Europe\/Dublin", "totals": 1,\r\n "filter": {\r\n "browser_id": [2], "campaign_id": [123456], "country_iso": ["USA"], "date_from": \r\n"2019-04-15", "date_to": "2019-04-30", "language_id": [149], "zone_id": [7891011]\r\n },\r\n "group_by": ["date", "zone_id"],\r\n "order_by": [{"field": "impressions", "order": "desc"}],\r\n "projection": ["video"],\r\n "limit": 25,\r\n "offset": 0\r\n}\r\n<\/pre>\n\t\t\t<\/div>\n![\"\"](\"https:\/\/www.exoclick.com\/wp-content\/uploads\/2019\/05\/adv_api4.png\")
<\/p>\n![\"\"](\"https:\/\/www.exoclick.com\/wp-content\/uploads\/2019\/05\/adv_api5.png\")
<\/p>\n{\r\n "count": 0, "detailed": 0, "timezone": "Europe\/Dublin", "totals": 1,\r\n "filter": {\r\n "adblock": "standard", "browser_id": [12345], "category_id": [12345],\r\n "carrier_id": [12345], "country_iso": ["USA"], "device_id": [12345],\r\n "date_from": "2019-01-01", "date_to": "2019-01-14", "hour": [1, 2],\r\n "language_id": [12345], "operating_system_id": [12345],\r\n "region_id": [12345], "site_id": [12345], "sub": [12345], "zone_id": [12345]\r\n },\r\n "group_by": ["date"], "order_by": [{"field": "impressions", "order": "desc"}],\r\n "projection": ["video"],\r\n "limit": 25,\r\n "offset": 0\r\n}\r\n<\/pre>\n\t\t\t<\/div>\n{\r\n "count": 0, "detailed": 1, "timezone": "Europe\/Dublin", "totals": 1,\r\n "filter": {\r\n "adblock": "standard", "browser_id": [2], "category_id": [],\r\n "carrier_id": [], "country_iso": ["USA"], "device_id": [43],\r\n "date_from": "2019-04-15", "date_to": "2019-04-30", "hour": [],\r\n "language_id": [149], "operating_system_id": [11],\r\n "region_id": [], "site_id": [], "sub": [], "zone_id": [3340006]\r\n },\r\n "group_by": ["date"], "order_by": [{"field": "impressions", "order": "desc"}],\r\n "projection": ["video"],\r\n "limit": 25,\r\n "offset": 0\r\n}\r\n<\/pre>\n\t\t\t<\/div>\n![\"\"](\"https:\/\/www.exoclick.com\/wp-content\/uploads\/2019\/05\/pub_api6.png\")
<\/p>\n![\"\"](\"https:\/\/www.exoclick.com\/wp-content\/uploads\/2019\/05\/pub_api7.png\")
<\/p>\n