Find Jobs
Hire Freelancers

music marketing company in need of a new database

$750-1500 USD

Closed
Posted about 5 years ago

$750-1500 USD

Paid on delivery
For the last 20 years I have been using Microsoft Outlook to run my music marketing business. I have been using Outlook as my database. I currently have 20,000 contacts stored in Outlook, and almost a million more across a number of Excel files. My company is about to expand dramatically, and I want to create a new, more flexible and powerful database before that happens. I need a database that: • Will be able to handle millions of contacts. • Can be used by multiple users – 5 to 20 seems reasonable to start. MAILINGS • Currently, in order to send mass emails I have to export a csv from Outlook to Sendy, an external newsletter service installed on my Wordpress server which sends emails via my Amazon AWS SMTP account. I need a database from which I can conduct mass mailings directly – without exporting and uploading CSVs across two platforms. • I need to be able to send individual emails directly from the database a la Outlook, at the same time as mass email campaigns are underway. • I need a highly customizable mass email solution, with the ability to regulate the speed at which emails are sent out, customize the emails by pulling text customize the emails with personalized data pulled from any data field the contacts have (first name, location, etc). DATA POINTS • Adding custom data fields to Outlook is cumbersome. I need a database where I can easily add data fields as I see fit. • I need the data to include correspondence information such as Date Last Emailed, Date Last Responded, Date Of Last Email Open, and a way to easily view all our correspondence with a contact. • I need to be able to set reminders on contacts. STORING/CREATING CONTACTS • We regularly receive lists of emails in the form of simple columns. Converting these into Outlook contacts is also very cumbersome. I need to be able to take a column of emails and with one paste, add them all to the database. • I need to be able to group individual contacts by Company, in the same manner as Microsoft Outlook’s Contact Groups. • Our website has a page where DJs can download tracks from our artists by entering their contact info. I need this information to automatically be entered into our database, and all duplicate info detected and excluded. I need to be able to send automatic pre-written emails to the people who give us their email addresses through this form. SEARCHING CONTACTS • A fast and intelligent search function is critical. • I need to be able to paste in a simple column of emails, and have all their contacts come up automatically in one view. • I need to be able to search the database by multiple data fields, for example “search all EDM-related contacts that live in Texas and have replied in the last year” • I also need to be able to do so while excluding certain results, for example “search all EDM-related contacts that live in Texas BUT EXCLUDE all contacts that have replied in the last year” • Searches need to be performed fast, for all users, not just the user with the data locally stored. CHARTS I need to be able to create different visual charts based on the data in my contacts. For instance, being able to view them all on a map by location. Pie charts, graphs, etc. HANDLING CONTACTS • I need duplicate emails to automatically be detected. • I need to be able to easily edit multiple contacts, for instance, easily turn all caps to sentence case, delete punctuations and erroneous characters, etc. • I need contacts that unsubscribe to automatically be updated as such
Project ID: 18851436

About the project

19 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average $1,470 USD for this job
User Avatar
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Microsoft Access, of course, familiar. Give me a chance to show what I can do!
$1,500 USD in 21 days
4.9 (111 reviews)
6.4
6.4
User Avatar
INTRODUCTION I can see you are interested in building database to for your business workflows processes. I can translate your various business procedures into application modules including: Mailing, data entry and storage, together with other specified business intelligence searches and lookup integrations. I am smart enough to take your business requirements and work to reflect the intent of your requirements. SIMILAR PROJECTS COMPLETED: • https://www.freelancer.com/projects/website-design/database-design-link-site/ • https://www.freelancer.com/jobs/project-15444898/ • https://www.freelancer.com/projects/mysql/review-database-model-for-survey/ • https://www.freelancer.com/projects/sql/human-resources-database-creation/ EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008.
$800 USD in 20 days
4.8 (27 reviews)
6.2
6.2
User Avatar
Hi there, I am java developer with 7+ years of experience in web and desktop app development. I have read all the details. This is an easy job for me. Please have a look at my profile portfolio and similar past work with reviews. Message me, I would like to discuss further over chat.
$2,000 USD in 20 days
5.0 (17 reviews)
5.1
5.1
User Avatar
During my 30-year career, I’ve done many similar projects where the task was to create powerful databases with flexible mailing systems and smart data management. I can create an application that will allow you to manage the entities and their status in a structured database, send emails from Excel lists via Outlook, automatically update and validate information as well as prepare documents and charts based on the required parameters and criteria. There will also be a report generator, which allows you to develop reports independently. There will be an option to enter the information by hand or by uploading the databases into a master file with a possibility to review and update them in Excel. You’ll be able to easily organise it as you see fit and there will be a search engine with high search capability. The proposed database can be used by multiple users and secured by a login form with usernames and passwords. About me: I am a financial guru and expert in Excel. I have an in-depth knowledge of advanced formulas, pivot tables and Visual Basic Application, including dynamic dashboards, screen layouts (UserForms), drop-down boxes, report generation and charts. With these skills, I develop sophisticated modules which incorporate complex components of business in an easy-to-use and logical manner.
$1,500 USD in 6 days
4.9 (5 reviews)
4.7
4.7
User Avatar
Hi Nice to meet you We are a senior Website and Mobile App Development Company - DG Electronic Entertainment Co., LTD, located in Dalian, China. (Hangzhou Dongcheng Electronic Co., LTD is changed to Dongcheng Global) We have done more than 180+ web projects so far. We can do your job without having any problem, we have string experiences in Web development, we can do any Web development projects, please let us know. Portfolio URLs will be provided via chat If you are doubt about our ability, please review our profile and reviews how we completed the projects. We are fully experienced, we can assure you the best results and stay faster speed, please let me know. Regards
$1,250 USD in 20 days
3.4 (1 review)
4.5
4.5
User Avatar
Hi there, I have checked the details. I have rich experience with Database Development, Database Programming. Please initiate the chat so we can discuss this job in detail.
$1,250 USD in 13 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I'm an experienced developer that worked on huge projects, and I see the need for a smart mailing and contact DB solution you need. I can cater all the prerequisities, and please feel free to contact for details. Best regards, Baris Atasoy
$2,000 USD in 19 days
0.0 (1 review)
0.0
0.0
User Avatar
hi, your need is pretty clear. i can implement it. at your disposal to discuss it. akli from paris
$3,333 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
To be honest, your project isn't that hard. However, you'll need someone with fresh knowledge on Databases in order to solve your problems. So, here I am. I'll need more information, so contact ASAP in order to work on it.
$1,000 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello there, it was a really nice explanation woork thx: ) i have several ideas in my mind. so the first would microsoft access with sql database behind. so i can prepare the databse there aand also forms. so u can play around and do all what u want easily. at the moment i take care of onee company databse in this way.. but they wanted access database.. anyway that was just one optiono.. another one would be also sql base Mysql databse with some visual interface that u can add easily emails in a box and can detect if there are duplicates. and youo can with one click send email or yoou can choose some eamails from list and send .. so these ones we can discuss about it.. i can fiinish this stuff mainly in a week and then we can test it for some ddays. so i would say 10 days.. so please let me know and we can discuss it further.. cheers Amadeus
$1,250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. This seems like a fairly well defined spec and well within the scope of my team. I've worked on a number of similar project previously in my professional career. I do have a couple of questions about some of the details (specifically around the format and quality of the data sources, and the approach we would use to integrate the database/application with your email system going forward). I've found the best approach would be to have an initial conversation prior to selection (google hangout/skype etc) to make sure we both feel that we can work well together, and to decide on the details of each milestone.
$1,666 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm an experienced freelancer database and report design, development and optimization with 10 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. Here is few technologies I have mastered since last 10 years and can deliver the best solutions if you get me hired. I am in Florida, US 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS
$1,250 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
George Town, United States
5.0
36
Payment method verified
Member since Oct 13, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.