Reports
The Suger Salesforce App ships with a set of Custom Report Types and pre-built Reports that give your team out-of-the-box visibility into marketplace offers, entitlements, revenue, co-sell referrals, and funding activity.
This page documents each report type β what object itβs built on, what data it joins together, and what fields it exposes.
Overview
If you manage marketplace sales across multiple cloud providers, reporting usually means switching between AWS, Azure, and GCP, exporting CSV files, and manually combining them into a single spreadsheet. This creates three common problems:
- Data is fragmented across different systems.
- Reports take hours to build and validate.
- Itβs hard to compare performance across clouds consistently.
Suger acts as the data layer between the cloud marketplaces and your CRM. It standardizes marketplace data from AWS, Azure, and GCP into a single structure before syncing it into Salesforce. Once connected, all marketplace activity shows up in one consistent format β regardless of which cloud it originated from β so you can report on it directly in Salesforce.
How Suger Normalizes Marketplace Data
A common question from RevOps teams is whether they need separate reporting logic for each cloud. With Suger, the answer is no. Suger maps AWS, Azure, and GCP marketplace objects into a unified data model so they behave consistently inside Salesforce. This means:
- A deal from AWS looks the same as a deal from GCP.
- Fields and object types are consistent across all clouds.
- One reporting model works across all marketplace activity.
This removes the need to build and maintain cloud-specific reporting logic.
Before vs. After Suger
| Reporting task | Without Suger | With Suger |
|---|---|---|
| Track pipeline across clouds | Export separate reports from AWS, Azure, and GCP, then combine manually | View all marketplace opportunities in a single Salesforce dashboard |
| Monitor deal status | Check each cloud portal individually for updates | See real-time status updates directly in Salesforce |
| Build leadership reports | Download and merge multiple CSV files every reporting cycle | Run unified reports directly from Salesforce with standardized data |
What Your Team Can Track
Once Suger is connected to Salesforce, marketplace data can be used directly in dashboards and reports.
Sales and Growth
Use these to understand how your marketplace business is growing over time:
- Number of accepted offers per month
- Average time from offer creation to buyer acceptance
- Top customers ranked by marketplace revenue
Instead of waiting for a finance report at the end of the month, your sales team can see in real time which deals have closed and which are still pending buyer action.
Funnel Performance
Use these to track how opportunities move through your co-sell pipeline:
- Volume of opportunities shared to cloud marketplaces (outbound referrals)
- Marketplace close rates by cloud provider
- Conversion metrics across AWS, Azure, and GCP side by side
If your team is co-selling with a cloud partner, these metrics tell you which partnerships are actually driving closed revenue and which ones need attention.
Financial Health
Use these to stay on top of payment and contract status without chasing down individual deals:
- Overdue payments and past-due contract flags
- Refund trends over time
- Transaction volume broken down by country or region
Your Finance team gets a live view of payment health instead of waiting for end-of-month reconciliation.
Where to Find Reports
- In Salesforce, click Reports in the App Launcher.
- Open the All Folders view and look for:
- Suger Reports β pre-built dashboards and reports for co-sell and marketplace activity.
- Suger Marketplace Operations Reports β operations-focused reports (offers, entitlements, revenue).
- To build your own report, click New Report and search for any report type with the βSugerβ prefix.
To view pre-built dashboards:
- Go to the Dashboards section in Salesforce.
- Search for Suger dashboards (for example, marketplace or co-sell dashboards).
- Apply filters such as date range or cloud provider.
- Drill into individual reports to explore deal-level details.
Custom Report Types
All Suger report types are listed below grouped by primary domain. Field coverage notes refer to which Suger custom-object fields are queryable; standard Salesforce system fields (Id, Owner, Name, CreatedDate, LastModifiedDate, etc.) are included on every report type and are not listed individually.
Marketplace Report Types
| Report Type | Label | Base Object | Joined Objects | Purpose |
|---|---|---|---|---|
Suger_Offers | Suger (Offers) | Offer__c | β | Single-object report on marketplace offers. Includes status, type, buyer info, dates, approval status, AWS Net Payment Term, and external IDs from each cloud marketplace. |
Suger_Offers_with_Dimensions | Suger Offers and Offer Dimensions | Offer__c | OfferDimension__c (child) | Offers, including AWS Net Payment Term, joined to their metering dimensions. Use when you need per-dimension pricing (Rate, Key, Plan) alongside offer attributes. |
Entitlements_Suger | Cloud Entitlements (Suger) | Entitlement__c | β | Single-object report on customer entitlements. Includes financial roll-ups (Invoiced, Collectable, Disbursed amounts), product, offer, and buyer linkage. |
Suger_Entitlements_and_Revenue_Records | Suger Entitlements and Revenue Records | Entitlement__c | RevenueRecord__c (child) | Entitlements joined to their per-transaction revenue records. Use for revenue breakdown by entitlement, invoice date, or disbursement period. Also exposes the linked Account β the lookup itself plus Account Name and Account ID via lookup β so revenue can be grouped and filtered by customer account. |
Suger_Revenue_Records | Suger Revenue Records | RevenueRecord__c | β | Revenue transactions tracking payments from buyers and disbursements from cloud partners. Includes invoice amount, collectable amount, disburse amount, and partner fees. |
Suger_Offer_Payment_Installments | Suger Offer Payment Installments | OfferPaymentInstallment__c | β | The payment schedule behind an offer, with the parent offer reachable through the Offer lookup. Exposes Charge Date, Amount, Original Amount, Discount Percentage, Credit, and Currency β use it to report on prepay schedules and negotiated free credit rather than on offer totals. |
Suger_Fundings | Suger (Fundings) | Funding__c | β | AWS Funding requests, including status, opportunity linkage, approval workflow, and claim amounts. |
Co-Sell Report Types
| Report Type | Label | Base Object | Joined Objects | Purpose |
|---|---|---|---|---|
Cloud_Referrals | Cloud Referrals (Suger) | Referral__c | β | Single-object report on all co-sell referrals. Includes common fields plus all AWS, Azure, and GCP cloud-specific fields (AWS_*, AZURE_*, GCP_*). |
Opportunities_with_Cloud_Referrals | Opportunities with Cloud Referrals | Opportunity | Referral__c (via Referrals__r) | Salesforce Opportunities joined to their Suger referrals. Useful for measuring opportunities that have an associated co-sell referral. |
Cosell_Opportunities_with_Cloud_Referrals | Co-Sell Opportunities with Cloud Referrals | Opportunity | Referral__c (via Referrals__r) | Variant of the above scoped to co-sell-tagged opportunities. |
opportunities_trending | Co-Sell Opportunities Trending | Opportunity | Referral__c (via Referrals__r) | DEPRECATED. Earlier version of the Opportunities-with-Referrals report type. Kept for backwards compatibility with existing dashboards. Use Opportunities_with_Cloud_Referrals for new reports. |
Invitation Message (AWS_InvitationMessage__c) is selectable as a column on the referral report types β the covering note the sender attached to an AWS engagement invitation. It is an invitation-only field, so it stays populated after acceptance and is one way to identify, after the fact, that a referral arrived as an inbound invitation.
Cross-Domain Report Types
| Report Type | Label | Base Object | Joined Objects | Purpose |
|---|---|---|---|---|
Opportunities_Suger | Opportunities - Offers (Suger) | Opportunity | Offer__c (via Offers__r) | Opportunities joined to their Suger offers, including AWS Net Payment Term. Useful when an Opportunity drives one or more marketplace offers and you want both on a single row. |
Opportunities_with_Suger_Entitlements | Opportunities with Suger Entitlements | Opportunity | Offer__c β Entitlement__c (two-level join via Offers__r.Entitlements__r) | Opportunities all the way through to fulfilled entitlements, with AWS Net Payment Term available from the offer. Tracks the full sales-to-fulfillment lifecycle on one report. |
Pre-Built Reports
The Suger app installs two folders of pre-built reports:
Suger Reports
Focused on co-sell activity and pipeline health:
- All Co-Sell Opportunities β every opportunity tagged with a referral
- All Co-Sell Opportunities by Week β co-sell volume trend
- Inbound / Outbound Co-Sell Opportunities by Week β directional volume trends
- Win Ratio (Current FY) β co-sell-influenced win rate
- CoSell Opportunity Leaderboard β leaderboard by opportunity owner
- CoSell Opportunities by AWS AM / AWS ISM / Sales Stage / Referral Type / PTB β segmentation breakdowns
- Days to Close (Opportunity Created Date / Referral Created Date) β cycle-time metrics
- Inbound CoSell Opportunities by AWS AM / MS Contact β partner-rep attribution
- MS All Referrals by MACC Eligibility β Microsoft MACC eligibility breakdown
- Opportunities without CoSell β uncovered pipeline
This folder also carries a few marketplace reports alongside the co-sell ones:
- All Marketplace Offers β offer-level inventory of all marketplace activity, with AWS Net Payment Term included as a column
- All Active Entitlements Report β the contracts currently running
- Opportunities with Suger Entitlements β opportunities followed through to fulfilled entitlements
- Suger Revenue Records / Suger Entitlements and Reveue Records β transaction-level revenue
Suger Marketplace Operations Reports
Focused on marketplace transactions and revenue ops. The folder installs sixteen reports:
| Report | What it answers |
|---|---|
| Current FY Accepted Private Offers | Private offers accepted so far this fiscal year. |
| Current FQ Accepted Private Offe | The same, scoped to the current fiscal quarter. |
| FQ Accepted Private Offers SUM | Fiscal-quarter accepted private offers, summed. |
| All Time Accepted Private Offers | Every private offer ever accepted. |
| Private Offers Expiring This Week | Offers whose acceptance window closes within the week. |
| Contracts Expiring this Month | Entitlements reaching their end date this month. |
| Active Public Offers Over Time | Public (listing) offer volume as a trend. |
| Accepted Offer Distribution by Country | Where accepted offers are coming from geographically. |
| Current FY Pipeline by Cloud | This fiscal yearβs marketplace pipeline split by cloud. |
| Current FY Sum/Average Deal Size | Deal-size totals and averages for the current fiscal year. |
| Previous FY Sum/Average Deal Size | The same for the prior fiscal year, for comparison. |
| Marketplace Average Deal Size (12 month) | Rolling twelve-month average deal size. |
| Average for Offer Acceptance | How long buyers take to accept. |
| Marketplace Revenue by Product and Cloud | Revenue broken out by product and cloud. |
| Marketplace Leaderboard | Ranking by marketplace activity. |
| Past-Due Marketplace Disbursements | Disbursements the cloud partner has not paid on time. |
The offer-level AWS Net Payment Term field is exposed as a selectable column on all four Offer/Opportunity report types that reach an offer β Suger_Offers, Suger_Offers_with_Dimensions, Opportunities_Suger, and Opportunities_with_Suger_Entitlements β and on none of the others. It is off by default; add it from the field list. The existing revenue-record Payment Terms field keeps its current meaning and is not replaced by this offer field.
You can clone any pre-built report and adapt it; the underlying Custom Report Types listed above are the foundation.
Building Your Own Report
To build a custom report using Suger data:
- In Salesforce, go to Reports β New Report.
- In the report type picker, search for βSugerβ to filter to Suger report types.
- Select the report type matching the data you need (see the tables above).
- Add columns from the available fields. All custom fields on the base object (and joined child objects, where applicable) are queryable.
- Apply filters and groupings as you would with any Salesforce report.
Field Reference
For per-field definitions, see the Custom Objects page β every field exposed in a report type is documented on its parent objectβs table.
Spotted something wrong or out of date on this page? Tell us and we'll correct it.