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

[Wilcox_Tunnel]

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

[brian_au · Accepted solution]

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_O...

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/for...

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

Best,

Brian

[Wilcox_Tunnel]

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!