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

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

        The following article is a guide to automating reports with your Mailchimp connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Mailchimp reports. To begin creating ...

      • Stripe Data Connector User Guide

        The following article is a guide to automating reports with your Stripe connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Stripe reports. To begin 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 ...

      • BigCommerce Data Connector User Guide

        Are you looking to streamline your BigCommerce data analysis and reporting? Power My Analytics' BigCommerce connector automates the collection and integration of your e-commerce data, saving you time and providing deeper insights into your online ...

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