Can we export Lookup Schema attribute along with Profile attribute to destination? | Community
Skip to main content
M
mansibedi
Level 3
September 27, 2023
Solved

Can we export Lookup Schema attribute along with Profile attribute to destination?

  • September 27, 2023
  • 1 reply
  • 1086 views

Hi Team,

 

I have created a segment and exporting Profile attribute (email address identity map) to the destination (SFTP). Can I export a Lookup Schema attribute along with Email for the segment (eg: Campaign name, IDs etc?) 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by arpan-garg

Hello, @mansibedi ,

As per my understanding, only attributes associated with an individual profile can be exported to destinations through segmentation. If there's a specific attribute from the lookup schema that you wish to export to the destination, you can utilize a scheduled query. First, write that attribute directly into the individual profile dataset using the scheduled query, and then proceed to export it directly.

 

Thanks,

Arpan

1 reply

Verticurl
Verticurl
September 28, 2023
  • Create a dataset with combined data you want and export that dataset.
  • Include lookup data you want within the profile entity.
  • Import external custom uploaded audience and select enrichment attributes for export.
    M
    mansibediAuthor
    Level 3
    September 29, 2023

    Hi @verticurl 

     

    I'm not sure if I understand this correctly. The Sources of XDM individual profile Schema and Lookup Schema (with relationship) are Snowflake, through Daily Batch ingestion. I created segment using attributes of both these Schemas to test stitching and exporting Email from XDM schema and Campaign name from Lookup schema to SFTP. 

    My question is - how to I create a dataset of the audience in the above segment itself and export it? 

      arpan-garg
      Community Advisor
      arpan-gargCommunity AdvisorAccepted solution
      Community Advisor
      September 29, 2023

      Hello, @mansibedi ,

      As per my understanding, only attributes associated with an individual profile can be exported to destinations through segmentation. If there's a specific attribute from the lookup schema that you wish to export to the destination, you can utilize a scheduled query. First, write that attribute directly into the individual profile dataset using the scheduled query, and then proceed to export it directly.

       

      Thanks,

      Arpan

        Terms & ConditionsAccessibility statement

        Loading footer...