Skip to Content
0
Jul 01, 2020 at 03:33 PM

Segmentation Profile filter issue

137 Views

Hi all,

I encounter the following difficulty on filtering my marketing segmentation profiles:

We have some marketing areas in our company, let's label them area 1 and area 2.

And each marketing area has a separate segmentation profile.

On the segmentation profile there is a filter on the respective marketing area of the InteractionContact, e.g. filter on marketing area 1.

Then we noticed that in the segmentation profile of Area 1, we could still see interactions belonging to Area 2. We didn't want that, so we added a second filter on the Interaction's Marketing Area = 1.

Then we had the problem that this filtered out any contacts who did not yet have any interactions... also not the purpose.

So we added a third filter: Interaction's Marketing Area can also be "Null", so empty.

But now we are stuck on the final issue:

A contact exists on both marketing area 1 and 2.

He already has interactions on area 2, but he does not yet have interactions on area 1.

Unfortunately this contact gets filtered out of the segmentation profile with the three mentioned filters :(

So to summarize, my three filters are:

IC_MKT_AREA_ID EQ 1

IA_MKT_AREA_ID EQ 1

IA_MKT_AREA_ID is NULL

Any idea how I can make sure my final case of contacts does not get filtered out?

Thanks!