Data Collaboration Platform (DCP) - View measurement reports

The collaboration measurement report is an aggregated report that summarizes data by grouping and combining individual records. It provides high-level insights rather than raw, user-level data.

Report fields are divided into two types: dimensions and metrics. Each can be further divided into basic fields and calculated fields.

Dimensions

A dimension is a grouping category that aggregates event-level data into report records. For example, if the media source is selected as the report dimension, each row will contain aggregated data for all events attributed to that media source. The number of rows equals the number of media sources.

Adding more dimensions increases the grouping granularity. For instance, selecting Event date, Media source, and Campaign results in one row per unique combination of those fields.

Metrics

A metric is numerical data grouped based on the selected dimensions.

For example, if Revenue is selected as the metric and Media source is the only dimension, the report displays total revenue per media source.

When multiple dimensions are selected, such as Event date, Media source, and Campaign, the revenue is grouped by the combination of those fields.

When selecting a metric, choose its aggregation function. For example, for the revenue metric, you would select the SUM function. 

What are basic and calculated fields?

Dimensions and metrics can be either basic fields or calculated fields.

• Basic fields: Basic fields contain raw data from sources or in-app events.
• Calculated fields: Calculated fields use basic fields to compute values using defined functions.

1. In AppsFlyer, from the side menu, go to Collaborate > Data Clean Room.
2. On the Data Collaboration Platform page, select the relevant collaboration.
3. On the measurement dashboard, click Create report.
4. In the dialog that appears click Customize.
5. On the New report page, perform the listed steps.

Under the Report type step, select  Commerce media measurement, then, click Next.

Under the Filters and data sources step:

1. In the Report name box, enter a name for the report.
   • This can be any name that will help you identify the report in the DCR platform.
   • Important! Ensure that the report name is different from all other reports in your account or you will not be able to save the report.
   • Report name requirements:
     • Length: 2-80 characters
     • Valid characters:
       • letters (A-Z, a-z)
       • numbers (0-9), cannot be the first character of a name
       • a hyphen (-), cannot be the first character of a name
     • Invalid characters:
       • spaces
       • all other symbols or special characters
2. In the Collaboration name box, select the relevant collaboration.
3. In the Timeframe slider, set the report’s span in days (1-180). Only attributed conversion events occurring within the selected span will appear in the report. The span is calculated backward from the report’s day.
4. Click Next.

If you want to customize the report you can select your report dimensions and metrics. For a comprehensive list of the report fields see the report scheme in this article.

To set the report dimensions and metrics, follow these steps:

1. Under the Structure step, from the Dimension from sources list, select the fields you want to be included in the report.
2. If you want to create a calculated field click + Calculated field and see Create calculated field in this article.
3. You can include the field in the report as a dimension or as a metric.
   • To include the field in the report as a dimension, click Set as dimension.
   • To include the field in the report as a metric, click Set as metric.
4. If you set the field as a metric, select its aggregation function:
   • Sum: The metric value is the sum of event-level values aggregated in the report record. For example, the revenue metric is the sum of  sku_revenue all events grouped in the record.
   • Count: The metric value is the count of event-level values aggregated in the report record. For example, the conversions metric is the count of all the conversions included in the grouped record.
   • Count distinct: The metric value is the number of unique values for a given field across the events grouped in the report record. For example, If the selected metric is count-distinct of sku and a grouped record includes 10 events containing 4 different SKUs, the metric value will be 4.
5. To change the display name of the field, hover over the field and click Edit display name.

Dimension groups with very few user-level events may conflict with data privacy regulations.

To resolve this, DCR merges small groups with larger groups by eliminating the dimensions with the highest specificity. 

By default, dimensions are removed in reverse order of their position in the Report dimensions list. However, you can adjust the default order and apply a different regrouping priority to preserve the dimensions most important to you. To learn more see a Regrouping example.

To change the dimension priority:

1. Under the Manage dimension priority step, click Manage dimension priority.
2. Drag the dimension to rearrange the order.
   • The dimension labeled as the Highest priority (at the top of the list) means it will be the last to be eliminated if regrouping is required.
3. [Optional] To apply regrouping to custom source dimensions:
   1. Click Use advanced options to refine regrouping
   2. Select custom source dimensions to which you'd like to apply regrouping.
   3. The selected dimensions are added to the Manage dimension priority list.
      • By default, these dimensions are added to the bottom of the list as the Lowest priority for regrouping. However, you can reorder them just like attribution data dimensions, as described above.
4. Click Next to save your changes.
   • The Report dimensions list on the main screen remains in its original order, but the revised order has been saved. (Click again on the Manage dimension priority button to review or edit your selection.)

DCP delivers reports to your selected cloud services using AppsFlyer Data Locker. Therefore, specifying the report destination involves selecting or creating a Data Locker connection.

To set the report schedule and destination:

1. In the Settings step, under the Schedule section, select the report schedule (daily, weekly, or monthly).
2. Depending on the selected interval, select the hour, day in a week, or month of the report.
3. Under the Destination section, select from the list of Data Locker connections available in your AppsFlyer account.
   • If there are no connections defined in your account:
     • A new tab will open in your browser (showing the AppsFlyer Data Locker page)
     • A New connection dialog will open. Follow these instructions to create the connection.
   • If you have existing connections but want to use a new one, click + New connection in Data Locker:
     • A new tab will open in your browser (showing the AppsFlyer Data Locker page)
     • A New connection dialog will open. Follow these instructions to create the connection.
     • After creating the connection, return to the DCP tab in your browser and select the newly created connection from the list of Data Locker connections.
4. To receive report status notifications via API, turn on Report status notifications, and in the API endpoint box, enter your API URL.
5. Click Save to save the report.
6. The new report is now displayed in the Reports tab.