素早く結果が得られます
様々な分野の事業で使えるレポート用クエリを用意してあります。顧客単価の算出から顧客の支払い方法分析など、カスタマイズ可能な作成済みテンプレートが手に入ります。もちろん一から作ることもできます。シンタックスハイライト、エラー表示、自動補完もサポートしていますので、クエリを簡単に作成できるようになります。
- 未払いの請求書を送ってもらえますか?
- Sigma レポートをどうぞ! https://dashboard.stripe.com/query/p893j4rv1x
SQL で Stripe データを検索
SQL で即時に解決。
企業が自社の Stripe のデータをすばやく分析し、チームがいち早くインサイトを得られるよう Stripe Sigma が開発されました。
今すぐ始めましょう
無料トライアルを有効にするか、以下で詳細を確認してください。
selectid,amount,currency,source_idfrombalance_transactions
idPrimary keyUnique ID.
amountBigintThe amount (in the smallest currency unit; e.g. cents in USD and yen in JPY).
amount_dueBigintamount_offBigintamount_refundedBigintamount_reversedBigint
customersTablecustomers.account_balanceBigintcustomers.business_vat_idVarcharcustomers.createdTimestampcustomers.currencyVarcharcustomers.default_source_idVarcharcustomers.delinquentBooleancustomers.descriptionVarcharcustomers.discount_coupon_idForeign key
currencyVarcharThree-letter ISO currency code, in lowercase. Must be a supported currency.
current_period_endTimestampcurrent_period_startTimestamp
currencyVarcharThree-letter ISO currency code, in lowercase. Must be a supported currency.
source_idForeign keyID of the related payment source.
source_transaction_idVarcharsource_transfer_idVarcharsource_typeVarcharsourcesTablesources_metadataTablesources_metadata.keyVarchar
source_idForeign keyID of the related payment source.
source_transaction_idVarcharsource_transfer_idVarcharsource_typeVarchar
source_idForeign keyID of the related payment source.
balance_transactionsTablebalance_transactions.amountBigintbalance_transactions.automatic_transfer_idForeign keybalance_transactions.available_onTimestampbalance_transactions.createdTimestampbalance_transactions.currencyVarchar
Stripe データをすぐに活用
Stripe に保管された構造化データ（追加メタデータを含む）へ素早くサイドバーからアクセスできます。これにより Stripe の支払い、顧客、サブスクリプション、返金などのデータと簡単に連携させられます。
利用可能なスキーマが Stripe Sigma 上で閲覧できます。
Payment tables
balance_transaction_fee_details
balance_transaction_idvarchar
amountbigint
applicationvarchar
currencyvarchar
descriptionvarchar
typevarchar
balance_transactions
idvarchar
amountbigint
available_ontimestamp
createdtimestamp
currencyvarchar
descriptionvarchar
feebigint
netbigint
statusvarchar
typevarchar
source_idvarchar
automatic_transfer_idvarchar
charges
idvarchar
amountbigint
amount_refundedbigint
application_fee_idvarchar
balance_transaction_idvarchar
capturedboolean
createdtimestamp
currencyvarchar
customer_idvarchar
descriptionvarchar
destination_idvarchar
dispute_idvarchar
failure_codevarchar
failure_messagevarchar
invoice_idvarchar
order_idvarchar
paidboolean
receipt_emailvarchar
receipt_numbervarchar
refundedboolean
statement_descriptorvarchar
statusvarchar
source_transfer_idvarchar
transfer_idvarchar
transfer_groupvarchar
application_idvarchar
source_idvarchar
card_idvarchar
card_address_cityvarchar
card_address_countryvarchar
card_address_line1varchar
card_address_line1_checkvarchar
card_address_line2varchar
card_address_statevarchar
card_address_zipvarchar
card_address_zip_checkvarchar
card_brandvarchar
card_countryvarchar
card_customer_idvarchar
card_cvc_checkvarchar
card_dynamic_last4varchar
card_exp_monthinteger
card_exp_yearinteger
card_fingerprintvarchar
card_fundingvarchar
card_last4varchar
card_namevarchar
card_tokenization_methodvarchar
charges_metadata
charge_idvarchar
keyvarchar
valuevarchar
disputes
idvarchar
amountbigint
charge_idvarchar
createdtimestamp
currencyvarchar
is_charge_refundableboolean
reasonvarchar
statusvarchar
evidence_access_activity_logvarchar
evidence_billing_addressvarchar
evidence_cancellation_policy_idvarchar
evidence_cancellation_policy_disclosurevarchar
evidence_cancellation_rebuttalvarchar
evidence_customer_communication_idvarchar
evidence_customer_email_addressvarchar
evidence_customer_namevarchar
evidence_customer_purchase_ipvarchar
evidence_customer_signature_idvarchar
evidence_duplicate_charge_documentation_idvarchar
evidence_duplicate_charge_idvarchar
evidence_product_descriptionvarchar
evidence_receipt_idvarchar
evidence_refund_policy_idvarchar
evidence_refund_policy_disclosurevarchar
evidence_refund_refusal_explanationvarchar
evidence_service_datevarchar
evidence_service_documentation_idvarchar
evidence_shipping_addressvarchar
evidence_shipping_carriervarchar
evidence_shipping_datevarchar
evidence_shipping_documentation_idvarchar
evidence_shipping_tracking_numbervarchar
evidence_uncategorized_file_idvarchar
evidence_uncategorized_textvarchar
evidence_details_due_bytimestamp
evidence_details_has_evidenceboolean
evidence_details_past_dueboolean
evidence_details_submission_countinteger
disputes_metadata
dispute_idvarchar
keyvarchar
valuevarchar
refunds
idvarchar
amountbigint
balance_transaction_idvarchar
charge_idvarchar
createdtimestamp
currencyvarchar
reasonvarchar
receipt_numbervarchar
statusvarchar
refunds_metadata
refund_idvarchar
keyvarchar
valuevarchar
Transfer tables
transfer_reversals
idvarchar
amountbigint
balance_transaction_idvarchar
createdtimestamp
currencyvarchar
transfer_idvarchar
transfers
idvarchar
amountbigint
amount_reversedbigint
application_fee_idvarchar
balance_transaction_idvarchar
createdtimestamp
currencyvarchar
datetimestamp
descriptionvarchar
destination_idvarchar
destination_payment_idvarchar
failure_codevarchar
failure_messagevarchar
reversedboolean
source_transaction_idvarchar
source_typevarchar
statement_descriptorvarchar
statusvarchar
transfer_groupvarchar
typevarchar
transfers_metadata
transfer_idvarchar
keyvarchar
valuevarchar
Customer tables
customers
idvarchar
account_balancebigint
business_vat_idvarchar
createdtimestamp
currencyvarchar
delinquentboolean
descriptionvarchar
emailvarchar
default_source_idvarchar
shipping_namevarchar
shipping_phonevarchar
shipping_address_cityvarchar
shipping_address_countryvarchar
shipping_address_line1varchar
shipping_address_line2varchar
shipping_address_postal_codevarchar
shipping_address_statevarchar
discount_coupon_idvarchar
discount_customer_idvarchar
discount_endtimestamp
discount_starttimestamp
discount_subscriptionvarchar
customers_metadata
customer_idvarchar
keyvarchar
valuevarchar
Billing tables
coupons
idvarchar
amount_offbigint
createdtimestamp
currencyvarchar
durationvarchar
duration_in_monthsinteger
max_redemptionsinteger
percent_offinteger
redeem_bytimestamp
times_redeemedinteger
validboolean
coupons_metadata
coupon_idvarchar
keyvarchar
valuevarchar
invoice_items
idvarchar
amountbigint
currencyvarchar
customer_idvarchar
datetimestamp
descriptionvarchar
discountableboolean
invoice_idvarchar
period_endtimestamp
period_starttimestamp
plan_idvarchar
prorationboolean
quantityinteger
subscription_idvarchar
invoice_items_metadata
invoice_item_idvarchar
keyvarchar
valuevarchar
invoice_line_items
invoice_idvarchar
source_idvarchar
amountbigint
currencyvarchar
descriptionvarchar
discountableboolean
period_endtimestamp
period_starttimestamp
plan_idvarchar
prorationboolean
quantityinteger
subscriptionvarchar
source_typevarchar
invoices
idvarchar
amount_duebigint
application_feebigint
attempt_countinteger
attemptedboolean
charge_idvarchar
closedboolean
currencyvarchar
customer_idvarchar
datetimestamp
descriptionvarchar
ending_balancebigint
forgivenboolean
next_payment_attempttimestamp
paidboolean
period_endtimestamp
period_starttimestamp
receipt_numbervarchar
starting_balancebigint
statement_descriptorvarchar
subscription_idvarchar
subscription_proration_datetimestamp
subtotalbigint
taxbigint
tax_percentdouble
totalbigint
webhooks_delivered_attimestamp
discount_coupon_idvarchar
discount_customer_idvarchar
discount_endtimestamp
discount_starttimestamp
discount_subscriptionvarchar
invoices_metadata
invoice_idvarchar
keyvarchar
valuevarchar
plans
idvarchar
amountbigint
createdtimestamp
currencyvarchar
intervalvarchar
interval_countinteger
namevarchar
statement_descriptorvarchar
trial_period_daysinteger
plans_metadata
plan_idvarchar
keyvarchar
valuevarchar
subscriptions
idvarchar
application_fee_percentdouble
cancel_at_period_endboolean
canceled_attimestamp
createdtimestamp
current_period_endtimestamp
current_period_starttimestamp
customer_idvarchar
ended_attimestamp
plan_idvarchar
quantityinteger
starttimestamp
statusvarchar
tax_percentdouble
trial_endtimestamp
trial_starttimestamp
discount_coupon_idvarchar
discount_customer_idvarchar
discount_endtimestamp
discount_starttimestamp
discount_subscriptionvarchar
subscriptions_metadata
subscription_idvarchar
keyvarchar
valuevarchar
Other tables
application_fees
idvarchar
account_idvarchar
amountbigint
amount_refundedbigint
application_idvarchar
balance_transaction_idvarchar
charge_idvarchar
createdtimestamp
currencyvarchar
originating_transaction_idvarchar
refundedboolean
sources
idvarchar
amountbigint
client_secretvarchar
createdtimestamp
currencyvarchar
flowvarchar
statusvarchar
typevarchar
usagevarchar
code_verification_attempts_remaininginteger
code_verification_statusvarchar
owner_emailvarchar
owner_namevarchar
owner_phonevarchar
owner_verified_emailvarchar
owner_verified_namevarchar
owner_verified_phonevarchar
owner_address_cityvarchar
owner_address_countryvarchar
owner_address_line1varchar
owner_address_line2varchar
owner_address_postal_codevarchar
owner_address_statevarchar
owner_verified_address_cityvarchar
owner_verified_address_countryvarchar
owner_verified_address_line1varchar
owner_verified_address_line2varchar
owner_verified_address_postal_codevarchar
owner_verified_address_statevarchar
receiver_addressvarchar
receiver_amount_chargedbigint
receiver_amount_receivedbigint
receiver_amount_returnedbigint
redirect_return_urlvarchar
redirect_statusvarchar
redirect_urlvarchar
sources_metadata
source_idvarchar
keyvarchar
valuevarchar
transfer_reversals_metadata
transfer_reversal_idvarchar
keyvarchar
valuevarchar
クエリを保存してチーム内で共有
よく使われるクエリを保存しておき、いつでも実行したりチームメンバーと共有したりできます。
料金体系
Stripe は蓄積されたビジネスデータを並行処理して瞬時に複雑なレポートを生成できます。 Stripe Sigma の料金は基本的に前月の決済回数、オーソリ数、プラットフォーム手数料の合計に基づいています。もっと知る
-
0
月の決済回数
-
お問い合わせ
0
推定月額コスト
0–500
€0.03/決済
501–1,000
€0.027/決済
1,001–5,000
€0.024/決済
5,001–50,000
€0.021/決済
50,001–∞
インフラ手数料