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 table.

Detailed Breakdown

The formula above is derived from the following components:

Conversion Value (CV) = SUM(conversion_value) --> Ads 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

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;