Report Builder Limitations

[jeff_bloomer]

I seem to be running into limitations very quickly with row labels for a report I want to run in Report Builder.  It appears that I'm only able to add two or three dimensions at the most for a single metric, and then I'm done.  Am I really limited to running a report out of the Data Warehouse and not from Report Builder.  If so, what's the purpose in having report builder?

[brian_au · Accepted solution]

Hi Jeff,

Report Builder utilizes the Adobe Analytics API within Excel and should be on par with what you can pull in Reports & Analytics (formerly SiteCatalyst). The purpose of Report Builder is to allow for Reports & Analytics data to be pulled direct into Excel spreadsheets with potential for dynamic cell references, custom formulas, and Excel graphs/charts. Data Warehouse can run off the raw data which allows for more dimension breakdowns and it is intended to be a data extract tool. You may need to work with the raw clickstream feed or Data Warehouse to meet your reporting needs.

http://microsite.omniture.com/t2/help/en_US/arb/
http://microsite.omniture.com/t2/help/en_US/reference/data_warehouse.html

http://microsite.omniture.com/t2/help/en_US/sc/clickstream/home.html

Best,

Brian

[jeff_bloomer]

I appreciate what you're saying, but it sure is frustrating to have a tool that is not as robust.  It would make things a lot easier if Report Builder worked with the same functionality of the Data Warehouse request instead, but without the 24 hour wait.  It's much harder to build reports from the true raw data feed as it is not joined in any way.  That being said, are you aware of any documentation out there containing best practices for leveraging the raw data stream in something like a large relational database?  Thanks!

[brian_au]

The Help microsite and developer connection has further information on the clickstream feeds:

http://microsite.omniture.com/t2/help/en_US/sc/clickstream/home.html
http://microsite.omniture.com/t2/help/en_US/sc/clickstream/datafeeds_configure.html

http://microsite.omniture.com/t2/help/en_US/sc/clickstream/datafeeds_reference.html

https://marketing.adobe.com/developer/documentation/data-feeds/overview

Best,

Brian

[jeff_bloomer]

Very much appreciated for the assistance.  This will help a lot.  Thanks again!

[imene_drir]

Jeff, you can get a DW request in tableau format and be done with it (of course doable only if you have tableau which is worth it). For the data feeds, they can be humoungous but unless you really need to dig at the hit level data and are looking at building a DB or find a discrepancy, it's a waste of your time unless, then again you might get enjoy having all the benefits of the raw data. If you just want multiple dimensions, a bunch of metrics as per your above request, then yeah data warehouse is the right choice + Tableau for visualization.

[jeff_bloomer]

I saw this option as well.  The one problem with the DW request is the time involved in waiting for it to arrive.  If it was real-time like Report Builder, it wouldn't be an issue.   Thanks for the advice, though.  I appreciate it.