How can I run a trend report. | Community
Skip to main content
thomas_wesselin
thomas_wesselin
Level 2
June 30, 2016
Solved

How can I run a trend report.

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?  

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Hyder_Ziaee
    Hyder_ZiaeeAccepted solution
    Employee
    July 21, 2016

    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

    View reply

    5 replies

    Hyder_Ziaee
    Hyder_ZiaeeAccepted solution
    Employee
    July 21, 2016

    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

    Translate
    thomas_wesselin
    thomas_wesselinAuthor
    Level 2
    July 20, 2016

    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.

    Translate
      ishitaa25076879
      ishitaa25076879
      Level 2
      July 20, 2016

      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?

      Translate
        thomas_wesselin
        thomas_wesselinAuthor
        Level 2
        July 20, 2016

        Anyone?

        Translate
        thomas_wesselin
        thomas_wesselinAuthor
        Level 2
        June 30, 2016

        Attachment wasn't added. Now it is.

        Translate
        Terms & ConditionsAccessibility statement

        Loading footer...