Advanced find query for marketing list

(0) Share

Report

Posted on by Abdul Wahab

12,119 Moderator

Hi all

I want to select first name, last name and email address 1 of lead members which are in marketing list. I make this advanced fin d query.

1121.a.jpg

When I go to edit columns.

0572.b.jpg

I am unable to see there lead columns. How can I get lead columns with the help of my above query? Please help me.

Thank You

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

PS 23,577 on at

Like (0)

Report

Hi Abdul,

Your query should be like this:

Was this reply helpful? Yes No
Abdul Wahab 12,119 Moderator on at

Like (0)

Report

Hi Prashant Shukla and all

I need to get mailChimp attributes also. How can I get it wit the help of my above query.

Please help me.

Thank You

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report

Hi Abdul,

You need to ask your questions clearly.

Whatever you asked has been answered and now you have a separate question altogether.

From your query, remove the second filter 'marketing list'

Keep the mailchimp filter and add one more row.... mailchimp list equals 'select a record'

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Only Entities with one to many Relationship are shown in Add Columns of Advanced Find.

Since there is no 1:N relation between Lead and MailChimp Entity it won't show up in Advanced Find. That's a limitation. You can check if you can get you query from MailCHimp Entity. In Look For select MailChimp and then see if you can add Lead attributes.

Was this reply helpful? Yes No
Suggested answer

tw0sh3ds 5,600 on at

Like (0)

Report

Hi,

Since there can be many mailChimps for one Lead (as far as I understand) you cannot put mailChimp columns on a Lead (because how many records can be displayed in one row? Which record data should be displayed? First, last? etc.). The only way would be to make a query for mailChimps and put columns from Lead there (since there is only one lead per group of mailchimps it's possible)

Was this reply helpful? Yes No
Abdul Wahab 12,119 Moderator on at

Like (0)

Report

Hi Pawel Gradecki

There is one mailChimp for every record.

Thank You

Was this reply helpful? Yes No
ha3an 5 on at

Like (1)

Report

I did as image step by step, but there is no result! I have 13 contact in marketing like member view, but when use advance find and do like that I cant see the members.

I have another question: I have two marketing lists those made before, called M1 and M2, now I want to make new third one called M3 that should define like this: the contacts who are IN (M1) and NOT IN (M2). how can I define that in marketing lists?

Was this reply helpful? Yes No
Suggested answer

fcna 55 on at

Like (0)

Report

Hi

Touchdown is an alternative of Mailchimp and uses the native entities. www.touchdown.co/.../

Was this reply helpful? Yes No