Data Clean Room—Working with reports

At a glance: Set up the reports you'll receive from the Data Clean Room (DCR).

Introduction

Once you have set up your sources in the AppsFlyer DCR platform, the next step is to set up the reports you want to receive.

You can see a list of all existing reports in the Reports tab of the DCR.

Creating a report

Preliminary steps

To create a report:

  1. Go to the Reports tab of the Data Clean Room.
  2. Click the + New report button.
    The New report page opens.
  3. Enter the name of the report.
    • This can be any name that will help you identify the report within the AppsFlyer DCR platform.
    • Important! Ensure that the report name is different 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
        • hyphens (-), cannot be the first character of a name
      • Invalid characters:
        • spaces
        • all other symbols or special characters
    • Once a report has been saved, the report name cannot be edited without recreating the report.

Select sources

Custom sources: When defining report structure, you can elect to use data from any of the sources you have set up. You must select at least one of your sources.

Attribution data sources: Several options are available for specifying the AppsFlyer attribution data to be used in a report:

  • Attribution type: Select one or more types of AppsFlyer attribution data to be used for the report – installs, re-engagements, and/or re-attributions.
  • Apps: Select data from one or more of the apps in your AppsFlyer account.
  • Timeframe: Select the number of days of historical data for which you want the DCR to search for attribution events matching your source events (from 1 to 180 days).

Join sources

In order to match data among sources, each of the sources to be included in the report must include at least one identifier mapped to an identifier in another source.

  • One of your sources must include an identifier mapped to a key identifier.

Treatment of multiple matching events (matching model)

If the AppsFlyer event types you select for your report include re-engagements or re-attributions, it's possible that the AppsFlyer attribution data will include more than one event during the selected timeframe with the same key identifier. When this is the case, you must instruct AppsFlyer which matching events it should include in the report.

  • Note: If you elect to include only installs, this section is irrelevant, and you can skip to Select dimensions.

Matching all events

The most comprehensive matching model allows your report to include all matching events. In order to achieve this result, you must map the AppsFlyer identifier install_time to an identifier in one of your sources.

  • The identifier in your source that is mapped to AppsFlyer install_time must be in the following format: yyyy-MM-dd HH:mm:ss
  • Note: Though the name of the AppsFlyer identifier is install_time, it actually means event time when referring to re-engagement or re-attribution events.

Matching a single event

If the AppsFlyer event types you select for your report include re-engagements or re-attributions but you do not map the AppsFlyer identifier install_time to an identifier in one of your sources, you must select to use either the last or first matching event in your report.

  • Last event: The attribution event included in the report is the last event (chronologically) in the data lookback period that matches a specific AppsFlyer_ID.
  • First event: The attribution event included in the report is the first event (chronologically) in the data lookback period that matches a specific AppsFlyer_ID.

Make this selection based on the event you consider to be most relevant to the insights you want to obtain from the report.

This selection is irrelevant for your report if:

  • You have mapped the AppsFlyer identifier install_time to an identifier in one of your sources; or
  • Your report's AppsFlyer attribution types include installs only

Select dimensions

Recall that user-level data cannot be reported by the DCR. Instead, it provides you with the decision-making insights you need by aggregating (or grouping) the data by the dimensions you choose.

A dimension is generally an attribute by which you categorize app users (for example, geo, install date, campaign, etc.) and can be any field from your sources that you have categorized as a dimension.

To select the dimensions to include in your report:

  1. Select one or more dimensions in the Dimensions from sources list on the left and use the Add button in the middle of the screen to add them to the list of Report dimensions.
    • You can use the search bar to search for dimensions in the lists.
  2. To remove a dimension, select it from the Report dimensions list and use the Remove button to return it to the Dimensions from sources list.
  3. Repeat this process until you have added each dimension you want to include in the report.

By default, all reports are grouped by the dimension of media_source.

Preserving privacy while grouping by dimension

Depending on the size of your data set, the number of dimensions you choose, and other factors, it's possible that a report would include one or more groups of only 1 user. Reporting the data in this way would violate restrictions against providing user-level data.

However, instead of removing or hiding the data from the report completely, AppsFlyer uses a regrouping mechanism to provide as much detail as possible while maintaining a commitment to user privacy.

 Regrouping example

Assume you have set up a report according to the following dimensions (in order):

  • AppsFlyer dimensions:
    • media source
    • campaign
    • adset_name
    • ad_id
  • Your source dimensions:
    • user_type

Before regrouping

After initial analysis of the data, AppsFlyer determines that the data would break down as follows:

media
source
campaign adset
name
ad
id
user
type
rev
D0
rev
D7
count reportable?
facebook_ads UA_100 green kjh867 buyer 1 4 12

facebook_ads UA_101 green jkj987 ultra 2 23 22

facebook_ads UA_200 green lkh123 beg 6 7 1

X

facebook_ads UA_200 green ilk945 beg 3 21 1

X

facebook_ads UA_200 green plm654 beg 8 17 1

X

