Stripe Data Connector User Guide

Stripe Data Connector User Guide

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 + New Data 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 Looker Studio Report

Follow these steps to create a Looker Studio report using your Stripe data:
  1. After adding Stripe as a data source, go to Reports > Looker Studio in the PMA hub
  2. Select Stripe under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
  3. Google Looker 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. Backfilling: Power My Analytics can backfill up to 2 years of historical data from Stripe. When you first connect your Stripe account, an initial backfill of 13 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.

    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • Mailchimp Data Connector User Guide

        Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...

      • Klaviyo Data Connector User Guide

        Are you looking to streamline your email and e-commerce marketing data analysis? This guide will walk you through setting up Klaviyo as a data source in Power My Analytics. By integrating Klaviyo with PMA, you'll be able to automate your data ...

      • Criteo Data Connector User Guide

        This guide will walk you through the process of connecting your Criteo account to Power My Analytics and creating reports using the data. Criteo is a powerful advertising platform specializing in retargeting, customer acquisition, and personalized ...

      • PayPal Data Connector User Guide

        PayPal is a widely used payment processing platform, and integrating its data into your analytics workflow can provide valuable insights into your business performance. This guide will walk you through the process of setting up PayPal as a data ...

      • CartStack Data Connector User Guide

        Are you looking to streamline your e-commerce analytics and improve your cart abandonment recovery efforts? This guide will walk you through setting up and using the CartStack data source in Power My Analytics. By integrating CartStack with our ...