I have a table with over 8000 records that I use a groupby: term to add 5 fields together based on their keyword. This data is displayed in RG. I then have a group of 10 fields that displays data from this RG (i.e. search term that highest value from sum1, etc). However, now I need to find the search term with the highest quotient of 2 fields.
For example, I need to the following (RG Data’s List of Grouping’s sum of Spend/RG Data’s List of Grouping’s sum of 7 Day Sales) sorted: first Item: Keyword Name value
This equation doesn’t work as is. It is just how I visualize it. The dividing of the 2 variables gives me a value called ACOS. I need the name of the of the keyword with the lowest ACOS, hence the sort and first item. Is there a way to do this server side?
I have no idea how to do this or if it can be done. Help would be greatly appreciated.