Docs

Taboola Data Export

What is Taboola?

Taboola help thousands of advertisers reach their audiences with compelling native ads. Consumers see your content and it proves to be effective across the buyer journey from increasing awareness to driving online purchases. Taboola campaign can be targeted based by location, time, browser type, connection type, audience segments, and more. Your content and ads get recommended on thousands of top websites and apps.

How to add a Taboola Source in Electrik.AI?

Follow these steps to connect your Taboola account to Electrik.AI

Step 1: Ensure you have following prerequisites to create a Taboola Connection in Electrik.AI

a. Taboola Account Client Id & Client Secret.

Step 2: Sign-in into your Electrik.AI account.

Step 3: Select IO in Electrik.AI dashboard.

Select IO in Electrik.AI dashboard

Step 4: Select the Connections Icon in the left most panel and click on “Add” button the top.

Select the Connections tab in the left most navigation bar & click on “Add” action button

Step 5: The Source default tab is selected just click on “Taboola” connection.

Conn-Step 5 The Source default tab is selected just click on “Taboola” connection ElectrikAI

Step 6: Enter Client Id and Client Secret of your Taboola account.

Conn Step 6 Enter Client Id and Client Secret of your Taboola account ElectrikAI

Step 7: Click on Choose Account and select your account from dropdown.

Conn Step 7 Click on Choose Account and select your account from dropdown ElectrikAI

Step 8: Click on Save button on the top. 

Conn Step 8 Click on Save button on the top ElectrikAI

Congratulations, you have now successfully created a Taboola Connection in Electrik.AI

Conn Congratulations, you have now successfully created a Taboola Connection in ElectrikAI

What are the supported Data Destinations?

Electrik.AI supports the following destination to export Taboola Data.

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI
EletrikAI

How to export Taboola Data?

Electrik.AI creates a data flow (or ETL process) that exports Taboola Performance reports of your choice to a target database or data warehouse. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from Taboola to Database

Step 1:  Ensure you have the following prerequisites.

  1. Access to Taboola.
  2. Taboola Account Client Id and Client Secret.
  3. Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)
  4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password.

Step 2: Sign-in into your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4: Click on Add button to create a Taboola Performance Data Extractor Flow.

Click on Add button to create a Flow

Step 5: Select Taboola Connection present in the list of available sources.

Flow Step 5 Select Taboola Connection present in the list of available sources ElectrikAI

Step 6: Select your existing Taboola connection in Electrik.AI.

Flow Step 6 Select your existing Taboola connection in ElectrikAI

To Configure a new connection, refer to this link.

Step 7: Click on a destination of your choice from list of available destinations.
In this example we are choosing BigQuery. 

Flow Step 7 Click on a destination of your choice from list of available destinations ElectrikAI

Step 8: Select your existing BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this link.

Flow Step 8 Select your existing BigQuery connection in ElectrikAI

Step 9:

a. Choose the desired report to get the appropriate data. In this example we are choosing all.

Flow Step 9a ElectrikAI

b. Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.
Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

Taboola Flow 9b ElectrikAI

Note: By Default, Electrik.AI chooses an existing Data Set to load your Taboola Report. You can create a new Dataset in your bucket by selecting the “Create Data Set” radio button.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

Flow - Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen ElectrikAI

You have now successfully setup Taboola to BigQuery Data Warehouse flow in Electrik.AI

Flow- You have now successfully setup Taboola to BigQuery Data Warehouse flow in ElectrikAI

Your Taboola data will start loading after 24 hours in your Data Set.

Your Taboola data will start loading after 24 hours in your Data Set ElectrikAI

Stripe Data Schema

