Referral insights download – Data definitions
Appropriate roles: Referrals admin
Introduction
By using the Download button on the Lead and Co-sell analytics page, you can download the raw datasets.
The various reports, which you can download along with their data definitions, are listed in the following tables:
Leads download
| Column Name | Data description |
|---|---|
| Referral ID | Unique ID for referral |
| Creation Date | Creation date of referral |
| Updated Date | Last updated date of referral |
| PartnerID | Microsoft AI Cloud Partner Program ID of the partner |
| Customer Country | Country/region of the customer |
| Customer City | City of the customer |
| Customer Name | Name of the customer |
| Lead Type | Type of the lead (Qualified lead, offer lead, profile lead) |
| Lead Source | Source of the referral: Appsource, Azure Marketplace, Azure portal |
| Call to action | Call to action (CTA) against which the lead is generated: Contact me, Get it now, Test drive |
| Referral program | Referral program from which qualified lead is generated |
| Business profile ID | Business profile ID |
| Offer ID | List of the offer ID |
| Offer name | List of offer name |
| Lead currency | Currency of the lead |
| Lead value | Estimated lead value provided by partner |
| Lead value (USD) | Estimated lead value provided by partner in USD |
| Status | Latest status of referral |
| Status Reason | Remarks or reason for the status |
Co-sell download
| Column Name | Data description |
|---|---|
| Referral ID | Unique ID for referral |
| Customer Country | Country/region of the customer |
| Customer City | City of the customer |
| Customer Name | Name of the customer |
| Referral Creation Date | Creation date of referral |
| Deal Type | Type of the deal: co-sell, partner-led, private |
| Deal Direction | Direction of the deal: Incoming and Outgoing |
| Deal currency | Currency of the deal |
| Estimated Deal value | Estimated deal value provided by partner |
| Estimated Deal value (USD) | Estimated deal value provided by partner in USD |
| Solution ID | List of the solution ID |
| Solution Name | List of the solution names |
| PartnerID | Microsoft partner network ID of the partner |
| Partner Name | Name of the partner |
| Deal ID | ID of the deal |
| Engagement ID | Unique engagement ID |
| Microsoft MSX ID | MSX ID of deal |
| Microsoft Referral Creation Date | Referral creation date by Microsoft |
| Contract Currency | Currency of the contract provided during deal registration |
| Contract Value | Total contract value provided during deal registration. This value includes software and service fees but not hardware costs |
| Contract Value (USD) | Total contract value in USD provided during deal registration |
| Contract Start Date | Start date of the contract provided during deal registration |
| Contract End Date | End date of the contract provided during deal registration |
| Contract Sign Date | Sign date of the contract provided during deal registration |
| Contract Term | Term of the contract - Finite and Perpetual |
| Registered deal solution ID | ID of solution for deal registration |
| Registered deal solution name | Name of solution for deal registration |
| Registered deal solution currency | Currency for solution provided during deal registration |
| Registered deal solution value | Solution value provided during deal registration. Generally, this is total contract value less any non-recurring implementation fees. |
| Registered deal solution value (USD) | Solution value in USD provided during deal registration |
| Deployed On | Indicates if the solution is deployed on Azure or Others |
| Primary Deployment On | Indicates if the solution is deployed on Customer Tenant or Partner Tenant |
| Deal Creation Date | Creation date of deal registration |
| Deal Review Pending Date | Date when deal registration is picked for Review |
| Deal Approved Date | Date when deal registration is approved |
| Deal Review Passed Date | Date when deal registration review is passed |
| Deal Review Failed Date | Date when deal registration review is failed |
| Annual Contract Value | Annualized contract value for approved and review passed deals |
| Pricing Model | Pricing model for registered deals - Pay as you go and others |
| US Federal Deal | Indicates if it's a US federal deal |
| Is Marketplace Transacted Deal | Indicates if it's a Marketplace transacted deal |
| Marketplace transaction date | Marketplace transaction date if the deal is transacted on marketplace |
| Status | Latest status of referral |
| Status Reason | Remarks or reason for the status |
| Partner Program | Indicates if this referral was shared because of your enrollment or participation in a specific go-to-market (GTM) program (for services co-sell deals). |
| Partner Role | Role that a services partner can play in the opportunity based on their endorsements (for services co-sell deals). |
| Solution Area | Solution Areas categorize offerings across Microsoft product portfolio. |
| Solution Play | Solution Plays are how Microsoft executes business objectives to achieve customer outcomes and enable success. |