> ## Documentation Index
> Fetch the complete documentation index at: https://help.cryptolens.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Daily Country Aggregate

> A daily country aggregate contains Web API log totals for a product, date, and country.

A daily country aggregate contains Web API log totals for a product, date, and country.

Usage analytics are updated asynchronously, so very recent activity may not appear immediately. Countries are
resolved from request IP addresses. Activity without a resolvable country is not included in this result. Daily
country aggregates exclude license keys that are configured to be excluded from usage analytics. See the
[KPI dashboard guide](https://help.cryptolens.io/feature/web-ui/kpi-dashboards#excluding-licenses-that-are-used-for-testing-purposes)
for details about excluding test licenses.

*Successful* counts Web API log states with third digit *1*, and *Failed* counts states with third digit
*2*. See [Web API Log state codes](/api-reference/generated/model/WebAPILog#state-codes) for the general format.

### Structure

| **Parameter** | **Description** | **Remarks** |
| - | - | - |
| Id | A unique identifier of this aggregate. | An integer |
| ProductId | The id of the product. | An integer |
| Date | The date that this aggregate describes. | yyyy-MM-dd |
| CountryCode | The two-letter country code. | A string, for example US or SE |
| TotalRequests | The total number of requests logged for this product, day, and country. | An integer |
| Successful | The number of successful requests. | An integer |
| Failed | The number of failed requests. | An integer |