Index Category Electrik.AI Column Name Description Sample Value
1 Metric amount Gross amount of the transaction. 9900
2 Dimension available_on The date the transaction’s net funds will become available in the Stripe balance. 12/1/2021
3 Dimension created Time at which the object was created. Measured in seconds since the Unix epoch. 11/29/2021
4 Dimension currency Three-letter ISO currency code, in lowercase. Must be a supported currency. usd
5 Dimension data contains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty. {id=txn_3JtbvqKFb2PyqLAG0A59Qldw, object=balance_transaction, amount=9900, available_on= 1638316800, created=1638208132, currency=usd, description=Invoice CE2B17E8-0009, exchange_rate=null, fee=317, fee_details=[{amount=317, application=null,
currency=usd, description=Stripe processing fees, type=stripe_fee}], net=9583, reporting_category=charge, source= ch_3JtbvqKFb2PyqLAG0Sk1TFao, status=pending, type=charge}
6 Dimension description An arbitrary string attached to the object. Often useful for displaying to users. invoice ce2b17e8-0009
7 Metric exchange_rate The exchange rate used, if applicable, for this transaction. Specifically, if money was converted from one currency to other. For example, suppose you charged a customer 10.00 EUR. Then the PaymentIntent’s amount would be 1000 and currency
would be eur. Suppose this was converted into 12.34 USD in your Stripe account. Then the BalanceTransaction’s amount would be 1234, currency would be usd, and exchange_rate would be 1.234.
null
8 Metric fee Fees paid for this transaction. 317
9 Dimension fee_details Detailed breakdown of fees paid for this transaction. [{“amount”:317,”application”:null, “currency”:”usd”,”description”:”Stripe processing fees”,”type”:”stripe_fee”}]
10 Metric fee_details_amount fee details amount 317
11 Dimension fee_details_application fee details application null
12 Dimension fee_details_currency fee details currency usd
13 Dimension fee_details_description fee details description stripe processing fees
14 Dimension fee_details_type fee details type stripe_fee
15 Dimension id Unique identifier for the object. txn_3jtbvqkfb2pyqlag0a59qldw
16 Metric net Net amount of the transaction 9583
17 Dimension object Stripe Object Type balance_transaction
18 Dimension reporting_category Learn more about how reporting categories can help you understand balance transactions from an accounting perspective. charge
19 Dimension source The Stripe object to which this transaction is related. ch_3jtbvqkfb2pyqlag0sk1tfao
20 Dimension status Either available or pending based on the transaction’s net funds available in the Stripe balance yet. pending
21 Dimension type Transaction type: adjustment, advance, advance_funding, anticipation_repayment, application_fee, application_fee_refund, charge, connect_collection_transfer, contribution, issuing_authorization_hold, issuing_authorization_release, issuing_dispute,
issuing_transaction, payment, payment_failure_refund, payment_refund, payout, payout_cancel, payout_failure, refund, refund_failure, reserve_transaction, reserved_funds, stripe_fee, stripe_fx_fee, tax_fee, topup, topup_reversal, transfer,
transfer_cancel, transfer_failure, or transfer_refund
charge
22 Electrik.AI sha_id Hashed Primary Key. 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
23 Electrik.AI etl_org Organization Id ORG000097
24 Electrik.AI etl_project Project Id PR000154
25 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
26 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
27 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
28 Electrik.AI etl_flow_nm EAI Flow Code FL001282
29 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Metric amount Amount intended to be collected by this payment. A positive integer representing how much to charge in the smallest currency unit. 9900
2 Metric amount_captured Amount in cents captured (can be less than the amount attribute on the charge if a partial capture was made). 9900
3 Metric amount_refunded Amount in cents refunded (can be less than the amount attribute on the charge if a partial refund was issued). 0
4 Dimension application ID of the Connect application that created the charge.
5 Metric application_fee The application fee (if any) for the charge.
6 Metric application_fee_amount The amount of the application fee (if any) requested for the charge.
7 Dimension balance_transaction ID of the balance transaction that describes the impact of this charge on your account balance (not including refunds or disputes). txn_3jtbvqkfb2pyqlag0a59qldw
8 Dimension billing_details Billing information associated with the payment method at the time of the transaction. {“address”:{“city”:”New Brighton”,”country”: “US”,”line1″:”2155 Old Hwy 8 NW”,”line2″:null,”postal_code”:”55112″,”state”: “MN”},”email”:”developer@roofle.com”,”name”:”Brad Greenwald”,”phone”:null}
9 Dimension billing_details_address Complete Address {“city”:”New Brighton”,”country”:”US”,”line1″: “2155 Old Hwy 8 NW”,”line2″:null,”postal_code”:”55112″,”state”:”MN”}
10 Dimension billing_details_ address_city City, district, suburb, town, or village. new brighton
11 Dimension billing_details_ address_country Two-letter country code us
12 Dimension billing_details_ address_line1 Address line 1 2155 old hwy 8 nw
13 Dimension billing_details_ address_line2 Address line 2
14 Dimension billing_details_ address_postal_code ZIP or postal code. 55112
15 Dimension billing_details_ address_state State, county, province, or region. mn
16 Dimension billing_details_email Email address. developer@roofle.com
17 Dimension billing_details_name Full name. brad greenwald
18 Dimension billing_details_phone Billing phone number (including extension).
19 Dimension calculated_statement_ descriptor The full statement descriptor that is passed to card networks, and that is displayed on your customers’ credit card and bank statements. Allows you to see what the statement descriptor looks like after the static and dynamic portions are combined. electrik.ai inc
20 Dimension captured If the charge was created without capturing, this Boolean represents whether it is still uncaptured or has since been captured. TRUE
21 Dimension created Time at which the object was created. Measured in seconds since the Unix epoch. 11/29/2021
22 Dimension currency Three-letter ISO currency code, in lowercase. Must be a supported currency. usd
23 Dimension customer ID of the customer this charge is for if one exists. cus_iis3948rdp6qqj
24 Dimension data contains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty. {id=ch_3JtbvqKFb2PyqLAG0Sk1TFao, object=charge, amount=9900, amount_captured=9900, amount_refunded=0, application=null, application_fee=null, application_fee_amount=null, balance_transaction=txn_3JtbvqKFb2PyqLAG0A59Qldw, billing_details={address={city=New
Brighton, country=US, line1=2155 Old Hwy 8 NW, line2=null, postal_code=55112, state=MN}, email=developer@roofle.com, name=Brad Greenwald, phone=null}, calculated_statement_descriptor=ELECTRIK.AI INC, captured=true, created=1638208132,
currency=usd, customer=cus_IiS3948rDP6qQJ, description=Invoice CE2B17E8-0009, destination=null, dispute=null, disputed=false, failure_code=null, failure_message=null, fraud_details={}, invoice=in_1Jtbv9KFb2PyqLAGKiVqAjvT, livemode=true,
metadata={}, on_behalf_of=null, order=null, outcome={network_status=approved_by_network, reason=null, risk_level=normal, seller_message=Payment complete., type=authorized}, paid=true, payment_intent=pi_3JtbvqKFb2PyqLAG0TiI7dVG, payment_method=pm_1JcbevKFb2PyqLAGsZjS0Y9p,
payment_method_details={card={brand=visa, checks={address_line1_check=pass, address_postal_code_check=pass, cvc_check=null}, country=US, exp_month=6, exp_year=2023, fingerprint=3EHTuLY2f0fy6Zke, funding=credit, installments=null, last4=0579,
network=visa, three_d_secure=null, wallet=null}, type=card}, receipt_email=developer@roofle.com, receipt_number=2947-9659, receipt_url=https://pay.stripe.com/receipts/ acct_1FEyUIKFb2PyqLAG/ch_3JtbvqKFb2PyqLAG0Sk1TFao/ rcpt_KgbA415KT0hCIzxUHa7j55xoZt9JQJx,
refunded=false, refunds={object=list, data=[], has_more=false, total_count=0, url=/v1/charges/ch_3JtbvqKFb2PyqLAG0Sk1TFao/ refunds}, review=null, shipping=null, source=null, source_transfer=null, statement_descriptor=null, statement_descriptor_suffix=null,
status=succeeded, transfer_data=null, transfer_group=null}
25 Dimension description An arbitrary string attached to the object. Often useful for displaying to users. invoice ce2b17e8-0009
26 Dimension destination ID of the bank account or card the payout was sent to.
27 Dimension dispute Whether the charge has been disputed.
28 Dimension disputed disputed status FALSE
29 Dimension failure_code Error code explaining reason for charge failure if available Data Migration Testing
30 Dimension failure_message Message to user further explaining reason for charge failure if available.
31 Dimension fraud_details Information on fraud assessments for the charge. {}
32 Dimension id Unique identifier for the object. ch_3jtbvqkfb2pyqlag0sk1tfao
33 Dimension invoice ID of the invoice this charge is for if one exists. in_1jtbv9kfb2pyqlagkivqajvt
34 Dimension livemode Has the value true if the object exists in live mode or the value false if the object exists in test mode. TRUE
35 Dimension metadata Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format. {}
36 Dimension object String representing the object’s type. Objects of the same type share the same value. charge
37 Dimension on_behalf_of The account (if any) the charge was made on behalf of without triggering an automatic transfer.
38 Dimension order ID of the order this charge is for if one exists. USD
39 Dimension outcome Details about whether the payment was accepted, and why. {“network_status”:”approved_by_network”, “reason”:null,”risk_level”:”normal”, “seller_message”:”Payment complete.”, “type”:”authorized”}
40 Dimension outcome_network_status Possible values are approved_by_network, declined_by_network, not_sent_to_network, and reversed_after_approval. The value reversed_after_approval indicates the payment was blocked by Stripe after bank authorization, and may temporarily appear
as “pending” on a cardholder’s statement.
approved_by_network
41 Dimension outcome_reason An enumerated value providing a more detailed explanation of the outcome’s type.
42 Dimension outcome_risk_level Stripe Radar’s evaluation of the riskiness of the payment. Possible values for evaluated payments are normal, elevated, highest. For non-card payments, and card-based payments predating the public assignment of risk levels, this field will
have the value not_assessed. In the event of an error in the evaluation, this field will have the value unknown. This field is only available with Radar.
normal
43 Dimension outcome_risk_score Stripe Radar’s evaluation of the riskiness of the payment. Possible values for evaluated payments are between 0 and 100. For non-card payments, card-based payments predating the public assignment of risk scores, or in the event of an error
during evaluation, this field will not be present. This field is only available with Radar for Fraud Teams.
44 Dimension outcome_seller_message A human-readable description of the outcome type and reason, designed for you (the recipient of the payment), not your customer. payment complete.
45 Dimension outcome_type Possible values are authorized, manual_review, issuer_declined, blocked, and invalid. authorized
46 Dimension paid true if the charge succeeded, or was successfully authorized for later capture. TRUE
47 Dimension payment_intent ID of the PaymentIntent associated with this charge, if one exists. pi_3jtbvqkfb2pyqlag0tii7dvg
48 Dimension payment_method ID of the payment method used in this charge. pm_1jcbevkfb2pyqlagszjs0y9p
49 Dimension payment_method_details Details about the payment method at the time of the transaction. {“card”:{“brand”:”visa”,”checks”:{“address_line1_check”: “pass”,”address_postal_code_check”: “pass”,”cvc_check”:null},”country”: “US”,”exp_month”:6,”exp_year”:2023, “fingerprint”:”3EHTuLY2f0fy6Zke”,”funding”: “credit”,”installments”:null,”last4″:”0579″,”network”:
“visa”,”three_d_secure”:null,”wallet”:null},”type”:”card”}
50 Dimension payment_method_ details_card If this is a card payment,the card details {“brand”:”visa”,”checks”:{“address_line1_check”:”pass”, “address_postal_code_check”: “pass”,”cvc_check”:null},”country”: “US”,”exp_month”:6,”exp_year”:2023, “fingerprint”:”3EHTuLY2f0fy6Zke”,”funding”: “credit”,”installments”:null,”last4″:”0579″,”network”:
“visa”,”three_d_secure”:null,”wallet”:null}
51 Dimension payment_method_ details_card_brand Card brand. Can be amex, diners, discover, jcb, mastercard, unionpay, visa, or unknown. visa
52 Dimension payment_method_ details_card_checks Check results by Card networks on Card address and CVC at time of payment. {“address_line1_check”:”pass”, “address_postal_code_check”: “pass”,”cvc_check”:null}
53 Dimension payment_method_ details_card_country Two-letter ISO code representing the country of the card. us
54 Dimension payment_method_ details_card_exp_month Two-digit number representing the card’s expiration month. 6
55 Dimension payment_method_ details_card_exp_year Four-digit number representing the card’s expiration year. 2023
56 Dimension payment_method_ details_card_fingerprint Uniquely identifies this particular card number. You can use this attribute to check whether two customers who’ve signed up with you are using the same card number, for example. For payment methods that tokenize card information (Apple Pay,
Google Pay), the tokenized number might be provided instead of the underlying card number.
3ehtuly2f0fy6zke
57 Dimension payment_method_ details_card_funding Card funding type. Can be credit, debit, prepaid, or unknown. credit
58 Dimension payment_method_ details_card_installments “Installment details for this payment (Mexico only). For more information, see the installments integration guide.”
59 Dimension payment_method_ details_card_last4 The last four digits of the card. 579
60 Dimension payment_method_ details_card_network Identifies which network this charge was processed on. Can be amex, cartes_bancaires, diners, discover, interac, jcb, mastercard, unionpay, visa, or unknown. visa
61 Dimension payment_method_details_ card_three_d_secure Populated if this transaction used 3D Secure authentication. 1/0/1900 0:00
62 Dimension payment_method_ details_card_wallet If this Card is part of a card wallet, this contains the details of the card wallet.
63 Dimension payment_method_ details_type he type of transaction-specific details of the payment method used in the payment, one of ach_credit_transfer, ach_debit, acss_debit, alipay, au_becs_debit, bancontact, card, card_present, eps, giropay, ideal, klarna, multibanco, p24, sepa_debit,
sofort, stripe_account, or wechat.
card
64 Dimension receipt_email This is the email address that the receipt for this charge was sent to. developer@roofle.com
65 Dimension receipt_number This is the transaction number that appears on email receipts sent for this charge. This attribute will be null until a receipt has been sent. 2947-9659
66 Dimension receipt_url This is the URL to view the receipt for this charge. The receipt is kept up-to-date to the latest state of the charge, including any refunds. If the charge is for an Invoice, the receipt will be stylized as an Invoice receipt. https://pay.stripe.com/receipts/ acct_1feyuikfb2pyqlag/ch_ 3jtbvqkfb2pyqlag0sk1tfao/ rcpt_kgba415kt0hcizxuha7j55xozt9jqjx
67 Dimension refunded Whether the charge has been fully refunded. If the charge is only partially refunded, this attribute will still be false. FALSE
68 Dimension refunds A list of refunds that have been applied to the charge. {“object”:”list”,”data”:[],”has_more”:false, “total_count”:0,”url”:”/v1/charges/ ch_3JtbvqKFb2PyqLAG0Sk1TFao/refunds”}
69 Dimension review ID of the review associated with this charge if one exists. Bing and Yahoo! search – Top
70 Dimension shipping Shipping information for the charge.
71 Dimension source
72 Dimension source_transfer The transfer ID which created this charge. Only present if the charge came from another Stripe account.
73 Dimension statement_descriptor complete description of a charge on your customers’ statements. PR000253
74 Dimension statement_descriptor_ suffix Provides information about the charge that customers see on their statements. Concatenated with the prefix (shortened descriptor)
75 Dimension status The status of the payment is either succeeded, pending, or failed. succeeded
76 Dimension transfer_data An optional dictionary including the account to automatically transfer to as part of a destination charge 6/24/2020 16:02
77 Dimension transfer_group A string that identifies this transaction as part of a group. FL001309
78 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
79 Electrik.AI etl_org Organization Id ORG000097
80 Electrik.AI etl_project Project Id PR000154
81 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
82 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
83 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
84 Electrik.AI etl_flow_nm EAI Flow Code FL001282
85 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Metric account_balance Current balance, if any, being stored on the customer. If negative, the customer has credit to apply to their next invoice. If positive, the customer has an amount owed that will be added to their next invoice. The balance does not refer to
any unpaid invoices; it solely takes into account amounts that have yet to be successfully applied to any invoice. This balance is only taken into account as invoices are finalized.
0
2 Dimension address The customer’s address.
3 Metric balance The customer’s balance. 0
4 Dimension billingid billing id 6189712531f7706105baf97c
5 Dimension created Time at which the object was created. Measured in seconds since the Unix epoch. 11/10/2021
6 Dimension currency Three-letter ISO currency code, in lowercase. Must be a supported currency.
7 Dimension data contains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty. {id=cus_KZWQVQGAKPavHY, object=customer, account_balance=0, address=null, balance=0, created=1636576011, currency=null, default_source=null, delinquent=false, description= Customer for Organization ‘FinLocker LLC’, discount=null, email=bryan.garcia@finlocker.com,
invoice_prefix=462A0B86, invoice_settings ={custom_fields=null, default_payment_method =pm_1JuNP7KFb2PyqLAGve2lNaan, footer=null}, livemode=true, metadata= {organizationId=6189712331f7706105baf97b, billingId=6189712531f7706105baf97c},
name=FinLocker LLC, next_invoice_sequence=1, phone=3146160874, preferred_locales=[], shipping={address={city=WATERLOO, country=US, line1=2929 ESTATE DR, line2=, postal_code=62298, state=IL}, name= Bryan Garcia, phone=3146160874}, sources=
{object=list, data=[], has_more=false, total_count=0, url=/v1/customers/cus_KZWQVQGAKPavHY/sources}, subscriptions={object=list, data=[], has_more=false, total_count=0, url=/v1/customers/cus_KZWQVQGAKPavHY/ subscriptions}, tax_exempt=none,
tax_ids= {object=list, data=[], has_more=false, total_count=0, url=/v1/customers/cus_KZWQVQGAKPavHY/tax_ids}, tax_info=null, tax_info_verification=null}
8 Dimension default_source ID of the default payment source for the customer.
9 Dimension delinquent “When the customer’s latest invoice is billed by charging automatically, delinquent is true if the invoice’s latest charge failed. When the customer’s latest invoice is billed by sending an invoice, delinquent is true if the invoice isn’t
paid by its due date. If an invoice is marked uncollectible by dunning, delinquent doesn’t get reset to false.”
FALSE
10 Dimension description An arbitrary string attached to the object. Often useful for displaying to users. customer for organization ‘finlocker llc’
11 Metric discount Describes the current discount active on the customer, if there is one.
12 Dimension email The customer’s email address. bryan.garcia@finlocker.com
13 Dimension id Unique identifier for the object. cus_kzwqvqgakpavhy
14 Dimension invoice_prefix The prefix for the customer used to generate unique invoice numbers. 462a0b86
15 Dimension invoice_settings The customer’s default invoice settings. {“custom_fields”:null, “default_payment_method”: “pm_1JuNP7KFb2PyqLAGve2lNaan”, “footer”:null}
16 Dimension invoice_settings_ custom_fields Default custom fields to be displayed on invoices for this customer.
17 Dimension invoice_settings_ default_payment_method ID of a payment method that’s attached to the customer, to be used as the customer’s default payment method for subscriptions and invoices. pm_1junp7kfb2pyqlagve2lnaan
18 Dimension invoice_settings_footer Default footer to be displayed on invoices for this customer.
19 Dimension livemode Has the value true if the object exists in live mode or the value false if the object exists in test mode. TRUE
20 Dimension name The customer’s full name or business name. finlocker llc
21 Dimension next_invoice_sequence The suffix of the customer’s next invoice number, e.g., 0001. 1
22 Dimension object String representing the object’s type. Objects of the same type share the same value. customer
23 Dimension organizationid organization id 6189712331f7706105baf97b
24 Dimension phone The customer’s phone number. 3146160874
25 Dimension preferred_locales preferred locales []
26 Dimension shipping Mailing and shipping address for the customer. Appears on invoices emailed to this customer. {“address”:{“city”:”WATERLOO”, “country”:”US”,”line1″:”2929 ESTATE DR”,”line2″: “”,”postal_code”: “62298”,”state”:”IL”},”name”: “Bryan Garcia”,”phone”:”3146160874″}
27 Dimension shipping_address Customer shipping address. {“city”:”WATERLOO”,”country”: “US”,”line1″:”2929 ESTATE DR”,”line2″: “”,”postal_code”:”62298″,”state”:”IL”}
28 Dimension shipping_name Customer name. bryan garcia
29 Dimension shipping_phone Customer phone (including extension). 3146160874
30 Dimension sources The customer’s payment sources, if any. {“object”:”list”,”data”:[],”has_more”:false,”total_count” :0,”url”:”/v1/customers/cus_KZWQVQGAKPavHY/ sources”}
31 Dimension subscriptions The customer’s current subscriptions, if any. {“object”:”list”,”data”:[],”has_more”:false,”total_count”:0,”url”: “/v1/customers/cus_KZWQVQGAKPavHY/ subscriptions”}
32 Dimension tax_exempt Describes the customer’s tax exemption status. One of none, exempt, or reverse. When set to reverse, invoice and receipt none
33 Dimension tax_ids The customer’s tax IDs. {“object”:”list”,”data”:[],”has_more”:false,”total_count” :0,”url”:”/v1/customers/cus_ KZWQVQGAKPavHY/tax_ids”}
34 Dimension tax_info Tax details about the customer.
35 Dimension tax_info_verification tax info verification
36 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
37 Electrik.AI etl_org Organization Id ORG000097
38 Electrik.AI etl_project Project Id PR000154
39 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
40 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
41 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
42 Electrik.AI etl_flow_nm EAI Flow Code FL001282
43 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Metric api_version The Stripe API version used to render data. 8/14/2019
2 Dimension created Time at which the object was created. Measured in seconds since the Unix epoch. 11/19/2021
3 Metric data contains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty. {“object”:{“id”:”in_1Jtbv9KFb2PyqLAGKiVqAjvT”, “object”:”invoice”,”account_country”:”US”, “account_name”:”Electrik.AI Inc”,”account_tax_ids”: null,”amount_due”:9900,”amount_paid”:0, “amount_remaining”:9900,”application_fee_amount”: null,”attempt_count”:3,”attempted”:true,”auto_advance”:
true,”automatic_tax”:{“enabled”:false,”status”:null}, “billing”:”charge_automatically”,”billing_reason”: “manual”,”charge”:”ch_3JtbvqKFb2PyqLAG0WIafDGl”, “collection_method”:”charge_automatically”, “created”:1636393575,”currency”:”usd”,”custom_fields”:null,
“customer”:”cus_IiS3948rDP6qQJ”,”customer_address” :{“city”:null,”country”:””,”line1″:””,”line2″:””, “postal_code”:null,”state”:””},”customer_email”: “developer@roofle.com”,”customer_name”: “Roofle Developer”,”customer_phone”:”6122558200″,
“customer_shipping”:{“address”:{“city”:”New Brighton”, “country”:”US”,”line1″:”2155 Old Hwy 8 NW”,”line2″:””, “postal_code”:”55112″,”state”:”MN”},”name”: “Roofle Developer”,”phone”:”6122558200″}, “customer_tax_exempt”:”none”,”customer_tax_ids”:[],
“default_payment_method”:null,”default_source”:null, “default_tax_rates”:[],”description”: “Billing Period: 10/01/2021 – 10/31/2021″,”discount”:null,”discounts”:[],”due_date”:1636998418,”ending_balance”:0, “footer”:null,”hosted_invoice_url”:
“https://invoice.stripe.com/i/acct_1FEyUIKFb2PyqLAG/live_ YWNjdF8xRkV5VUlLRmIyUHlxTEFHLF9LWWp ONXlRZXpZdUpNcHlJRWxYcTJTajVtNTI5QUp20100UWf6KDL4”, “invoice_pdf”:”https://pay.stripe.com/invoice/ acct_1FEyUIKFb2PyqLAG/live_YWNjdF8xRkV5VUlLRmIy
UHlxTEFHLF9LWWpONXlRZXpZdUpNcHlJRWxYc TJTajVtNTI5QUp20100UWf6KDL4/pdf”, “last_finalization_error”:null,”lines”: {“object”:”list”,”data”:[{“id”:”ii_1Jtbv9KFb2PyqLAG0BSPdBko”, “object”:”line_item”,”amount”:9900,”currency”: “usd”,”description”:”Google
Analytics to Google BigQuery (Service Account) – October 2021″,”discount_amounts”:[], “discountable”:true,”discounts”:[],”invoice_item”: “ii_1Jtbv9KFb2PyqLAG0BSPdBko”,”livemode” :true,”metadata”:{},”period”:{“end”:1636393575,”start”:1636393575},
“plan”:null,”price”:{“id”:”price_1Jtbv9KFb2PyqLAGzBmk97zO”, “object”:”price”,”active”:false,”billing_scheme”: “per_unit”,”created”:1636393575,”currency”: “usd”,”livemode”:true,”lookup_key”:null,”metadata”:{}, “nickname”:null,”product”:”prod_KYjNqBt76RJMXQ”,
“recurring”:null,”tax_behavior”:”unspecified”,”tiers_mode” :null,”transform_quantity”:null,”type”:”one_time”,”unit_amount”:9900 ,”unit_amount_decimal”:”9900″},”proration”:false,”quantity”: 1,”subscription”:null,”tax_amounts”:[],”tax_rates”:[],”type”:
“invoiceitem”,”unique_id”:”il_1Jtbv9KFb2PyqLAGGIqfoYpS”}], “has_more”:false,”total_count”:1,”url”:”/v1/invoices/ in_1Jtbv9KFb2PyqLAGKiVqAjvT/lines”},”livemode”: true,”metadata”:{},”next_payment_attempt”:1637754442, “number”:”CE2B17E8-0009″,”on_behalf_of”:null,”paid”:
false,”payment_intent”:”pi_3JtbvqKFb2PyqLAG0TiI7dVG”, “payment_settings”:{“payment_method_options”:null,”payment_method_types” :null},”period_end”:1636393575,”period_start”:1636393575, “post_payment_credit_notes_amount”:0, “pre_payment_credit_notes_amount”:0,”quote”:
null,”receipt_number”:null,”starting_balance”:0, “statement_descriptor”:null,”status”:”open”,”status_transitions”: {“finalized_at”:1636393617,”marked_uncollectible_at”: null,”paid_at”:null,”voided_at”:null},”subscription”:null, “subtotal”:9900,”tax”:null,”tax_percent”:null,”total”:9900,
“total_discount_amounts”:[],”total_tax_amounts”:[],”transfer_data”:null,”webhooks_delivered_at”: 1636393575},”previous_attributes”:{“next_payment_attempt”:1637300826}}
4 Dimension event_id Unique identifier for the object. evt_1jxpxikfb2pyqlagtfk9aqol
5 Dimension livemode Has the value true if the object exists in live mode or the value false if the object exists in test mode. TRUE
6 Dimension object String representing the object’s type. Objects of the same type share the same value. event
7 Dimension pending_webhooks Number of webhooks that have yet to be successfully delivered 0
8 Dimension request Information on the API request that instigated the event. {“id”:null,”idempotency_key”:null}
9 Dimension type Description of the event (e.g., invoice.created or charge.refunded). invoice.updated
10 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
11 Electrik.AI etl_org Organization Id ORG000097
12 Electrik.AI etl_project Project Id PR000154
13 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
14 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
15 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
16 Electrik.AI etl_flow_nm EAI Flow Code FL001282
17 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Metric amount Amount (in the currency specified) of the invoice item. This should always be equal to unit_amount * quantity. 19800
2 Dimension currency Three-letter ISO currency code, in lowercase. Must be a supported currency. usd
3 Metric customer The ID of the customer who will be billed when this invoice item is billed. cus_gigwzgjampvazx
4 Dimension data contains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty. {id=ii_1JzUlqKFb2PyqLAGkTzlLC18, object=invoiceitem, amount=19800, currency=usd, customer=cus_GIGWZGJAmPVaZX, date=1637796058, description=GAHIT2BQ, discountable=true, discounts=[], invoice=in_1JzUlQKFb2PyqLAG7qaLb4BH, livemode=true, metadata={},
period={end=1637796058, start=1637796058}, plan=null, price={id=price_1JzUl0KFb2PyqLAGxixSnbP2, object=price, active=true, billing_scheme=per_unit, created=1637796006, currency=usd, livemode=true, lookup_key=null, metadata={}, nickname=null,
product=prod_KeoNlm0Djwpvn1, recurring=null, tax_behavior=unspecified, tiers_mode=null, transform_quantity=null, type=one_time, unit_amount=9900, unit_amount_decimal=9900}, proration=false, quantity=2, subscription=null, tax_rates=[],
unit_amount=9900, unit_amount_decimal=9900}
5 Dimension date Time at which the object was created. 11/24/2021
6 Dimension description An arbitrary string attached to the object. Often useful for displaying to users. gahit2bq
7 Dimension discountable If true, discounts will apply to this invoice item. Always false for prorations. TRUE
8 Dimension discounts The discounts which apply to the invoice item. Item discounts are applied before invoice discounts. Use expand[]=discounts to expand each discount. []
9 Dimension id Unique identifier for the object. ii_1jzulqkfb2pyqlagktzllc18
10 Dimension invoice The ID of the invoice this invoice item belongs to. in_1jzulqkfb2pyqlag7qalb4bh
11 Dimension livemode Has the value true if the object exists in live mode or the value false if the object exists in test mode. TRUE
12 Dimension metadata Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format. {}
13 Dimension object String representing the object’s type. Objects of the same type share the same value. invoiceitem
14 Dimension period_end End of the line item’s billing period 11/24/2021
15 Dimension period_start Start of the line item’s billing period 11/24/2021
16 Dimension plan
17 Dimension price_active Whether the price can be used for new purchases. TRUE
18 Dimension price_billing_scheme Describes how to compute the price per period. Either per_unit or tiered. per_unit indicates that the fixed amount (specified in unit_amount or unit_amount_decimal) will be charged per unit in quantity (for prices with usage_type=licensed),
or per unit of total usage (for prices with usage_type=metered). tiered indicates that the unit pricing will be computed using a tiering strategy as defined using the tiers and tiers_mode attributes.
per_unit
19 Dimension price_created Time at which the object was created. Measured in seconds since the Unix epoch. 11/24/2021
20 Dimension price_currency Three-letter ISO currency code, in lowercase. Must be a supported currency. usd
21 Dimension price_id Unique identifier for the object. price_1jzul0kfb2pyqlagxixsnbp2
22 Dimension price_livemode Has the value true if the object exists in live mode or the value false if the object exists in test mode. TRUE
23 Dimension price_lookup_key A lookup key used to retrieve prices dynamically from a static string. This may be up to 200 characters.
24 Dimension price_metadata Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format. {}
25 Dimension price_nickname A brief description of the price, hidden from customers.
26 Dimension price_object String representing the object’s type. Objects of the same type share the same value. price
27 Dimension price_product The ID of the product this price is associated with. prod_keonlm0djwpvn1
28 Dimension price_recurring The recurring components of a price such as interval and usage_type.
29 Dimension price_tax_behavior Specifies whether the price is considered inclusive of taxes or exclusive of taxes. One of inclusive, exclusive, or unspecified. Once specified as either inclusive or exclusive, it cannot be changed. unspecified
30 Dimension price_tiers_mode Defines if the tiering price should be graduated or volume based. In volume-based tiering, the maximum quantity within a period determines the per unit price. In graduated tiering, pricing can change as the quantity grows.
31 Dimension price_transform_quantity Apply a transformation to the reported usage or set quantity before computing the amount billed. Cannot be combined with tiers.
32 Dimension price_type One of one_time or recurring depending on whether the price is for a one-time purchase or a recurring (subscription) purchase. one_time
33 Metric price_unit_amount The unit amount in paise to be charged, represented as a whole integer if possible. Only set if billing_scheme=per_unit. 9900
34 Metric price_unit_amount_decimal The unit amount in paise to be charged, represented as a decimal string with at most 12 decimal places. Only set if billing_scheme=per_unit. 9900
35 Dimension proration Whether the invoice item was created automatically as a proration adjustment when the customer switched plans. FALSE
36 Metric quantity Quantity of units for the invoice item. If the invoice item is a proration, the quantity of the subscription that the proration was computed for. 2
37 Dimension subscription The subscription that this invoice item has been created for, if any.
38 Dimension tax_rates The tax rates which apply to the invoice item. When set, the default_tax_rates on the invoice do not apply to this invoice item. []
39 Metric unit_amount Unit amount (in the currency specified) of the invoice item. 9900
40 Metric unit_amount_decimal Same as unit_amount, but contains a decimal value with at most 12 decimal places. 9900
41 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
42 Electrik.AI etl_org Organization Id ORG000097
43 Electrik.AI etl_project Project Id PR000154
44 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
45 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
46 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
47 Electrik.AI etl_flow_nm EAI Flow Code FL001282
48 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension account_country The country of the business associated with this invoice, most often the business creating the invoice. us
2 Dimension account_name The public name of the business associated with this invoice, most often the business creating the invoice. electrik.ai inc
3 Dimension account_tax_ids The account tax IDs associated with the invoice. Only editable when the invoice is a draft.
4 Metric amount_due Final amount due at this time for this invoice. If the invoice’s total is smaller than the minimum charge amount, for example, or if there is account credit that can be applied to the invoice, the amount_due may be 0. If there is a positive
starting_balance for the invoice (the customer owes money), the amount_due will also take that into account. The charge that gets generated for the invoice will be for the amount specified in amount_due.
0
5 Metric amount_paid The amount, in pence, that was paid. 0
6 Metric amount_remaining The amount remaining, in pence, that is due. 0
7 Metric application_fee_amount The fee in pence that will be applied to the invoice and transferred to the application owner’s Stripe account when the invoice is paid.
8 Metric attempt_count Number of payment attempts made for this invoice, from the perspective of the payment retry schedule. Any payment attempt counts as the first attempt, and subsequently only automatic retries increment the attempt count. In other words, manual
payment attempts after the first attempt do not affect the retry schedule.
0
9 Dimension attempted Whether an attempt has been made to pay the invoice. An invoice is not attempted until 1 hour after the invoice.created webhook, for example, so you might not want to display that invoice as unpaid to your users. FALSE
10 Dimension auto_advance Controls whether Stripe will perform automatic collection of the invoice. When false, the invoice’s state will not automatically advance without an explicit action. FALSE
11 Dimension automatic_tax Settings and latest results for automatic tax lookup for this invoice. {“enabled”:false,”status”:null}
12 Dimension automatic_tax_

