How to export rowdata from custom dimensions saved in analytics?

[#1]

Hi all,

I have created new custom variables with 'extract variables' policy and with the 'collector statistics' policy these are saved in the analytics tables.

After that I have created a custom report using them as a dimensions and I see the aggregated data very well.

However, I would like to have the traced data to have my own operations, and for that I need to export the traced data but I don't know how to do that.

Does anyone know if is it possible?

Any help will be appreciated.

Thanks

[#2]

Hi, You can save the data of custom reports using 'Export as CSV' option. The process is depicted in docs here.

[#3]

Hi Neha,

thanks for the response but I know this functionality but it does not work for me.

I would like to have more information in the select clause than the aggregate functions, for example, the full http request (not noly the api proxy itself because of I can have different resources in the same proxy), or combined information in more than one custom dimension defined.

Do you know if it is possible?

I have seen also, using analytic apis, the tables used to get this information.

Does anyone know if it is posible exporting the whole table in any way? or limited by number of rows?

Thanks a lot

[#4]

I don't know much regarding this, maybe someone else can help you with it.

[DChiesa]

Yes, @mbonilla , there is a good way. Have you seen the documentation page for stats with custom analytics? We have a nice guide on the topic.

Suppose your custom dimension is named "location". (This custom dimension needs to have been implicitly added to the analytics dataset with a StatisticsCollector policy in the proxies that get invoked). Given that custom dimension, here's an API call to retrieve the message count statistic for it:

curl -n https://api.enterprise.apigee.com/v1/o/YOURORG/e/ENV/stats/location?"select=sum(message_count)&timeRange=11/17/2015%2000:00~11/19/2015%2000:00&timeUnit=day"

The stats that are available include the basic stats like message_count and error_count, as well as the aggregate functions. You can request multiple stats by using a comma to separate them.

curl -n 'https://api.enterprise.apigee.com/v1/o/YOURORG/e/ENV/stats/location?select=message_count,error_count,user_count&timeRange=11/14/2015%2000:00~11/19/2015%2000:00&sort=ASC&sortby=user_count&timeUnit=hour' 

See more examples here. Does this answer your question?

[#6]

Hello Dino,

I have followed the same thing. Have extracted a variable using javascript, and mentioned in stats collector policy. We are able to see it in custom dimensions and reports.

However when i execute the below api, i'm not receiving the report data, instead providing me error

"{ "code": "Missing select parameter", "message": "Missing select parameter", "contexts": [] }"

https://managementurl.test.com/v1/o/testorg/e/test/stats/Company?"select=sum(message_count)&timeRange=02/20/2016%2000:00~02/21/2016%2000:00&timeUnit=day"

Company is the custom dimension.

Note:

1. Have defined name as "Company" in stats collector policy

2. However in report-custom dimension is being visible as "company"

Please help in resolving this issue.

Regards,

Ch.Venkat

[DChiesa]

is it a case issue? If you use lowercase company in the URL, do you get the results you expect?