Dynamic report building using a heterogeneous combination of filtering criteria

• US 9,645,990 B2
• Filed: 08/02/2012
• Issued: 05/09/2017
• Est. Priority Date: 08/02/2012
• Status: Active Grant

• Current Assignee: Adobe Inc.
• Original Assignee: Adobe Systems Incorporated (Adobe Inc.)
• Inventors: Anderson, Dale A., Lott, Timothy J., Meyer, James R., Richardson, Michael J., Dillenbeck, Thomas M., Smith, Kyle W.
• Primary Examiner(s): Xiao, Di
• Application Number:
  US13/565,662
• Publication Number:
  US 20140040806A1
• Time in Patent Office: 1,741 Days
• Field of Search: 715204, 715212, 715214, 715220, 715221, 715235
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

Methods and apparatus are presented for flexibly building a dynamic report using a heterogeneous mix of dimensions, segments, and metrics. Within a report building tool a user may introduce any number of dimensions and segments at any point within a generated report. Further within the report building tool, a user may break down existing dimensions and segments within a report with nested dimensions and segments, which may be added without limits on a nesting level. Given a generated report, a user may pivot the generated report, where the pivot includes pivoting any heterogeneous combination of dimensions, segments, and metrics within the generated report defined along each axis. Further, the pivot operation maintains the relative groupings and nestings of dimensions, dimension items, segments, and metrics in going from a column to a row or from a row to a column.

Claims

1. A system, comprising:

at least one processor; and

a memory having program instructions stored thereon, that when executed by the at least one processor, cause the at least one processor to;

provide a user interface for specifying a report on web site analytics data, wherein the user interface comprises user interface elements for specifying;

one or more dimensions of the web site analytics data;

metrics of the web site analytics data, the metrics including measurable attributes of visitor interaction with content of a web site; and

one or more segments for filtering the web site analytics data, the one or more segments identifying a subset of web site visitors having at least one measurable attribute in common;

wherein;

the user interface allows specification and movement of the metrics and one or more segments in a hierarchy to define rows and columns of the report for dimensions of the web site analytics data;

each unique path through the hierarchy defines a different row or column value; and

the user interface further allows a location of a segment in the hierarchy to be changed by dragging and dropping the segment into a location within the user interface to modify the definition of one or more columns or rows;

receive input to the user interface to create one or more hierarchies of one or more of the metrics and one or more segments to define one or more rows and one or more columns for the report; and

generate the report to comprise the one or more rows and the one or more columns according to the created one or more hierarchies of the one or more of the metrics and the one or more segments.

2. The method of claim 1, further comprising:

prior to said generating the report, retrieving at least a portion of the web site analytics data from a server, the at least a portion being sufficient to generate the report according to the created one or more hierarchies of the one or more of the metrics and the one or more segments.

3. The method of claim 1, further comprising:

prior to said generating the report, determining whether a locally stored portion of the web site analytics data from a server is sufficient to generate the report according to the created one or more hierarchies of the one or more of the metrics and the one or more segments;

wherein, in response to determining that the locally stored portion of the web site analytics data from the server is sufficient to generate the report, said generating the report is based on the locally stored portion of the web site analytics data; and

wherein, in response to determining that the locally stored portion of the web site analytics data from the server is not sufficient to generate the report, retrieving additional web site analytics data from the server.

4. The method of claim 1, further comprising:

receiving, via the user interface, input specifying a plurality of segments in a same one of the one or more hierarchies such that a row or column in the report is filtered according to the intersection of the plurality of segments.

5. The method of claim 1, further comprising:

receiving, via the user interface, input changing the order of at least one of a dimension, segment, or metric in one of the one or more hierarchies to modify the definitions of at least one row or column in the report, wherein a value displayed in each cell of the at least one row or column is dependent on the order of the one or more dimensions, segments, or metrics in the hierarchy.

6. The method of claim 1, wherein a metric quantizes an aspect of the web site analytics data across one or more dimensions of the web site analytics data.

7. The method of claim 1, wherein a segment filters the web site analytics data according to a specified segment criterion.

8. The method of claim 1, further comprising:

generating, in response to receiving input via an element of the user interface corresponding to a pivot operation, an updated report,

wherein each row of the updated report is based on a corresponding column of the report,

wherein each column of the updated report is based on a corresponding row of the report, and wherein the one or more hierarchies describe both the report and the updated report.

9. The method of claim 1, wherein said receiving input to the user interface comprises:

receiving, via the user interface element for specifying one or more segments of the web site analytics data, a selection of the one or more segments for filtering the web site analytics data,

wherein placement within the user interface element of each segment of the one or more segments corresponds to a hierarchical level of the one or more hierarchies; and

receiving, via the user interface element for specifying one or more dimensions of the web site analytics data, a selection of the one or more dimensions of the web site analytics data,

wherein after input for each of the one or more segments and the one or more dimensions has been received, said generating is in response to receiving input to a user interface element indicating generation of the report.

