# 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)

<figure><img src="/files/LMMdPxIuzXjpDQCp9fBF" alt=""><figcaption></figcaption></figure>

Here is a sample csv file:

<figure><img src="/files/myrs4IYnjYObLxXodhtF" alt=""><figcaption></figcaption></figure>

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

<table><thead><tr><th width="275.3333333333333">Column Header</th><th width="271">Definition</th><th>Notes</th></tr></thead><tbody><tr><td>lead_uuid</td><td>This column contains lead UUID</td><td>–</td></tr><tr><td>rate_table_uuid</td><td>Unique identifier for a rate table. </td><td>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</td></tr><tr><td>offer_uuid</td><td>This column contains a unique ID for each individual offer</td><td>–</td></tr><tr><td>lender</td><td>Unique ID for each lender in our system</td><td>–</td></tr><tr><td>lead_created_at</td><td>Timestamp for when the lead was created</td><td>–</td></tr><tr><td>purpose</td><td>Lead provided loan purpose for the loan. Could be any of the options listed in the notes columns</td><td><p>• Auto</p><p>• Auto Refinance</p><p>• Baby</p><p>• Business</p><p>• Car Repair</p><p>• Cosmetic</p><p>• Credit Card Refi</p><p>• Debt Consolidation</p><p>• Emergency</p><p>• Green</p><p>• Home Improvement</p><p>• Household expenses</p><p>• Large Purchases</p><p>• Life Event</p><p>• Medical </p><p>• Dental</p><p>• Moving</p><p>• Relocation</p><p>• Other</p><p>• Special Occasion</p><p>• Student Loan</p><p>• Student Loan Refi</p><p>• Taxes</p><p>• Vacation</p><p>• Wedding</p></td></tr><tr><td>amount</td><td>Lead provided requested loan amount</td><td>–</td></tr><tr><td>credit_bucket_self_reported</td><td>Lead provided credit score bucket</td><td><p>• Excellent</p><p>• Good</p><p>• Fair</p><p>• Poor</p><p>• Unknown (credit score not provided)</p><p>• Limited (no history)</p></td></tr><tr><td>annual_income_self_reported</td><td>Lead provided annual income</td><td>–</td></tr><tr><td>pay_frequency_self_reported</td><td>Lead provided frequency of income payments</td><td><p>• Weekly (Once every week)</p><p>• Biweekly (Once every other week)</p><p>• twice_monthly (Twice per month)</p><p>• monthly (Once per month)</p></td></tr><tr><td>employment_status_self_reported</td><td>Lead provided employment status</td><td><p>• Employed</p><p>• Employed_full_time</p><p>• Employed_part_tim</p><p>• Military</p><p>• Not Employed</p><p>• Retired</p><p>• Self Employed</p><p>• Other</p></td></tr><tr><td>education_level_self_reported</td><td>Lead provided education level</td><td><p>• High_school (High School Diploma)</p><p>• Associate (Associate’s Degree)</p><p>• Bachelors (Bachelor’s Degree)</p><p>• Certificate</p><p>• Did_not_graduate</p><p>• Doctorate</p><p>• Master’s Degree</p><p>• Other Graduate Degree</p><p>• Other</p></td></tr><tr><td>property_status_self_reported</td><td>Lead provided residence status</td><td><p>• Rent</p><p>• own_with_mortgage (Own with mortgage)</p><p>• own_outright (Own)</p></td></tr><tr><td>state</td><td>Lead provided state of residence</td><td>–</td></tr><tr><td>zip_code</td><td>Lead provided zip code</td><td>–</td></tr><tr><td>birth_year</td><td>Lead provided year of birth</td><td>–</td></tr><tr><td>offer_amt</td><td>The loan amount for specific offer that was offered to the lead</td><td>–</td></tr><tr><td>offer_apr</td><td>The loan APR for the specific offer that was offered to the lead</td><td>–</td></tr><tr><td>orgination_fee</td><td>Fees paid on the loan for the specific offer that was offered to the lead</td><td>–</td></tr><tr><td>term_in_months</td><td>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.</td><td>–</td></tr><tr><td>monthly_payment_amount</td><td>The monthly payment amount for the specific offer that was offered to the lead</td><td></td></tr><tr><td>is_static</td><td>The column represents if the lead was evaluated in real time via an API integration or not</td><td><p>• True</p><p>• False</p></td></tr><tr><td>rate_table_offer_rank</td><td>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</td><td>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</td></tr><tr><td>rate_table_lender_rank</td><td>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</td><td>–</td></tr><tr><td>available_on_first_page</td><td>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</td><td>–</td></tr><tr><td>offer_clicked</td><td>This column denotes if the offer was clicked by the lead</td><td></td></tr></tbody></table>

