My boss likes me to send me a brief report each week about my previous week of prospects and sales. Basically the day and date they came in, their names, what they were interested in, buying or renting, and what product, and next step. Would there be a way I can automate this so I don’t have to create this email to send to her every week? What would be the best way to handle?
I would do this using a filter and customising the table view to include all the information you need to share. So you would have columns for Date Created, Name, Interested In, Buying or Renting, Next Step (i.e. all of these would need to be custom fields). You can then export this as a spreadsheet on a weekly basis.
Paul, once I set up a personalized field in the Person section por example, if I entered the type of field as numeric is there a way I can change it to monetary o something else without deleting the field?
Paul, where can I learn more about filtering and logic. At least with Insightly I was constantly getting unexpected results. And I couldn't always figure out what was causing the unexpected results.
Do you have like a list of common mistakes, or things that are likely to cause issues (I learned, for example, to set up one condition at a time, examine the results, and then add another layer). But even doing that I never quite mastered it - and so I never trusted that the data I was getting back was actually accurate and not missing anything.
Would love any further guidance you might have on this topic.
Hi Claudine. I don't have any additional resources I'm afraid. But like you said, take it slowly. I recommend working through one line of logic at a time before adding another. Make sure you're adding conditions to the right section i.e. do you want to match ALL conditions or ANY. And, with some filter options, you need to think about whether you want to use an IS or CONTAINS condition for a multi-option data field e.g. 'Deal source IS abc' or 'Deal source CONTAINS abc' They're different. But yeah, that's the best thing. Take it slowly and carefully think through the logic as you go.