Overview: Query Builder for Microsoft Advertising (former Bing Ads)
How to access the Query Builder for Microsoft Advertising
Navigate to Metrics > Query Builder to access the Query Builder for Microsoft Advertising. Click the green + Create Custom Metric button and select your connected Microsoft Advertising Account from the Data Source drop-down list.
Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only. Request a trial of Query Builder by following
How to use the Query Builder for Microsoft Advertising
Pro Tip: Add the word "by" in between the Metric and Dimension in order to determine an appropriate Custom Metric Name. From the Metric and Dimension examples outlined above, we could create the Custom Metrics "Clicks by Ad Group," "Conversions by Campaign," or "Spend by Ad Type."
Pro Tip : If you don't know which Filters to put in place for your use case, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your Microsoft Advertising Account for each field. Learn more here.
How to create a Custom Microsoft Advertising Metric [Example]
In this example, we'll create a Custom Metric to report on Impressions split up based on the Ad. We only want to include Ads from our "Red" Campaign.
How to add a Custom Microsoft Advertising Metric to a Databoard
Learn how to add a Custom Metric to a Databoard here.