---
updatedAt: 2025-01-29T10:32:22.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# LinkedIn CV (Revenue on Conversions)

conversion_value

# Overview

LinkedIn Conversion Value (LinkedIn CV, LinkedIn Revenue on Conversions) refers to the total conversion value as reported by LinkedIn.

> 📘 LinkedIn CV = Total LinkedIn-Reported Conversion Value

The calculation is based on data from the [Ads](https://triplewhale.readme.io/docs/ads-table) table.

### Detailed Breakdown

The formula above is derived from the following components:

Conversion Value (CV) = `SUM(conversion_value)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) table\
LinkedIn Ads = `where channel = 'linkedin'`

# Insights and Actions

LinkedIn Conversion Value (CV) measures the total value of conversions attributed to your LinkedIn ads, offering insights into the revenue impact of your campaigns:

* **Assess Campaign Revenue Impact**: Track LinkedIn CV to understand how much revenue your campaigns are generating. Use this data to evaluate the overall effectiveness of your LinkedIn ad spend.
* **Identify High-Value Audiences**: Compare conversion value across campaigns or audience segments to pinpoint which groups deliver the most revenue, guiding targeting strategies.
* **Optimize Campaign Strategy**: Pair LinkedIn CV with metrics like ROAS and CPA to refine bidding strategies and allocate budget to high-performing campaigns.

### Related Metrics

* **LinkedIn ROAS**: Complements CV by showing revenue generated per dollar spent, helping evaluate campaign profitability.
* **LinkedIn Conversions (Purchases)**: Provides context for CV by revealing the number of conversions driving the reported revenue.
* **LinkedIn Ad Spend**: Offers insights into the cost side of the equation, helping to balance revenue against investment for better campaign optimization.

# Example Use

### Prompt

> What's my total LinkedIn-reported conversion value over the last 7 days?

### Response

![](https://files.readme.io/180fa3ea72cae61861c6814ae37ce941e2bb33fb9cb047c258d5ee8c378d64fe-image.png)

### Query

```sql
SELECT
  pjt.channel AS channel,
  SUM(pjt.channel_reported_conversion_value) AS channel_reported_conversion_value
FROM
  pixel_joined_tvf () AS pjt
WHERE
  pjt.model = 'Triple Attribution'
  AND pjt.channel = 'linkedin'
  AND pjt.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1
GROUP BY
  pjt.channel;
```