How can I run a trend report.

[thomas_wesselin]

See for example the attached report on unique visitors. This is showing the weekly unique visitors.

Is it possible to generate a trend report that shows the cumulative growth in unique visitors on a weekly base?  

[thomas_wesselin]

Attachment wasn't added. Now it is.

[thomas_wesselin]

Anyone?

[ishitaa25076879]

Hi Thomas, 

Analytics mainly pulls data from tables and organizes them by dates. I have not seen having a cumulative view inside the UI. The best option I can think of is downloading the report into excel and applying a the cumulative formula on it. Will that work for you?

[thomas_wesselin]

ishitaa25076879 wrote...

Hi Thomas, 

Analytics mainly pulls data from tables and organizes them by dates. I have not seen having a cumulative view inside the UI. The best option I can think of is downloading the report into excel and applying a the cumulative formula on it. Will that work for you?

Yup, that's what I did so far. I was wondering if it would be possible to render trends info in Adobe as well but your suggestion works for me.

[Hyder_Ziaee · Accepted solution]

Hi Thomas,

Unfortunately there is no direct way of doing this in Analytics UI. However, you can do this through the Report Builder and Excel. This will automate your reports and also get you the cumulative numbers that you desire. 

Report Builder would give you a lot of flexibility as well in terms of formatting and additional excel features will increase what you can do with that data.

Here is the help article for Report Builder: https://marketing.adobe.com/resources/help/en_US/arb/

-Hyder