« previous next »
Pages: [1] 2

Author Topic: Email database management software recommendations??  (Read 8131 times)

hungrygoose

  • Inner Core
  • Sr. Member
  • *
  • Posts: 316
    • View Profile
Email database management software recommendations??
« on: July 12, 2012, 08:13:57 AM »
Hi

For a new venture I've bought 10m optin email addresses but they are split into a load of septate files.  I need to somehow add them all together and sort by postcode so I can geo target my campaigns.  I've spent ages looking but can't seem to find a way to combine these into some sort of CRM database.  Does anyone have any ideas or recommendations??
Logged

Adam C

  • Inner Core
  • Hero Member
  • *
  • Posts: 618
    • View Profile
Re: Email database management software recommendations??
« Reply #1 on: July 12, 2012, 08:17:44 AM »
what format are the files in?

Are the fields consistent?
Logged

Rumbas

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2105
  • Viking Wrath
    • MSN Messenger - rasmussoerensen@hotmail.com
    • AOL Instant Messenger - seorasmus
    • View Profile
Re: Email database management software recommendations??
« Reply #2 on: July 12, 2012, 09:09:03 AM »
If the data is consistent, you can pretty much use one of the email services as Mailchimp, Aweber, Ubivox etc? They all offer importing of large lists - however at 10M you might be in for a rather huge bill..
Logged

hungrygoose

  • Inner Core
  • Sr. Member
  • *
  • Posts: 316
    • View Profile
Re: Email database management software recommendations??
« Reply #3 on: July 12, 2012, 09:51:28 AM »
Hi

They are CSV and consistent.  There are a few files which are a bit different but most are the same.

I did look at mailchimp etc but its too expensive.  Been looking at SugarCRM to see if i can upload them there and then sort as I need a CRM to feed leads into to get qualified, signed up, visited and contracts sent to a provider..  New to this stuff though.

BTW planning on sending a few emails with sendblaster to begin and then get a pro mailing software set up on a dedicated server with quite a few IP addresses.
Logged

thesaintv12

  • Inner Core
  • Sr. Member
  • *
  • Posts: 471
    • View Profile
    • Email
Re: Email database management software recommendations??
« Reply #4 on: July 12, 2012, 10:53:22 AM »
You might be better off sorting them before hand as that is a very big list.

SQL Server express (free edition) is worth a look if you have time to play around - http://www.microsoft.com/en-us/download/details.aspx?id=1695  You will be able to import the csv files to a table, query that table as required and then export it into any format you need

I am sure there are lots of other free options out there too though.
Logged

hungrygoose

  • Inner Core
  • Sr. Member
  • *
  • Posts: 316
    • View Profile
Re: Email database management software recommendations??
« Reply #5 on: July 12, 2012, 10:57:10 AM »
SugarCRM is not what I was hoping... but might be ok to manage leads through

Thanks saint, I will take a look at that.  I'm thinking a simple DB is the answer now but there are also a lot of spam traps i need to clean out as well.
Logged

hungrygoose

  • Inner Core
  • Sr. Member
  • *
  • Posts: 316
    • View Profile
Re: Email database management software recommendations??
« Reply #6 on: July 12, 2012, 01:31:21 PM »
oook then.  got them imported into access :) now just trying to remember how to run reports from my school days..
Logged

Chunkford

  • Inner Core
  • Hero Member
  • *
  • Posts: 1057
    • View Profile
Re: Email database management software recommendations??
« Reply #7 on: July 12, 2012, 05:04:22 PM »
If you've got Excel 2010 then this should do the job :) - http://www.microsoft.com/en-us/bi/powerpivot.aspx
Logged
"If my answers frighten you then you should cease asking scary questions"

JasonD

  • Inner Core
  • Hero Member
  • *
  • Posts: 1420
  • Look at THAT!!!!
    • AOL Instant Messenger - JasonDDuke
    • View Profile
    • Domain Names
    • Email
Re: Email database management software recommendations??
« Reply #8 on: July 12, 2012, 05:34:54 PM »
* JasonD is very interested in how this pans out...
Logged

hungrygoose

  • Inner Core
  • Sr. Member
  • *
  • Posts: 316
    • View Profile
Re: Email database management software recommendations??
« Reply #9 on: July 12, 2012, 06:30:30 PM »
Downloading that now Chunkford, thanks.  I ended up unselecting "all" in the counties column and only selecting the desired county, then I just ctrl+c ctrl+v into excel and saved as csv :D  Now imported the 1st 20k records into Sendblaster to test reactions.

Ah another thing, I use CMD to combine all the 1st batch of csv into one. 

Thanks again Saint, without your post I wouldn't have tried Access again and would still be trying to figure this out.

What part are you most interested in JasonD??
Logged

JasonD

  • Inner Core
  • Hero Member
  • *
  • Posts: 1420
  • Look at THAT!!!!
    • AOL Instant Messenger - JasonDDuke
    • View Profile
    • Domain Names
    • Email
Re: Email database management software recommendations??
« Reply #10 on: July 12, 2012, 07:59:56 PM »
> What part are you most interested in JasonD??

Everything, but most of all where you have pain or things didn't go well.

Identify the pain, build the painkiller (and yes, there may be something in the works... )
Logged

hungrygoose

  • Inner Core
  • Sr. Member
  • *
  • Posts: 316
    • View Profile
Re: Email database management software recommendations??
« Reply #11 on: July 12, 2012, 08:49:56 PM »
I will keep you updated. Without the pain it normally means for me I've gotten lazy or I'm not trying tbh. There's 12-24 months of very high liquidity in a market I'm already somewhat familiar with so I'm hoping I develop some serious stretchmarks.
Logged

grnidone

  • Inner Core
  • Hero Member
  • *
  • Posts: 1643
    • Yahoo Instant Messenger - e
    • View Profile
    • Email
Re: Email database management software recommendations??
« Reply #12 on: July 12, 2012, 11:44:09 PM »
I've actually done this before, taking flat files and putting them into a site.  I did it a few years back and it was a b*tch.   I think I used a script called xeoport to dump them all into a php database though.  Then I had to make my own content management system to deal with them. 

Great way to learn PHP and regex.
Logged

JasonD

  • Inner Core
  • Hero Member
  • *
  • Posts: 1420
  • Look at THAT!!!!
    • AOL Instant Messenger - JasonDDuke
    • View Profile
    • Domain Names
    • Email
Re: Email database management software recommendations??
« Reply #13 on: July 13, 2012, 06:29:16 PM »
Heather, I think you meant to post in another thread ?
Logged

jimbanks

  • Inner Core
  • Full Member
  • *
  • Posts: 196
    • MSN Messenger - gdmjim@live.com
    • AOL Instant Messenger - jimbanks46
    • Yahoo Instant Messenger - jimbanks44@yahoo.com
    • View Profile
    • Email
Re: Email database management software recommendations??
« Reply #14 on: July 14, 2012, 06:59:50 AM »
First off, why on earth did you buy 10 million records?

We are using VoloMP for managing our mail and a few ESP's for delivery based on whether it is bulk mailing or premium.

Logged
Pages: [1] 2
« previous next »