Buying Advanced Google Docs Setup

Discussion in 'Programming' started by Borduhh, Feb 6, 2017.

  1. #1
    Hi All,

    I am looking for someone to setup an advanced Google Sheet Doc for my enterprise. We get raw sales data from amazon and need to be able to better visualize it using graphs and such. Here is the scope of the project:

    We get a this CSV report weekly exported from Amazon:
    [​IMG]

    We are looking to create a Google Sheets file that is comprised of the following:
    Sheet 1 - Summary
    Sheet 2 - Sessions
    Sheet 3 - Session %
    Sheet 4 - Page Views
    Sheet 5 - Page Views %
    Sheet 6 - Buy Box %
    Sheet 7 - Unit Ordered
    Sheet 8 - Unit Session %
    Sheet 9 - Product Sales $

    Each sheet (excluding the summary sheet) should have a column for the SKU and then the respective data for 12 weeks (we will paste it in at the beginning of each week). For example a sheet's headers might look like:

    SKU - Week 1 - Week 2 - Week 3 - Week 4 - Week 5 - Week 6 - Week 7 - Week 8 - etc...
    Code (markup):
    The summary page will have an input cell where we would type a SKU. Then a summary table with the individual sheets as rows. A formula would go through each of the sheets and plug in the data for the 12 weeks for just that SKU which we inputed.

    Below the table would be an individual graph which represented each row of data in the table in a visual format.

    I hope that wasn't too vague. We are looking to get this done ASAP.

    I look forward to working with you all!
     
    Borduhh, Feb 6, 2017 IP
  2. Borduhh

    Borduhh Well-Known Member

    Messages:
    767
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    150
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    PLEASE DISREGARD. IF MODERATOR SEES THIS. PLEASE DELETE!
     
    Borduhh, Feb 6, 2017 IP