AWS Marketplace Single Pane of Glass (SPG) Dashboard - Cloud Intelligence Dashboards on AWS

AWS Marketplace Single Pane of Glass (SPG) Dashboard

Introduction

The AWS Marketplace Single Pane of Glass (SPG) dashboard delivers comprehensive procurement insights through an interactive, out-of-the-box Amazon QuickSight interface. Designed for AWS Marketplace buyers, this solution offers detailed visibility into third-party software subscriptions, including AI Agents, data products, and professional services. Users can access visualizations spanning all AWS Marketplace offerings, encompassing both self-service public offers and custom seller private offers. The dashboard provides detailed analytics on AWS Marketplace spend and usage across multiple AWS Organizations, displays software license grants and entitlements, and surfaces critical agreement information such as "Deployed on AWS" badge status and contract terms. This unified view enables procurement teams to monitor and analyze their AWS Marketplace investments effectively.

The dashboard has five tabs:

  • Spend Summary:

    • AWS Marketplace Cumulative Spend by Seller

    • AWS Marketplace Cumulative Spend by Product

    • AWS Marketplace Spend by Seller

    • AWS Marketplace Spend and Usage by Seller Product

    • Marketplace Invoice Tracker

  • Spend Deep Dive:

    • Spend by Product

    • Spend by AWS Account ID

    • Spend Mapping by Seller

    • Spend Details by Invoice

  • Bedrock 3P Foundational Model (FM) Spend

    • 3P FM Spend by Seller

    • Spend and Usage by FM Product

  • Granted and Entitled Licenses

    • Upcoming Contract Expirations

    • Org View of Licenses

    • License Summary by Product

    • License Grant and Sharing Details

    • Product mapping to License Grants

  • Marketplace Agreements

    • Active Agreement Count by Deployment Status

    • Active Agreement Value by Deployment Status

    • Agreement Information

    • Active Agreement Acceptances

    • Agreement Charges by Month

    • Agreement Charge Details

    • Agreement Legal Terms

Demo Dashboard

