1. Help Center
  2. SETUP
  3. Order Systems and Shopping Carts

How to Integrate PayPal with Wicked Reports

Everything to know about the PayPal to Wicked Reports integration.

Table of Contents

  1. Why people integrate PayPal & Wicked Reports

  2. Integration Requirements

  3. How to integrate PayPal with Wicked Reports

  4. What Happens After Integration

  5. Non-PayPal Orders

  6. Upsell Orders and Software

  7. Subscription Attribution and Reporting

  8. Product Attribution and Reporting

  9. Cohort Reporting

  10. Gross vs Net Revenue Reporting

  11. Testing & Troubleshooting

Why people integrate PayPal & Wicked Reports 

  • Looking to get ROI on Google & Facebook ad spend
  • Leads take time to buy from your CRM and want to connect customer lifetime value from PayPal revenue back to ad spend
  • High value subscription customers and you’d like the recurring purchase to track back to the top and middle of the funnel ad clicks
  • Ad Platform conversion tracking is taking credit for email abandoned cart campaigns that are actually converting the sales
  • Pixel conversion is inaccurate, missing subscription conversions, inaccurate ROI, or taking credit for other channel’s conversions.

    Integration Requirements

    The PayPal setup process is fast and simple with our PayPal Integration Wizard. 

    The shopping cart software has to properly pass product information into PayPal, or we won't be able to report on your products.
    • The shopping cart must include product details in the charges (orders).  
    • The order must reference the product or plan.

    How to integrate PayPal

      1. For live credentials, log in to your PayPal business account at www.paypal.com. For test credentials, log in to the PayPal Sandbox at www.sandbox.paypal.com using a Sandbox business test account.

      2. Click the profile icon (  ) on the top right side of the page. From the Business Profile menu, select Profile and Settings.

      3. From the left menu, click My Selling tools.


    4. In the Selling online section, click the Update link for the API access item.



    5. In the NVP/SOAP API integration (Classic) section, click "Manage API credentials"



    6. To generate the API signature, click Request API Credentials on the API Access page.



    Note: If you've already generated an API signature, a View API Signature link is displayed on the API Access page. If you need to generate a new API signature, you first need to delete the existing API signature. If the existing API signature is not being used by your live application, click the View API Signature link, and then click the Remove button to delete the existing signature.


     


    8. Select "Request API Signature" and click the "Agree and Submit" button


    9. The figure below shows this page with an example API signature credential.



    10. In "Date to Start Order Import From" on the Authorization page in Wicked Reports, select the earliest order date in your PayPal Account.  This will be the date we begin importing your orders from



    Note: If you've already generated an API signature, a View API Signature link is displayed on the API Access page. If you need to generate a new API signature, you first need to delete the existing API signature. If the existing API signature is not being used by your live application, click the View API Signature link, and then click the Remove button to delete the existing signature.

     

    What Happens After Integration

    • Historical Orders
      Wicked Reports will retrieve your entire PayPal order history for cohort and customer lifetime value reporting.
    • Order Tracking
      You will need to place our tracking code on your entire checkout process:
    • When will I see my data?
      Each morning, at about 12 pm UTC, Wicked Reports updates its database. This is when we retrieve the previous day's PayPal orders, attribute them back to clicks, leads, and ad spend, and update your reports.

    Orders Outside Your PayPal Account

    If you also have orders happening outside of the ones appearing in your PayPal account each day, you can authorize another order source from the Setup->Authorizations menu.

    Only authorize additional order sources that have unique orders not already found in your PayPal account.  

    Upsell Orders and Software

    If you have upsells that get processed with PayPal, we can pull those sales with this integration.  If you are using upsell software to acquire these upsells and the sales do not get processed by PayPal, we can integrate, please discuss with your Customer Success rep.  It is likely you will need to use our Order API to send us the Upsell orders.

    Subscription Attribution and Reporting

    If your subscriptions is managed inside of PayPal , Wicked Reports ill detect and chain the subscriptions together.  This allows for accurate, valuable customer lifetime value to be attributed to your marketing efforts.

    Product Attribution and Reporting

    Wicked Reports reports off the product names that are in your PayPal account.  You can validate this by going to the Wicked Report's product report.

    Note:  You need to create product IDs and names in PayPal and then have them attached to customers and invoices at the time of sale.  Without this, Wicked Reports marketing attribution will still work, but the product attribution and product reporting will not .

    The shopping cart software has to properly pass product information into PayPal, or we won't be able to report on your products.
    • The shopping cart must include product details in the charges (orders).  
    • The order must reference the product or plan.

    If you find your PayPal account is not meeting these 2 requirements, this is an issue with how your shopping cart integrates with PayPal.

    Without both requirements met, Wicked Reports won't be able to display product data on the customer LTV report, ROI attribution, or product reporting. 
     
    * If you are using PayPal as your payment processor and the shopping cart does not properly include product details in the charges (orders).  Even if you have products and/or created in PayPal, if the order does not reference the product or plan, we won't be able to report on the sales of the products.  This is an issue with how your shopping cart integrates with PayPal.

    Cohort Reporting

    Approximately 1 day after you have integrated PayPal and your CRM data (Klaviyo, ActiveCampaign, HubSpot, Drip, Infusionsoft, Ontraport, Mailchimp, OmniSend, etc) with Wicked Reports, you will have access to powerful cohort customer lifetime value reporting.  You can take advantage of these reports before a single click is tracked or attributed!

    Wicked connects the CRM lead information with the historical PayPal sales and revenue data so you can see time to 1st purchase, accumulated customer lifetime value by month, and time to break-even based on cost per lead and cost to acquire the customer.

    Click here for our Complete Guide to Cohort Reporting.

    Historical Tracking Data

    Some of our clients already have tracking (or, attribution) data stored in their CRM from past effort's to track and attribute customer lifetime value back to ad spend.  If you have this data, you can send it to Wicked Reports.  We will then attribute your custom tracking data to PayPal sales & revenue.

    Gross vs Net Revenue Reporting

    Wicked's Gross PayPal revenue = Gross order amount

    Wicked's Net PayPal Revenue  = Gross order amount - discounts - refunds

    Note:  Discounts will show up in the Customer LTV report as "partially refunded" status.

    Testing & Troubleshooting

    The PayPal Wicked Reports integration generally works without issue to bring in the sales from the previous day.  The risk areas are subscriptions and products - they are dependent on how you setup and use Stripe.  See those sections above.

    How to test the tracking of a PayPal order

    PayPal customers can use the Wicked Reports tracking validation tool. 

    1. Go to Setup-> Tracking Validation
    2. Click on "Manually Validate URL" and then select the Sales Tracking option. Paste in your URL and start test
    3. After making the test purchase and reaching the thank you page, come back to Wicked Reports and click End Test.

    How to Validate Wicked Report order and revenue data matches your store

    Wicked Reports order count and revenue amount will usually match your shopping cart order system numbers.

    If the numbers are off slightly, here are possible causes:

    • Time zone differences between your source system and Wicked Reports.
    • Confirm you are looking at gross or net revenue in both systems.
    • Orders that are entered with back-dates, edited days later, or deleted days later - Wicked misses those, we pull a day's orders one-time only.

    To validate and reconcile orders, we recommend starting with 1 day and using this process:  My revenue doesn't match what I'm seeing in my shopping cart
    It's the exact process our Customer Success team uses.