Very Odd...

[CHUMPS FROM OXFORD]

I received a lead (from ASAP...not that it matters). It was bogus...wrong phone number etc...) It went into my autoresponder. Shortly, I got this message. Maybe a tech person can figure it out.

How can my quote engine company know it is a bad lead? Or maybe they don't. I always worry that leads of mine are being sold. I hope not. I don't think they are. But I always worry...

PreparedStatementCallback; uncategorized SQLException for SQL [select lcdv.call_record_id, lcdv.lead_id, crat.timestamp, crats.short_desc as call_status, case when (crat.status_id = 5) then lcdv.call_duration end as call_duration, bdv.description as voicemail_name from lead_call_duration_view lcdv INNER JOIN call_record_audit_trail crat ON crat.call_record_id = lcdv.call_record_id INNER JOIN call_record_audit_trail_status crats ON crats.id = crat.status_id INNER JOIN call_record_lead crl ON crl.call_record_audit_trail_id = crat.id and crl.lead_id = lcdv.lead_id LEFT JOIN broker_dialer_voicemail bdv ON bdv.id = crl.voicemail_id WHERE lcdv.subscriber_id = ? and lcdv.lead_id = ? AND crats.status in ('CONSUMER_BADNUMBER','CONSUMER_NO_ANSWER','CONSUMER_UNREACHABLE','CONSUMER_REJECT','CONSUMER_BUSY','CONSUMER_VOICEMAIL','CONSUMER_ANSWER') ORDER by lcdv.call_record_id DESC, crat.timestamp DESC]; SQL state [28000]; error code [1045]; Access denied for user 'leaddistribution'@'app_.bo-prod.norvax.net' (using password: YES) Query being executed when exception was thrown: select lcdv.call_record_id, lcdv.lead_id, crat.timestamp, crats.short_desc as call_status, case when (crat.status_id = 5) then lcdv.call_duration end as call_duration, bdv.description as voicemail_name from lead_call_duration_view lcdv INNER JOIN call_record_audit_trail crat ON crat.call_record_id = lcdv.call_record_id INNER JOIN call_record_audit_trail_status crats ON crats.id = crat.status_id INNER JOIN call_record_lead crl ON crl.call_record_audit_trail_id = crat.id and crl.lead_id = lcdv.lead_id LEFT JOIN broker_dialer_voicemail bdv ON bdv.id = crl.voicemail_id WHERE lcdv.subscriber_id = 17191 and lcdv.lead_id = 15473968 AND crats.status in ('CONSUMER_BADNUMBER','CONSUMER_NO_ANSWER','CONSUMER_UNREACHABLE','CONSUMER_REJECT','CONSUMER_BUSY','CONSUMER_VOICEMAIL','CONSUMER_ANSWER') ORDER by lcdv.call_record_id DESC, crat.timestamp DESC; nested exception is java.sql.SQLException: Access denied for user 'leaddistribution'@'app_.bo-prod.norvax.net' (using password: YES) Query being executed when exception was thrown: select lcdv.call_record_id, lcdv.lead_id, crat.timestamp, crats.short_desc as call_status, case when (crat.status_id = 5) then lcdv.call_duration end as call_duration, bdv.description as voicemail_name from lead_call_duration_view lcdv INNER JOIN call_record_audit_trail crat ON crat.call_record_id = lcdv.call_record_id INNER JOIN call_record_audit_trail_status crats ON crats.id = crat.status_id INNER JOIN call_record_lead crl ON crl.call_record_audit_trail_id = crat.id and crl.lead_id = lcdv.lead_id LEFT JOIN broker_dialer_voicemail bdv ON bdv.id = crl.voicemail_id WHERE lcdv.subscriber_id = 17191 and lcdv.lead_id = 15473968 AND crats.status in ('CONSUMER_BADNUMBER','CONSUMER_NO_ANSWER','CONSUMER_UNREACHABLE','CONSUMER_REJECT','CONSUMER_BUSY','CONSUMER_VOICEMAIL','CONSUMER_ANSWER') ORDER by lcdv.call_record_id DESC, crat.timestamp DESC
- - - - - - - - - - - - - - - - - -
Let me add this...

Has ANYONE ever had a lead they generated from their website (or purchased) mysteriously find its way into other broker's hand?

That is...has your health insurance search engine company EVER mistakenly sold one of YOUR leads to other people?

Just curious.

 

[djs]

The sql engine died, you are simply seeing the query. The query does a bunch of status checks to see if it has been marked as a bad number / bogus / whatever, but this does not mean they are making that determination.

Without knowing the database structure, it's not possible to completely interpret the query, but basically there is a spot that says either show me bogus leads or don't show me bogus leads (you'll see this as:
AND crats.status in ('CONSUMER_BADNUMBER','CONSUMER_NO_ANSWER','CONSUM ER_UNREACHABLE','CONSUMER_REJECT','CONSUMER_BUSY', 'CONSUMER_VOICEMAIL','CONSUMER_ANSWER')

I assume these are leads you have marked as bogus somewhere, and then it just removes them from the typical display.

Dan

 

[CHUMPS FROM OXFORD]

That's the odd thing. I never marked them bogus. But they were bogus.
Actually, the phone number was a working number, but not for that lead.

 

[djs]

I understand that, but the query runs the check. It doesn't know whether it is marked bogus or not until it asks. This is just it asking.

Computers are pretty stupid, you have to tell them exactly what you want.

I assume the programming assumption is that once you mark a lead bogus, you never want to see it again unless you specifically ask for it.

So, if you ask an admin person, you say:
"Show me all of my current leads". That person should be smart enough to filter out all of the bogus leads.

The same question to the computer is:
"Show me all of my current leads, but skip the ones with bad phone numbers, bad addresses, emails that bounce, etc, etc, etc".

That's all it was doing, asking for a list of leads (or maybe a single lead) that were not not marked bogus.

Besides, when they resell your leads, they simply make a copy of them and resell them. It wouldn't impact your lead and your own work to discover that it is bogus!

Dan

 

[on7of9]

nothing has been marked bogus or good. the sql statement is just listing the fields. the error is "SQL state [28000]; error code [1045]; Access denied for user 'leaddistribution'@'app_.bo-prod.norvax.net' (using password: YES) Query being executed when exception was thrown"

 

[CHUMPS FROM OXFORD]

"Besides, when they resell your leads"

That's my point. When you use a health quote engine...they should not be selling your leads. Even if they have their own lead company, they should keep their paws off my leads that I bought or generated through my website.

I assume that is not going on here. But if it was...we all would want to know.