As it stands, the final three rows are not reportable because each row contains only 1 user. According to the regrouping logic, AppsFlyer first "eliminates" the last-listed AppsFlyer dimension (which, in this case, is ad_id). It then analyzes the data again to see which rows are reportable.

  • Note: AppsFlyer applies regrouping based only on AppsFlyer dimensions. Regrouping is not applied to advertiser dimensions.

After regrouping

After applying the regrouping logic, the report appears as follows:

media
source
campaign adset
name
ad
id
user
type
rev
D0
rev
D7
count reportable?
facebook_ads UA_100 green kjh867 buyer 1 4 12

facebook_ads UA_101 green jkj987 ultra 2 23 22

facebook_ads UA_200 green RESTRICTED beg 17 45 3

Results:

  • The last row now combines the data that had previously been on 3 rows. The combined row now has a user count of greater than 1 and can be reported.
  • The dimension that was eliminated is now reported as RESTRICTED.
  • Had there still been unreportable rows (number of users=1), AppsFlyer would continue to analyze the data on an iterative basis, eliminating one dimension after another in reverse order until it either:
    • can report all rows; or
    • runs out of AppsFlyer dimensions to eliminate

 Important!

Because regrouping iterations eliminate dimensions in order (working backward through the list of configured report dimensions), it's important that you set up your report with AppsFlyer dimensions listed in order of importance (most important to least important).

Currently, dimensions cannot be reordered directly. Therefore, if you want to change the order in which dimensions appear in the Report dimensions list, remove the dimensions from the list and re-add them in the order you choose.

Select metrics

Metrics are the numeric data you have collected with respect to an app user (examples might include revenue, number of app opens, LTV, etc.) and can be any numeric data field from your sources that you have categorized as a metric.

To select the metrics to include in your report:

  1. Select one or more metrics in the Metrics from sources list on the left and use the Add button in the middle of the screen to add them to the list of Report metrics.
    • You can use the search bar to search for metrics in the lists.
  2. For each metric in the Report metrics list, select whether you want the data reported as either:
    • a sum of numeric values; or
    • a count of distinct values
  3. To remove a metric, select it from the Report metrics list and use the Remove button to return it to the Metrics from sources list.
  4. Repeat this process until you have added each metric you want to include in the report.

Identifier count

By default, each row of the report ends with a column containing a count of the distinct AppsFlyer IDs that are grouped in that row's data.

If you wish to add columns for the distinct counts of other identifiers from your sources, do so as follows:

  1. Select one or more identifiers in the Identifiers from sources list on the left and use the Add button in the middle of the screen to add them to the list of Report distinct count identifiers list.
    • You can use the search bar to search for identifiers in the lists.
  2. To remove an identifier, select it from the Report distinct count identifiers list and use the Remove button to return it to the Identifiers from sources list.
  3. Repeat this process until you have added each identifier you want to be counted in the report.

Set the report destination and save the report

The report destination consists of a cloud storage bucket (known as a connector) and the underlying file path to which the DCR will send the report each time it is processed. 

This bucket and file path are created using the interface of your selected cloud service. The full instructions for this process, including examples, are detailed here.

To set the report destination and save the report:

  1. Click Set report destination.
    The Report destination dialog will open.
  2. Select the connector on which the report file path is located.
    1. If you want to use a new connector for this source, click the + New connector button.
  3. Enter the report folder path:
    1. The bucket and DCR key folder will display automatically.
    2. Enter the full path following the DCR key folder, up to and including the second-level folder for the report.
    3. Your report folder path might look something like this:
      s3://af-dcr-example-bucket/01bcc5fb/output/conversions/
  4. Click Apply to apply the report destination.
  5. Click Save to save the report.
  6. The new source will now display in the Reports tab of the Data Clean Room.

What if I don't know the report destination?

In certain cases, you may want to define a report's structure before knowing its destination (for example, if your cloud storage structure is not yet finalized). This is possible as long as all the sources that are used to create the report have been set up in the AppsFlyer DCR platform.

 Important!

A report cannot be saved until a report destination is specified.

To save the report before you know its permanent destination, you can save it using a temporary (even non-working) destination. However, in order to begin receiving a report, you must provide its actual (working) location by editing it later.

Editing or deleting a report

To edit a report:

  1. Go to the Reports tab of the Data Clean Room.
  2. In the list of reports, hover over the row of the report you want to edit.
  3. Click the edit button edit_button.png that displays on the right side of the row.
  4. On the Edit report page, make changes to the report settings as necessary.
    • Report name can not currently be edited.
  5. To edit the report destination:
    1. Scroll down to the Report destination section.
    2. Click the edit button edit_button.png next to the current report destination.
    3. Make the necessary changes in the Report destination dialog.
    4. Click Apply to implement your changes.
  6. Click the Update button to save the report with the new settings or click Discard changes to undo your changes.

To delete a report:

  1. Go to the Reports tab of the Data Clean Room.
  2. In the list of reports, hover over the row of the report you want to delete.
  3. Click the delete button delete_button.png that displays on the right side of the row.
  4. In the dialog, confirm that you want to delete the report.
Was this article helpful?