Text

Create a report in AEM

Text

The reports feature in AEM is very helpful to look at all web pages in a site or site section. Filters can be added to take a look at various page properties and better understand content. Reports can also be exported to Excel to further filter and sort the page data. 

Text
  1. Go to the AEM Reports page.
  2. Select New and from the drop-down options, then select New page.
  3. Enter a title for the report in the Title field.
  4. Select Create.
  5. Find the report you just created in the list of reports and double click on it to open. Tip: You can sort by Modified so that the report just created will appear at the top.
  6. Once the report is open, select Edit and in the Root path select the path for the relevant site or site section. Select OK.
  7. In the sidekick, select Custom Report 3.0 and select filters you are interested in and drag them into the blank area. Tip: Last replication action can be helpful to eliminate any deactivated pages from the reporting. Drag that filter onto the report, then hover over the right side of the column label, click on it, select Filter settings then change the drop-down option to Equals and type Activate in the open-field below. 
  8. To remove a filter, select the name of the filter on the column label and drag it outside of the report area. 
  9. In general, the following filters are helpful: Title, Page Archive Date, Page Owner, Path (Can be converted to a URL in Excel).
  10. When the report has all pertinent fields added, you can export it to a .csv which can then be saved as an .xls. Select Export next to the report name in the upper left-hand corner. 
  11. The report can be further manipulated and filtered once it is in spreadsheet form. 
Text

Steps 1-5: Creating a report

Text

Step 6: Setting up a report

Text

Steps 7-9: Adding filters to a report and filtering columns

Text

Step 9: Exporting a report