Google Sheets Integration, using Apps Script, and Data Visualization in Looker Studio – Upwork

Affiliate Dev

We are looking for an experienced freelancer to help us automatically integrate data from Refersion and Shopify into a Google Sheet using Google Apps Script for data analysis and visualization using Looker Studio. The goal is to create an interactive dashboard to gain insights into our affiliate program performance and sales.
Project Requirements:
Set up Google Sheet integration with automatic updates using Google Apps Script:
a. Use Google Apps Script with UrlFetchApp and Refersion webhooks to automatically update both the "Conversions" and "Affiliates" sheets in Google Sheets when a new item is created or updated in Refersion.
b. Use Google Apps Script with UrlFetchApp to automatically update a new sheet named "Sales" with relevant sales information from Shopify API when a new sale is created or updated.
Implement functions in Google Sheets:
a. Create a new sheet named "Summary" to consolidate and analyze data from the "Conversions," "Affiliates," and "Sales" sheets.
b. Use Google Sheets functions (QUERY, VLOOKUP, INDEX/MATCH) to match and search data by name, order, and date range.
c. Implement conditional formatting to visually indicate if information from Refersion matches with sales data from Shopify.
d. Calculate average order values, sales with and without discount codes, and average order values for each type of sale.
Connect Google Sheet to Looker Studio:
a. Import Google Sheet data into Looker Studio.
b. Ensure data updates in the Google Sheet are reflected in Looker Studio.
Create visualizations in Looker Studio:
a. Design an interactive dashboard that matches Refersion conversions with Shopify sales and other relevant information.
b. Include visualizations for average order value per affiliate, sales with and without discount codes, and average order values for each type of sale.
c. Add tables that display outstanding conversions for affiliates that need to be confirmed, matched with a sale from Shopify or indicate if no sale can be found, and outstanding affiliate fees for individual affiliates.
The ideal freelancer should have experience working with Google Apps Script, Google Sheets, Refersion, Shopify, and Looker Studio. Please provide examples of similar projects you have completed.
To apply, please briefly explain your approach to this project and provide an estimate for the time needed to complete each step. We look forward to working with you!
Hourly Range: $10.00-$42.00

Posted On: April 28, 2023 14:08 UTC
Category: Scripting & Automation
Skills:Automation, API Integration, Google Data Studio, Google Apps Script, Google Sheets, Data Visualization

Country: Ireland

click to apply

Leave a comment

Your email address will not be published. Required fields are marked *