enabled

Whether Stripe automatically computes tax on this invoice. FALSE
13 Dimension automatic_tax_status The status of the most recent automated tax calculation for this invoice.
14 Dimension billing billing send_invoice
15 Dimension billing_reason Indicates the reason why the invoice was created. subscription_cycle indicates an invoice created by a subscription advancing into a new period. subscription_create indicates an invoice created due to creating a subscription. subscription_update
indicates an invoice created due to updating a subscription. subscription is set for all old invoices to indicate either a change to a subscription or a period advancement. manual is set for all invoices unrelated to a subscription
manual
16 Dimension charge ID of the latest charge generated for this invoice, if any.
17 Dimension collection_method Either charge_automatically, or send_invoice. When charging automatically, Stripe will attempt to pay this invoice using the default source attached to the customer. When sending an invoice, Stripe will email this invoice to the customer with
payment instructions.
send_invoice
18 Dimension created Time at which the object was created. Measured in seconds since the Unix epoch. 11/24/2021
19 Dimension currency Three-letter ISO currency code, in lowercase. Must be a supported currency. usd
20 Dimension custom_fields Custom fields displayed on the invoice.
21 Dimension customer The ID of the customer who will be billed. cus_k4erj1tetvoalx
22 Dimension customer_address The customer’s address. Until the invoice is finalized, this field will equal customer.address. Once the invoice is finalized, this field will no longer be updated.
23 Dimension customer_email The customer’s email. Until the invoice is finalized, this field will equal customer.email. Once the invoice is finalized, this field will no longer be updated. pranaliamde@gmail.com
24 Dimension customer_name The customer’s name. Until the invoice is finalized, this field will equal customer.name. Once the invoice is finalized, this field will no longer be updated. p test
25 Dimension customer_phone The customer’s phone number. Until the invoice is finalized, this field will equal customer.phone. Once the invoice is finalized, this field will no longer be updated. 5454545656
26 Dimension customer_shipping The customer’s shipping information. Until the invoice is finalized, this field will equal customer.shipping. Once the invoice is finalized, this field will no longer be updated. {“address”:{“city”:””,”country”:”US”,”line1″:””,”line2″:””, “postal_code”:””,”state”:””},”name”:”Pranali”, “phone”:”5454545656″}
27 Dimension customer_shipping

