Power BI Board games Enterntainment
  • 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.