Overview: LinkedIn Ads Query Builder
In this article, we will create a Custom Metric using LinkedIn Ads Query Builder in order to highlight the features and functionality of the tool. For this example, we will be creating a new metric that will give us the Impressions split up by Campaign for Text Ads.
IN THIS ARTICLE
1. Basic Options
We chose "Impressions by Campaign (Text Ads)" for our custom query name. When we're pulling this metric onto a Databoard, this is the metric name we will select.
You can find more information about metrics here.
dimensionsparameter breaks down or recategorizes metrics by common criteria, such as by Company Industry, Job Seniority, Company Size, Country or Campaign (like in our example).
When a Dimension is selected, values are segmented by the Dimension value. If a query has no
dimensionsparameter, the returned metrics returned will provide aggregate values for the requested Date Range, such as overall Impressions for Last Month.
Read more about: How to Add Additional Date Ranges to a Datablock.
Same period last year.
2. Advanced Options
In our example, we set a Filter in order to only retain data only for the Campaign Type "Text Ads."
ANDboolean logic. Filtered queries restrict the rows of data that do (or do not) get included in the final result. Each piece of data returned is tested against the Filter. If the Filter is true, the data is retained. If the Filter is false, the data is excluded from this query.
3. Data preview
Once you Run the query, you will see all values for selected Metrics, Dimensions and Date Ranges in the Data Preview. At the bottom, you can see the total values bolded. To switch between Date Ranges, simply click on the different Tabs at the top of the Data Preview Table.
When your query is ready, click Save query. This will create the new custom metric in the Databox system.
By default, the custom metric will be added as a metric option under the selected LinkedIn Ads Account. In most cases, this should be left as is. However, it is possible to change the target Data Source by clicking on Change target data source in the top right of the query screen.
It is possible to rename Dimensions that are returned from the custom query. The best practice is to rename all Dimensions before saving the query. You can do this by clicking "..." next to "Dimension" and then selecting "Rename dimension"
This functionality is useful when you want to exclude one or more Dimensions from the custom query. For example, this would be useful if you want to show data for all Campaigns except for one. Click "..." next to "Dimension" and select "Skip dimension"
Click "..." next to "Value" and select "Round values." Enter the number of decimal places to be rounded to into field in popup, and values will be rounded accordingly.