The agency has several clients with the same name, so they can't distinguish between them.
The agencies need to analyze data at the Product level because they report on that.
Prevent Future Issues
- Go to the Report Roles tab inside the report settings
- Ensure that the user you are using for this test, has the role/profile added there
- Go to the reports module and run the report
- Verify that the Product field appears and has the correct values
- Verify that the client name and code appear in the client filter
- Export to Excel and verify that a ClientNameAndCode field appears.