## 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&#x20;

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

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

<figure><img src="/files/E611MxVenrWdaUpyyfOI" alt=""><figcaption></figcaption></figure>

Here is a sample csv file:

<figure><img src="/files/UuAa7Rd2r3SeG0YYdMgr" alt=""><figcaption></figcaption></figure>

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.&#x20;

### 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.&#x20;

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

<table><thead><tr><th width="275.3333333333333">Column Header</th><th width="271">Definition</th><th>Notes</th></tr></thead><tbody><tr><td>lead_uuid</td><td>This column contains lead UUID</td><td>–</td></tr><tr><td>rate_table_uuid</td><td>Unique identifier for a rate table </td><td>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</td></tr><tr><td>loan_purpose</td><td>Lead provided loan purpose for the loan. Could be any of the options listed in the notes columns</td><td><p>• Auto</p><p>• Auto Refinance</p><p>• Baby</p><p>• Business</p><p>• Car Repair</p><p>• Cosmetic</p><p>• Credit Card Refi</p><p>• Debt Consolidation</p><p>• Emergency</p><p>• Green</p><p>• Home Improvement</p><p>• Household expenses</p><p>• Large Purchases</p><p>• Life Event</p><p>• Medical </p><p>• Dental</p><p>• Moving</p><p>• Relocation</p><p>• Other</p><p>• Special Occasion</p><p>• Student Loan</p><p>• Student Loan Refi</p><p>• Taxes</p><p>• Vacation</p><p>• Wedding</p></td></tr><tr><td>requested_amount</td><td>Lead provided requested loan amount</td><td>–</td></tr><tr><td>clicked_lender</td><td>This column represents the lender UUID of the lender who’s offer lead clicked and eventually got funded</td><td>–</td></tr><tr><td>clicked_offer_amount</td><td>This column represents the loan amount of the offer that the lead clicked on</td><td>–</td></tr><tr><td>clicked_offer_apr</td><td>This column represents the offer APR of the offer that the lead clicked on</td><td>–</td></tr><tr><td>clicked_offer_origination_fee</td><td>This column represents the origination fee of the offer that the lead clicked on</td><td>–</td></tr><tr><td>clicked_offer_term_in_months</td><td>This column represents the offer term of the offer that the lead clicked on</td><td>– </td></tr><tr><td>clicked_offers_offer_rank</td><td>This column represents the rate table rank of the offer the lead clicked on</td><td>– </td></tr><tr><td>clicked_offers_lender_rank</td><td>This column represents the rank of the lender who’s offer lead clicked on and got funded in the rate table</td><td>–</td></tr><tr><td>clicked_offer_available_on_first_page</td><td>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</td><td>–</td></tr><tr><td>last_clicked_at</td><td>This column represents the date when the lead last clicked on an offer from the lender who funded the lead</td><td>–</td></tr><tr><td>funded_loan_amount</td><td>This column represents the actual funding amount</td><td>–</td></tr><tr><td>funded_loan_at</td><td>This column represents the date when the lead was funded</td><td></td></tr><tr><td>your_highest_ranked_offer_apr</td><td>This column represents your best offer’s APR that was offered to the lead</td><td></td></tr><tr><td>your_higest_ranked_offer_amount</td><td>This column represents your best offer’s loan amount that was offered to the lead</td><td></td></tr><tr><td>your_highest_ranked_offer_origination_fee</td><td>This column represents your best offer’s origination fee that was offered to the lead</td><td></td></tr><tr><td>your_higest_ranked_offer_term_in_months</td><td>This column represents your best offer’s term that was offered to the lead</td><td></td></tr><tr><td>your_highest_offer_rank</td><td>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</td><td></td></tr><tr><td>your_highest_lender_rank</td><td>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</td><td></td></tr><tr><td>your_highest_ranked_offer_available_on_first_page</td><td>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</td><td></td></tr></tbody></table>

<br>

<br>

<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://even-financial.gitbook.io/control-center/financial-services-provider/marketplace-comparison-insights-mci-guide.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.