Marketplace Comparison Insights (MCI) Guide

Marketplace Comparison Insights (MCI): Offers Reports

The Marketplace Comparison Insights (MCI) Offers Reports Guide aims to provide an overview of how MCI Offers reports can empower you to make informed decisions and optimize your offerings on our platform. By leveraging lead-level data reporting, MCI Offers reports enable lenders to gain valuable insights into the competitiveness of their offers in comparison to others presented to leads on our platform.

Understanding MCI Offers Reports

MCI Offers reports are comprehensive reports that provide detailed lead-level data insights to our lending partners. These reports serve as a powerful tool for lenders, providing a clear understanding of the offers presented to leads on our platform and where their own offers stand in terms of competitiveness.

Empowering Better Decisioning

MCI Offers reports enable lenders to make better-informed decisions by equipping them with crucial insights. By analyzing the data provided in these reports, lenders can evaluate the performance and effectiveness of their offers, identify areas for improvement, and adjust their strategies accordingly. This empowers lenders to optimize their underwriting process and enhance the overall effectiveness of their offerings.

Optimization of Partner Offerings

The data-driven insights from MCI Offers reports allow lenders to optimize their offerings on our platform. By comparing their offers to those presented to the same leads, lenders can assess the competitiveness of their offers in the marketplace and use the insights provided to identify opportunities for optimizing your offerings and improving competitiveness.

Leveraging MCI Offers Reports

To leverage the full potential of MCI Offers reports, we recommend the following best practices:

• Regular Review: Regularly review the reports to stay up-to-date with the performance of

  your offers and make data-driven decisions.

• Identify Opportunities: Use the insights provided to identify opportunities for optimizing

  your offerings and improving competitiveness of your offers

Report Details

MCI Offers reports are uploaded on a weekly basis, every Monday, in the Demand Control Center experience. The reports are downloaded as csv files. (Offer Management => Personal Loans => Data & Analytics => MCI Offers)

Here is a sample csv file:

Here is the definition of all the columns available in MCI Offers reports csv file:

Column Header	Definition	Notes
lead_uuid	This column contains lead UUID	–
rate_table_uuid	Unique identifier for a rate table.	It helps you identify cases if the same lead receives multiple rate tables. This may happen if the same lead came in through different channel partners and applied for a loan multiple times
offer_uuid	This column contains a unique ID for each individual offer	–
lender	Unique ID for each lender in our system	–
lead_created_at	Timestamp for when the lead was created	–
purpose	Lead provided loan purpose for the loan. Could be any of the options listed in the notes columns	• Auto • Auto Refinance • Baby • Business • Car Repair • Cosmetic • Credit Card Refi • Debt Consolidation • Emergency • Green • Home Improvement • Household expenses • Large Purchases • Life Event • Medical • Dental • Moving • Relocation • Other • Special Occasion • Student Loan • Student Loan Refi • Taxes • Vacation • Wedding
amount	Lead provided requested loan amount	–
credit_bucket_self_reported	Lead provided credit score bucket	• Excellent • Good • Fair • Poor • Unknown (credit score not provided) • Limited (no history)
annual_income_self_reported	Lead provided annual income	–
pay_frequency_self_reported	Lead provided frequency of income payments	• Weekly (Once every week) • Biweekly (Once every other week) • twice_monthly (Twice per month) • monthly (Once per month)
employment_status_self_reported	Lead provided employment status	• Employed • Employed_full_time • Employed_part_tim • Military • Not Employed • Retired • Self Employed • Other
education_level_self_reported	Lead provided education level	• High_school (High School Diploma) • Associate (Associate’s Degree) • Bachelors (Bachelor’s Degree) • Certificate • Did_not_graduate • Doctorate • Master’s Degree • Other Graduate Degree • Other
property_status_self_reported	Lead provided residence status	• Rent • own_with_mortgage (Own with mortgage) • own_outright (Own)
state	Lead provided state of residence	–
zip_code	Lead provided zip code	–
birth_year	Lead provided year of birth	–
offer_amt	The loan amount for specific offer that was offered to the lead	–
offer_apr	The loan APR for the specific offer that was offered to the lead	–
orgination_fee	Fees paid on the loan for the specific offer that was offered to the lead	–
term_in_months	Number of months in which the lead has to repay the loan for the offer that was presented to the lead. At the moment values of "1" and "0" are currently populating in MCI Offer reporting for LOC products when the term unit is "Open" which means no term limit.	–
monthly_payment_amount	The monthly payment amount for the specific offer that was offered to the lead
is_static	The column represents if the lead was evaluated in real time via an API integration or not	• True • False
rate_table_offer_rank	This column shows the ranking our recommendation score model assigned to each offer returned for a consumer. The offer with the highest recommendation score will have rank 1, the second highest recommendation score offer will have rank 2 and so on	Each lender has their single highest ranked offer presented to the user. Consumers can click “show more” to see all offers returned by a given lender
rate_table_lender_rank	This column shows the order of each lender’s best offer on the rate table. It will help you determine your rank compared to the other lenders on the rate table	–
available_on_first_page	This column can be used to determine if (to the best of our knowledge) the offers were ranked and shown to the user based on Engine by MoneyLion’s recommendation score. Partner Page and Embed integrations always use Engine’s recommendation score, so each offer with the highest score per lender will show a value Yes. API partners may use their own logic in ranking offers and hence if the offer was displayed per recommendation score is Unknown to us. Offers that were not your top scoring offer will have a value No, as they are not available on the first page but can be seen by a consumer who clicks “show more” offers	–
offer_clicked	This column denotes if the offer was clicked by the lead