_ address

Customer shipping address. {“city”:””,”country”:”US”,”line1″:””,”line2″:””, “postal_code”:””,”state”:””}
28 Dimension customer_shipping

_ address_city

City, district, suburb, town, or village.
29 Dimension customer_shipping_ address_country Two-letter country code us
30 Dimension customer_shipping

_ address_line1

Address line 1
31 Dimension customer_shipping

_ address_line2

Address line 2
32 Dimension customer_shipping_ address_postal_code ZIP or postal code.
33 Dimension customer_shipping_

address_state

State, county, province, or region.
34 Dimension customer_shipping_

name

Customer name. pranali
35 Dimension customer_shipping_

phone

Billing phone number (including extension). 5454545656
36 Dimension customer_tax_exempt The customer’s tax exempt status. Until the invoice is finalized, this field will equal customer.tax_exempt. Once the invoice is finalized, this field will no longer be updated. none
37 Dimension customer_tax_ids The customer’s tax IDs. Until the invoice is finalized, this field will contain the same tax IDs as customer.tax_ids. Once the invoice is finalized, this field will no longer be updated. []
38 Dimension data contains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty. {id=in_1JzUqIKFb2PyqLAGGMMnbdkw, object=invoice, account_country=US, account_name= Electrik.AI Inc, account_tax_ids=null, amount_due=0, amount_paid=0, amount_remaining=0, application_fee_ amount=null, attempt_count=0, attempted=false, auto_
advance=false, automatic_tax={enabled=false, status=null}, billing=send_invoice, billing_reason=manual, charge=null, collection_method=send_invoice, created=1637796334, currency=usd, custom_fields=null, customer=cus_GIGWZGJAmPVaZX, customer_address=null,
customer_email=sumit.m@toranainc.com, customer_name=TORANA, customer_phone=2036139296, customer_shipping={address={city=Stamford, country=US, line1=60 Long Ridge Rd, line2=Ste 303, postal_code=06902, state=CT}, name=Sandesh Gawande, phone=2036139296},
customer_tax_exempt=none, customer_tax_ids=[], default_payment_method=null, default_source=null, default_tax_rates=[], description=null, discount=null, discounts=[], due_date=null, ending_balance=null, footer=null, hosted_invoice_url=null,
invoice_pdf=null, last_finalization_error=null, lines={object=list, data=[], has_more=false, total_count=0, url=/v1/invoices /in_1JzUqIKFb2PyqLAGGMMnbdkw/lines}, livemode=true, metadata={}, next_payment_attempt=null, number=74E81D3E-0002,
on_behalf_of=null, paid=false, payment_intent=null, payment_settings= {payment_method_options=null, payment_method_types=null}, period_end=1637796334, period_start=1637796334, post_payment_credit_notes_amount=0, pre_payment_credit_notes_amount=0,
quote=null, receipt_number=null, starting_balance=0, statement_descriptor=null, status=draft, status_transitions= {finalized_at=null, marked_uncollectible_at=null, paid_at=null, voided_at=null}, subscription=null, subtotal=0, tax=null,
tax_percent=null, total=0, total_discount_amounts=[], total_tax_amounts=[], transfer_data=null, webhooks_delivered_at =1637796334}
39 Dimension default_payment_

