AEP Data Prep - Creating a calculated field for marketing channel definitions | Community
Skip to main content
F
farzaanh
Level 2
May 7, 2026
Question

AEP Data Prep - Creating a calculated field for marketing channel definitions

  • May 7, 2026
  • 1 reply
  • 20 views

Hi all, I’m currently trying to use the calculated field function in Data Prep to write logic for marketing channels, based on different URL parameters. However, I’m struggling with the syntax the interface is expecting, it seems to be semi SQL based but Adobe’s documentation is unclear around what the expected syntax should be.

I’m trying to use the iif function to build out the logic, such as:

iif(web.webPageDetails.URL LIKE ‘%di-social%’, "Social ",

iif…

Has anyone else used calculated fields for a similar purpose? Or are familiar with what syntax is expected for using nested iif statements?

1 reply

G
GaneshKalamadug
Level 2
May 8, 2026

!--scriptorstartfragment-->

I did use calculated fields, but not for marketing channels, I used for list..   In your case may be you can try this.. 

iif(web.webPageDetails.URL LIKE '%di-social%', 'Social',

    iif(web.webPageDetails.URL LIKE '%di-email%', 'Email',

        iif(web.webPageDetails.URL LIKE '%di-paid%', 'Paid',

            'Other'

        )

    )

)
iif(
  size_of(xdm._experience.analytics.customDimensions.lists.list1.list) > 0,
  join(xdm._experience.analytics.customDimensions.lists.list1.list, ","),
  iif(
    size_of(xdm._experience.analytics.customDimensions.lists.list2.list) > 0,
    join(xdm._experience.analytics.customDimensions.lists.list2.list, ","),
    iif(
      size_of(xdm._experience.analytics.customDimensions.lists.list3.list) > 0,
      join(xdm._experience.analytics.customDimensions.lists.list3.list, ","),
      nullify
    )
  )
)

!--scriptorendfragment-->

Terms & ConditionsAccessibility statement

Loading footer...