Knowledge base

Report Builder (beta)

Overview

This article provides a comprehensive look at each setting for your campaigns.

Report Builder is an easy-to-use drag and drop reporting tool available from the Acquire dashboard. Use the Report Builder’s data visualizations to:

  • Analyze performance metrics and gain deeper insights into your campaign data.

  • Visualize data through your preferred chart options.

  • Troubleshoot campaign performance.

  • Filter data in ways that provide actionable insights.

  • Compare based on single or multiple dimensions.

Use Report Builder as a standalone tool, or to supplement your own business intelligence tools, including data you collect using Unity’s Advertiser Statistics API.

Access Report Builder from the left menu of the Acquire dashboard. The landing page displays two sections: DATA CUBES and DASHBOARDS.

  • Data Cubes provide granular report filtering, so that you can drill down and easily modify what is displayed.

  • Dashboards provide holistic overviews of campaign performance.

Initial Dashboard

Dashboards provide a comprehensive view of your campaigns, while data cubes let you drill down or filter over 35 dimensions and over a dozen metrics.

Working with Dashboards

To start with a big picture view, click Performance Visualizations under DASHBOARDS.

Performance visualizations

The first dashboard you will see is the Overview. Under each value, you’ll see a positive or negative value reflecting the difference between this and the last similar period. To help you spot trends, positive values appear green, with an up-arrow, while negative values appear red, with a down-arrow.

Metrics

The top section provides an overview of your cumulative campaign performance over the specified time period (the default is Latest 7 days). The overview tracks the following metrics:

  • Starts: The number of times a user viewed your ad. Starts are commonly called impressions.

  • Installs: The number of times an install was attributed to your ads.

  • Spend: The total budget spent in this period, based on number of installs and cost per install.

  • eCPM: Effective cost per mille is the estimated cost per 1,000 impressions shown.

  • CPI: Cost per install

  • CVR (Installs/Starts): Conversion rate is the total number of installs divided by the number of starts or impressions.

Changing the dashboard filters

You can change the dashboard, time period, and other filters.

Dashboard filters

1 - Use the left menu to choose a dashboard:

  • Overview (the default)

  • Creative Analysis

  • Source Analysis

  • Audience Pinpointer - ROAS

  • Audience Pinpointer - Retention

2 - Click Latest 7 days to select from a list of choices for filtering the time period shown.

Click the + icon to select from a list of dimensions to filter by.

Setting time zone, caching, and update frequency

Click the settings icon in the upper-right corner to configure time zone, update frequency, and caching options.

1 - Set the timezone for the period of the data displayed.

2 - Set how often the data refreshes. You can click the refresh icon at any time to manually update the data.

3 - Set whether to enable caching.

4 - Click View Essence to see the programmatic expression of your data filters.

Switching to Data Cube

As you scroll through the performance dashboards, you’ll see additional tables. Click the double-arrow icon to expand any of the Performance Overview sections. This will switch you to Data Cube mode, where you can drill down further.

Switch to data cube mode

Comparing time periods

The green or red value beneath each metric shows the positive or negative delta (change) from a similar period, as both a total number and a percentage.

For example, the image below shows the number of Starts for your campaigns in the last 7 days, compared to the previous 7-day period.

In this case, your ads were viewed over 3 million times, representing a 646,256 (or 24.1%) increase from the number of times your ads were viewed in the previous 7-day period. For more information, see the section about comparisons.

Working with Data Cubes

To build custom reports, choose the Data Cube you want.

Data Cubes allow you to explore and visualize data from different angles, customizing metrics, chart types, dimensions, and displays.

Using dimensions to customize reports

When you open a Data Cube, a list of dimensions appears in the left column.

Add dimensions as building blocks for your reports. Use the FILTER field to restrict the range of data that appears in the report, and the SHOW field to specify what data fields appears in the report.

Note: A dimension can appear in both the FILTER and SHOW bar.

Example: Suppose you want to study a portion of the countries your campaign runs in. Drag the country dimension to the FILTER bar, then select the countries you want to include. Then, to see the countries listed as a column header, and to be able to sort by them, drag "country" to the SHOW bar.

To apply dimensions to your report either:

  • drag the dimension from the left panel to the + symbol in the FILTER or SHOW bar.

  • highlight a dimension in the left panel, then use the context menu to select Filter or Show. The Add button also allows you to sort how the data appears, and limit what appears.

Working with the FILTER bar

