AWS Marketplace Single Pane of Glass (SPG) Dashboard

Introduction

The AWS Marketplace Single Pane of Glass (SPG) Dashboard is an interactive, customizable and accessible QuickSight dashboard to help AWS Marketplace buyers gain insights into their subscriptions of third-party software, data products, and services. It provides visualizations across all Marketplace offerings, whether subscribed through a self-service public offer or a private offer. The dashboard visualizations include summary views of spend and usage across all Payer IDs, and also provides deep-dive by individual Payer ID, by product, and by AWS Marketplace invoice.

The dashboard has four 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

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)

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.

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.

   

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

Note

The licenses 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, Marketplace Specialist PSA

• Kaushik Raha, MP Customer Advisor

• Soumya Vanga, Marketplace Specialist PSA

Feedback & Support

Follow Feedback & Support guide

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

• Please email: [e-mail]

Note

These dashboards and their content: (a) are for informational purposes only, (b) represents 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.