Find Jobs
Hire Freelancers

Keywords database

$10-30 USD

Closed
Posted over 6 years ago

$10-30 USD

Paid on delivery
I have an excel file where I store a keywords (one word or a multiple words –sentence), this file have 11 columns This file have to be imported and stored inside a database and I have to update it every day with a CSV file with 5 columns. Requetes Clics Impressions CTR Position # Type Region ST2 ST3 ST4 When I import the new file with a name like [login to view URL] where yyyy yearn, mm mounth, dd date,T (time) , hh hour, mm minutes, ss seconds I have to look if the keywords is already exist, - If the keyword is not here, I create a new line with that keyword and store all the related information “Clicks, Imression, CTR & Position” - If the keywords is already here I have also to store the related information “Clicks, Imression, CTR & Position” Evry keywords can have inside it some specific word like a region, city, special activity or type I have a column where I have a list of types of keywords and have to be updated I have a column where I have a list of regions and cities will be updated I have a column where I have a list of ST2 and cities will be updated I have a column where I have a list of ST3 and cities will be updated Now I have stored all my list of keywords on a daily basis, with the 4 main informatins 1 - I will look inside my sentence, if it have one word from my column “Type”, if it have it I will associate the keyword or sentence with that type 2 – I will look inside my sentence, if it have one word from my column “Region”, if it have it I will associate the keyword or sentence with that “Region” but here a region can be writed in different type like “fes, fès, fés or fez, فاس » so we have to deal with that and also if in the keyword have 2 regions inside it like country maroc morocco and a city name like fes we have to consider the name of a city as first choice 3 – I will see if my keyword – sentence have a word from my column ST2, I will associate it 4 – I will see if my keyword – sentence have a word from my column ST3, I will associate it 5 – I will see if my keyword – sentence have a word from my column ST4, I will associate it
Project ID: 15646300

About the project

2 proposals
Remote project
Active 6 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
2 freelancers are bidding on average $23 USD for this job
User Avatar
Hire me Relevant Skills and Experience Never give up for any work
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi There, I have reviewed your requirements & understood them. I can develop your preconceived project. Im actually a web developer and designer and work with a team. Relevant Skills and Experience developer Stay tuned, I'm still working on this proposal.
$21 USD in 5 days
0.0 (0 reviews)
2.4
2.4

About the client

Flag of MOROCCO
Casablanca, Morocco
5.0
1
Payment method verified
Member since Oct 22, 2017

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.