Campaign ROI Analysis

Table of contents

applicable Roles

Demand Gen Lead
CFO
CRO
RevOps

Prompt

Copy

Petavue, over the past 90 days, please compile campaign ROI across LinkedIn and Google Ads:

1. Spend Data: Pull ad spend by campaign from LinkedIn Ads and Google Ads.

2. Revenue Data: Retrieve pipeline generated and Closed-Won revenue from HubSpot/Salesforce campaign records (join on campaign ID or name).

3. ROI Calculation: Calculate ROI % = (Closed-Won $ ÷ Spend $) × 100.

4. Results Table: Return a table with columns:

- Campaign
- Spend $
- Pipeline $
- Closed-Won $
- ROI %

5. Highlights: Mark campaigns with ROI ≥ 150% in green and those with ROI ≤ 50% in red.

Follow-up Prompts

Copy

List campaigns with ROI below 50 percent and their corresponding spend and revenue figures.
Show the top ten campaigns by Closed‑Won revenue alongside their spend and ROI percent.
Break down ROI and pipeline efficiency by channel (LinkedIn vs Google Ads).
Recommend budget reallocation scenarios to bring under‑performing campaigns up to 100 percent ROI.
Project the pipeline and revenue impact of shifting 10 percent of spend from low‑ROI to high‑ROI campaigns.

Action Prompt

What This Prompt Does

This prompt fetches campaign spend data from LinkedIn Ads and Google Ads for the past 90 days and joins it with associated pipeline and Closed‑Won revenue from HubSpot or Salesforce campaign objects. It returns a table showing each campaign’s spend, pipeline value, closed‑won revenue and calculated ROI percentage, with high‑ROI campaigns highlighted in green and low‑ROI campaigns highlighted in red for immediate focus.

Strategic Impact

Providing a unified view of cost versus revenue empowers teams to optimize marketing investments and drive more efficient growth.

Business outcomes:

→ Enhances decision making by linking spend directly to revenue outcomes

→ Improves overall marketing efficiency and return on ad spend