DoubleClick Search: Tips & Tricks: Using Formula Columns to Streamline...

DoubleClick Search: Tips & Tricks: Using Formula Columns to Streamline...: Spend less time in spreadsheets: use Formula columns to streamline your workflow by moving your offline calculations into the DoubleClick Search UI.

Using metrics from DoubleClick Search, combined with familiar formulas, you can customize your DoubleClick Search reporting to tailor to your needs and report on what really matters. Create your own custom columns and KPI calculations in terms that you and your team will understand. These columns are calculated in real-time and will update as new data comes in, so you know you’re always making changes based off of the freshest data.

To set one up, click on the “Formula columns” tab in your DS columns picker. Then combine standard DS columns with simple, spreadsheet-like language:

• Evaluate any DS metric with arithmetic operations
• Make comparisons between any and all DS metrics using boolean logic
• Evaluate your keywords, ads, campaigns and ad groups using if statements, then display a value if that condition is true or false
• Convert formulas to percentage, money, or number values
• Compare and compute metrics irrespective of the selected reporting date range
• … and more! See all valid operations and examples here.

These options give you creative license to think up all sorts of calculations!

Need more ideas? Talk to your Account Manager or email ds-support@google.com for more tips and tricks on how to make the best use of Formula columns.