Tables/APIs

The following is the list of tables or APIs associated with the GoAffpro connector:

• Affiliates
• Orders
• Traffic
• Multilevel
• Coupons
  
  Affiliates:
  This table contains information related to affiliates in the GoAffPro affiliate management platform. Each record corresponds to a unique affiliate and includes various attributes such as affiliate identification details, personal and contact information, referral codes and tracking data, commission and payout statistics, account status, group or hierarchy assignments, and additional metadata. It also captures affiliate performance metrics, such as total referred sales, number of orders generated, earned commissions, payout history, and other operational details that support tracking, managing, and evaluating affiliate activities within the program.
  
  Source API: Swagger UI
  Schema: GoAffpro_Scehma
  
   Orders:
  This table contains comprehensive information related to orders tracked through the GoAffPro affiliate management platform. Each record corresponds to a unique order and includes attributes such as order identification details, customer information, associated affiliate or referral data, and commission-related metadata. It captures key order-specific details including order value, currency, applied discounts, purchased products, and timestamps for order creation and updates. In addition, the table stores referral attribution details such as the referring affiliate, referral codes or tracking links used, and the commission earned from each order. It also includes order lifecycle and operational data, covering payment and fulfillment status, commission approval stages, payout-related information, and other metadata that support tracking, validating, and managing order-level activity within the affiliate program.
  
  Source API: Swagger UI
  Schema: GoAffpro_Scehma
  
  Traffic:
  This table contains information related to visitor activity and click-level tracking within the GoAffPro affiliate management platform. Each record represents a unique click or traffic event and includes attributes such as visitor identifiers, referral source details, associated affiliate information, landing page URLs, device and browser data, IP address, and timestamps.
  It also captures attribution-related metadata, including the referral link or coupon used, first-touch and last-touch tracking, and whether the click led to a successful conversion. This table supports analyzing affiliate-driven traffic patterns, measuring engagement, identifying top-performing affiliates, and validating referral activity for accurate commission assignment.
  
  Source API: Swagger UI
  Schema: GoAffpro_Scehma
  
  Multilevel:
  This table contains information related to the multilevel (MLM/Upline-Downline) structure configured within the GoAffPro affiliate management platform. Each record represents a hierarchical relationship between affiliates, capturing attributes such as parent (upline) and child (downline) affiliate IDs, their respective levels, and associated commission configurations.
  The table also includes metadata related to multilevel earnings, such as commission percentages, payout eligibility, performance tiers, and relationship creation or update timestamps. It enables tracking, managing, and evaluating multilevel referral networks, ensuring accurate propagation of commissions and maintaining structured affiliate hierarchies within the program.
  
  Source API: Swagger UI
  Schema: GoAffpro_Scehma
  
  Coupons:
  This table contains information related to discount or referral coupons assigned and tracked through the GoAffPro affiliate management platform. Each record represents a unique coupon and includes attributes such as coupon codes, associated affiliate details, discount type and value, usage limits, validity dates, and status.
  Additionally, the table stores metadata on coupon performance, including number of uses, total sales generated through the coupon, commissions earned, and related order details. It facilitates accurate tracking of coupon-driven conversions, managing incentive campaigns, and analyzing the effectiveness of affiliate-specific or global promotional codes.
  
  Source API: Swagger UI
  Schema: GoAffpro_Scehma