Use Goal seek to work backwards from a calculated field
Goal seek is a function that allows you to back into a calculated value.
Instead of manually entering each part of the formula, you tell the system what result you want and it figures out what input value is needed to reach it.
Follow these steps to use Goal seek:
Open Sheet View: Goal seek is only available when you're in the sheet view of a plan. Make sure you're in sheet view before you begin.
Access the Goal Seek Function: Right-click on a calculated field, these fields appear greyed out. Then select goal seek from the menu.
Set the Goal seek Parameters:
a. Target Value: Enter the value you want the calculated field to show.
b. Input Field: Choose which input the system should fill in or adjust to reach that target.
Example: If the formula for Est. CPM is Impressions / Planned Spend / 1000, and you want the CPM to be 10, you need to first enter Planned Spend in the sheet view. Then, you can goal seek by having the system calculate the required Est. Impressions.
Goal Seek Across Multiple Rows
You can also apply Goal seek to multiple rows at once.
Select multiple rows before right-clicking to open goal seek in bulk mode.
Use the top section (blue) to apply the same target value to all selected rows.
Use the bottom section (pink) to apply a different target value to each row.
Get Support
Have questions or need help? You can reach us directly via the messenger on camphouse.io or the contact support button located in the top right corner of the Camphouse App.
Learn More
Not a Camphouse user but interested in learning more? Book a demo with the Camphouse team today and start being more productive with your marketing.