Actuals Report

Jusang SongWritten by Jusang Song,

The Actuals Report displays the touchpoint data and event data tracked by Airbridge. You can customize the report using a variety of metrics and further segment the data using GroupBys and filters to build a report that suits your marketing needs.

The configured reports can be saved and pulled up whenever you want to view them. You can also download your reports as CSV files or export them to Google Spreadsheets.

 

How to Build Reports

Click the [Configuration] icon on the right, or the “+ Add” button in the configuration box to start building a report.

Metrics

The Actuals Report displays the metrics you select by aggregating the touchpoint data, cost data, and event data from various sources.

For the full list of the available metrics in the Actuals Report, refer to the Report Metric user guide. You can also create your own custom metrics.

You can also select events as your metric to view the aggregated event data that are pulled from your app and web service. The app event names include “(App),” and web event names include “(Web).” Depending on the event metrics you select, you can view the event count, event value, or user count in your report.

 

Event Count

Most event metrics measure the event count. For example, when selecting the “Installs (App),” your report will display the number of install events that occurred within the set analysis period.

Event Value

Some event metrics measure the event value, such as the revenue from purchased product items, subscriptions, ad impressions, and more. For example, when selecting “Revenue (App),” your report will display the revenue generated by the “Order Complete (App)” event during the set analysis period.

The following table lists the metrics that measure the event value. To activate the following metrics, you need to define the event values in the Airbridge taxonomy setup process.

App Event Metrics

Web Event Metrics

Description

Revenue (App)

Revenue (Web)

Revenue generated by the Order Complete events

First Revenue (App)

First Revenue (Web)

Revenue generated by the first Order Complete events

Re-revenue (App)

Re-revenue (Web)

Revenue generated by recurring Order Complete events

Attributed Revenue (App)

Attributed Revenue (Web)

Revenue generated by Order Complete events attributed to integrated ad channels or custom channels

Unattributed Revenue (App)

Unattributed Revenue (Web)

Revenue generated by Order Complete events not attributed to any channel

Contribution Margin Revenue (App)

Contribution Margin Revenue (Web)

Contribution margin

Refund Amount (App)

Refund Amount (Web)

Refund amount from the purchase

Subscription Revenue (App)

Subscription Revenue (Web)

Revenue generated by subscriptions

Unsubscription Amount (App)

Unsubscription Amount (Web)

Canceled payment amount from unsubscriptions

Ad Impression Revenue (App)

Ad Impression Revenue (Web)

Revenue generated by ad impressions

Ad Click Revenue (App)

Ad Click Revenue (Web)

Revenue generated by ad clicks

Total Ad Revenue (App)

Total Ad Revenue (Web)

The sum of Ad Impression Revenue and Ad Click Revenue

  

Users

The number of users who performed Airbridge Standard Events and Custom Events that have been collected via the Airbridge SDK at least once can be viewed in the Actuals Report by selecting event metrics that include “Users” in their names.

For example, if you select the “Add to Cart Users (App)” event, the report will display the number of users that added at least one item to their cart in the app during the set analysis period.

The value for the event metrics measuring user counts is updated on an hourly basis. For example, the number of users that subscribed to your app service between 12:00 PM and 1:00 PM will be aggregated and made available in the Actuals Report after 1:00 PM when selecting “Subscribe Users (App)” as your report metric.

Unique identification

Different types of UUID are used to identify unique devices for app and web events. Airbridge Device ID is used for app events, and Cookie ID is used for web events.

Airbridge Device ID

Airbridge Device ID is the UUID used to identify unique devices. By default, GAID (Android) and IDFV (iOS) are used as the Airbridge Device ID. In case GAID or IDFV could not be collected or is unavailable due to the restrictions of LAT or ATT, a UUID randomly generated by the Airbridge SDK is used as the Airbridge Device ID.

GroupBy

You can segment your data by using GroupBy. GroupBys are categorized into Event Datetime, Touchpoint, Attribution Result, to name a few. The order of the selected GroupBys can be reorganized by dragging and dropping individual GroupBys.

For example, if you select “Event Date,” “Channel,” and “Campaign” and click the “Done” button at the bottom, your data will be grouped accordingly and will be displayed like the following image.

If you remove the “Event Date,” the “Event Date” column will disappear, and the data will be displayed like the following image.

Filter

You can add filters to create a report that only includes data that is most relevant to your marketing context. For example, if you want to create a report with data from apple.searchads and google.adwords, click the [Filter] tab, and create a filter accordingly in the configuration board.

When the filter is applied, the report will show the filtered result. The following report shows the install counts and in-app event counts aggregated from the channel data of apple.searchads and google.adwords.

For a quick filter edit, simply hover over the GroupBy items to find the [=] and [≠] icons on the right of each column. Click the icons to add or delete filters. From the top configuration box, you can also delete a filter by clicking the [x] icon or deactivate a filter by clicking the [eye] icon.

Time zone

When you set a time zone in the Actuals report, you can view data aggregated by time zone. The default timezone is the same as the App time zone.

Save and Bookmark Your Report

If you want to save your report for later, click the “Save” button in the upper right. Enter a name for your report to save it.

To open a saved report, click “Saved Reports” on the top right and find the report from the dropdown list. The Owner role account user and the In-house Marketer role account users share the same list of saved reports. The Agency role users share the same list of saved reports with the Agency role users from the same agency.

The saved reports can be bookmarked as well. To bookmark a report, click the star left to the report name. By selecting the [Bookmarks] menu with the star icon at the top of the menu bar, you can quickly pull up the saved reports. Up to 40 reports can be bookmarked per account.

 

Copy Your Report

You can easily copy the values in the report table and paste them directly into an Excel file, or a spreadsheet with the table formatting kept intact.

Download Your Report

You can download your reports as CSV files or export them to Google Spreadsheets by clicking the [Expand] icon next to the “Export CSV” button at the top of the configuration box. The download time may vary depending on the amount of data.

Copy the Configuration

You may need to create a Trend Report with the same configuration as your Actuals Report or describe an issue in your Actuals Report to your CSM. In those situations, you can easily copy the configuration of your Actuals Report by clicking the “Copy Config” button. To paste the copied configuration, open a new report, click the [Expand] icon next to the “Copy Config” button, and select “Past Config,” or select “Open Editor” to edit the config.

Please note that some data fields in the Actuals Report may not be supported in the Trend Report.

Service Limit

Resource

Value

Max. number of metrics configurable per report

20

Max. number of GroupBys configurable per report

10

Max. visible rows in Airbridge Dashboard

10,000

Max. visible rows in the downloaded CSV or Spreadsheet file

500,000

Max. visible rows in the CSV file available by the Sharelink

50,000

Data Retention

365 days

Was this page helpful?

Have any questions or suggestions?