Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: > Subject: Add campaign_id and creative_id to lead_form_response table for LinkedIn Ads connector

Answered
Brendan Walsh User
>
> The LinkedIn Lead Sync API (GET /rest/leadFormResponses) returns leadMetadataInfo.sponsoredLeadMetadataInfo.campaign.id and associatedEntityInfo.associatedCreative.id per lead form response (see sample response at https://learn.microsoft.com/en-us/linkedin/marketing/lead-sync/leadsync?view=li-lms-2025-11#find-lead-form-responses-by-owner).
>
> These fields are not currently synced to the lead_form_response table, which only has 7 columns. Without them, there's no way to associate a lead form submission with the campaign or ad creative that generated it.
>
> Requesting you add at minimum:
> - campaign_id (from leadMetadataInfo.sponsoredLeadMetadataInfo.campaign.id)
> - creative_id (from associatedEntityInfo.associatedCreative.id)
>
> Ideally also:
> - campaign_name (from leadMetadataInfo.sponsoredLeadMetadataInfo.campaign.name)
> - campaign_type (from leadMetadataInfo.sponsoredLeadMetadataInfo.campaign.type)

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Brendan,

    Thanks for reaching out!

    leadMetadataInfo.sponsoredLeadMetadataInfo.campaign.id is stored as sponsored_lead_metadata_campaign in the LEAD_FORM_RESPONSE response table. It should function as an FK to the urn/id in the CAMPAIGN_HISTORY table, where you can get the name and type.

    Thanks for flagging associatedCreative. It looks like we're missing this from the schema, and that it should be included as a field in LEAD_FORM_RESPONSE and act as a FK to the CREATIVE_HISTORY table. I've added this as a feature improvement in our backlog. I'll let you know when it's picked up by the team.

    Here's the ERD for this connector to help understand the schema in case you don't already have it handy: https://docs.google.com/presentation/d/1nwR5efra1p3S1uOwUgU9Wdx7WBKXE7onxNDffK0IpgM/.

    Cheers,
    Luke