Which free members converted to paid

I exported the users list and am trying to determine if there is a way to figure out which of our free members (subscriber level) have upgraded to a paid membership. Do your reports have that capability?

In the report, what does the big string of data mean under the “First Payment Date” column?

ex: a:3:{s:5:”level”;i:##########;s:6:”level4″;i:##########;s:7:”level10″;i:##########;}

Thank you.

That is a serliazed array of payment times.
Please see: Knowledge Base » Import (or Mass Update) Users

A couple of things you can do.

1. When you do an export, choose the friendlier format for output.
Instead of that serialized array, you’ll get a line delimited list of these times, which is easier to read.

2. Instead of going by this column, it’s better to go by the Role column and/or the Custom Capabilities column in the export file. If a user is NOT a subscriber they are likely a customer at one of these Roles. See: Knowledge Base » s2Member® Roles/Capabilities