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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive