Find Jobs
Hire Freelancers

music marketing company in need of a new database

$750-1500 USD

Avslutat
Publicerad ungefär fem år sedan

$750-1500 USD

Betalning vid leverans
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

Om projektet

19 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
19 frilansar lägger i genomsnitt anbud på $1 470 USD för detta uppdrag
Använd 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 Om 21 dagar
4,9 (111 omdömen)
6,4
6,4
Använd 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 Om 20 dagar
4,8 (27 omdömen)
6,2
6,2
Använd 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 Om 20 dagar
5,0 (17 omdömen)
5,1
5,1
Använd 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 Om 6 dagar
4,9 (5 omdömen)
4,7
4,7
Använd 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 Om 20 dagar
3,4 (1 omdöme)
4,5
4,5
Använd 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 Om 13 dagar
0,0 (0 omdömen)
0,0
0,0
Använd 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 Om 19 dagar
0,0 (1 omdöme)
0,0
0,0
Använd avatar
hi, your need is pretty clear. i can implement it. at your disposal to discuss it. akli from paris
$3 333 USD Om 40 dagar
0,0 (0 omdömen)
0,0
0,0
Använd 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 Om 30 dagar
0,0 (0 omdömen)
0,0
0,0
Använd 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 Om 10 dagar
0,0 (0 omdömen)
0,0
0,0
Använd 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 Om 20 dagar
0,0 (0 omdömen)
0,0
0,0
Använd 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 Om 20 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för UNITED STATES
George Town, United States
5,0
36
Verifierad betalningsmetod
Medlem sedan okt. 13, 2010

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.