Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Scheduled Reports: Show Data for Month before Last

Avatar

Avatar
Boost 1
Level 1
alina_streltsov
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
alina_streltsov
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
alina_streltsov
Level 1

25-01-2016

In my dashboard which is sent as a scheduled report on the first day of the month, there is a reportlet called "Visits Previous Month". But the reportlet would actually contain the data for the month 2 months ago. E.g. if the dashboard is generated on Feb 1, the reportlet should contain data for December. My problem is: how can you set a reporting period for this reportlet as a rolling time range? There is no preset date range for that (only "Last 2 months", but it is not what I need). And just a rolling period is also not an option, because the number of days in month vary (30/31). Are there any workarounds I'm missing?

Any advice will be much appreciated!

Replies

Avatar

Avatar
Validate 1
Level 2
martijn_123
Level 2

Likes

7 likes

Total Posts

26 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 5
View profile

Avatar
Validate 1
Level 2
martijn_123
Level 2

Likes

7 likes

Total Posts

26 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 5
View profile
martijn_123
Level 2

25-01-2016

Hi Aline,

 

You can not schedule it for the 28th of each month? A last month report will contain the data you are looking for.

 

Cheers,

Martijn

Avatar

Avatar
Boost 1
Level 1
alina_streltsov
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
alina_streltsov
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
alina_streltsov
Level 1

25-01-2016

Hi Martijn,

Thanks for your comment. I considered this option. I don't want to send out the dashboard, on say the 28th, cause this dashboard is a monthly report and then for most of the reportlets (except for the troublesome "Visits previous month") the data for 2-3 last days of the month will be missing. What I considered doing is sending the dashboard on the last day of the month as late as possible (11pm). BUT in AA you cannot schedule a report to be sent on the last day on the month!! you can choose 30th, or 31st day of the month, but you cannot have a flexible solution! That's why I chose to send the report on the first day of the month.

Avatar

Avatar
Validate 10
Level 5
warrensander
Level 5

Likes

56 likes

Total Posts

152 posts

Correct Reply

37 solutions
Top badges earned
Validate 10
Validate 1
Boost 50
Boost 5
Boost 3
View profile

Avatar
Validate 10
Level 5
warrensander
Level 5

Likes

56 likes

Total Posts

152 posts

Correct Reply

37 solutions
Top badges earned
Validate 10
Validate 1
Boost 50
Boost 5
Boost 3
View profile
warrensander
Level 5

29-01-2016

i would think running the dashboard on the 1st of the month at 3 AM with dates set for the last 2 months and rolling monthly would give you dec/gan on 2/1 and jan/feb on 3/1 etc.

You can also play with the custom dates now available and create your own dates

it's in the left nav, open the components section and 'manage date ranges'

Avatar

Avatar
Boost 1
Level 1
alina_streltsov
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
alina_streltsov
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
alina_streltsov
Level 1

01-02-2016

Wow, actually this should work. Thanks for the tip!

Regarding "Manage date ranges" - I have recently noticed this new feature as well, but as far as I understood custom date ranges can be used only in Adobe Workspace.

Avatar

Avatar
Boost 1
Level 1
alina_streltsov
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
alina_streltsov
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
alina_streltsov
Level 1

04-03-2016

Hi there!

The same problem with the data for the month before last became relevant again. So I decided to try out the proposed solution (with the 2 last months). But it is not working as I expected!

So if I send the dashboard on March 1st, I want the reportlet to include the data for January (Traffic - Last Month). And this time period should be rolling. With the proposed solutions I would get data for January and February combined (with 2 last months setting).

Any other suggestions? I really do not understand how this issue did not get more attention. It is a standard reporting requirement: monthly reporting with data for current and previous months. The report is sent on the first day of thr following month. And there is no way to make the report automated! You have to adjust the time periods every month!

Hoping for some advice,

Alina