Marketplace Comparison Insights (MCI): Rejections Reports

The Marketplace Comparison Insights (MCI) Rejections Reports Guide aims to provide an in-depth understanding of how the MCI Rejections Report can offer valuable insights into the other offers presented to leads that you rejected and did not provide offers to. By leveraging this report, lenders can gain a comprehensive understanding of the market's response to leads that were rejected based on their offer underwriting criteria.

Understanding MCI Offers Reports

The MCI Rejections Report provides lenders with detailed insights into the other offers that were presented to leads whom you rejected and did not provide offers to. This report allows lenders to see the types of offers these leads were offered, providing valuable information about market dynamics and how competitors are servicing similar leads.

Enhanced Market Insights

By analyzing the data provided in the MCI Rejections Report, lenders gain a deeper understanding of how the market is addressing leads that were rejected due to their offer underwriting criteria. Specifically, lenders will be able to see how many prequalified offers the lead saw, the corresponding terms, and whether or not they were clicked.

Leveraging the MCI Rejections Reports

To make the most of the MCI Rejections Report, we recommend the following best practices:

• Regular Review: Consistently review the report to stay informed about the market's response to your rejected leads and gain insights for potential improvements.

• Comparative Analysis: Analyze the terms, click rates, and overall competitiveness of other offers presented to rejected leads, enabling you to refine your underwriting criteria and enhance your offerings.

• Adapt and Optimize: Utilize the insights from the report to make data-driven adjustments to your underwriting criteria and strategies, enhancing your ability to convert leads.

Report Details

MCI Rejections reports are uploaded on a weekly basis, every Monday, in the Demand Control Center experience. The reports are downloaded as csv files.

(Offer Management => Personal Loans => Data & Analytics => MCI Rejections)

Here is a sample csv file:

The MCI Rejections Report shares the same columns as the MCI Offers Report, however, the key distinction lies in the focus of the report. While the MCI Offers Report provides details about offers presented to leads alongside your offer, the MCI Rejections Report sheds light on the other offers presented to leads that you rejected.

Please refer to the Report Details section of MCI Offers report for more details.

Marketplace Comparison Insights (MCI): Conversions Reports

The Marketplace Comparison Insights (MCI) Conversions Report aims to provide an in-depth understanding of how the MCI Conversions Report can offer invaluable insights into funding information for leads to whom you extended an offer, but another lender ended up funding them. Additionally, this report offers a wealth of information about the specific offers these leads clicked on, your best offer to the lead, and details about the funded amount and time.

Understanding MCI Conversions Reports

The MCI Conversions Report is a comprehensive tool that offers insights into the outcomes of leads you provided offers to. It focuses on leads who received offers from you but were ultimately funded by other sources. The report provides a detailed breakdown of the entire conversion process for these leads.

Key Data Points in the MCI Conversions Report:

The MCI Conversions Report contains several critical data points that empower you with valuable information:

• Lead Details: This section provides an overview of the loan purpose and loan amount the lead requested for.

• Offer Information: Discover the details of the offer the lead clicked on and eventually funded.

