Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Get the count of accounts associated with contacts in Marketing List. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    In my current CRM system,

    We are trying to create a custom Campaign Effectiveness report.

    I wanted to display the below columns in the report.

    1. Campaign Name.
    2. Related Marketing List Member Count. (We are using only Contacts in Marketing Lists).
    3. Count of Accounts that are associated with the Contacts in Marketing List.
    4. Campaign Response Count - Response Type "Interested".
    5. Campaign Response Count - Response Type "Not-Interested".

    Can anyone help me how could i frame the FetchXML query to achieve this?

    Thanks and Regards. Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    Monday, March 10, 2014 6:12 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    I'm afraid your report requirement is too complex for FetchXML to handle.

    You might have to build your custom SSRS report using SQL query if it's on-premise environment.

    Monday, March 10, 2014 10:41 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Linn,

    Thanks for your reply.

    I am using on-line environment. 

    Thanks and Regards. Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    Monday, March 10, 2014 1:00 PM