# Asking a Question

{% hint style="info" %}
If you're just getting started, we recommend you read the [<mark style="color:blue;">analytics layout page</mark>](https://docs.adlibertas.com/the-platform/business-analytics/analytics-layout)<mark style="color:blue;">.</mark>
{% endhint %}

### Walk-through video asking a custom question

{% embed url="<https://youtu.be/8GIhPTlvtTU>" %}

### Step 1: "Data" - Choose your data table

![](https://336314087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaO8orL32xNzJW4MhnNef%2Fuploads%2FAVLj2zqN4fR9fa1WTjbD%2Fimage.png?alt=media\&token=975f83ab-6690-4adf-b569-061183c2406a)

The "data" field allows you to select data tables available to you. These tables will depend on which products you've signed up for in AdLIbertas.

![](https://336314087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaO8orL32xNzJW4MhnNef%2Fuploads%2FZEoPyrA9gT8SAa8NRJzy%2Fimage.png?alt=media\&token=5ebdc269-6c0a-4ed4-a578-312dbb4c1eeb)

* ~~AdLibertas Cost:~~ Deprecated
* ~~App Store and MoPub Revenue:~~ Deprecated
* **App Store IAP:** in-app purchase data collected from the app stores. For more information please see [<mark style="color:blue;">How App Store Reporting works</mark>](https://docs.adlibertas.com/data-integrations/ad-network-and-store-connections/how-does-app-store-reporting-work)<mark style="color:blue;">.</mark>
* **App Store Subscriptions:** Same as above, except for subscriptions.
* **Audience Reporting Metrics:**  volume and count of user-level data you are importing. For more information, see [<mark style="color:blue;">AdLibertas Cost.</mark>](https://docs.adlibertas.com/the-platform/general/adlibertas-cost)
* **Consolidated Reporting Data:** Table of all ad revenue earnings. For more information see [Consolidated Reporting Overview.](https://docs.adlibertas.com/the-platform/consolidated-revenue-reporting)
* **Consolidated Reporting Inventory Data:** For the difference see [<mark style="color:blue;">Consolidated Reporting vs. Consolidated Inventory Reporting</mark>](https://docs.adlibertas.com/the-platform/consolidated-revenue-reporting/consolidated-reporting-vs.-consolidated-inventory-reporting)
* Li~~ne Item Change Logs~~: deprecated
* ~~MoPub Campaign Reporting~~ deprecated
* ~~MoPub Inventory Reporting:~~ deprecated
* **Reporting Absolute Audience Reports:** Keeps an updated table of your most recently run [<mark style="color:blue;">user</mark> ](https://docs.adlibertas.com/the-platform/user-level-audience-reporting)level [<mark style="color:blue;">absolute reports</mark>](https://docs.adlibertas.com/the-platform/user-level-audience-reporting/report-layout/chart-type-module-absolute-vs.-relative-reports). Subsequent reports will overwrite previously run reports.
* **Reporting Absolute Audience Historical Reports:** A comprehensive table of all user-level [<mark style="color:blue;">absolute reports</mark>](https://docs.adlibertas.com/the-platform/user-level-audience-reporting/report-layout/chart-type-module-absolute-vs.-relative-reports). Every day an absolute report is updated, a historical record will be stored.
* **Reporting Relative Audience Reports:** Table containing results of the recently run user-level relative report. Every report run overwrites previously created data.
* **Reporting Relative Audience HIstorical Reports:** Table contains the daily historical record of [<mark style="color:blue;">user</mark>](https://docs.adlibertas.com/the-platform/user-level-audience-reporting)-level [<mark style="color:blue;">relative</mark> ](https://docs.adlibertas.com/the-platform/user-level-audience-reporting/report-layout/chart-type-module-absolute-vs.-relative-reports)reports. Every day an absolute report is updated, a record will be stored in this table.
* **Users By App Version:** A table outlining revenue, impressions, and users by app version. Useful for setting up custom KPIs to track new app releases.

### **Step 2: "Filtered By"  - Setting filters**

Filters limit the amount of data returned in your report.

![](https://336314087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaO8orL32xNzJW4MhnNef%2Fuploads%2FFBUTN44Id4o5rmEue17n%2Fimage.png?alt=media\&token=ebcef55b-b49e-4125-9626-90fe3f5294e6)

Each table has the ability to limit the data by column or row values in the table. In the example above a date filter will only return data from within the selected date ranges.&#x20;

{% hint style="info" %}
PivotTable Junkies: This is your **FILTERS** field
{% endhint %}

### Step 3: "View" -  choose metrics/dimensions for your report

The view section allows you to choose metrics to be returned in your report.

![](https://336314087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaO8orL32xNzJW4MhnNef%2Fuploads%2FtnkpTvpAicCjLFD8S5No%2Fimage.png?alt=media\&token=f762ef86-a18c-4d48-a199-09ecd11906d0)

This section will allow you to add metrics to your report, such as users, impressions, or revenue. In a chart, the metrics will be the individual variants. In a table, the metrics will be table values.

Once you get familiar with metrics, consider exploring [custom metrics.](https://docs.adlibertas.com/the-platform/business-analytics/creating-a-custom-dimension)

![](https://336314087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaO8orL32xNzJW4MhnNef%2Fuploads%2F04QXbLHIV7NE9iUbhfZj%2Fimage.png?alt=media\&token=4c20ec56-e640-4989-838a-7303787c4be3)

{% hint style="info" %}
PivotTable Junkies: This is your **VALUES** field
{% endhint %}

### Step 4: "Grouped By" - Choose data segmentation

![](https://336314087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaO8orL32xNzJW4MhnNef%2Fuploads%2F389E4RQg8tfJMWXZfYuu%2Fimage.png?alt=media\&token=7edbdd13-851a-4055-bfcb-a702b33fb864)

The group by section allows you to break out your report by values in your table. You can only chart 20 individual groupings.

![](https://336314087-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaO8orL32xNzJW4MhnNef%2Fuploads%2Fc5sG5M29CoH2aGN9rZH6%2Fimage.png?alt=media\&token=9361738d-bc0a-4577-adcd-c6f15bd0b149)

{% hint style="info" %}
PivotTable Junkies: This is your **ROW** field
{% endhint %}

{% embed url="<https://youtu.be/8GIhPTlvtTU>" %}

###

###