method

ID of the default payment method for the invoice. It must belong to the customer associated with the invoice. If not set, defaults to the subscription’s default payment method, if any, or to the default payment method in the customer’s invoice
settings.
40 Dimension default_source ID of the default payment source for the invoice. It must belong to the customer associated with the invoice and be in a chargeable state. If not set, defaults to the subscription’s default source, if any, or to the customer’s default source.
41 Metric default_tax_rates The tax rates applied to this invoice, if any. []
42 Dimension description An arbitrary string attached to the object. Often useful for displaying to users. Referenced as ‘memo’ in the Dashboard. ORG000097
43 Metric discounts Describes the current discount applied to this invoice, if there is one. Not populated if there are multiple discounts. []
44 Dimension due_date The date on which payment for this invoice is due. This value will be null for invoices where collection_method=charge_automatically. 2021-06-13 12:45:42 UTC
45 Metric ending_balance Ending customer balance after the invoice is finalized. Invoices are finalized approximately an hour after successful webhook delivery or when payment collection is attempted for the invoice. If the invoice has not been finalized yet, this
will be null.
2021-06-13 12:45:42 UTC
46 Dimension footer Footer displayed on the invoice.
47 Dimension hosted_invoice_url The URL for the hosted invoice page, which allows customers to view and pay an invoice. If the invoice has not been finalized yet, this will be null.
48 Dimension id Unique identifier for the object. in_1jzuhtkfb2pyqlagwu7wwphw
49 Dimension invoice_pdf The link to download the PDF for the invoice. If the invoice has not been finalized yet, this will be null.
50 Dimension last_finalization_error The error encountered during the previous attempt to finalize the invoice. This field is cleared when the invoice is successfully finalized.
51 Dimension lines The individual line items that make up the invoice. lines is sorted as follows: invoice items in reverse chronological order, followed by the subscription, if any. {“object”:”list”,”data”:[],”has_more”:false,”total_count”:

0,”url” :”/v1/invoices/in_1JzUhtKFb2Pyq

LAGWu7WwpHw/lines”}

