Google Data studio - Price scraping - Price monitoring tool

Project Description: Creation of a Business Intelligence Dashboard on Google Data Studio for tracking discount rates applied by retailers on Amazon IT and Google Shopping IT channels.

Overview: The goal of this project is to develop a Business Intelligence (BI) dashboard using Google Data Studio. The dashboard will display and analyze the discount rates offered by retailers on two major e-commerce platforms: Amazon IT and Google Shopping IT. To accomplish this, we will provide an Excel file containing all the product data, and the developer will need to perform web scraping to retrieve the prices from the respective platforms. The scraping process should occur on a weekly basis to ensure up-to-date information.


Key Requirements:

1. Data Source: We will provide an Excel file with comprehensive product data, including product names, SKUs, and other relevant details.
2. Web Scraping: The developer needs to implement web scraping functionality to extract the prices from Amazon IT and Google Shopping IT. This scraping process should be automated and run weekly to maintain accurate data.
3. Dashboard Design: Utilizing Google Data Studio, the developer will create an intuitive and visually appealing dashboard that presents the collected data. The dashboard should include various metrics and visualizations to provide meaningful insights into the discount rates offered by retailers.
4. Weekly Email Summary: The dashboard should have the ability to generate and send a weekly email summary to each retailer. This summary will highlight the products that are being sold with a discount rate exceeding a certain threshold, which can be set by the user. The email should include relevant details such as product names, SKUs, discount rates, and any other pertinent information.

Timeline and Deliverables:

1. Web scraping functionality: Develop and test the web scraping functionality to extract prices from Amazon IT and Google Shopping IT. Ensure that the scraping process runs automatically on a weekly basis.
2. Dashboard Creation: Design and implement the BI dashboard using Google Data Studio. Include relevant visualizations, metrics, and filters to facilitate data analysis.
3. Email Automation: Integrate the email functionality into the dashboard, allowing for the automatic generation and sending of weekly summaries to each retailer.
4. Testing and Refinement: Thoroughly test the dashboard and email functionality, ensuring they operate correctly and meet all requirements. Make any necessary refinements based on feedback.
5. The project will involve approximately 8,000 products.

Please let me know if you need any further clarification or if there are additional details you'd like to include.