|
They
Don't Call It "GoldMine" For Nothing...
|
![]() |

|
![]() |

|
Date:
I wrote The GoldMine Guide to SQL Queries for the GoldMine community after helping a client boost sales by increasing the number of email addresses in their GoldMine database by 125%. I put together a simple SQL Query that showed all of their customers that they didn't have an email address on file for. They ran a contest for their account managers, the one who got the most new email addresses entered into the system won. All these new email addresses helped them reach more suspects, more prospects and more customers through their eMarketing. Filters & Groups sometimes are great for segmenting and finding data, but sometimes a SQL Query just works best or is the only option, The GoldMine Guide to SQL Queries will teach you how to write those queries so you can get the most out of GoldMine. I've been implementing, supporting, and training on GoldMine for over 10 years now, and the best SQL tricks have gone into this book. Enjoy!
Chad
Smith, Author |
![]()
|
Thank-you
so much for putting together such wonderful information. The chapters
have really helped me, not only in creating SQL Queries, but getting my
mind thinking in the right direction for creating much needed Crystal
Reports. Thank again!
Gerri Lawall |
|
|
You need
to see all accounts without an email address
|
|
|
You want to see a list
of all primary and secondary contacts, together
|
|
|
You loose
clients because you forget to contact them for 6 (3? 2?) months
|
|
|
You need to develop a
call list of all prospects that were entered into the system last year
|
|
|
You want
to see how many prospects came from each lead source
|
|
|
You need to see who is
tagged with a particular merge code
|
|
|
You
struggle to develop lists for mailing out holiday cards, brochures, new
product announcements
|
|
|
You need a list of all
secondary contact and their email addresses
|

What Is The GoldMine Guide to SQL Queries?The GoldMine Guide to SQL Queries is an eBook written for GoldMine users to assist you in writing SQL Queries. Through 11 chapters and over 70 pages of explanations, examples, and exams with answers you'll learn how to write even the most challenging SQL queries for GoldMine to help you mine your GoldMine. |
![]() |
|
Start Mining Today For: $29.95 |

|
I
can't thank you enough for taking the time to write this
manual! It will definitely improve our ability to get information out
of GoldMine. Part of the problem we have been experiencing is the
limited capabilities of the built in SQL queries in GM. With your
manual, I have been able to modify them to get the information I need
from the system. That in itself is priceless.
I can honestly tell you that I've been waiting months for the information I got yesterday within minutes. Our system has some issues ”so we are unable to pull accurate sales information, etc. Your queries solved my problem! Thank you again. I would highly recommend your manual to anyone who uses GoldMine. Geanine Jamison |
|
I had no idea of how to do SQL queries until I
spoke with Chad and began using his SQL book. Since that time, I have
been able to simply and effectively create queries that easily enable
me to create a list of clients that I have not seen, called or
otherwise communicated with, within a period that I am able to easily
specify. Being able to do this simply and quickly has
been a great time saver, and has enabled me to be far more productive
in my follow up. Goldmine is a great tool. Knowledge of
how to use the SQL query capability makes it an order of magnitude
better.
John Vettel |

|
Get The GoldMine
Guide To SQL Queries Right Now! 100% Satisfaction Guaranteed
|

Start Mining Today & Receive These Special Bonuses!
|
Bonus # 1
|
|
|
|
Bonus # 2
|
|
|
|
Bonus # 3
|
|
|
|
Bonus # 4
|
|
|

|
'The Guide' Is Relevant To Users of GoldMine Standard & Corporate Editions 4.x, 5.x, 6.x, 7.x and GoldMine Premium Edition 8.0 |

![]() |
I stand behind my work. If you're not completely satisfied with The GoldMine Guide to SQL Queries I'll refund your purchase, no questions asked for 90 days after your purchase! |
|
Start Mining Today For: $29.95 |
