This brief aims to achieve the following outcomes for the following Social Media platforms (SMP) & Google Analytics (GA) that we have access to.
We require a developer experienced at building APIs to pull this data who understand insight and analysis from a social media context. This will need to be completed in 7-8 days, and ideally in Python using the Chalice framework to create AWS Lambda functions.
Business Outcome: Connect and retrieve data by real-time queries to enable insight into channels and posts for selected SMPs, and website via GA We require the ability to search on posts so that we can keyword, label and date search to return key industry metrics and land these into a database.
Technical Outcomes: For each SMP and GA, we will require the data for the channel and the individual post/video/tweet etc.
Connect and load: Have an instructional process for each SMP and GA that allows the owner to give a level of permission that can provide a real-time API connection for the data outlined later on in the paper. The API will need to follow full security and connectivity as per best practice.
Document: For each SMP and GA have a document of what API is suitable, what connection is required, API configuration (for data later on in the paper) and any comments. Documentation is to enable the development for the API.
Develop: Turn the documentation in code for each SMP and GA; the developer will write the code in Python using the Chalice framework to create AWS Lambda functions, if there is a challenge with this, please let me know and the reason why. The data will land in an AWS postgres and you will need to send the DB schema before development. There will need to be a report that confirms data pull and any issues.
Initial Load: We will want to load say 8 month of data so will need advice on the best way to extract and load this in as a one off manual load.
Our engineering team will integrate code into the existing system with a front end taking the connectivity information and passing to the SMP or GA code, then the SMP/ GA code pulling the data and then landing this into the DB.
We have a more in-depth brief will all the key requirements.
4 freelancer chào giá trung bình$140 cho công việc này
Hello welcome there I had read your project and I can assure you that we can complete this work in your preferred time. Me with my team are always ready to serve you Please message us for further discussion Thank you.
hi I could do it as all I could say as know python, django, postgres and api so I would be one of the suitable person for that if you would try me together we could do it