ShareASale Data Connector User Guide

ShareASale Data Connector User Guide

This guide will walk you through the process of integrating ShareASale with Power My Analytics, enabling you to automate your data collection and create powerful reports. By following these steps, you'll be able to effortlessly track key metrics, analyze your affiliate program's success, and make data-driven decisions to optimize your marketing efforts.

Prerequisites

Before you begin, ensure you have the following:
  1. An active ShareASale merchant account
  2. Your ShareASale Token, API Secret (on the Merchant API page), and Merchant ID (in the upper left corner of your ShareASale account)





  3. ShareASale Merchant API settings set to "Require IP address match only for version 1.1 and lower"

Adding ShareASale as a Data Source

  1. Go to your PMA hub and navigate to Sources from the menu.
  2. Click + New Data Source.
  3. Choose ShareASale from the gallery.
  4. Enter your Token, API Secret, and Merchant ID for your ShareASale account.
  5. Provide a name for your ShareASale account.
  6. Click Connect.

Creating a Looker Studio Report

Follow these steps to create a Looker Studio report using your ShareASale data:
  1. After adding ShareASale as a data source, go to Reports > Looker Studio
  2. Select ShareASale 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., "ShareASale - Your Organization Name")
      2. Choose your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked for the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select your ShareASale account (for real data) or "Sample Account" (for sample data)
      2. Click Next
    3. Step 3:
      1. 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 ShareASale demo template.

Key Reports and Fields

ShareASale offers a wide range of metrics and dimensions for comprehensive reporting. Some popular metrics include:
  • Key Performance Metrics: Transactions, Net Sales, Clicks, Commissions, Active Affiliates
  • Transaction Metrics: Transaction Amount, Return Days, Commission, ShareASale Fees; by Date And Time, Transaction ID, Commission Type, Comment, Transaction Type
  • Banner Reporting Metrics: Transaction Amount, Return Days, Commission, ShareASale Fees; by Banner Name, Banner Type, Banner Number, User ID
  • Affiliate Reporting Metrics: Affiliates, Active Affiliates, Avg Return Days, Account Balance, Number of Bonuses, Transaction Amount, Return Days, Commission, ShareASale Fees
  • Affiliate Sales Metrics: Affiliates, Active Affiliates, Gross Sales, Commissions, Clicks, Net Sales, Sales Commissions
For a complete list of available fields, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Backfilling: Up to 18 months of historical data can be retrieved. Initial backfill is 30 days when first connecting your account.
  2. Request limit: ShareASale's API allows 200 reports per account per month. Power My Analytics generates around 90 reports per month, with backfills generating about 3 reports.
  3. Affiliate Reporting: Be cautious when using Affiliates and Active Affiliates fields, as they have different versions for daily charts and scorecards. Using the wrong type in a report can lead to inflated values.

Unavailable Data

  1. Custom fields

Understanding Affiliate Reporting

There are two types of fields for Affiliates and Active Affiliates. They are labeled (use in a daily chart) and (use in a scorecard). If a field that is labeled (use in a scorecard) is used in a daily chart, or vice versa, the numbers will be inflated. Use caution when choosing the appropriate field for your chart.

Troubleshooting

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

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

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

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