52 Dimension livemode Has the value true if the object exists in live mode or the value false if the object exists in test mode. TRUE
53 Dimension metadata Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format. {}
54 Dimension next_payment_attempt The time at which payment will next be attempted. This value will be null for invoices where collection_method=send_invoice.
55 Dimension number A unique, identifying string that appears on emails sent to the customer for this invoice. This starts with the customer’s unique invoice_prefix if it is specified. 6076f4fd-0001
56 Dimension object String representing the object’s type. Objects of the same type share the same value. invoice
57 Dimension on_behalf_of The account (if any) for which the funds of the invoice payment are intended. If set, the invoice will be presented with the branding and support information of the specified account.
58 Dimension paid Whether payment was successfully collected for this invoice. An invoice can be paid (most commonly) with a charge or with credit from the customer’s account balance. FALSE
59 Dimension payment_intent The Payment Intent associated with this invoice. The PaymentIntent is generated when the invoice is finalized, and can then be used to pay the invoice. Note that voiding an invoice will cancel the PaymentIntent.
60 Dimension payment_settings Configuration settings for the PaymentIntent that is generated when the invoice is finalized. {“payment_method_options”:null, “payment_method_types”:null}
61 Dimension period_end End of the usage period during which invoice items were added to this invoice. 11/24/2021
62 Dimension period_start Start of the usage period during which invoice items were added to this invoice. 11/24/2021
63 Metric post_payment_credit