10. The method of claim 1, further comprising:

displaying, within a display area, the one or more segments within an element of the user interface; and

wherein said receiving input to the user interface comprises receiving drag and drop input corresponding to a drag of a single segment of the one or more segments from the display area onto a row or column of an existing report;

wherein said generating is in response to receiving the drag and drop input of the single segment onto the row or the column of the existing report.

11. A method, comprising:

providing a user interface for specifying a report on web site analytics data, wherein the user interface comprises user interface elements for specifying;

one or more dimensions of the web site analytics data;

metrics of the web site analytics data, the metrics including measurable attributes of visitor interaction with content of a web site; and

one or more segments for filtering the web site analytics data, the one or more segments identifying a subset of web site visitors having at least one measurable attribute in common;

wherein;

the user interface allows specification and movement of metrics and one or more segments in a hierarchy to define rows and columns of the report for dimensions of the web site analytics data;

each unique path through the hierarchy defines a different row or column value; and

the user interface further allows a location of a segment in the hierarchy to be changed by dragging and dropping the segment into a location within the user interface to modify the definition of one or more columns or rows;

receiving input to the user interface to create one or more hierarchies of one or more of the metrics and one or more segments to define one or more rows and one or more columns for the report; and

generating the report to comprise the one or more rows and the one or more columns according to the created one or more hierarchies of the one or more of the metrics and the one or more segments.

12. The method of claim 11, comprising:

retrieving at least a portion of the web site analytics data from a server, the at least a portion being sufficient to generate the report according to the created one or more hierarchies of the one or more of the metrics and the one or more segments.

13. The method of claim 11, comprising:

receiving, via the user interface, input specifying a plurality of segments in a same one of the one or more hierarchies such that a row or column in the report is filtered according to the intersection of the plurality of segments.

14. The method of claim 11, comprising:

receiving, via the user interface, input changing the order of at least one of a dimension, segment, or metric in one of the one or more hierarchies to modify the definitions of at least one row or column in the report,

wherein a value displayed in each cell of the at least one row or column is dependent on the order of the one or more dimensions, segments, or metrics in the hierarchy.

15. The method of claim 11, comprising:

generating, in response to receiving input via an element of the user interface corresponding to a pivot operation, an updated report, wherein each row of the updated report is based on a corresponding column of the report,

wherein each column of the updated report is based on a corresponding row of the report, and wherein the one or more hierarchies describe both the report and the updated report.

16. A non-transitory computer-readable storage medium storing program instructions that when executed by a computing device cause the computing device to perform operations comprising:

providing a user interface for specifying a report on web site analytics data, wherein the user interface comprises user interface elements for specifying;

one or more dimensions of the web site analytics data;

metrics of the web site analytics data, the metrics including measurable attributes of visitor interaction with content of a web site; and

one or more segments for filtering the web site analytics data, the one or more segments identifying a subset of web site visitors having at least one measurable attribute in common;

wherein;

the user interface allows specification and movement of metrics and one or more segments in a hierarchy to define rows and columns of the report for dimensions of the web site analytics data;

each unique path through the hierarchy defines a different row or column value; and

the user interface further allows a location of a segment in the hierarchy to be changed by dragging and dropping the segment into a location within the user interface to modify the definition of one or more columns or rows;

receive input to the user interface to create one or more hierarchies of one or more of the metrics and one or more segments to define one or more rows and one or more columns for the report; and

generate the report to comprise the one or more rows and the one or more columns according to the created one or more hierarchies of the one or more of the metrics and the one or more segments.

17. The non-transitory computer-readable storage medium of claim 16, wherein the program instructions, when executed by the computing device, further cause the computing device to perform operations comprising:

retrieving at least a portion of the web site analytics data from a server sufficient to generate the report according to the created one or more hierarchies of the one or more of the metrics and the one or more segments.

18. The non-transitory computer-readable storage medium of claim 16, wherein the program instructions, when executed by the computing device, further cause the computing device to perform operations comprising:

receiving, via the user interface, input specifying a plurality of segments in a same one of the one or more hierarchies such that a row or column in the report is filtered according to the intersection of the plurality of segments.

19. The non-transitory computer-readable storage medium of claim 16, wherein the program instructions, when executed by the computing device, further cause the computing device to perform operations comprising:

receiving, via the user interface, input changing the order of at least one of a dimension, segment, or metric in one of the one or more hierarchies to modify the definitions of at least one row or column in the report,

wherein a value displayed in each cell of the at least one row or column is dependent on the order of the one or more dimensions, segments, or metrics in the hierarchy.

20. The non-transitory computer-readable storage medium of claim 16, wherein the program instructions, when executed by the computing device, further cause the computing device to perform operations comprising:

generating, in response to receiving input via an element of the user interface corresponding to a pivot operation, an updated report, wherein;

each row of the updated report is based on a corresponding column of the report,

each column of the updated report is based on a corresponding row of the report, and

the one or more hierarchies describe both the report and the updated report.