Creating a Trend Report - Airbridge Help Center

The Trend Report visualizes data collected by Airbridge as a time series.

Configuring the Trend Report

Configure the period, metric, GroupBy, and filter to view the data you need. Use GroupBys to break down the selected metrics, and apply filters to narrow down to specific GroupBy values.

Date range

The period consists of four settings: granularity, condition, date, and timezone.

Granularity

Granularity has four options: hourly, daily, weekly, and monthly. Data appears in the selected granularity unit.

Date condition

Three date conditions are available.

Condition	Reference	Date range
Between	Start and end date	From start date to end date
Since	Start date	From start date to today
Last	Number (n)	From n days/weeks/months ago to yesterday

For ‘Last’, you can add ‘Include today’, ‘Include this month’, and ‘Offset’. Including today or this month extends the range from n units ago to today or this month. Click ‘Offset’ and enter a number to push the start point back by that many units. For example, with ‘Daily’ granularity and ‘Last 30 days’, the range runs from 30 days ago to 1 day ago. Turning off ‘Include today’ and adding ‘Offset 3 days’ shifts the range to 33 days ago through 4 days ago.

Date

Use the following criteria when selecting dates.

Earliest selectable date: February 1, 2023
Maximum date range per query: 400 days (daily, weekly, monthly), 15 days (hourly)

Timezone

Timezone is the time zone applied to the report. The default matches the Airbridge App timezone.

Metric

Metrics quantify the data Airbridge collects through tracking links, the SDK, the API, and other sources. Select 1 to 8 metrics for a single view. Metrics without collected data do not appear. Three metric types are available: Standard Metric, Cohort Metric, and Custom Metric. For details, see Airbridge report metrics.

GroupBy

GroupBys break metrics down by the selected dimension. For example, selecting Channel groups metrics by ad channel. You can select up to 4 GroupBys. The behavior varies by metric type.

Standard Metric, Custom Metric: Applied per metric.
Cohort Metric: Applied to the start event.

Filter

Filters narrow results to specific GroupBy values. The format is A is B, where A is a GroupBy and B is the filter value. Only values Airbridge has collected at least once appear in the search results for B. ‘is’ is the default condition. All available conditions are listed below.

Condition	Format	Description
is	A is B	Returns data where A equals B
is not	A is not B	Returns data where A does not equal B
contains	A contains B	Returns data where A includes B
does not contain	A does not contain B	Returns data where A does not include B
exists	A exists	Returns data where A is present
does not exist	A does not exist	Returns data where A is not present

Viewing the Trend Report

Once you finish configuring the report, you can view the results. The results appear in chart and table form.

Chart

NoteThe Trend Report chart displays the metric data in count or sum units. If the value gap between the items is too wide, the chart may not display them correctly due to the difference in results. To avoid such errors, it is recommended not to query items with value gaps expected to be too wide.

The line chart shows data by granularity. Hover over the chart to see all values for that date, or hover over a specific point on a line to see only that point. Click items in the legend below the chart to toggle them. Drag to select an area for zoom, and click ‘Reset’ to return to the original view.

Table

All data appears in the table. Use the checkboxes on the left to show only selected items on the chart.

Example) View app install trends by channel

On the Airbridge dashboard, go to [Reports]>[Trend] and configure as follows.

Period: Set the date range and granularity. For example, select ‘Daily’ to view daily trends.
Metric: Select ‘Installs (App)’.
GroupBy: Select ‘Channel’.

You can share the results through the following features.

Feature	Description
Report Library	When you save a report with your settings, other users with access can see it with your settings applied. Saved reports appear under [Report Library].
Copy Config	Share view settings with other Airbridge users regardless of their app roles or access level. Trend Report configs can be pasted into the Actuals Report to view the same data. Depending on the number of metrics and GroupBys, an Actuals Report config may not paste into the Trend Report.
Report URL	A Report URL is generated each time you view a report. Even without saving, you can share the URL with users who have view access to see the same report.
Copy Table	Click ‘Copy Table’ to paste the table into Excel, Google Sheets, or similar tools.
Export	Download report results in your chosen format.

Trend Report features and limitations

Below are the features and limitations of the Trend Report.

Feature/Limitation	Description
No. of metrics configurable	8
No. of GroupBys configurable	4
Self-serve Metrics, Custom Metrics, Custom GroupBys	Supported
Timezone	The configured Airbridge App timezone. Configurable per report view.
Currency	The configured Airbridge App standard currency
Data visualized in	Tables, charts
Data refresh cycle	Real-time, except for user count metric data (1 hour)
Aggregated data	App event data, web event data, SKAN data, cost data
Custom events	Supported
Maximum no. of rows in the Airbridge dashboard	100 rows
Maximum no. of rows in CSV/Google Sheets	1,000 rows
Data available of	Past 5 years
Maximum date range configurable for a single report view	400 days (daily, weekly, monthly), 15 days (hourly)

General features

These features are supported across Airbridge reports. Some may not apply to certain reports.

Name	Description
Refresh	Reloads results with the current report configuration. The time since the last load appears next to the button.
Wide controls	Configure the report on a wider panel.
Search	Search within the report results.
Expand/Collapse	Expand or collapse the report configuration.
Report naming	Name the report. A name is required to save the report.

Attention

Note the following.

Custom Metrics using metrics from only some apps

Custom Metrics are available across every app in your organization. However, if a Custom Metric’s formula includes a metric defined for only some apps, the results may not reflect what you expect.

Example) When some apps in the organization do not collect a specific metric

App A and App B are in the same organization. Both apps use the following custom events and self-serve metric.

Event/Metric	push_sent (custom event)	in_app_sent (custom event)	push_clicked (self-serve metric)
App A	Collected	Collected	Collected
App B	Collected	Collected	Not collected

Assume custom metrics are defined as follows.

message_sent = push_sent + in_app_sent
push_click_rate = (push_clicked / push_sent) * 100

In the results for each app, App A can see both custom metrics. However, App B shows push_click_rate as 0 because App B does not collect the push_clicked metric.

App	message_sent	push_click_rate
App A	Available	Available
App B	Available	Unavailable (Shown as 0 because push_clicked metric is not collected)

Interoperability of Copy Config

Among Airbridge reports, configs can be copied only between the Actuals Report and the Trend Report.
The Trend Report allows fewer metrics and GroupBys than the Actuals Report. Pasting an Actuals Report config that exceeds the Trend Report’s limits results in an error.

​Configuring the Trend Report

​Date range

Granularity

Date condition

Date

Timezone

​Metric

​GroupBy

​Filter

​Viewing the Trend Report

​Chart

​Table

​Sharing the Trend Report

​Trend Report features and limitations

​General features

​Attention

​Custom Metrics using metrics from only some apps

​Interoperability of Copy Config

Configuring the Trend Report

Date range

Metric

GroupBy

Filter

Viewing the Trend Report

Chart

Table

Sharing the Trend Report

Trend Report features and limitations

General features

Attention

Custom Metrics using metrics from only some apps

Interoperability of Copy Config