Exporting data to CSV

Hi Guys,

I am looking for some help with exporting client data (specifically billing information) out of campaign monitor.

Using the PHP wrapper would it be possible to export all of the clients and their details, including billing data to a .csv file. I have been able to export certain variables such as currency, company name etc already but I need a way of looping through all of my clients and exporting their data.

Any help on where to get started would be fantastic,

Thanks,

- Dan

roshodgekiss roshodgekiss, 4 years ago

Hey there Dan, while it's possible to return the client's name and ID via the API, at present we don't have a way of returning their billing history. Sorry about this - it's certainly one for us to consider in the future, so I'll happily add your vote for this and keep you posted.


Get in touch with us on Twitter: http://twitter.com/campaignmonitor
We're also on Facebook: http://facebook.com/campaignmonitor
dannetherton, 4 years ago

Hi Ros,

I may have not explained myself very well.

Using the PHP wrapper I can currently obtain specific variables such as currency and markup per recipient.

My issue is currently I can only do this for one client at a time which I enter manually. I was wandering if there would be a way to loop through all of my clients within the system that then exports to an external file.

I hope this makes my issue a bit easier to understand.

Thanks,

- Dan

Phil Phil, 4 years ago

Hi Dan,

You can easily grab all the clientIDs from the API and loop through them to grab all the information.

Writing to a CSV file then looks to be fairly trivial in PHP.

Hope that helps :)
Phil

Join 200,000 companies around the world that use Campaign Monitor to run email marketing campaigns that deliver results for their business.

Get started for free
1-888-533-8098