List companies that checked our Linkedin Ads this week
Data source
Department
Share
Copy link
Twitter / X
Creator
Albert Lundberg
Nov 1, 2025
Albert Lundberg
Nov 1, 2025
Albert Lundberg
Nov 1, 2025
Prompt
Copy Prompt
Copied!
Use the Lemonado MCP to:
Explore the LinkedIn company-level data available in the database.
Query data from the most recent week available to fetch unique company URLs, impressions, campaigns, and dates, aggregated and deduplicated by company URL.
Ensure you only include companies with non-zero impressions and valid LinkedIn URLs.
Return a clean table with:
linkedin_url
company_id
total_impressions
campaigns (list of campaign names)
days_active (number of days the company appeared in the data)
Make sure the output is:
Clean and deduplicated by company URL
Sorted by total impressions (highest first)
Shows only data from the most recent week available in the database
Prompt
Copy Prompt
Copied!
Use the Lemonado MCP to:
Explore the LinkedIn company-level data available in the database.
Query data from the most recent week available to fetch unique company URLs, impressions, campaigns, and dates, aggregated and deduplicated by company URL.
Ensure you only include companies with non-zero impressions and valid LinkedIn URLs.
Return a clean table with:
linkedin_url
company_id
total_impressions
campaigns (list of campaign names)
days_active (number of days the company appeared in the data)
Make sure the output is:
Clean and deduplicated by company URL
Sorted by total impressions (highest first)
Shows only data from the most recent week available in the database
Prompt
Copy Prompt
Copied!
Use the Lemonado MCP to:
Explore the LinkedIn company-level data available in the database.
Query data from the most recent week available to fetch unique company URLs, impressions, campaigns, and dates, aggregated and deduplicated by company URL.
Ensure you only include companies with non-zero impressions and valid LinkedIn URLs.
Return a clean table with:
linkedin_url
company_id
total_impressions
campaigns (list of campaign names)
days_active (number of days the company appeared in the data)
Make sure the output is:
Clean and deduplicated by company URL
Sorted by total impressions (highest first)
Shows only data from the most recent week available in the database
You might also like
Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Marketing
Google Ads Superprompt - deep analysis
Micha Lindqvist
Marketing
Google Ads Superprompt - deep analysis
Micha Lindqvist
Marketing
Google Ads Superprompt - deep analysis
Micha Lindqvist
Marketing
Linkedin engagement analyzer
Lane Goedhart
Marketing
Linkedin engagement analyzer
Lane Goedhart
Marketing
Linkedin engagement analyzer
Lane Goedhart
Stop fighting with data. Start feeding your AI.
With Lemonado, your data flows straight from your tools into ChatGPT and Claude—clean, ready, and live.