Get more familiar with Dashboard using the live, interactive demo dashboard following this [Link] (https://cid.workshops.aws.dev/demo?dashboard=aws-marketplace)

Image of a AWS Marketplace SPG dashboard in QuickSight

Prerequisites

  1. Deploy one or more of the foundational dashboards: CUDOS, Cost Intelligence, or KPI Dashboard.

  2. (Optional, only for Licenses Page) Deploy the Data Collection, with module Include Marketplace Licensing Collection parameter.

  3. (Optional, only for Agreements Page) Deploy the Data Collection, with module Include Marketplace Data Collection Module parameter.

Deployment

CloudFormation
Note

Prerequisite: To install this dashboard using CloudFormation, you need to install Foundational Dashboards CFN with version v4.0.0 or above as described here

  1. Log in to to your Data Collection Account.

  2. Click the Launch Stack button below to open the pre-populated stack template in your CloudFormation.

    Launch Stack button

  3. You can change Stack name for your template if you wish.

  4. Leave Parameters values as it is.

  5. Review the configuration and click Create stack.

  6. You will see the stack will start in CREATE_IN_PROGRESS. Once complete, the stack will show CREATE_COMPLETE

  7. You can check the stack output for dashboard URLs.

    Note

    Troubleshooting: If you see error "No export named cid-CidExecArn found" during stack deployment, make sure you have completed prerequisite steps.

Command Line

Alternative method to install dashboards is the cid-cmd tool.

  1. Log in to to your Data Collection Account.

  2. Open up a command-line interface with permissions to run API requests in your AWS account. We recommend to use CloudShell.

  3. In your command-line interface run the following command to download and install the CID CLI tool:

    pip3 install --upgrade cid-cmd
  4. In your command-line interface run the following command to deploy the dashboard:

    cid-cmd deploy --dashboard-id aws-marketplace

    Please follow the instructions from the deployment wizard. More info about command line options are in the Readme or cid-cmd --help.

Update

Please note that dashboards are not updated with update of CloudFormation Stack. When new version of the dashboard template is released, you can update your dashboard by running the following command in your command-line interface:

cid-cmd update --dashboard-id aws-marketplace

Visualizing Third-Party Software License Procurement

In the SPG Dashboard, to view the AWS Marketplace licenses and grants in the Granted and Entitled Licenses tab, follow these steps:

  • Deploy the Data Collection, make sure to select yes for the Include Marketplace Licensing Collection parameter.

  • Go to the Amazon Athena Query Editor.

  • Select the database that has the views for CID. By default it can be cid_cur database.

  • Run the following query to update marketplace_licenses_grants_view view in Amazon Athena.

CREATE OR REPLACE VIEW "marketplace_licenses_grants_view" AS SELECT DISTINCT lt.payer_id management_account_id , SPLIT_PART(lt.beneficiary, ':', 5) "subscribed_account_id" , SPLIT_PART(gt.granteeprincipalarn, ':', 5) "grantee_account_id" , FROM_UNIXTIME(CAST(lt.createtime AS DOUBLE)) "license_create_time" , date_parse(substr(lt.validity.begin, 1, 10), '%Y-%m-%d') "license_start_date" , date_parse(substr(lt.validity."end", 1, 10), '%Y-%m-%d') "license_end_date" , SPLIT_PART(lt.licensearn, ':', 7) "license_id" , lt.productname , data.value "seller" , SPLIT_PART(agreement.value, ':', 7) "agreement_id" , lt.status "license_status" , lt.productsku , lt.issuer.NAME "license_issuer" , lt.homeregion , lt."version" "license_version" , gt.grantname "grant_name" , SPLIT_PART(gt.grantarn, ':', 7) "grant_id" , gt.grantstatus "grant_status" , gt.version "grant_version" , ARRAY_JOIN(gt.grantedoperations, ',') "granted_operations" , gt.options.activationoverridebehavior "activation_override_behavior" FROM optimization_data.license_manager_licenses lt , optimization_data.license_manager_grants gt , UNNEST(licensemetadata) t ("data") , UNNEST(licensemetadata) s (agreement) WHERE ((lt.licensearn = gt.licensearn) AND (t."data".NAME = 'sellerOfRecord'))

Visualizing AWS Marketplace Agreements

In the SPG Dashboard, to view the AWS Marketplace Agreements in the Marketplace Agreements tab, do the following:

  • Deploy the Data Collection, make sure to select yes for the Include Marketplace Data Collection Module parameter.

  • Go to the Amazon Athena Query Editor.

  • Select the database that has the views for CID. By default it can be cid_cur database.

  • Run the following queries to update terms and agreements views in Amazon Athena.

CREATE OR REPLACE VIEW "terms" AS SELECT * FROM optimization_data.terms
CREATE OR REPLACE VIEW "agreements" AS SELECT * FROM optimization_data.agreements
Note

The licenses and Agreements data in the dashboard refreshes once a day. If you would like to customize the schedule, please review Tailoring Data Collector schedules.

Learn more

Explore more on Buyer Workshop

Authors

  • Ramya Vijayaraghavan, Ex-Amazonian

  • Kaushik Raha, Prinipal Specialist, AWS Marketplace

  • Soumya Vanga, Solutions Architect, AWS Marketplace

Feedback & Support

Follow Feedback & Support guide

Have a success story to share with the Team, suggest an improvement or report an error?

Note

These dashboards and their content: (a) are for informational purposes only, (b) represent current AWS product offerings and practices, which are subject to change without notice, and (c) does not create any commitments or assurances from AWS and its affiliates, suppliers or licensors. AWS content, products or services are provided "as is" without warranties, representations, or conditions of any kind, whether express or implied. The responsibilities and liabilities of AWS to its customers are controlled by AWS agreements, and this document is not part of, nor does it modify, any agreement between AWS and its customers.