Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Export data in rectangular data format for consumption by other analysis tools

Avatar

Avatar
Boost 1
Level 1
awegro
Level 1

Likes

2 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
awegro
Level 1

Likes

2 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
awegro
Level 1

16-12-2011

The current Discover export mimics the on screen display of the data. Attached is an example.

 

The current data format is entirely UNUSEFUL when even simple additional analysis (ratios, comparisons, etc) is required using tools such as Excel, Tableau, R, or importing the data into a SQL database.

 

Discover needs to export a file AND provide a API which makes this process easy.

 

A standard format is a ASCII file that contain rectangular data with a header.

 

Here's an example of how data needs to be structured. http://www.ats.ucla.edu/stat/r/faq/inputdata_R.htm

 

This will save me and all all of your users considerable time by reducing the time needed for data manipulation. It will also save Omniture TIME and MONEY by avoiding the need to add analysis tools into Discover. As analysts all we need is the data.


Thank you.