At a glance: Set up the reports you'll receive from the Data Clean Room (DCR), using your data combined with AppsFlyer attribution data.
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 Data Clean Room.
Creating a report
To create a report:
- Go to the Reports tab of the Data Clean Room.
- Click the + New report button.
The New report page opens.
- 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 source name is different all other sources in your account or you will not be able to save the report.
- Report name requirements:
- Length: 2-80 characters
- Valid characters:
(0-9), cannot be the first character of a name
(-), cannot be the first character of a name
- Invalid characters:
- all other symbols or special characters
- Once a report has been saved, the report name cannot be edited without recreating the report.
Your 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.
AppsFlyer 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.
- Data lookback period: 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).
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 the AppsFlyer_ID.
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 data lookback period with the same AppsFlyer_ID. When this is the case, you must instruct AppsFlyer which matching events it should include in the report.
- Note: If your report's AppsFlyer attribution types include installs only, 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
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:
- 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.
- 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.
- 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.
Assume you have set up a report according to the following dimensions (in order):
- AppsFlyer dimensions:
- media source
- Your source dimensions:
After initial analysis of the data, AppsFlyer determines that the data would break down as follows:
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 applying the regrouping logic, the report appears as follows:
- 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
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.
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:
- 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.
- 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
- 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.
- Repeat this process until you have added each metric you want to include in the report.
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:
- 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.
- 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.
- 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:
- Click Set report destination.
The Report destination dialog will open.
- Select the connector on which the report file path is located.
- If you want to use a new connector for this source, click the + New connector button.
- Enter the report folder path:
- The bucket and DCR key folder will display automatically.
- Enter the full path following the DCR key folder, up to and including the second-level folder for the report.
- Your report folder path might look something like this:
- Click Apply to apply the report destination.
- Click Save to save the report.
- 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.
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:
- Go to the Reports tab of the Data Clean Room.
- In the list of reports, hover over the row of the report you want to edit.
- Click the edit button that displays on the right side of the row.
- On the Edit report page, make changes to the report settings as necessary.
- Report name can not currently be edited.
- To edit the report destination:
- Scroll down to the Report destination section.
- Click the edit button next to the current report destination.
- Make the necessary changes in the Report destination dialog.
- Click Apply to implement your changes.
- Click the Update button to save the report with the new settings or click Discard changes to undo your changes.
To delete a report:
- Go to the Reports tab of the Data Clean Room.
- In the list of reports, hover over the row of the report you want to delete.
- Click the delete button that displays on the right side of the row.
- In the dialog, confirm that you want to delete the report.