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

# LinkedIn Ad Spend

spend

# Overview

LinkedIn Ad Spend refers to the total amount of money spent on advertising through LinkedIn Ads.

> 📘 LinkedIn Ad Spend = Ad Spend on LinkedIn

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:

Ad Spend = `SUM(spend)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) table\
LinkedIn Ads = `where channel = 'linkedin'`

# Insights and Actions

LinkedIn Ad Spend helps you track your total investment in LinkedIn advertising, enabling informed decisions about budget allocation and campaign performance:

* **Assess LinkedIn Campaign ROI**: Compare LinkedIn ad spend with metrics like ROAS or conversion value to evaluate the return on your investment in this platform.
* **Optimize LinkedIn Ad Strategies**: Use spend data to identify high-performing campaigns and allocate more budget to these, while reducing spend on underperforming ones.
* **Monitor Spending Trends**: Analyze LinkedIn ad spend over time to detect increases or inefficiencies, ensuring your ad budget is managed effectively.

### Related Metrics

* **LinkedIn ROAS**: Complements ad spend by indicating how much revenue is generated for every dollar spent, helping evaluate campaign profitability.
* **LinkedIn Click-Through Rate (CTR)**: Provides insight into ad engagement, showing if higher ad spend translates into greater audience interest.
* **LinkedIn Conversions (Purchases)**: Tracks the effectiveness of your LinkedIn ads in driving purchases, offering a clearer picture of campaign success.

# Example Use

### Prompt

> What's my total LinkedIn Ad Spend over the past 30 days?

### Response

![](https://files.readme.io/01b46156fd97cba60a2e0fc6476606d5ddeecedd7c212afb1179307cd2e11e0c-image.png)

### Query

```sql
SELECT
  adt.channel AS channel,
  COALESCE(SUM(adt.spend), 0) AS total_spend
FROM
  ads_table AS adt
WHERE
  adt.channel = 'linkedin'
  AND adt.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1
GROUP BY
  adt.channel;
```