Extracting Info from 2 Data Tables in Campaign Standard

Avatar

Avatar

bobbyjss

MVP

Avatar

bobbyjss

MVP

bobbyjss
MVP

31-05-2018

Hi all,

I'm hoping there's an easy solution to my following use case, but currently I'm drawing a blank on how to achieve it:

Goal: We want to be able to export a complete list of subscribers to a specific service, but along with profile data, we also want to be able to extract data from a separate data table (related professional).

We currently have the data stored in 3 different data tables:

  • Profiles: This table holds all of the profile and subscription data on the contact
  • Professionals: This table holds records of all the individual professionals that contacts can be linked to (Fields include Pro ID, Pro Email, Pro First Name, Pro Last Name)
  • Related Professional: This table holds the link between the two, so the customer email field, and the professional ID make the link

I can easily create a query looking at all subscribers who also have a related professional, but we need the full list of subscribers to a particular service, regardless of whether a related professional link exists or not.

I suspect I need to somehow use the Enrichment activity but after hours of playing around with it I'm unable to achieve what I need.

Any help or suggestions greatly appreciated.

Many thanks,

Bob

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

bobbyjss

MVP

Avatar

bobbyjss

MVP

bobbyjss
MVP

05-06-2018

If anyone is interested, below is a screenshot of the workflow that solved my problem.

1502172_pastedImage_1.png

Answers (0)