phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

Merge and process two datasets relating to jobs

  • Posted:
  • Proposals: 10
  • Remote
  • #1697889
  • Awarded
Stephen M.Mark R.Joe P.Carl W.M Safdar A. + 5 others have already sent a proposal.
  • 2

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:

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Sk. Imtiaz A.

    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.

  • Peyman A.

    Can you provide some sample data.

  • Matthew G.

    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

  • Matthew G.

    Dont see the link from the google analytics , to the xml ? whats the linking field / id / PK ?