Creating a Trend Report

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.

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.

Viewing the Trend Report

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

Chart

Note

The 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.

Sharing the Trend Report

You can share the results through the following features.

A Sharelink is a URL that lets recipients download a CSV containing Trend Report data. Generate one by clicking the share button to the right of the report name. Sharelinks are available only from [Saved reports]. For details, see Sharing report data in real time with Sharelinks.

Trend Report features and limitations

Below are the features and limitations of the Trend Report.

General features

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

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.

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.