Level 3LET and LAMBDAPractice, 3 min
MAP with your own LAMBDA
The task
In D2, work out ROAS (revenue per $1 of spend) for every campaign with
MAP. Your LAMBDA gets one spend and one revenue at a time, and should return 0 when spend is 0.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Campaign | Spend | Revenue | ROAS |
| 2 | Brand | $2,400 | $14,400 | |
| 3 | Prospecting | $4,600 | $3,980 | |
| 4 | Retargeting | $1,900 | $8,550 | |
| 5 | Partner (free) | $0 | $2,100 | |
| 6 | Webinar | $600 | $4,380 |