Data Analyst (Excel Expert)

For our E-Commerce (Dropshopping) webshop we are looking for an Excel Expert for a temporary assignment.

On our general store we test between 3 and 5 new products per day. We want to develop an Excel File in which we can see exactly how much profit/loss we are running every day. We want to be able to see the total profit/loss and the profit/loss per product in this Excel File. So we are looking for an Excel Expert who can develop such a file for us.

The following values must be included in this Excel File:

• Total daily revenue
• Daily revenue per product
• FB / Google Advertisement costs
• COGS (Total COGS and COGS per product)
• Transaction Fee’s
• Upgrade to see actual infoom the Excel File we want to get the following KPIs:

• Total profit/loss
• Total profit/loss per product
• Breakeven costs per product
• Average order value
• ROAS (Return on Ad Spent)
• Profit Margin

If interested: Put "blue" in your response and send a motivation and CV.