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,

 

thanks for your reply. 

This is the Link that includes the explanation about the different Reports and how to get them via API. I have already extracted Audit Reports Via API and in that case it is possible to get the data in csv format (screenshot).

However for the campaign Performance Report this is not possible (I have tried). In the documentation the following is stated:

Parse the Query Response

Optionally, you can use a scripting language such as Perl, Python, and Ruby, to parse the results and write them to an output file, such as a CSV file, that you can view in any spreadsheet application.

As I mentioned before I don't know any of those Languages and yet I would like to distribute the report in excel format. Any help would be appreciated.

Thanks,

Ivan