...
First off, we need to make sure, to know how our desired values are calculated. For the CTR it’s taking the total number of Impressions and then divide it by clicks and impressions. 100 (percent) is divided by the impressions and then multiplied with the number of clicks, to receive a the percentage , how many impressions Impressions of the Ad led to a click on the ad.
So for this example, the total delivered impressions and the total delivered clicks are needed.
...
Then the required formula (1 / impressions / clicks) is entered. You can add a fitting help text for your users and then save the new field.
...
| Info |
|---|
Please note that Salesforce formula fields expect a value between 0 and 1 to show the proper percentage. Hence it’s ‘1 / Impressions' not '100 / impressions’ in our example. |
4.) Set permissions & add the field to page layouts, tab setup, reports ect.
...