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?
Solved! Go to Solution.
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
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..
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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]
Views
Replies
Total Likes