Breakdown a report into 2 levels & Download multiple pages in an Excel document | Community
Skip to main content
W
Wilcox_Tunnel
October 16, 2015
Solved

Breakdown a report into 2 levels & Download multiple pages in an Excel document

  • October 16, 2015
  • 2 replies
  • 1617 views

Hi,

I'm very new to Omniture so this may be a very simple question, but I don't see how to do it currently. I have a Yearly report broken down for a specific Tracking code that gives me metrics Broken down by Product Category on my site. I'm looking to have that report go one level lower and I'm not certain how to keep all the data in one report. 

I want the metrics filtered by Tracking Code (i already have this)

    Broken down by Category (I have this, and I can get product name, but I can't get them BOTH in one report) 

        Then Category broken down by product name.

**The reason I am looking for this is because I want to download the full report into excel and do data analysis with it via pivot tables etc.**  

I'm also unsure how to download multiple pages in one excel document. i.e. If my report goes into multiple pages, when I click the download icon at the top of Omniture it only downloads the information visible on the current page and doesn't download ALL OF MY DATA.

If anyone can help with these 2 issues it would be of GREAT HELP. Thanks!!!

-itw

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by BrianAu1

There is an advanced download option in Adobe Analytics which lets you specify how many rows of data to pull down (capable of well beyond the first page of line items):

https://microsite.omniture.com/t2/help/en_US/survey/index.html#Downloading_a_Report_Using_Advanced_Options

However to reach the desired higher breakdown dimension counts you may also need to try pulling data via other means in Adobe Analytics:

Data Warehouse: https://marketing.adobe.com/resources/help/en_US/reference/data_warehouse.html

Data Extract: https://marketing.adobe.com/resources/help/en_US/sc/user/data_extract.html

Freeform Analysis (BETA): http://help-forums.adobe.com/content/adobeforums/en/analytics-forum/freeform-analysis.topic.html/forum__amc5-as_users_askquestio.html

Ad Hoc Analysis (formerly Discover) tool is another option: https://marketing.adobe.com/resources/help/en_US/dsc/index.html

Best,

Brian

2 replies

B
Adobe Employee
BrianAu1Adobe EmployeeAccepted solution
Adobe Employee
October 16, 2015

There is an advanced download option in Adobe Analytics which lets you specify how many rows of data to pull down (capable of well beyond the first page of line items):

https://microsite.omniture.com/t2/help/en_US/survey/index.html#Downloading_a_Report_Using_Advanced_Options

However to reach the desired higher breakdown dimension counts you may also need to try pulling data via other means in Adobe Analytics:

Data Warehouse: https://marketing.adobe.com/resources/help/en_US/reference/data_warehouse.html

Data Extract: https://marketing.adobe.com/resources/help/en_US/sc/user/data_extract.html

Freeform Analysis (BETA): http://help-forums.adobe.com/content/adobeforums/en/analytics-forum/freeform-analysis.topic.html/forum__amc5-as_users_askquestio.html

Ad Hoc Analysis (formerly Discover) tool is another option: https://marketing.adobe.com/resources/help/en_US/dsc/index.html

Best,

Brian

W
Wilcox_TunnelAuthor
October 16, 2015

Thanks for the help. I was able to use the advanced option to download a multipage CSV file for Excel. The Excel option is limited to 500 rows. I did notice that the Data Extract and Free Form Analysis tools were not available because I'm not an admin. So I wasn't able to use those options. 

 

Thanks for you help! 

Terms & ConditionsAccessibility statement

Loading footer...