_notes_amount

Total amount of all post-payment credit notes issued for this invoice. 0
64 Metric pre_payment_credit

_notes_amount

Total amount of all pre-payment credit notes issued for this invoice. 0
65 Dimension qoute The quote this invoice was generated from.
66 Dimension receipt_number This is the transaction number that appears on email receipts sent for this invoice.
67 Dimension starting_balance Starting customer balance before the invoice is finalized. If the invoice has not been finalized yet, this will be the current customer balance. 0
68 Dimension statement_descriptor Extra information about an invoice for the customer’s credit card statement.
69 Dimension status The status of the invoice, one of draft, open, paid, uncollectible, or void. draft
70 Dimension status_transitions The timestamps at which the invoice status was updated. {“finalized_at”:null,”marked

_uncollectible_at”: null,”paid_at”

:null,”voided_at”:null}

71 Dimension status_transitions_ finalized_at The time that the invoice draft was finalized.
72 Dimension status_transitions_ marked_uncollectible_at The time that the invoice was marked uncollectible.
73 Dimension status_transitions_paid_ at The time that the invoice was paid.
74 Dimension status_transitions_voided_ at The time that the invoice was voided.
75 Dimension subscription The subscription that this invoice was prepared for, if any.
76 Metric subtotal Total of all subscriptions, invoice items, and prorations on the invoice before any invoice level discount or tax is applied. Item discounts are already incorporated 0
77 Metric tax The amount of tax on this invoice. This is the sum of all the tax amounts on this invoice.
78 Metric tax_percent tax percent
79 Metric total Total after discounts and taxes. 0
80 Metric total_discount_amounts total discount amounts []
81 Metric total_tax_amounts total tax amounts []
82 Metric transfer_data The account (if any) the payment will be attributed to for tax reporting, and where funds from the payment will be transferred to for the invoice.
83 Dimension webhooks_delivered

