Adobe Analytics, one of the most in-demand analytics solutions in the industry, is among the favorite tools for Fortune 1000 companies when it comes to analyzing their data. 
 
Adobe’s suite has a lot of powerful built-in functionalities, which analytics companies from all over the world, including Cognetik, use to generate insights for their clients. However, another amazing benefit that Adobe provides is the ability to use third-party connectors to make it even easier to pull data and interact with the solution, such as the Cognetik Cloud Connector and Data Streams. 
 
With the Cognetik Cloud Connector, companies can import their marketing and clickstream data into Tableau, automate data refreshes, and build dashboards in a fraction of the time. 
 
On the other hand, Data Streams helps companies easily extract and import all your data into your preferred warehouse.
 
One of the features that Data Streams can help with is the Top Limit Functionality in Adobe Analytics. 
 

What Is the Top Limit Functionality?

 
The Top Limit functionality is offered by Adobe Analytics and affects the number of elements returned by the query. More specifically, it keeps the first ‘n’ elements ordered by the first metric chosen in a query.
 

 

How It Works

 
The Top Limit takes the first n breakdowns, aggregated by the first metric requested, over the entire period specified, then returns the daily values for those values, whether or not they are in the top values for that given day.
 
The Top functionality works in several steps as follows:
 

  1. Adobe aggregates the metrics for each breakdown, over the entire period specified
  2. Compares the aggregated values and only keeps the top ‘n’ breakdowns (where ‘n’ is the top limit)
  3. Returns the daily values for the breakdowns that are in the top ‘n’

 
By using our Data Streams tool, you can choose the elements directly in the query. Below we present two possible scenarios. 
 
Scenario A – Top Limit set to 5
 
Query: Pageviews per page for 7 days, granularity daily. 
 
By setting the Top Limit to 5, Adobe takes the total pageviews for that week, sorts the pages by their total number of pageviews and takes the first 5 Pages. 
 
For each of these pages, it will then return the daily pageviews.
 
In this scenario, it will return *at most* 35 rows (5 pages * 7 days). 
 
NOTE: It is possible for Adobe to return less than 35 rows if, on a given day, one or more of those pages do not have any pageviews (yet in the overall ranking for that week, they are in the top 5).
 
Scenario B – Top Limit not set
 
Query: Pageviews per page for 7 days, granularity daily. 
 
If for the same query as in scenario A, the Top Limit is not set, Adobe simply returns the entire data for the daily pageviews.
 
In this scenario, it returns 49 rows. In general, the number of rows returned depends on the number of available pages.
 
This is just one feature of our products. You can free up even more time by customizing the date for refreshable dashboards, or by Setting Up a Scheduled Refresh in the Tableau Server. You can also use Data Streams to import data from Google Analytics, Adobe Analytics or other cloud sources to your data warehouse of choice.

About the author

Sebastian Stan

Sebastian is a journalist and digital strategist with years of experience in the news industry, social media, content creation and management, and digital analytics.

New eBook Release: A Guide to User Journey Analysis

Related Articles