ShareASale Data Connector User Guide

ShareASale Data Connector User Guide

The following article is a guide to automating reports with your ShareASale connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your ShareASale reports. To begin creating reports with your ShareASale connector, you will need at least one ShareASale account as well as access to Google Data Studio or Google Sheets.


The Power My Analytics ShareASale demo report template in Looker Studio.

Available Data

  1. Key Performance Indicators - Transactions, net sales, clicks, commissions, and affiliates.
  2. Transactions - Break down transaction amounts, return days, commissions, and fees by date and time, transaction ID, commission type, comments, and transaction types.
  3. Banner Reporting Break down transaction amounts, return days, commissions, and fees by Banner name, banner type, banner number, and User ID.
  4. Affiliate Reporting - Bonuses, affiliates, active affiliates, account balance, and return days over time.  Transaction amounts, return days, commissions, and fees by affiliate ID.
  5. Complete List of Fields.

API Limitations

  1. 200 Report Request Limit - ShareASale will not allow requests after the 200 report per account limit has been reached.
    1. Power My Analytics generates approximately 90 reports per account month.
    2. Each backfill generates approximately 3 reports.
  2. Custom Fields  - Custom fields are not available.

Connection Requirements

For a successful connection, follow these steps:
  1. Go to Merchant API.



  2. Select Require IP address match only for version 1.1 and lower.



  3. Click Update Settings.
  4. Use your Token, API Secret, and Merchant ID to authenticate. Your merchant ID is in the upper left corner of your ShareASale account.



    Your Token and API Secret are located on the Merchant API page.



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, the numbers will be inflated and vice versa. Use caution when choosing the appropriate field for your chart.



Backfilling

Power My Analytics will automatically backfill 30 days of data when you first create a report. To get up to 18 months of data, run a manual backfill from your Hub .

Troubleshooting

Follow the instructions in our  Basic Troubleshooting  guide to get your reports working again.

    Still having issues?
    Send us a ticket and we will get back to you.
      • 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 ...
      • Taboola Data Connector User Guide

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

        The following is a guide to automating reports with your AdRoll connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your AdRoll reports. To begin creating reports with your ...
      • eBay Data Connector User Guide

        The following is a guide to automating reports with your eBay Seller connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your eBay Seller reports. To begin creating reports ...
      • Quickbooks Data Connector User Guide

        The following article is a guide for automating reports with your Quickbooks connector. It includes metrics available and things to know about the connector. To create a report, you will need access to at least one or more Quickbooks online accounts ...