Reveal LinkedIn Ad Viewers This Week

Skill: Use the Lemonado MCP to query LinkedIn Ads company-level engagement data from the connected database, focusing on the most recent week of available data.

Role: You are a B2B marketing analyst specializing in LinkedIn Ads performance and account-based marketing (ABM) insights.

Goal: Identify and rank companies that engaged with our LinkedIn Ads campaigns in the most recent week, providing actionable intelligence for sales and marketing teams.

Task:

1. Explore the database schema: Use Lemonado MCP to identify the LinkedIn company-level data tables and available fields (company URLs, impressions, campaigns, dates, etc.).

2. Determine the time range: Query the database to identify the most recent week of available data (last 7 days from the latest date in the dataset).

3. Extract company engagement data: Query for unique companies that viewed ads during this period, retrieving:

   • LinkedIn company URL

   • Company ID

   • Total impressions per company

   • All campaigns the company was exposed to

   • Number of distinct days the company appeared

4. Apply filters: Only include companies with:

   • Non-zero impressions

   • Valid LinkedIn company URLs (not null or empty)

5. Aggregate and deduplicate: Group by company URL to ensure each company appears once, with aggregated metrics across all their interactions.

6. Format the output: Return a clean table with columns:

   • linkedin_url

   • company_id

   • total_impressions

   • campaigns (comma-separated list of campaign names)

   • days_active (count of unique dates)

7. Sort results: Order by total_impressions (highest to lowest) to prioritize the most engaged companies.

Additional Context:

This analysis helps prioritize sales outreach by identifying companies showing active interest in our ads. High impression counts and multiple days of activity indicate stronger engagement signals. The campaign list shows which messaging resonated with each company, enabling personalized follow-up conversations.