• Your Best Offer: Offer details of your best offer that was presented to the lead.

• Funded Amount and Time: Gain insights into the amount funded to the lead and the date the lead was funded.

Leveraging the MCI Conversions Reports

The MCI Conversions Report offers you a unique opportunity to enhance your lending strategies and make data-driven decisions. Here's how you can leverage these insights:

• Regular Review: Routinely review the report to stay informed about the outcomes of your leads.

• Continuous Improvement: Use the data to refine your offers, conversion strategies, and competitiveness in the market.

• Adapt and Thrive: By adapting based on the insights from this report, you can stay competitive and achieve better conversion rates.

Report Details

MCI Conversions reports are uploaded on a weekly basis, every Monday, in the Demand Control Center experience. The reports are downloaded as csv files.

(Offer Management => Personal Loans => Data & Analytics => MCI Conversions)

Column Header	Definition	Notes
lead_uuid	This column contains lead UUID	–
rate_table_uuid	Unique identifier for a rate table	It helps you identify cases if the same lead receives multiple rate tables. This may happen if the same lead came in through different channel partners and applied for a loan multiple times
loan_purpose	Lead provided loan purpose for the loan. Could be any of the options listed in the notes columns	• Auto • Auto Refinance • Baby • Business • Car Repair • Cosmetic • Credit Card Refi • Debt Consolidation • Emergency • Green • Home Improvement • Household expenses • Large Purchases • Life Event • Medical • Dental • Moving • Relocation • Other • Special Occasion • Student Loan • Student Loan Refi • Taxes • Vacation • Wedding
requested_amount	Lead provided requested loan amount	–
clicked_lender	This column represents the lender UUID of the lender who’s offer lead clicked and eventually got funded	–
clicked_offer_amount	This column represents the loan amount of the offer that the lead clicked on	–
clicked_offer_apr	This column represents the offer APR of the offer that the lead clicked on	–
clicked_offer_origination_fee	This column represents the origination fee of the offer that the lead clicked on	–
clicked_offer_term_in_months	This column represents the offer term of the offer that the lead clicked on	–
clicked_offers_offer_rank	This column represents the rate table rank of the offer the lead clicked on	–
clicked_offers_lender_rank	This column represents the rank of the lender who’s offer lead clicked on and got funded in the rate table	–
clicked_offer_available_on_first_page	This column represents if the offer the user clicked on was available on the first page. This column can be used to determine if (to the best of our knowledge) the offers were ranked and shown to the user based on Engine by MoneyLion’s recommendation score. Partner Page and Embed integrations always use Engine’s recommendation score, so each offer with the highest score per lender will show a value Yes. API partners may use their own logic in ranking offers and hence if the offer was displayed per recommendation score is Unknown to us. Offers that were not your top scoring offer will have a value No, as they are not available on the first page but can be seen by a consumer who clicks “show more” offers	–
last_clicked_at	This column represents the date when the lead last clicked on an offer from the lender who funded the lead	–
funded_loan_amount	This column represents the actual funding amount	–
funded_loan_at	This column represents the date when the lead was funded
your_highest_ranked_offer_apr	This column represents your best offer’s APR that was offered to the lead
your_higest_ranked_offer_amount	This column represents your best offer’s loan amount that was offered to the lead
your_highest_ranked_offer_origination_fee	This column represents your best offer’s origination fee that was offered to the lead
your_higest_ranked_offer_term_in_months	This column represents your best offer’s term that was offered to the lead
your_highest_offer_rank	This column represents your best offer’s offer rank in the rate table. You can use this value to compare your rank vs the rank of the offer the lead clicked on and got funded
your_highest_lender_rank	This column represents your rank in the rate table. You can use this value to compare your rank vs the rank of the lender who’s offer user clicked on and got funded
your_highest_ranked_offer_available_on_first_page	This column represents if your best offer was available to lead on the first page. This column can be used to determine if (to the best of our knowledge) the offers were ranked and shown to the user based on Engine by MoneyLion’s recommendation score. Partner Page and Embed integrations always use Engine’s recommendation score, so each offer with the highest score per lender will show a value Yes. API partners may use their own logic in ranking offers and hence if the offer was displayed per recommendation score is Unknown to us. Offers that were not your top scoring offer will have a value No, as they are not available on the first page but can be seen by a consumer who clicks “show more” offers