# AWS Marketplace Single Pane of Glass (SPG) Dashboard 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 Quick Sight 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 Quick Sight\]](http://docs.aws.amazon.com/guidance/latest/cloud-intelligence-dashboards/images/aws-marketplace-spg-pie.png) ## Prerequisites 1. Deploy one or more of the foundational dashboards: [CUDOS, Cost Intelligence, or KPI Dashboard](cudos-cid-kpi.md). 1. (Optional, only for Licenses Page) Deploy the [Data Collection](data-collection-deployment.md), with module *Include Marketplace Licensing Collection* parameter. 1. (Optional, only for Agreements Page) Deploy the [Data Collection](data-collection-deployment.md), with module *Include Marketplace Data Collection Module* parameter. ## Deployment **Example** **Prerequisite**: To install this dashboard using CloudFormation, you need to install Foundational Dashboards CFN with version v4.0.0 or above as described [here](deployment-in-global-regions.md#deployment-in-global-region-deploy-dashboard) 1. Log in to to your **Data Collection** Account. 1. Click the Launch Stack button below to open the **pre-populated stack template** in your CloudFormation. [https://console.aws.amazon.com/cloudformation/home#/stacks/create/review?templateURL=https://aws-managed-cost-intelligence-dashboards.s3.amazonaws.com/cfn/cid-plugin.yml&stackName=AWS-Marketplace-SPG-Dashboard¶m_DashboardId=aws-marketplace¶m_RequiresDataCollection=yes](https://console.aws.amazon.com/cloudformation/home#/stacks/create/review?templateURL=https://aws-managed-cost-intelligence-dashboards.s3.amazonaws.com/cfn/cid-plugin.yml&stackName=AWS-Marketplace-SPG-Dashboard¶m_DashboardId=aws-marketplace¶m_RequiresDataCollection=yes) 1. You can change **Stack name** for your template if you wish. 1. Leave **Parameters** values as it is. 1. Review the configuration and click **Create stack**. 1. You will see the stack will start in **CREATE\$1IN\$1PROGRESS**. Once complete, the stack will show **CREATE\$1COMPLETE** 1. 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. Alternative method to install dashboards is the [cid-cmd](https://github.com/aws-solutions-library-samples/cloud-intelligence-dashboards-framework/blob/main/CID-CMD.md#command-line-tool-cid-cmd) tool. 1. Log in to to your **Data Collection** Account. 1. Open up a command-line interface with permissions to run API requests in your AWS account. We recommend to use [CloudShell](https://console.aws.amazon.com/cloudshell). 1. In your command-line interface run the following command to download and install the CID CLI tool: ``` pip3 install --upgrade cid-cmd ``` If using [CloudShell](https://console.aws.amazon.com/cloudshell), use the following instead: ``` sudo yum install python3.11-pip -y python3.11 -m pip install -U cid-cmd ``` 1. 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](https://github.com/aws-solutions-library-samples/cloud-intelligence-dashboards-framework/blob/main/CID-CMD.md#command-line-tool-cid-cmd) 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](data-collection-deployment.md), make sure to select **yes** for the *Include Marketplace Licensing Collection* parameter. + Go to the [Amazon Athena](https://console.aws.amazon.com/athena/) Query Editor. + Select the database that has the views for CID. By default it can be **cid\$1cur** database. + Run the following query to update **marketplace\$1licenses\$1grants\$1view** 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](data-collection-deployment.md), make sure to select **yes** for the *Include Marketplace Data Collection Module* parameter. + Go to the [Amazon Athena](https://console.aws.amazon.com/athena/) Query Editor. + Select the database that has the views for CID. By default it can be **cid\$1cur** 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](tailor-data-collector.md). ## Learn more Explore more on [Buyer Workshop](https://catalog.workshops.aws/aws-marketplace-buyer/en-US/costmanagement/analysis/quicksight) ## Authors + Ramya Vijayaraghavan, Ex-Amazonian + Kaushik Raha, Prinipal Specialist, AWS Marketplace + Soumya Vanga, Solutions Architect, AWS Marketplace ## Feedback & Support Follow [Feedback & Support](feedback-support.md) guide Have a success story to share with the Team, suggest an improvement or report an error? + Please email: [aws-marketplace-cid-spg-dashboard@amazon.com](mailto:aws-marketplace-cid-spg-dashboard@amazon.com) **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.