Database Setup and GUI for Managing Google Ads Data

详细信息

I am looking for a skilled freelancer who can handle both the setup of a database and the development of a user-friendly interface for managing and searching Google Ads data. The project will be completed in two stages:
Stage 1: Database Setup (MySQL/PostgreSQL)I currently have CSV files containing Google Ads copy, headlines, and related information that need to be stored in a well-structured database. This stage involves:
- Setting up a MySQL or PostgreSQL database on my Contabo server.- Designing and implementing a schema to organize the following fields: headline, description, URL, last_seen, and any other necessary attributes.- Importing existing CSV data into the database.- Implementing deduplication logic to update records (e.g., update "last seen" dates for recurring ads).- Providing instructions or documentation on how to upload future CSV files and manage the data.
Stage 2: GUI Development for Data Search by Domain- Once the database is in place, I have a mockup for a user-friendly web-based interface to search the data. This stage includes:
- Deploying my simple, intuitive interface that connects to the database.The interface should allow users to:- Search by domain name.- Retrieve and display relevant Google Ads data, including headline, description, URL, and last_seen fields.- Implementing basic filtering and sorting options for the search results.- Ensuring the system is scalable and easy to maintain.
Deliverables:- Fully functional database on the Contabo server, including a structured schema and deduplication mechanism.- A web-based interface that allows searching by domain and retrieves relevant Google Ads data.- Clear documentation for both database management and the GUI.
If you're capable of handling both the backend database setup and the frontend GUI development, I would love to hear from you!