The Scenario
You run six LinkedIn lead gen form campaigns for a B2B software company. The head of demand gen asked you — for the third time this month — which forms are pulling the most submissions and what questions each one asks. You know the answer lives in Campaign Manager somewhere, but there's no single view that shows form configuration and submission volume together. So you've been manually opening each form, screenshotting the question list, and counting submissions from a separate analytics view.
The bad version:
- Navigate to Campaign Manager, find the Lead Gen Forms section, open each form one at a time.
- Note the form name, headline, and list of questions — including the question type and any legal disclaimer text.
- Cross-reference the submission count from the campaign analytics view, which is on a completely different screen.
- Paste all of it into a comparison workbook by hand.
Six forms doesn't sound like many until you realize Campaign Manager shows form details and submission counts in two separate places with no way to export both at once. The comparison you actually need requires stitching two data sources together manually every time someone asks.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to LinkedIn Ads and can pull the full form inventory — name, headline, status, question types, submission counts — in one pass, without navigating between multiple Campaign Manager screens.
List all LinkedIn lead gen forms for organization URN urn:li:organization:98765 and write the form ID, name, headline, status, and number of questions into columns A through E starting at row 2
What You Get
- Row 1: column headers — Form ID, Form Name, Headline, Status, Number of Questions.
- Rows 2 onward: one form per row for every lead gen form in the organization.
- Status reflects the current form state (active, draft, archived) as returned by the LinkedIn Ads API.
- Number of questions is a count — for the detailed question breakdown by type, include it in the initial ask.
What If the Data Is Not Quite Ready
I need the question types listed out, not just the count
List all LinkedIn lead gen forms for organization URN urn:li:organization:98765. For each form, write the form name into column A and list each question type as a comma-separated value in column B
The form IDs in column A need to be looked up for full question detail
Fetch the details for each LinkedIn lead gen form ID in column A and write the form title, description, question types, and legal disclaimer into columns B through E
I want to add submission counts from the campaign that uses each form
List all LinkedIn lead gen forms for organization URN urn:li:organization:98765. For each form, also pull the total submission count from campaign analytics for the last 90 days and write form name, status, number of questions, and submission count into columns A through D
Full audit with gap analysis in one shot
List all LinkedIn lead gen forms for organization URN urn:li:organization:98765. For each form, write the name, headline, status, and question count into columns A through D. Add a column E that flags "no legal disclaimer" if the form has no legal disclaimer text, and "draft — not live" if the form status is draft. Sort the output so active forms appear first
That prompt gives you a ready-to-share audit table, with gap flags built in, without a separate review pass.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull your full LinkedIn lead gen form inventory. For related workflows, see the campaign performance metrics guide or the multi-account campaign audit.