Using the Report Builder
NOTE: This document is in the process of being updated to reflect the new centralized Unified Dashboard design. Refer to the Unified Dashboard Guide to learn about the highlights and how to navigate the unified dashboard.
This article provides a comprehensive look at each setting for your campaigns.
- Working with Dashboards
- Working with Data Cubes
- Working with dimensions
- Working with metrics
- Examples and Tips
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.
- Click Reporting from the Acquire dashboard left menu. Acquire dashboard.
- You'll see the Report Builder launch page. Play the video for a brief introduction, then click Go to Report Builder.
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.
Working with Dashboards
To start with a big picture view, click Performance Visualizations under DASHBOARDS.
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.
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.
1 - Use the left menu to choose a dashboard:
Overview (the default)
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.
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.
|Time||The time period for which to display data.|
|Country||The user’s country.|
|Platform||The user’s platform (Android or iOS).|
|Reach Extension||The source of the user. Either Unity or Exchanges.|
|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 Billing Type||Can be either CPI (cost per install) with Android campaigns or CPM (cost per impression) with iOS campaigns.|
|Campaign Goal||The bid type of the campaign (e.g. standard CPI, ROAS, or Retention). This is the same as the Campaign Type.|
|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, playable, or video & playable end card).|
|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 (iOS)||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 (Android)||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 .|
|SKad Conversion Value||A single number between 0 and 63. This is sent by an app after it is installed, included in the SKAdNetwork postback sent to the advertising network responsible for the app install or app reinstall.|
|OS Version||The device’s operating system version.|
|Connection Type||The connection to the internet (WIFI or Cellular).|
|SKAd Enabled||True for devices that support Apple's SKAdNetwork. This field will give you better visibility into traffic that is coming from SKAd.|
|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.|
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:
|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:
|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.:
|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:
|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:
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.
Regex arguments are case- and space-sensitive. For more information about how to use them, read the following example and regular expressions.
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:
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":
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.
You can apply the following metrics to your measure panel.
|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.|
Spotting trends with COMPARE
Click COMPARE to see changes from different timeframes. This can help you drill down and understand performance impact.
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.
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.
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.|
|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
- 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:
- 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.