Bring data from Hotmart to your Lakehouse.
hotmart.com/club/{subdomain}
.Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
Sales History
id
: Unique identifier for the sale (transaction ID)product
: Product information
name
: Name of the productid
: Product identifierbuyer
: Buyer information
name
: Name of the buyerucode
: Unique code for the buyeremail
: Email of the buyerproducer
: Producer information
name
: Name of the producerucode
: Unique code for the producerpurchase
: Purchase details
transaction
: Transaction identifierorder_date
: Date of the orderapproved_date
: Date of approvalstatus
: Current status of the salerecurrency_number
: Recurrence number for subscriptionsis_subscription
: Whether this is a subscription purchasecommission_as
: Commission typeprice
:
value
: Price valuecurrency_code
: Currency codepayment
:
method
: Payment methodinstallments_number
: Number of installmentstype
: Payment typetracking
:
source_sck
: Source tracking codesource
: Traffic sourceexternal_code
: External tracking codewarranty_expire_date
: Warranty expiration dateoffer
:
payment_mode
: Payment modecode
: Offer codehotmart_fee
:
total
: Total feefixed
: Fixed fee amountcurrency_code
: Currency codebase
: Base fee amountpercentage
: Fee percentageSubscriptions
subscriber_code
: Code identifying the subscribersubscription_id
: Unique identifier for the subscriptionstatus
: Current status of the subscriptionaccession_date
: Date when the subscription startedend_accession_date
: Date when the subscription endedrequest_date
: Date when the subscription was requesteddate_next_charge
: Date of the next chargetrial
: Whether this is a trial subscriptiontransaction
: Transaction identifierplan
: Subscription plan details
name
: Name of the planid
: Plan identifierrecurrency_period
: Period between chargesmax_charge_cycles
: Maximum number of chargesproduct
: Product information
id
: Product identifiername
: Product nameucode
: Unique product codeprice
: Price information
value
: Price valuecurrency_code
: Currency codesubscriber
: Subscriber information
name
: Subscriber’s nameemail
: Subscriber’s emailucode
: Unique subscriber codeSubscription Transactions
id
: Unique identifier for the transactionlast_recurrency_start_date
: Start date of the last recurrencehas_unpaid_recurrency
: Whether there are unpaid recurrencesproduct
: Product information
name
: Product nameid
: Product identifiersubscriber
: Subscriber information
phone
: Phone numbername
: Subscriber’s nameid
: Subscriber identifierphone_ddd
: Phone area codeemail
: Subscriber’s emailrecurrency
: Recurrence information
number
: Recurrence numberscheduled_retry
: Scheduled retry timestampnumber_list
: List of recurrence numberstransaction_sequence
: Transaction sequence numberstart_datetime
: Start date and timepayment_delays_days
: Days of payment delaytransaction_type
: Type of transactionis_current_purchase
: Whether this is the current purchasehas_retry
: Whether retries are availablestatus
: Status of the recurrencelast_recurrency_number
: Last recurrence numbertrial_info
: Trial information
trial_end
: Trial end datetrial_period
: Trial period durationtrial
: Whether this is a trialpurchase
: Purchase information
order_date
: Order dateprice
:
total_value
: Total price valuecurrency
: Currency codevalue
: Base price valueinstallment
:
installment_number
: Number of installmentsinstallment_type
: Type of installmentpayment
:
refusal_message
: Payment refusal messagerefund_chargeback_date
: Refund or chargeback datepayment_type
: Type of paymentbillet_expiration_date
: Expiration date for bank slipbillet_recovery_type
: Recovery type for bank slippix_expiration_date
: PIX expiration datebillet_reprint_code
: Bank slip reprint codecredit_card_flag
: Credit card flagcommission
:
original_value
: Original commission valueproducer_paid_value
: Amount paid to producercurrency
: Currency codeoriginal_paid_value
: Original paid valueconversion_rate
: Conversion rateproducer_value
: Producer’s commission valueapproved_date
: Approval datetransaction
: Transaction identifierstatus
: Transaction statuscancellation_date
: Cancellation dateis_paid_anticipation
: Whether payment was anticipatedmax_cycles
: Maximum number of cyclesadoption_date
: Adoption datesubscriber_code
: Subscriber’s codedate_next_charge
: Next charge dateis_paid_negotiation
: Whether payment was negotiatedlast_update
: Last update timestampbilling_type
: Type of billingproducer
: Producer information
name
: Producer’s namesubscription_id
: Subscription identifierhas_credit_card_change
: Whether credit card was changedplan
: Plan information
offer
:
code
: Offer codedescription
: Offer descriptionkey
: Offer keyrecurrency_period
: Period between recurrencescoupon_code
: Applied coupon coderecurrency_type
: Type of recurrencename
: Plan namestatus
: Overall statusSales Commission
transaction
: Unique identifier for the transactionproduct
: Product information
name
: Name of the productid
: Product identifierexchange_rate_currency_payout
: Exchange rate for currency payoutcommissions
: Array of commission information
commission
: Commission details
currency_value
: Currency of the commissionvalue
: Commission amountuser
: User information
ucode
: Unique user codename
: User namesource
: Source of the commissionSales Participants
transaction
: Unique identifier for the transactionproduct
: Product information
name
: Name of the productid
: Product identifierusers
: Array of user information
role
: Role of the user in the transactionuser
: User details
ucode
: Unique user codelocale
: User’s localename
: User’s nametrade_name
: User’s trade namecellphone
: Cellphone numberphone
: Phone numberemail
: Email addressdocuments
: Array of document information
value
: Document valuetype
: Document typeaddress
: Address information
city
: Citystate
: Statecountry
: Countryzip_code
: ZIP codeaddress
: Street addresscomplement
: Address complementneighborhood
: Neighborhoodnumber
: Street numberPrice Details
transaction
: Unique identifier for the transactionproduct
: Product information
id
: Product identifiername
: Product namebase
: Base price information
value
: Base price valuecurrency_code
: Currency codetotal
: Total price information
value
: Total price valuecurrency_code
: Currency codevat
: VAT information
value
: VAT amountcurrency_code
: Currency codefee
: Fee information
value
: Fee amountcurrency_code
: Currency codecoupon
: Coupon information
code
: Coupon codevalue
: Coupon valuereal_conversion_rate
: Real currency conversion rateProducts
id
: Unique identifier for the productname
: Name of the productucode
: Unique product codestatus
: Current status of the productcreated_at
: Creation date timestampformat
: Product formatis_subscription
: Whether the product is a subscriptionwarranty_period
: Warranty period in daysStudents
user_id
: Unique identifier for the studentengagement
: Student’s engagement levelname
: Student’s nameemail
: Student’s emaillast_access_date
: Last access timestamprole
: Student’s rolefirst_access_date
: First access timestamplocale
: Student’s localeplus_access
: Plus access statusprogress
: Progress information
completed_percentage
: Percentage of completiontotal
: Total number of itemscompleted
: Number of completed itemsstatus
: Current statusaccess_count
: Number of accessesis_deletable
: Whether the student can be deletedclass_id
: Class identifiertype
: Student type