Stripe Data Connector User Guide

Stripe Data Connector User Guide

Info
Stripe is a powerful payment processing platform that enables businesses to accept online payments, manage subscriptions, and handle invoicing. This guide will walk you through the process of connecting Stripe to Power My Analytics, creating reports, and understanding key metrics and considerations. By integrating Stripe with Power My Analytics, you'll be able to automate your payment data collection and gain valuable insights into your business's financial performance.

Prerequisites

Before connecting Stripe to Power My Analytics, ensure that:
  1. Your Stripe account has the Administrator role

Grant Access to a User in Stripe

To grant Administrator access to a user on your Stripe account:
  1. Open your Stripe settings and go to Invite team members.
  2. Under Admin Roles, check Administrator.



  3. Click Send invites. The user will be granted the Administrator role.

Adding Stripe as a Data Source

  1. Log in to your Power My Analytics hub.
  2. Navigate to Sources from the main menu.
  3. Click on + Add New Source.
  4. Select Stripe from the gallery of available sources.
  5. You will be prompted to sign in to your Stripe account to authenticate.

Creating a Data Studio Report

Follow these steps to create a Data Studio report using your Stripe data:
  1. After adding Stripe as a data source, go to Reports > Data Studio in the PMA hub
  2. Select Stripe under Create Data Studio Report (this will open the official Data Studio application in a new window)
  3. Google Data Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g., "Stripe - Your Organization Name")
      2. Choose your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select your Stripe account (for real data) or "Sample Account" (for sample data)
      2. Click Next
    3. Step 3:
      1. Click Connect in the top right to complete the data source configuration
    4. Step 4:
      1. Click Create Report in the top right
For a quick start, use our pre-built Stripe demo template.

Key Reports and Fields

Stripe data in Power My Analytics offers a wide range of metrics and dimensions for your reports. Some popular metrics include:
  • Key Performance Metrics: Gross volume, Net volume from sales, New customers, Successful payments, Spend per customer, Dispute activity percentage, Dispute count, High risk payments
  • Balance Metrics: Total balance, Amount available, Amount in transit to bank
  • Transaction Metrics: Gross revenue, Fees, Net revenue
  • Payment Metrics: Date, Currency, Status, Description, Amount
  • Subscription Metrics: Subscription created, Subscription start date, Subscription ID, Subscription amount, Subscription interval, Subscription plan, Subscription product ID, Subscription quantity, Subscription status
For a complete list of available Stripe fields in Power My Analytics, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Cached Data Requests with Unique Metrics and Date Dimension: When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For more information, please see Understanding Cached and Live Data Requests.
  2. Backfilling: When you first connect your Stripe account as a data source, an initial backfill of 24 months of data will be performed.

Unavailable Data

  1. Realtime data
  2. Custom fields

Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the Stripe connector.