Skip to Content
avatar image
Former Member

Tables: Relationship between campaign and campaign-targetgroup

Hi Experts,

Iu2019m looking for the tables where I can find the relationship between campaign and the targetgroups which used in the campaign.

I tried the following way:

CGPL_PROJECT(guid) -> CRMD_MKTPL_TGGRP(project_guid) -> CRMD_MKTPL_TGGRP(targetgrp_guid) -> CRMD_MKTTG_SET_H(prof_guid)

But this way only work for a few campaigns. Not for all. So I think it is the wrong way.

Can anybody help me?

Thanks a lot

Best regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 17, 2008 at 08:56 AM


    you can use the bol entities to get all targetgroups of a campaign.

    Get the right entity of type "Campaign" (ie. with search object "CampaignSearch") and get the relation "CPGSegmentRel".

    Now you have a collection of entities of type "CPGSegment" where you can get the GUID of the assigned targetgroup.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi all,

      I found the mistake in my relationship. In the last step I don't have to use CRMD_MKTTG_SET_H(prof_guid) but CRMD_MKTTG_SET_H(guid).

      Then it works perfect.

      Thanks for your help!