Report Builder YTD daily trend Question | Community
Skip to main content
viktor_velikov
viktor_velikov
October 16, 2015
Solved

Report Builder YTD daily trend Question

  • October 16, 2015
  • 4 replies
  • 1327 views

Every morning I am updating a sheet with year to date metrics adding the day prior. I am using a Key Metrics report broken down by day. My date range starts at 1/1/15 and ends at =Today()-1. The report layout is standard with additional dates being populated in the same column and metrics next to them. I am doing this for 20+ Report suites broken down by marketing channel resulting in over 200 report requests that need to be updated.

Is it possible to only pull yesterday`s data without having to re-pull the request for the entire year? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by WhoaShekhar

Hi There,

Thanks for reaching out to Adobe Community.

You can run a report with the Rolling dates and select Yesterday in the 'From' and 'To' Field. This way will have the report for yesterday.

Thanks!

4 replies

WhoaShekhar
WhoaShekharAccepted solution
Level 10
October 16, 2015

Hi There,

Thanks for reaching out to Adobe Community.

You can run a report with the Rolling dates and select Yesterday in the 'From' and 'To' Field. This way will have the report for yesterday.

Thanks!

martijn_123
martijn_123
Level 3
October 16, 2015

You can pull the data of yesterday and add them to your previous ytd figures (in Excel). But this will not work for a lot of metrics like unique visitors, returning visitors, conversions, etc..  

viktor_velikov
viktor_velikovAuthor
October 16, 2015

Thank you for the suggestion. This is an option I`d look into when rebuilding the report but at the moment I am stuck with the current report structure.

viktor_velikov
viktor_velikovAuthor
October 16, 2015

Thank you for the suggestion. Unfortunately, that will not work in my case as I also need to keep prior day data as well, just like in the screenshot. Essentially, I just want to add 7/31/15 below 7/30/15 without erasing previous data and without having to re-pull the entire year worth of data and without editing the input cell for the request daily as I have over 200 requests in that report.

[img]2015-07-31_1042.png[/img]

Terms & ConditionsAccessibility statement

Loading footer...