Agent

Customer Email Advertiser ID Billing Ref#

Consumer

Consumer Email Consumer Phone Number Message

Lead Info

Lead ID Lead Product Visitor ID

Listing

Zip Code Listing ID MPRID

Date & Limit

Number of Leads Date Range

SELECT

FROM RDC_CORE.FACT.FCT_LEADS
WHERE SUBMITTED_LEAD_ID = SUBMITTED_LEAD_ID