{ 0 comments }
If you are responsible for sales for your company a great way to manage your pipeline is through forecasting sales.
To forecast a sale in GoldMine:
1) Be on the contact record you want to forecast the sale with.
2) Choose Schedule | Sale from the menu.
3) Enter in as much information as you have, but I think the minimum would be the items circled below.
4) Then Click OK.
5) Your Forecasted Sale will appear on the Contact’s Pending tab as well as your Calendar and Activity List.
6) To mark the sale as Won or Lost, complete the activity. It’ll be removed off of the contact’s Pnding tab and onto their History tab as either a Won or Lost Sale.
7) To see all of your Forecasted Sales use your Activity List.
{ 0 comments }
Email Blasts from GoldMine
- Create The Email Template (What you’re going to send)
- Filter or Group (Who to send the blast to)
- Test Email
- Email Blast
- Queue for Delivery
{ 0 comments }
GoldMine’s Forecasted Sales allow you to keep track of your open sales pipeline. If you’re not currently using Forecasted Sales check out this post for the basics: http://www.thegoldmineblog.com/?p=2017
Here’s a handy SQL Query to show all of the past due Forecasted Sales for the team. To run the query go to Tools | SQL Query:
Then copy and paste this in:
SELECT ca.userid , c1.company , c1.contact , ca.ondate , ca.number1 AS Amt , ca.duration AS Probability, ca.ref , c1.accountno FROM cal ca INNER JOIN contact1 c1 ON ca.accountno = c1.accountno WHERE rectype = 'S' AND ondate <= GETDATE() ORDER BY userid
{ 0 comments }
GoldMine’s Peg Board allows you to know who’s logged in to GoldMine, who’s not, and everyone’s last login or logout time. You can also use the “Log Away” function to denote where you are if you’re not at your desk.
To view the Peg Board open up the GoldMine calendar then choose the Peg Board tab.
You may or may not see everyone listed, if you don’t, then do a Right-Click and select Users.
Here you can add individual users or user groups by double-clicking on them.
You’ll also notice the “Whereabouts” area.
This lets you leave a message to other GoldMine users to let them know where you are and when you’ll be back. To use this, use File | Log Away in GoldMine.
After choosing Logout you will be logged out of GoldMine, you’ll show back in after you login to GoldMine. If you choose Wait for me, GoldMine will be minimized, but still running, when you maximize GoldMine, the Peg Board will be updated to display that you are back in the office.
{ 0 comments }
Happy New Year’s Everyone!
I’m looking forward to another great year with GoldMine, and if you have any suggestions for blog postings you’d like to see please drop me a line at chad.smith(@)thegoldmineblog.com!
GoldMine’s Opportunity Manager gives you a great place to track all of your open opportunities. You can even record your calls and appointments against an opportunity, which are all tracked within the Opportunity Manager.
Of course, we can’t remember all the opportunities we have and open and should be following up on, so here’s a SQL Query to show you all of your open opportunities sorted by the last time you have a history record recorded for them. To run the query go to Tools | SQL Query:
Use this SQL Query:
SELECT ch.lasthistory, o.userid , o.company , o.contact , o.name , o.status , o.cycle , o.stage , o.source , o.startdate , o.foramt , o.forprob , o.accountno FROM opmgr o LEFT OUTER JOIN (SELECT MAX(ondate) AS LastHistory, loprecid FROM conthist GROUP BY loprecid ) ch ON o.recid = ch.loprecid WHERE rectype = 'O' ORDER BY ch.lasthistory
Just copy and paste it into the query window and hit Query
I think this concept would be very applicable to some GoldMine Dashboards as well. If you’re looking for some dashboard help please drop me a line at chad.smith@thegoldmineblog.com.
{ 0 comments }
The Delete Wizard
- Archive Option
- Video: Creating Additional Contact Sets
- Quick SQL Backup
- Delete Wizard
- Entire Records
- Old History
{ 0 comments }
Here are a few great keyboard shortcuts to use in GoldMine to help you be a little bit more productive:
F2- Brings up the picklist for the field you’re currently on
F4 – Opens the Contact Search Center
F5 – Opens the Email Center
F6 – Opens your Activity List
F7 – Opens your Calendar
F9 – Opens the Opportunity Manager
Control-Shift-E – Send an Email to the Current Contact
{ 0 comments }
Purchase a yearly subscription to GoldMineTraining.net for just $99/year. Click below for more information.
{ 0 comments }
Telemarketing Scripts
- Scripts
- Predefined series of questions and answers
- Populate Fields
- Save Questions/Responses
- Demo
- Mortgage Script
- Creating a Script
- Customer Satisfaction
- Question 1: Do you have time to chat
- Yes, Ask 3 Questions (Product, Service, and Likelihood to Recommend Scoares)
- No
- Call Next Week
- Question 1: Do you have time to chat
{ 0 comments }
It’s likely there are some GoldMine tabs that you rarely, if ever use. Fortunately, GoldMine makes it easy to remove those from your view and simplify your screen. First click on the down-arrow on the left side of your tabs and then choose Customize.
From the Display Tabs window you can uncheck tabs to remove them from view as well as change the order of the tabs.
{ 0 comments }
GoldMine Alarms are great for reminding you to make that call, write up a quote, or attend a meeting.
To set an audible alert for your alarms go to Tools | Options then Alarms. Check Play alarm sound file.
Click on the eclipse, “…” next to the white space, which will bring up a standard Windows open dialogue box. From here you can choose any .WAV file or, if you navigate to C:\Windows\Media\ select one from Windows.
Now, whenever a GoldMine alarms pops up, you’ll also hear your sound file!
{ 0 comments }
From FrontRange Solutions:
The new release of GoldMine Premium Edition 9.2 is now available for download. We’ve incorporated new social media views and improved links to Google Search and Maps to provide more information on your contacts. These new links will help you manage your business relationships by integrating Facebook, Twitter, LinkedIn and Google to help you build enduring relationships.
- LinkedIn contact search – Shows the LinkedIn profile for each GoldMine contact’s connections with one click access, allowing you to quickly see their profile and their connections so you can contact a colleague or friend for insight and assistance in establishing the relationship. You can also request a prospect to connect – a great way to introduce yourself and create a warm lead.
- Use Twitter in GoldMine – see a contact’s latest tweets and retweet to others – all within GoldMine.
- Facebook – Quick access search for a GoldMine contact and then link their individual or company page.
- Google News Search – Before you call a prospect or customer quickly see they latest news on the company to always be prepared with the latest news for the company.
- Google Maps – Are you going to visit a customer? Quickly access a Google map for directions…and by the way, you can also do this in real-time on your iPhone or iPad using the add-on product of GoldMine Mobile.
For more information and how to update visit http://www.goldmine.com/new-goldmine-release/
{ 0 comments }
Customizing the GoldMine Service Center
- Customize Options
- Master Access for Options & Labels
- Tab/Column Selection Anyone (Mostly)
- Templates
- Creating a new Template
- Using Templates
- F2 Drop downs
{ 0 comments }
Even with tablets and smartphones it can be convenient to print off a contact record from time to time. Here’s how you do it in GoldMine.
First, find the record you want to print.
Choose File | Print a Report
Make sure the settings for Type, Category, User, Which contact(s) to print for, and the output to are set to these settings:
For the Report select Contact Profile (Detailed) to include contact information as well as the history, contacts, etc. from the tabs. For a summary, choose Contact Info (Top Half) of screen as the report.
Click OK and the report will appear and can be printed.
{ 0 comments }
Click here to watch!
Hey, Hope everyone is having a great summer!
Here’s a handy SQL Query to show everyone you’ve had a call or appointment with in the last 90 days. This could be a great list to use to remind of you follow ups you could be doing.
Go to Tools | SQL Query in GoldMine, copy and paste this in and hit query.
Simply change the part where it says ‘USERID = ‘Bill’ to your userid in GoldMine so you’ll be seeing only your activities.
SELECT c1.contact ,
c1.company ,
c1.phone1 ,
ch.ondate ,
ch.ref ,
ch.actvcode ,
ch.resultcode,
c1.accountno
FROM contact1 c1
INNER JOIN conthist ch
ON c1.accountno = ch.accountno
WHERE ch.srectype IN ('A',
'C')
AND ch.ondate >= GETDATE() - 90
AND userid = 'BILL'
{ 0 comments }
Are you a GoldMine User and have a good idea about what feature or capability should be in GoldMine? GoldMine have setup an on line voting page to have your say by creating new ideas or adding votes to existing ideas. Have a go at:
http://goldmine.uservoice.com/forums/163208-goldmine
{ 0 comments }
In our previous entry:
http://www.thegoldmineblog.com/?p=2465
We talked about how to use Record Alerts. Here are some advanced tips for records alerts.
First, if you want to change an existing alert, for example change the three letter code of ‘ATG’ to ‘CRD’, we’re going to do that within the Knowledge Base.
Click on Goto | Knowledge Base.
Open Knowledge Base | System | Contact Alerts to edit the alert message simply change the text.
To change the Code or Alert Description Right-Click | Edit within the Knowledge Base on the alert.
By default, a record alert pops up 7 seconds after a contact is ‘touched’. This can be changed by adding a line to your GM.INI file which is located wherever GoldMine is installed, e.g. S:\GoldMine… You may see it just as “GM” if you are hiding file extensions in Windows. It should open using Notepad.
RecAlertSec=2 under the [GoldMine] Section. Change 2 to the number of seconds before the alert should pop up.
Since we’re doing this within the GM.INI file the change will be universal.
To view all records with a record alert go to Tools | SQL Queries and paste this query in:
select contact1.company, contact1.contact, contact1.phone1, contsupp.notes from contact1, contsupp where contsupp.rectype = 'A' and contact1.accountno = contsupp.accountno order by company
{ 0 comments }
Using the GoldMine Service Center
- Creating Cases
- Managing Cases
- Case Preferences
- Filtering with the Show Dropdown
- Grouping
- Adding Information to Cases
- Scheduling & Completing (Pending & History)
- Notes & Teams
- Tasks & Attachments
- Contacts
- Resolutions
- Reassign, Escalate, and Resolve
- Analyze
{ 0 comments }