When you drag a dimension to the FILTER bar, a popup appears:

This image shows a report that displays only iOS data, and only data from the last 30 days. The table that appears will list results according to OS version.

For more about refining filter results, see Using filters.

Working with the SHOW bar

  • Move dimensions on the SHOW bar into the order in which you want to display results.
  • After you drag a dimension to the SHOW bar, the display will change to reflect this new field.

Dimensions

Dimension Description
Time The time period for which to display data (default is Latest 7 days)
Country The user’s country
Platform The user’s platform (Android or iOS)
Campaign Set ID The unique numerical identifier of the app plus platform combination.
Campaign Set Name The name of the app plus platform combination.
Campaign ID The unique identifier of individual campaigns
Campaign Name The names of included campaigns
Campaign Type The bid type of the campaign (e.g. standard CPI, ROAS, or Retention)
Creative Pack ID The unique identifier of the creative pack (including ad format and end card)
Creative Pack Name The name of the creative pack, which is the content of your ad campaign.
Creative Type The type of creative (video or playable)
Video Orientation The screen orientation of the creative (portrait or landscape)
Device Language The language settings of the device
Device Orientation The screen orientation of the device (portrait or landscape)
Device Type (Apple) The specific device type where the ad serves (iPhone 7, iPhone 9; limited to Apple only)
Limited Ad Tracking (iOS) The LAT setting of the device (enabled or disabled)
Screen density How many pixels appear within a constant area of the display. See Android pixel size documentation.
Screen Size (Android) Amount of physical space available for displaying an interface. See Android screen size documentation.
OS Version The device’s operating system version
Connection Type The way you are connected to the internet (WIFI or Cellular).
Source App ID The alpha-numeric identifier of the app that displayed your ad
Source Category The app store category of the app that displayed your ad
COPPA Indicates whether the source app’s target audience is under 13 years old in the United States in accordance with COPPA compliance
Target Store ID The identifier of the app listing on the Google Play or Apple App store
Target Game ID The unique identifier of the target (advertised app)
Target Game Name The target (advertised app) name
Target Game Category The app store category of the game or app being advertised
Source Bids Enabled Indicates whether the source bidding feature is enabled
Start Attribution Enabled Start (Impression) is fired when the ad starts
View Attribution Enabled Completed view is fired when the ad ends
Click Attribution Enabled Click event is fired when the user clicks the download button
Organization ID Unique identifier of the account Organization

Using filters

Apply filters to your data to gain powerful insight into campaign performance. You can apply filters to any dimensions. To refine a filter, drag a dimension to the + symbol on the FILTER field, then click to open its context menu.

Apply parameters using the following operations:

Operation Description Example
Include Use this operation to include the selected dimension parameters in your report. Anything not checked is excluded from the report for the corresponding dimension. To isolate campaign data for Android users:
  1. Add the Platform dimension to your filters.
  2. In the operations dropdown, select Include.
  3. Select Android from the dimension parameters, then click Okay.
Exclude Use this operation to exclude the selected dimension parameters from your report. Anything not checked is included in the report for the corresponding dimension. To isolate campaign data for users that are not in the U.S.:
  1. Add the Country dimension to your filters.
  2. In the operations dropdown, select Exclude.
  3. Select US from the dimension parameters, then click Okay.
Contains Use this operation to include any dimension parameters containing a partial string. To isolate campaign data for users that are running some version of the iOS 13 operating system:
  1. Add the OS Version dimension to your filters.
  2. In the operations dropdown, select Contains.
  3. Type 13 in the dimension parameters search bar, then click Okay.
Regex Use this operation to specify custom or compound parameters to include in your report. Some common examples include fuzzy matches, grouping, and "or" statements. For more information, see section on regular expressions. To isolate campaign data for three specific target games:
  1. Add the Target Game ID dimension to your filters.
  2. In the operations dropdown, select Regex.
  3. Type ^exampleID1$|^exampleID2$|^exampleID3$ in the dimension parameters search bar, then click Okay.

Regular expressions (REGEX)

Report Builder filters support regular expressions, or sequences of characters that define a search pattern. To apply regex operations to a filter dimension, select Regex from the operations dropdown that appears when you click a dimension on the FILTER BAR.

Choosing regex

Regex arguments are case- and space-sensitive. For more information about how to use them, read the following example and regular expressions.

Regex Example

Suppose you have a default report view that displays all data from all campaigns within the last 7 days, and you would like to see specific campaigns.

