PayPal Data Connector User Guide

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 source in Power My Analytics, enabling you to automate your data collection and create insightful reports.

Prerequisites

Before you begin, ensure you have:
  1. A PayPal Business account
  2. API credentials (API username, API password, and Signature) for your PayPal account
Follow the instructions in How to Connect to PayPal to obtain your API credentials.

Adding PayPal as a Data Source

  1. Log in to your Power My Analytics hub.
  2. Navigate to Sources from the menu.
  3. Click + New Data Source.
  4. Select PayPal from the gallery.
  5. Enter your PayPal API username, API password, and Signature to authenticate.

Creating a Looker Studio Report

Follow these steps to create a Looker Studio report using your PayPal data:
  1. After adding PayPal as a data source, go to Reports > Looker Studio
  2. Select PayPal 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., "PayPal - 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 PayPal account (for real data) or "Sample Account" (for sample data)
      2. Click Next
    3. Step 3:
      1. Choose the currency symbol for your reports
      2. Click Connect (top right) to complete the data source configuration
    4. Step 4:
      1. Click Create Report (top right)
For a quick start, use our pre-built PayPal demo template.

Key Reports and Fields

PayPal data in Power My Analytics offers a wide range of metrics and dimensions. Here are some popular metrics you can use in your reports:
  • Performance Metrics: Transactions, Transaction Total, PayPal Fees, Order Quantity, Net After Fees, Transaction Quantity
  • Transaction Metrics: Amount, Item Amount, Sales Tax, Shipping, PayPal Fees, Net After Fees
For a complete list of available PayPal fields, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Backfilling: PayPal data can be backfilled for up to 2 years. When you first connect your PayPal account, 13 months of historical data will be imported.

Unavailable Data

  1. Realtime data
  2. Custom fields

Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the PayPal 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 ...

      • 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, ...

      • 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 ...

      • 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 ...

      • SharpSpring Data Connector User Guide

        SharpSpring is a powerful marketing automation and customer relationship management platform that helps businesses streamline their marketing efforts and manage leads effectively. This guide will walk you through the process of connecting SharpSpring ...