Target for a campaign

Target for a campaign

Hi, 
Hope you can help me.
I need to create a report (for a marketing campaign) that combines Deals and Contacts to export all the contacts with closed deals. I can easily do that, what I cannot do is to remove from the target the contacts that have more than one deal and some are closed and some are open.

In my view I need to make a count of open and close deals for each contact and exclude the ones where open deals count > 0, but I've tried multiple way and cannot achieve the result I need.

Is there anyone able to help?

Thank you,




        • Recent Topics

        • Email Templates - Increase Width

          The email templates created in CRM do not seem to allow to widen the margins.  When the template is dropped into an email, the copy is centered in the email.  Is there a way to increase the width or the margins so the text simulates a normal email?

        • my clients are not receiving mails

          Hi, My clients are not receiving my mails sent . may we know the reason My dns server and imap settings are perfect

        • zoho mail and crm is very slow

          I have recently employed Zoho in our organisation. Even after taking high speed internet, mail and CRM takes many minutes to even load. Its really slow and faces lot of downtime.

        • How to use if_case with expressions other than equals

          I'm trying to define a formula column that implements logic like this case statement would: case when numfld1 is null then null when numfld2 > 0 then 100*numfld2 when numfld2 < 0 then numfld2 else 0.0 end In formula columns, the docs say you need to use

        • Create global project dashboard for all users

          Would like to be able to create a custom dashboard for projects with certain widgets that are default for all new projects.  right now, I have to modify each project dashboard per project per user.  This is not practical.  

        • Inline images are not shown on iPhone

          When I add an image inline it gets displayed on a Zoho's computer software or web browser, but not on Zoho's iPhone app - the image appears to be broken and cannot be copied neither saved. What's the problem with displaying images inline when reading

        • Kaizen #186 : Client Script Support for Subforms

          Hello everyone! Welcome back to another exciting Kaizen post on Client Script! In this edition, we’re taking a closer look at Client Script Support for Subforms with the help of the following scenario. " Zylker, a manufacturing company, uses the "Orders"

        • Viewing Live data

          Where can I see the live data that is sent from the device?

        • Canvas templates can now be shared with different CRM organizations

          ----------------------------------------Moderated on 14th February, 2023------------------------------------------- Dear all, This feature is now open for all users in all DCs. To learn more about importing and exporting canvas templates, read our help

        • CRM to Writer Mail Merge Preview not working

          When performing a mail merge from CRM to writer the preview function does not work. I get the following error. I am a Zoho one user on a ChromeOS. I have been successfully using mail merge from CRM to Writer about 4 years. This error seemed to coincide

        • Show Call History During a Blueprint Transition in Leads Module

          Hi all, I have a Blueprint set up in the Leads module with a transition to Reattempt Call, which updates the lead status to Attempted Contact. I’d like to know if there’s a way to show the call history or at least a summary of how many call attempts have

        • How to delete more than 100 leads at a time.

          We are a call center and we need to upload fresh leads daily.  Is there any way to delete all leads only at once.  Currently we are deleting 100 at a time. Please anyone who can help. Thank you.

        • The Next Chapter for CRM for Everyone: Moving from Early Access to Phased Rollout for Customers

          #CRM25Q1 Hello Everyone, Until now, CRM for Everyone has been available in early access mode exclusively for users who opted to try the new version. We are now transitioning to a phased release, starting with the basic edition. We are thrilled to announce

        • Canvas for related lists

          Hey, we would like to customize our related lists. For us, it would make more sense to present the data from an assigned record vertical instead of horizontal. Can we get a related list Canvas view?

        • Standalone custom function not generating logs

          Why dont't standalone custom functions generate logs when the're called from another function? I have some functions (workflow, buttons and blueprint) that have common parts, so I put that part in a standalone function which is called from the others.

        • ACR Phone mobile app for logging phone calls into Zoho CRM

          ACR Phone is an Android app recording voice calls with additional features such as blacklist, cloud upload, call log and more. Use the ACR Phone extension for Zoho CRM to generate Leads and Contacts with the voice recording attached right after your phone

        • How can I throw an error / terminate the flow from within a custom function?

          As the subject says. I would like to be able to terminate a flow from within a custom function if certain conditions are not met. I know I could hook a decision box to the output of my custom function and check return variable, but hoping there is a more

        • Multiple Zoho Attendees in a Customer meeting

          We are having constraints with having to log duplicate meetings when we have 2 Zoho users attending a customer meeting. What are the options to resolve this? You can add participants, but you cannot report on them. What can be done to avoid creating so

        • Password change restriction

          Can the administrator restrict users from changing their email password?

        • MS PowerApps Custom Connector

          Has anyone successfully connected to the API from MS PowerApps? The OAuth2 seems impossible to use from a platform like this.

        • Zdk-cli

          As i have tried to login to zdk cli as it returns this error ✔ Success! Logged in as JAYANTHAN ✖ Error during initialization of zdk api supported only in sandbox environment

        • Trying to do commission tracking with zoho crm, can i do a Lookup against multiple fields in a module?

          So i'm still designing my zoho one crm as i come over from salesforce. One of the things i'm trying to build is a commission tracking module. At some point i'll probably hire someone to help with custom code, I'm just proof of concepting it. I"m not sure

        • Customer Portal Zoho Desk | Sort ticket list

          Hello, If you view the ticket list inside the desk portal (https://xyc.zohodesk.eu/portal/de/myarea?departmentId=xyz) all tickets are displayed depending on the filters: department "my tickets" / "team tickets" status group/type channel My questions:

        • Customer/item(s) bought view

          Hello In Inventory/Customers/Transactions tab, how do I see what it is the customer actually ordered/bought without having to open each SO? Our customers buy a number of items thoughout the year. I've look at each transactions drop down, and no-where

        • ERROR: Product type cannot be changed for Items having transactions.

          I have mistakenly added a product type as goods for an item that was a digital service. Now when HSN/SAC became mandatory, this brought my attention to this error I did. So I tried changing the product type but it displayed this error message Product

        • Inventory Asset vs Finish Goods vs Work in Progress please explain or help me choose

          New to this so please if you can help in any way I would really appreciate it. So here we go. I make and sell and item which is made out of bunch of other items. (Composite Item). Now one of the parts that the item is made from is also a composite item.

        • WorkFlow to Update Custom Field in Sales Order with Tracking Information from Shipment of that Sales Order

          Hello All- I'd like to update the sales orders with the tracking information I enter in the shipping document. What is the proper variable to get the tracking information out of the shipping document? See attached.

        • ZOHO Desk-Enable Ticket Notification sound

          Hi, I answer the helpdesk tickets for Sevenstar. How can I enable the Ticket Notification sound when I receive a new ticket?

        • Batch Tracking Enhancements In Zoho Inventory

          Hello users, We’re excited to announce that we’ve taken batch tracking to a whole new level in Zoho Inventory! We’ve made it more accessible and easier to use than ever. Here’s a quick look at the improvements: 1) A New Way To Create or Modify Batches

        • Workflow not triggered by custom function field update

          I have a simple workflow that triggers when a field is updated on a Deal page. It works fine when I "manually" update the field via "edit" on that Deal page. It does NOT however work or trigger when that same field is updated with a custom function. I

        • Version history for Zoho CRM Functions

          Hi Zoho Support, I am wondering, there is no topics been posted for requesting the Zoho CRM Custom Functions Version history. It would be great to have mandatorily needed feature in Zoho CRM custom functions. Is there any work going on for this feature.

        • Creator portal user do not accept user password upon creation

          I placed a request at Zoho and they are working on it, but I try here too in case somebody has already the answer: Today, sudently, my customers that tried to join the portal were not abble to enter a valid password, even if the password had all the necessery

        • CRM Campaign -> Create Campaign ->Zoho Campaign. Add to Sender Address dropdown options (2024/08/01)

          I'm trying to add different Sender Address and Reply-to Address options to a new campaign created through Zoho CRM. There is one sender and reply-to address available and it is not the account I'm logged in with. The dropdown options do not match what

        • Create new ticket when another specific ticket is closed

          Hi. How can I create a ticket when another specific ticket is closed? So I have a ticket with subject 'Create agreement' connected to the contact of a customer. As soon as I close this ticket, I want that a new ticket is created (connected to the same

        • How can a Zoho Desk Admin access restricted files?

          How can a Zoho Desk Admin access restricted files from Zoho Desk that are not displayed to agents on tickets due to file type restrictions?

        • Need to bundle based on inventory stock not accounting stock

          Cannot create a bundle / composite item until a bill has been received, even if there is available stock due to an item receipt. This should be changed as it is required to make a bundle and invoice the customer before the vendor has billed us.

        • Can we make Transfer Orders based on Physical Stock?

          We are a manufacturing company and prefer to manage stock in "Physical Stock" mode. But if we don't have enough available quantity in "Accounting Stock", we couldn't make Transfer Orders, right? Is there any work around with this issue?

        • Why is my Lookup field not being set through Desk's API?

          Hello, I'm having trouble setting a custom field when creating a Ticket in Zoho Desk. The endpoint I'm consulting is "https://desk.zoho.com/api/v1/tickets" and even though my payload has the right format, with a "cf" key dedicated to all custom fields,

        • Ticket template - Send email to multiple contacts

          Is it possible to set up a ticket template with multiple contacts selected to receive an email, rather than just one contact as the default? We use Zoho Desk to send an email report to a group of contacts every day, and have to manually add each email

        • Zoho desk domain mapping not working

          Hi, I have followed this knowledge base support from your zoho site: https://help.zoho.com/portal/kb/articles/support-customers-from-your-own-domain-domain-host-mapping . First created a sub-domain(support.website.com), then went to zone editor to point "support.website.com" to cname desk.cs.zohohost.com . But it won't work out. What did I lack? Please I need it very much. Please see images below of the result: Please see below images of what I did: 1.)  2.) 3.) Hope to hear from you soon.

        • Next Page