- Pain Area: Client wanted to have Power BI reports in replacement of Excel due to complexity of calculations and limitatios of excel to generate real time lengthy and complex algorithm reports
- Requirement: Power BI Reporting daily advertising cost per sale & return on ad spend revenue per ad spend
- Ad platforms used: Amazon, Google, Facebook, Tiktok, Pinterest
- Marketplaces used: Amazon, Shopify, Walmar, OnBuy etc.
We calculated ACOS and ROAS based on given formulas:
- ACOS – (advertising cost per sale) shows the average percentage of the unit price (ex VAT) spend on ads.
- ROAS – (return on ad spend) Revenue (ex VAT) / ad spend
Client Writes:
“It was a pleasure working with the team at Infostork. They have managed to build a bespoke Powerbi setup that serves us incredibly and is very reliable. We are looking forward to continuing to work together”
Project Info
- Category: Power BI
- Client: McMiller Entertainment Inc.
- Location: LA, USA
- Client Business: A company that produces epic party games and toys. Client sells games through various marketplaces eCommerce like Amazon, Shopify, eBay, OnBuy, Wallmart etc.