# Activities analytics queries

This API gives you programmatic access to user activities as a data cube. You get metrics with dimensions, filters, and within date ranges leveraging the [Activity analytics](https://developer.mediarithmics.io/data-streams/data-ingestion/activities-analytics) part of our multi-model database.

![](https://4196284719-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMuoqM-5hJ5JY0WnAKL%2Fuploads%2FidmNpZOQByNZpeUJLOsJ%2FAnalytics%20cube%20queries%20datamart.png?alt=media\&token=6876c89b-6749-4f15-8031-63f8b0ad9398)

With the activities analytics API, you can create reports to answer questions like:  

* **Number of active users.** The metric is `users` and it has no dimensions or filter.
* **Number of active users per channel per day.** The metric is `users`, grouped by `channel_id` and `date_yyyymmdd` dimensions, without filters.
* **Number of sessions per day for users who had an activity of type AD\_VIEW on campaign 666.** The metric is `sessions`, grouped by the `date_yyyymmdd` dimension with filter clauses  `activity_type = AD_VIEW` and `origin_campaign_id = 666`  
* **Days with more than 200k transactions on a specific channel**. The metric is `number_of_transactions`, grouped ty the `date_yyyymmdd` dimension with filter clauses on `channel_id = 666`. Then a filter is applied on the calculated metric to only keep days with more than 200k transactions.

It can also be used to build custom dashboards. For more information, see [Dashboards](https://developer.mediarithmics.io/dashboards).

{% hint style="info" %}

* Maximum recommended **5 queries per second.**
* Response time around **1 second**.
* Results date range for the **4 latest months**.
  {% endhint %}

## Quick start guide

Calling the API to get your first metrics is easy with your favorite tool that you already use to query other mediarithmics endpoints. See the [API Quickstart](https://developer.mediarithmics.io/querying-your-data/activities-analytics-queries/api-quickstart) guide to get started.  

## Available endpoints

* [`user_activities_analytics`](https://developer.mediarithmics.io/resources/data-cubes/reference#user_activities_analytics-endpoint) returns a customized report of your activities analytics data.

## Supported dimensions and metrics

See [Dimensions en metrics](https://developer.mediarithmics.io/querying-your-data/activities-analytics-queries/dimensions-and-metrics) for the complete list of supported dimensions and metrics.

## How data cubes work

This endpoint is a mediarithmics [Data cube](https://developer.mediarithmics.io/resources/data-cubes). You can find documentation on how data cubes work and which data cubes are available in the specific documentation section.