Merge and process two datasets relating to jobs
- or -
Post a project like this2416
$
- Posted:
- Proposals: 10
- Remote
- #1697889
- Awarded
Design and Build Turnkey Data based business solutions and process streamlining for SME's
Birmingham
15017192258869020827096345114494731567827172698817470321817236
Description
Experience Level: Entry
General information for the business: We list conservation jobs
Description of requirements/functionality: Hi there,
I need someone to produce a spreadsheet for me from two sources, and join them together. The sources are (1) 12k job posts exported from my wordpress website of job listings as a .xml file, and (2) Google Analytics .csv file with data on each job postings page views.
The final file should be a simple excel spreadsheet with the following columns, and a row for each of the 12k jobs:
URL (From wordpress job listing export)
Job Title (From wordpress job listing export)
Job Category (From wordpress job listing export)
Job Level (From wordpress job listing export)
Job Region (From wordpress job listing export)
Job Description (From wordpress job listing export)
Closing Date (From wordpress job listing export)
Location (From wordpress job listing export)
Employer Name (From wordpress job listing export)
Apply link / URL (From wordpress job listing export)
Pageviews (from Google Analytics)
You can view the files in here: https://www.dropbox.com/sh/h1eqdcvbn8nymd1/AADghSCUQVTiP8Kj4P2o4Cn2a?dl=0
Extra notes:
Description of requirements/functionality: Hi there,
I need someone to produce a spreadsheet for me from two sources, and join them together. The sources are (1) 12k job posts exported from my wordpress website of job listings as a .xml file, and (2) Google Analytics .csv file with data on each job postings page views.
The final file should be a simple excel spreadsheet with the following columns, and a row for each of the 12k jobs:
URL (From wordpress job listing export)
Job Title (From wordpress job listing export)
Job Category (From wordpress job listing export)
Job Level (From wordpress job listing export)
Job Region (From wordpress job listing export)
Job Description (From wordpress job listing export)
Closing Date (From wordpress job listing export)
Location (From wordpress job listing export)
Employer Name (From wordpress job listing export)
Apply link / URL (From wordpress job listing export)
Pageviews (from Google Analytics)
You can view the files in here: https://www.dropbox.com/sh/h1eqdcvbn8nymd1/AADghSCUQVTiP8Kj4P2o4Cn2a?dl=0
Extra notes:
Nick A.
100% (81)Projects Completed
82
Freelancers worked with
31
Projects awarded
79%
Last project
25 Oct 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hey,
The Categories field is empty throughout.
By description do you mean post content? Also is the creator field supposed to be the employer?
There is no field named level, region or location.
Finally, There are two links(guide, link) which one is the apply link. -
Can you provide some sample data.
-
also you domain / dns/ settings are wroing , cant get to site via http://conservation-careers.com/ , only when you put www. infront , you want to fix that
-
Dont see the link from the google analytics , to the xml ? whats the linking field / id / PK ?
493610493468493435493429
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies