Skip to main content
Asked a question 5 months ago

How do I get the correct values for calculated fields like ACOS, CPC, ConvR, and CPC?

have a question?  ask it now and either we will answer it or one of you fellow community members.

Here are some calculated fields for common advertising metrics. Note, you will need to calculate these fields using sum aggregations as opposed to simply using the fields as is. For example, if you calculate the SUM of cost/sales, you'll get the sum of all the records' calculated results, returning an incorrect value. You should rather calculate sum(cost)/sum(sales) in order to return the correct value at the dashboard level:

ACOS = Cost/Sales

ROAS = Sales/Cost

CTR = Clicks/Impressions

CPC = Cost/Clicks

ConvR = Orders/Clicks

CPA = Cost/Orders

AOV = Sales/Orders