Aweber List Data Extraction

A few months ago Aweber (the autoresponder service I recommend to all my clients) came out with a new backup function — allowing you to download a backup of all your lists in one fell swoop.

For any of us who had been laboriously exporting our data one list at a time, this was real cause for celebration! I have one client with, I swear, over 100 lists at Aweber, and downloading the data from all of them was tedious, mind-numbing work. After the first time, I refused to do it anymore.

Anyway, I digress.

The only fly in the ointment is the way the data is exported. You get a zip file, and this zip file contains a folder for each list. That folder contains three MORE folders, “broadcasts”, “followups”, and “leads”. Inside the “leads” folder there are two files, “active_leads.csv” and “inactive_leads.csv”.

So if you want to have all the leads in a single file, you need some way of extracting data from this hierarchical file structure. Doing it manually can be very time consuming, especially if you have more than a half-dozen lists.

Remember that client I was talking about with over 100 lists? Scary!

But fear not, a simple solution I have for you! :-)

Just click here to download my “Aweber Data Extraction” software tool — you should probably “right-click” and “Save Target As” (or “Save Link As”) to save the .exe file to your hard drive.

Now, let’s say you downloaded the export file from Aweber. When you unzip it, you’ll have a folder with a name similar to “yourlogin_2007_06_01 ”

It’s important that the .exe file be placed in this main Aweber data folder, on the same level with all of the folders which consist of your list names. Drop the “extract_aweber_leads.exe” inside that folder and click (or double click) that file to execute the program.

This program will then extract all of the data from all of your lists, and will create three new files, “active_leads.csv”, “inactive_leads.csv”, and “all_aweber_data.csv”(which contains both active and inactive leads).

If you choose the option of only extracting the email addresses, then the software will remove duplicates — so you won’t have more than one instance of the same email address, even if that lead has subscribed to several of your lists.

Enjoy! :-)

Best,

Paul

P.S. If you download and use this utility, please let me know how it works for you!

[?]
Share This

5 Responses to “Aweber List Data Extraction”

  1. Tom Kulzer (AWeber CEO) Says:

    Paul,

    Very interesting tool. I’m curious though, why would you need to do
    anything with the backup data unless there was a problem with your
    account? Understanding how customers interact with their accounts
    is a big part of how we make improvements. I have to be honest,
    I don’t understand for what purpose you would regularly want all the
    subscribers in one file to the point where developing an application
    to do that was necessary.

    Enlighten me. ;)

  2. Paul Says:

    Hi Tom,

    I don’t recall the reason my client asked for all of the emails in one file — I’ve sent him an email asking for details.

    However, I believe it was so he could build a suppression list for some of his JV partners to use when mailing their own lists with his offer — or something along those lines.

    Also, just recently someone asked for a way to get a count of how many unique emails they had in all their lists.

    Since a single email can be subscribed to several different lists, the only way to get a “unique emails” count (as far as I know) is to combine all of the lists into one single list and remove the duplicates — that’s why I included the “emails only” feature in the extraction software.

    When I hear back from my client, I’ll update this post IF their purpose was something other than building a supression list.

    Best,

    Paul

  3. Paul Says:

    I should add that my client who first asked for this has over 200 lists — it was faster to develop this little utility app than to try to extract and merge the data from all of those lists manually (copy/paste hell!) . . .

  4. Internet Empire Says:

    It seems like a cool feature. It’s just too bad that I’m on GetResponse. :-(

    Regards,
    Edmund Ng

  5. Terry Says:

    Fantastic! I’m a die-hard Aweber fan ever since I sent out my first autoresponder, so my entire business is on there…this tool is fantastic for organising my backups (much better than the default one that Aweber provides). Well, my turn to share too…I’m using this method to keep track of who referred a subscriber to your list: How To Track Referrals With Aweber. It’s great, because it’s a great incentive for affiliates to promote YOUR list FOR YOU *evil grin*

Leave a Reply


Close
E-mail It