Google AdWords Adds Custom Formulas Support To Custom Columns

Jan 27, 2016 • 7:54 am | comments (0) by twitter Google+ | Filed Under Google AdWords

Google AdWords quietly announced on Google+ that the custom columns now let you do custom formulas in those columns. This means you can add computations like addition, subtraction and multiplication directly in your AdWords custom columns.

Google explained:

Now when you create custom columns, in addition to specifying custom segmentations for your metrics, you can apply formulas for those metrics. For example, to see the percentage of clicks you get from mobile devices, create a custom column that divides mobile clicks by total clicks. Or let's say you’re a shoe retailer and enjoy a 40% profit margin for each pair of shoes you sell. To understand your total profit for each sale, ensure your conversion value column tracks revenue. Then, create a custom column that multiplies conversion value by 40% and call it “Estimated Profit.” As always, you can still sort, chart, filter and download your custom columns, as well as include them in reports and automated rules.

click for full size

For more on this, see this help document.

Forum discussion at Google+.

Previous story: Daily Search Forum Recap: January 26, 2016
blog comments powered by Disqus