Beastmode to decide how much to spend per ad in a given category
We have a working beastmode that calculates what ‘n’ should be depending on spend, revenue, and page depth (page depth is in 3 categories – all pages, product, and shopping cart).
Here is the formula:
= 1 / ((spend / revenue) / (sum (all spend per category)/ sum (all revenue per category)))
Note that the category of all pages stands alone in this equation while the product page depths and shopping cart page depths are combined.
We want to create a new calculation that changes the value of ‘n’ to be between 0 and 2 so we currently have the following formula.
= (above formula) * (2/MAX(all bid multipliers per category)
Can someone help us write this in a beastmode formula? What we have right now isn’t working so far.
Best Answer

Try this:
(1 / ((spend / revenue) / (sum(spend) / sum(revenue)))) * (2 / MAX(bid_multiplier))** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers

Try this:
(1 / ((spend / revenue) / (sum(spend) / sum(revenue)))) * (2 / MAX(bid_multiplier))** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 602 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 695 Beast Mode
 43 App Studio
 39 Variables
 658 Automate
 170 Apps
 441 APIs & Domo Developer
 42 Workflows
 5 DomoAI
 32 Predict
 12 Jupyter Workspaces
 20 R & Python Tiles
 386 Distribute
 111 Domo Everywhere
 269 Scheduled Reports
 6 Software Integrations
 113 Manage
 110 Governance & Security
 8 Domo University
 30 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive