Pull data from Social Media & Google Analytic via APIs in Python

This brief aims to achieve the following outcomes for the following Social Media platforms (SMP) & Google Analytics (GA) that we have access to. Instagram Facebook Twitter YouTube Tiktok 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. Deliverables 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.