LinkedIn Ads report building guide

Prev Next

Use the LinkedIn Ads data source connector to create an overall view of what gets the attention of your audience. Combine this data with data from other paid media channels to see which channel drives the most conversions and compare the quality and price per conversion.

Before you begin

Before you build reports, you need to connect the data source to Supermetrics.

Popular queries

These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.

Compare conversions and ad spend over time

See how your total ad spend and conversions have trended day by day over the last 28 days — useful for spotting whether spend and conversion volume are moving in the same direction and identifying any efficiency gaps.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Last 28 days

Metrics

Total spent, Conversions

Dimensions

Date

Suggested visualization

Time series or combo chart

Understanding the data

  • Total spent: The campaign cost in the currency of your advertising account.

  • Conversions: The count of conversions indicated by pixel loads.

  • Date: Splits results by day so you can track spend and conversion trends together.

Note

Ad spend is given in the currency used by your LinkedIn Ads data source. You can convert the currency to other currencies in Google Sheets and Looker Studio. Learn more about currency conversion.

Break down conversions by type

See what types of conversions your LinkedIn Ads campaigns are generating year to date — useful for understanding which conversion actions are most common and evaluating campaign objective alignment.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Year to date

Metrics

Conversions

Dimensions

Conversion type

Suggested visualization

Table

Understanding the data

  • Conversions: The count of conversions indicated by pixel loads.

  • Conversion type: The type of conversion action tracked, used to compare volumes across different conversion goals.

Note: Many other metrics are not compatible with the Conversion type dimension and cannot be queried at the same time — they may return an error or empty values. This is a limitation of the LinkedIn API, which does not allow other dimensions or join keys alongside conversion-specific dimensions.

Review clicks, impressions, and spend by campaign last month

See how many times your ads were seen and clicked last month alongside your total spend, broken down by campaign — useful for comparing visibility, engagement, and budget efficiency across campaigns.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Last month

Metrics

Clicks, Impressions, Total spent

Dimensions

Campaign name

Suggested visualization

Time series chart

Understanding the data

  • Clicks: The count of chargeable clicks on your ads.

  • Impressions: The count of impressions for Direct Ads and Sponsored Updates, and sends for InMails.

  • Total spent: The campaign cost in the currency of your advertising account.

  • Campaign name: Splits results by campaign for side-by-side performance comparison.

Analyze clicks, impressions, leads, and spend by campaign last week

Get a detailed view of last week's campaign performance — combining clicks, impressions, lead generation, and spend — to identify which campaigns are most efficiently converting attention into leads.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Last week

Metrics

Clicks, Impressions, Leads, Total spent

Dimensions

Campaign name

Suggested visualization

Table

Understanding the data

  • Clicks: The count of chargeable clicks on your ads.

  • Impressions: The count of impressions for Direct Ads and Sponsored Updates, and sends for InMails.

  • Leads: The count of leads generated through One Click Lead Gen.

  • Total spent: The campaign cost in the currency of your advertising account.

  • Campaign name: Splits results by campaign for side-by-side performance comparison.

Estimate total reach by campaign

See the approximate reach and total impressions for each campaign last week — useful for understanding how many unique people your campaigns are targeting and how often they're being seen.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Last week

Metrics

Reach, Impressions

Dimensions

Campaign name

Suggested visualization

Table or bar chart

Understanding the data

  • Reach: The approximate number of unique people targeted by your campaign.

  • Impressions: The total count of times your ads were shown, including repeat views by the same person.

  • Campaign name: Splits results by campaign so you can compare reach and impression volume across campaigns.

More resources

See the Supermetrics blog for posts about LinkedIn Ads and tips for social media marketing funnel.

You might also be interested in: