Simple app to organize keywords in a database - Laravel - PHP - MySQL - JavaScript

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Freelance

SALARY

Negotiable

ID PROOF

50

DATE POSTED

May 19, 2019

JOB OVERVIEW

I need someone who can build me a web app.

The purpose of the app is to categorize & classify keyword data for SEO purposes.

We will be uploading large amounts of keywords along with data about those keywords. Once uploaded, we will use the app to categorize the data. We wil add Topic, Parent Topic & User Intent.

The app will be designed for maximum efficiency when inputting data.

Build with Laravel, PHP & MySQL (latest versions) - Potentially some JavaScript

Here is a breakdown of the features needed.

Full CRUD features

1 table - Keywords

Upload functionality:

- Upload CSV file
- CSV column headers match to database table columns
- If no match, discard that column, but still insert rest into database
- if keyword doesn't exists, add to DB
- if keyword does exist, update all data for DB record from CSV data
- blank data in CSV columns should be ignored, we do NOT delete data and replace with blank



Update Unprocessed functionality:

- User interface is very important here as there will potentially be hundreds of thousands of keywords to classify.
- Keywords without a Topic, Parent Topic or User Intent will be consider unprocessed and be in this view.
- This view should be sortable and filterable on any column
- Topic, Parent Topic or User Intent should be the 1st 3 columns followed by keyword
- Topic, Parent Topic or User Intent are single line text fields
- Topic, Parent Topic or User Intent should have Autocomplete functionality based on current records in the DB
- Topic, Parent Topic or User Intent should have the ability to have a drop down to select from list based on other records data
- Parent Topic will always be one of the data points inside of Topic, except when there is no Parent Topic, the Parent Topic is Root
- Tab order should be correct so I can tab between fields, type, and tab to the next for quick use
- Link the keyword to Google search with that keyword (ex: ftrjs://pjx.qhlfsf.tpp/uefssw?r=xayjh+jnndf for keyword "hello world")
- Data entered should auto save without needing to hit a save button
- pagination for large datasets



View All functionality:
- Table / Excel view
- This view should be sortable and filterable on any column
- pagination for large datasets
- ability to export any view (including paginated results) to CSV

SKILL SUMMARY
Web Development
Javascript Laravel Mysql PHP
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin