This 2-min video shows some of the List Aggregator's key features.
This video shows how to define the query that is used by the List Aggregator to aggregate list/library items.
This video shows how to configure KWizCom's SharePoint List Aggregator web part to perform aggregation in different scopes: current site, selected site, site collection.
This video shows how to configure the List Aggregator web part to aggregate different SharePoint List types.
This video shows how to configure the List Aggregator web part to roll-up list items from multiple SharePoint site collections.
This video shows how to aggregate the List Aggregator web part to retrieve items only from specific lists and/or sites.