_ at

Invoices are automatically paid or sent 1 hour after webhooks are delivered, or until all webhook delivery attempts have been exhausted. This field tracks the time when webhooks for this invoice were successfully delivered. If the invoice
had no webhooks to deliver, this will be set while the invoice is being created.
1637795813
84 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
85 Electrik.AI etl_org Organization Id ORG000097
86 Electrik.AI etl_project Project Id PR000154
87 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
88 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
89 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
90 Electrik.AI etl_flow_nm EAI Flow Code FL001282
91 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Metric amount Amount (in pence) to be transferred to your bank account or debit card. 9583
2 Dimension arrival_date Date the payout is expected to arrive in the bank. This factors in delays like weekends or bank holidays. 12/1/2021
3 Dimension automatic Returns true if the payout was created by an automated payout schedule, and false if it was requested manually. TRUE
4 Dimension balance_transaction ID of the balance transaction that describes the impact of this payout on your account balance. txn_1k1nnqkfb2pyqlagtqnvv8th
5 Dimension created Time at which the object was created. Measured in seconds since the Unix epoch. 11/30/2021
6 Dimension currency Three-letter ISO currency code, in lowercase. Must be a supported currency. usd
7 Dimension data contains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty. {id=po_1K1NNqKFb2PyqLAGUQmT7dYi, object=payout, amount=9583, arrival_date =1638316800, automatic=true, balance_transaction=txn_1K1NNqKFb2Pyq LAGtqNVv8tH , created=1638244318, currency=usd, description=STRIPE PAYOUT, destination=ba_1FgdQ8KFb2PyqLAGjLv
BpokN, failure_balance_transaction=null, failure_code=null, failure_message=null, livemode=true, metadata={}, method=standard, original_payout=null, reversed_by=null, source_type=card, statement_descriptor=null, status=in_transit, type=bank_account}
8 Dimension description An arbitrary string attached to the object. Often useful for displaying to users. stripe payout
9 Dimension destination ID of the bank account or card the payout was sent to. ba_1fgdq8kfb2pyqlagjlvbpokn
10 Dimension failure_balance_ transaction If the payout failed or was canceled, this will be the ID of the balance transaction that reversed the initial balance transaction, and puts the funds from the failed payout back in your balance.
11 Dimension failure_code Error code explaining reason for payout failure if available. See Types of payout failures for a list of failure codes.
12 Dimension failure_message Message to user further explaining reason for payout failure if available.
13 Dimension id Unique identifier for the object. po_1k1nnqkfb2pyqlaguqmt7dyi
14 Dimension livemode Has the value true if the object exists in live mode or the value false if the object exists in test mode. TRUE
15 Dimension metadata Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format. {}
16 Dimension method The method used to send this payout, which can be standard or instant. instant is only supported for payouts to debit cards. standard
17 Dimension object String representing the object’s type. Objects of the same type share the same value. payout
18 Dimension original_payout If the payout reverses another, this is the ID of the original payout.
19 Dimension reversed_by If the payout was reversed, this is the ID of the payout that reverses this payout.
20 Dimension source_type The source balance this payout came from. One of card, fpx, or bank_account. card
21 Dimension statement_descriptor statement descriptor 2021-06-13 12:45:42 UTC
22 Dimension status Only return payouts that have the given status: pending, paid, failed, or canceled. in_transit
23 Dimension type Can be bank_account or card. bank_account
24 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
25 Electrik.AI etl_org Organization Id ORG000097
26 Electrik.AI etl_project Project Id PR000154
27 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
28 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
29 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
30 Electrik.AI etl_flow_nm EAI Flow Code FL001282
31 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension active Whether the product is currently available for purchase. TRUE
2 Dimension created Time at which the object was created. Measured in seconds since the Unix epoch. 11/24/2021
3 Dimension data contains an array of up to limit transactions, starting after transaction starting_after. Each entry in the array is a separate transaction history object. If no more transactions are available, the resulting array will be empty. {id=prod_KeoNlm0Djwpvn1, object=product, active=true, attributes=[], created=1637796006, description=Google Analytics Hit Level Data to BigQuery, images=[], livemode=true, metadata={}, name=GAHIT2BQ, package_dimensions=null, shippable=null,
statement_descriptor=null, tax_code=null, type=service, unit_label=null, updated=1637796006, url=null}
4 Dimension description The product’s description, meant to be displayable to the customer. Use this field to optionally store a long form explanation of the product being sold for your own rendering purposes. google analytics hit level data to bigquery
5 Dimension id Unique identifier for the object. prod_keonlm0djwpvn1
6 Dimension images A list of up to 8 URLs of images for this product, meant to be displayable to the customer. []
7 Dimension livemode Has the value true if the object exists in live mode or the value false if the object exists in test mode. TRUE
8 Dimension metadata Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format. {}
9 Dimension name he product’s name, meant to be displayable to the customer. Whenever this product is sold via a subscription, name will show up on associated invoice line item descriptions. gahit2bq
10 Dimension object String representing the object’s type. Objects of the same type share the same value. product
11 Dimension package_dimensions The dimensions of this product for shipping purposes.
12 Dimension shippable Whether this product is shipped (i.e., physical goods).
13 Dimension statement_descriptor Extra information about a product which will appear on your customer’s credit card statement. In the case that multiple products are billed at once, the first statement descriptor will be used.
14 Dimension tax_code A tax code ID.
15 Dimension unit_label A label that represents units of this product in Stripe and on customers’ receipts and invoices. When set, this will be included in associated invoice line item descriptions.
16 Dimension updated Time at which the object was last updated. Measured in seconds since the Unix epoch. 11/24/2021
17 Dimension url A URL of a publicly-accessible webpage for this product.
18 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
19 Electrik.AI etl_org Organization Id ORG000097
20 Electrik.AI etl_project Project Id PR000154
21 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
22 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
23 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
24 Electrik.AI etl_flow_nm EAI Flow Code FL001282
25 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196