First, drag Campaign Name from the DIMENSIONS panel to the SHOW field:

Using show

What if you want to study only those campaigns with the words Farm or City? To do this, add a filter for Campaign Name, using the Regex option, with the text "Farm|City":

Regex example

When you press OK, only those campaign names that contain the specified text will appear.

Working with metrics

The right panel displays the MEASURE settings. Click the overflow options icon to compare or filter by individual metrics, and the drop-down menu to select which metrics to apply.

Filter choices

Measure (metrics)

You can apply the following metrics to your measure panel.

Metric Description
Starts Start (Impression) is fired when the ad starts
Views The number of times people watched the entire ad
Clicks The number of times people clicked on the button to install a game.
Installs The number of times people actually installed an app.
Spend Budget spent based on number of installs and cost per install
eCPM (effective cost per mille) Estimated cost per 1,000 impressions.
CPI ($) Cost per Install
CTR (Clicks Starts) Clickthrough rate, or the number of times users clicked the install link divided by the number of impressions.
CVR (Installs/Starts) Conversion rate, or the number of installs divided by the number of impressions.
View Completion Rate The number of views divided by the number of starts.

Click COMPARE to see changes from different timeframes. This can help you drill down and understand performance impact.

Time periods

Use this feature to spot trends. Red and green indicators show if the change is positive (green) or negative (red), so that you can see performance at a glance.

r-builder compare

r-builder compare2

Chart types

As you add or subtract dimensions, Report Builder may automatically change to a chart type that might work better for your data. You can change back, or choose another chart type, by clicking the data visualization indicator. As you change chart types, Report Builder may prompt you to add or subtract dimensions.

To see the different charts available, click the current chart type.

Chart Requirements

When you change chart types, Report Builder guides you to add additional dimensions as needed.

Name Limitations and rules
Overall This needs a Measure value but can be used with just a time filter and no dimension.
Table At least one Dimension
Grid Exactly two Dimensions
Line Chart Requires a time dimension.
Area Stack Requires a time dimension.
Bar Chart Flexible, but you might want to limit this to dimensions with few types.
Sunburst Flexible, but you might want to limit this to dimensions with few types.
Heatmap Requires two dimensions.
Treemap Flexible.
Sankey Requires two dimensions.
Bubble Chart Requires two dimensions.
Cross Tab At least two dimensions.
Geo Marks Geo Shades These are not in use at this time.

Examples and Tips

Questions you can ask your data

Which OS versions should I support?

Problem: Keeping your game and creatives backwards-compatible (meaning they work on older levels of operating systems) can be expensive. Is it worth it to keep supporting older systems? Suppose you have this question about iOS devices.

Here are two ways you can find out.

The Big Picture Method

  1. Using My Campaigns, show all OS Versions from the past 30 days by selecting these filters:

To narrow this to iOS, drag platform over to FILTER, then click to select iOS:

  1. Click the top of the column that you think will help you get your answer. You can sort it up or down:

In the table, you can quickly glance to see the various OS’s in use. This is useful, but doesn’t give you the information you want at a glance.

Click the Installs table header. If Installs shows an up arrow, you will see the data sorted with least used operating systems on the top.

To see this information in a way that works for you, experiment with different charts and settings, such as Tree Map. Consider limiting results to the top 5.

Where are my ads performing well?

Using the Filter and the Show settings, you can create a table like this:

As you skim through this page, you notice that video ads that are served in Australia are performing especially well:

Click on the row labeled video to see more information about this, then click Select.

By narrowing what you are looking at to AU and video, the filters at the top also change.

But this doesn’t tell you enough. Drag Campaign Name from the DIMENSIONS list to the SHOW bar.

Click and sort by headings to discover which ad is helping AU perform so well. Then you can apply that knowledge to other campaigns:

Limiting what is displayed

If you see more than you need to see, you can limit what is displayed. For example, if you only want to see the top 10 countries in a chart, click a SHOW dimension and set the Limit to narrow the elements shown:

More about comparing by time

To see what installs and eCPM were the previous quarter, click the ellipsis and select Compare.

To choose the value that matches the current time filter, select Previous period.

Removing all filters and dimensions

Click Reset to remove all filters except the time period.

For more information

Report Builder will give you powerful insights. Please reach out to support if you need help using it or you need more information.

Still need help? Get in touch!
Last updated on 10th Aug 2020