Performance Report API to CSV

Avatar

Avatar

ivan_ruiz2

Avatar

ivan_ruiz2

ivan_ruiz2

15-10-2015

Hello,

 

I just wanted to ask if there is a solution to parse the results of the performance API report to a CSV file. I have read the documentation and notice that this could be done by creating a script using Perl, Python or Ruby, however I don't really know any of the scripting languages and I do need to create reports from my campaigns that can be distributed in excel. Is there any way of transferring API's results to CSV without having to write a script.

Thanks in advance,

Ivan

View Entire Topic

Avatar

Avatar

ivan_ruiz2

Avatar

ivan_ruiz2

ivan_ruiz2

15-10-2015

Hello Nikhil,

In both cases I am able to retrieve the reports. The only difference is that the Campaign Performance report doesn't support CSV Format, meaning that the output is only XML, which need to be parsed using Ruby, Python or Perl scripting (according to your documentation).

So my question is if there is any other option to parse the results to CSV? or are you planning to support CSV output for the Campaign Report API?

This is quite important for us, and probably for other companies too, because if you want to do analysis bases on segments and day, then the normal CSV download on T&T is not very useful, as you only get aggregate data. We run tests across 7 different domains, using 20+ segments for periods of up to three months and T&T's interface is not so friendly to analyze and report.

Thanks,

Ivan