Adobe monthly reports- Truncated rows issue

[SindhushreeHo]

Hi all, I manage the AEM site for a Stanford research program. I had a question about the monthly analytics reports and have been trying to reach the AEM team onsite for a few months without success. I’m hoping someone on here might be able to help. I would greatly appreciate it!!

The PDF reports we currently receive each month seem to truncate some of the data. For example, please see screenshot under Monthly Key Metrics, the page names are abbreviated due to limited space in each row, making it difficult to tell which specific pages the metrics refer to and only 6 rows are shown out of the total 25 rows in this instance (Rest are missing). 

Thanks,

Sindhu

[SindhushreeHo]

Also wanted to add that I have requested to receive .csv reports and unfortunately haven't been able to make contact with AEM team onsite. Thanks!!

[bjoern__koth]

The csv format can be chosen in the dashboard export settings (Share > Schedule File Export).

or for an existing report like yours Components > Scheduled exports

[bjoern__koth]

Hi @SindhushreeHo 

have you tried resizing the columns? Since your screen is typically wider, once Adobe is rendering a pdf, this space has to be reduced to a normal A4 page size. I would recommend you do some manual PDF creations and adjust size in between. To my knowledge , there is unfortunately no other way around.

[Jennifer_Dungan]

I agree with @bjoern__koth on both counts, the columns can be resized, the data can be split to multiple tables with less columns (like maybe create a table for All Traffic, a second table for Mobile and a third table for Non-Mobile), or the reports can be scheduled to send as CSV instead of PDF...

However, it all comes down to who owns the reports and the report schedule....  If you don't have direct access to those, @SindhushreeHo that will be a problem.... However, this doesn't seem like an "AEM Team" thing... more of your "Analytics Team" thing, as these reports shouldn't be owned by AEM (which is your content management system), unless you refer to the "AEM Team" as the team responsible for the sites built on AEM which includes the Analytics team....

Anyway, regardless, the only people who can really address your needs would be someone with access to the report (and possibly the schedule)... However, if you have access directly to the report (and not the schedule), you can create your own CSV schedule, you will just end up with 2 emails.. the original PDF and the CSV that you created.