Pause Refresh of Data in Ad Hoc Reports

Avatar

Avatar
Boost 5
Level 2
jakewinterbb
Level 2

Likes

17 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
jakewinterbb
Level 2

Likes

17 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
jakewinterbb
Level 2

07-05-2015

When constructing a report with layered segments and dimensions in Ad Hoc Analysis, it would be useful to Pause the refresh of the data so that it's not trying to update every time a new metric or segment is changed. This would allow the analyst to construct the report entirely before pulling larger sets of data.

The Table Builder only helps with this so far. At a certain point in more complex reports, the layering of segments and metrics can not be recreated with Table Builder.

This would also help when loading larger workspaces that are refreshing in the background, using up bandwidth, when maybe I only was interested in seeing data in 1 specific report.

5 Comments

Avatar

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

12-05-2015

This is a really interesting idea, @jake_winter. Without exposing any company data can you give me an example of the kind of analysis you're trying to do where Table Builder falls short in this regard? 

 

As I'm sure you've seen we're doing a lot of work on building complex tables and analyses in the new Analysis Workspace and I want to make sure we account for this there as well as in Ad Hoc Analysis. 

Avatar

Avatar
Boost 5
Level 2
jakewinterbb
Level 2

Likes

17 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
jakewinterbb
Level 2

Likes

17 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
jakewinterbb
Level 2

12-05-2015

The biggest shortcoming of Table Builder is that it multiplies everything. So if I'm doing exploration, and want to see how a conversion rate for a single segment is comparing to visit trends, Table Builder adds Conversion Rate to every segment I have up, increasing the time it takes to load the data, and providing extraneous data, when I just wanted to do a quick check. Then I just drag out Conversion Rate as a new column manually, and now the Table Builder is out of sync and I lose the conversion rate if I rebuild the table.

 

I end up using Table Builder as a starting point, but once my report starts having layered segments, date ranges, dimensions slicing the metrics... then Table Builder becomes inefficient and impractical.

 

Aside from Table Builder, the huge benefit of a pause button would be when opening a new Workspace with 6 or 7 reports. If I could quickly pause all of the ones I don't need, then it would save a ton of time (and I'm assuming bandwidth to Adobe... win-win!).

Avatar

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

12-05-2015

@jake_winter: Now that you explain it, it seems obvious and I'm a little embarrassed that I had to ask Smiley Happy 

 

This is a good suggestion, I agree. I'll take it back to the team. 

Avatar

Avatar
Validate 1
Level 2
ecarpe15
Level 2

Likes

6 likes

Total Posts

38 posts

Correct reply

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

Avatar
Validate 1
Level 2
ecarpe15
Level 2

Likes

6 likes

Total Posts

38 posts

Correct reply

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

21-05-2015

You can stop a report from processing if you click the X in the data table.  Then you can add segments with out the auto fresh.  Not sure if this was what you're looking for.  It really doesn't pause it, it just prevents it from running until you hit Replace Table.  

 

 

 

example.png

Avatar

Avatar
Boost 5
Level 2
jakewinterbb
Level 2

Likes

17 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
jakewinterbb
Level 2

Likes

17 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
jakewinterbb
Level 2

21-05-2015

As a workaround I have used this, but if you have a number of reports, some in sync with table builder, others not, it becomes unmanageable to remember what dimension/metric you have X'ed out. If there was also an Undo option, then maybe this is ok, but there isn't so this becomes equally frustrating.