Using a reporting tool depends on the volume of data to manipulate, its complexity, and on the type of reporting to be set up.
To optimize the creation, use and durability of a report, you need to take a close look at the needs which you want to meet. This first analysis will enable you to identify the type of report to create and the best creation mode. To create the report, apply the following steps:
- Identify the needThe first step is to clearly identify the need: what you want to show in your report and what its goal is (monitoring, analysis, data export, etc.).Adobe Campaign offers a wide range of reporting capacities. It is important to analyze your need to identify the most suitable functionality.For instance, you can:
- Explore the data in the database and define measurements (via this section ),
- Add indicators to an existing report (refer to this section ),
- View the data in the database (via this section ),
- Create a new delivery report (refer to this section ),
- Export data from the Adobe Campaign database (via a workflow, refer to this section ),
- Create a pivot table (refer to this section ),
- Explore aggregated data (via this section ),
- Use a wizard to analyze data (via this section ),
- Analyze large volumes of data (refer to this section ), etc.
- Identify the target populationThen you need to find out who the report you want to create will target, know the kind of public who will view it and the report display mode (in a browser, in Adobe Campaign, for a specific object, for the entire platform, etc.).You can also create reports for:
These considerations also need to take into account the issues linked to access rights and security.
- All Adobe Campaign operators,
- Operators with the rights to access a marketing campaign only,
- A single operator for temporary use,
- All operators in Web access, etc.
- Define the contentThen you need to find out what type of data you want to display: delivery indicators, reports on the database profiles, etc.You also need to know the nature of this data (simple, resulting from a calculation, significant, etc.), its location (in Adobe Campaign, in a third-party system), its update frequency to define the calculation periodicity (daily, weekly, on-the-fly), as well as its volume.The issues linked to data volumes and updates need to be looked into carefully to avoid report display problems, especially in terms of time. We therefore recommend creating aggregates to pre-calculate some data outside of the report. Tables that contain the tracking and delivery logs can include millions of records: this means the data needs to be aggregated via a workflow to be used in a report.