Twitter Ads are display ads and have three types of ads viz Promoted Ads, Follower Ads, and Trend Takeover. Promoted Ads are just like regular tweets and can be liked, retweeted, or replied to. Follower ads let you expand your account’s reach as well as grow your audience. Whereas Trend Takeover puts your ad alongside what’s trending. Twitter Ads help thousands of advertisers reach their audiences and help increase followers.
Twitter Ads Data Export
What are Twitter Ads?
How to add a Twitter Ads Source in Electrik.AI?
Follow these steps to connect your Twitter Ads account to Electrik.AI
Step 1: Ensure you have the following prerequisites to create a Twitter Ads Connection in Electrik.AI
a. Twitter Ads username & password
Step 2: Sign-in into your Electrik.AI account
Step 3: Select IO in Electrik.AI dashboard
Step 4: Select the Connections Icon in the left most panel and click on “Add” button the top.
Step 5: The Source default tab is selected just click on “Twitter Ads” connection.
Step 6: Enter your Twitter Ads User Id and Password.
Step 7: Allow Electrik.AI to access your Twitter Ads account.
Step 8: Select the Twitter Ads Account from the dropdown whose data you wish to export.
Step 9: Click on Save button on the top.
Congratulations, you have now successfully created a Twitter Ads Connection in Electrik.AI
What are the supported Data Destinations?
Electrik.AI supports the following destination to export Twitter Ads Data.
How to export Twitter Ads Data?
Electrik.AI creates a data flow (or ETL process) that exports Twitter Ads 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 Twitter Ads to Database
Step 1: Ensure you have the following prerequisites.
- Access to Twitter Ads.
- Twitter Ads username & password.
- Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)
- 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
Step 4: Click on Add button to create a Twitter Ads Performance Data Extractor Flow
Step 5: Select Twitter Ads Connection present in the list of available sources
Step 6: Select your existing Twitter Ads connection in Electrik.AI.
To Configure a new connection, refer to this link.
Step 7: Click on a destination of your choice from the list of available destinations.
In this example we are choosing BigQuery.
Step 8: Select your existing BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this link.
Step 9:
a. Choose the desired report to get the appropriate data. In this example we are choosing all.
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.
Note: By Default, Electrik.AI chooses an existing Data Set to load your Twitter Ads 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.
You have now successfully set up Twitter Ads to BigQuery Data Warehouse flow in Electrik.AI
Your Twitter Ads data will start loading after 24 hours in your Data Set.
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”:”[email protected]”,”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. | [email protected] |
| 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 protected], 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}, [email protected], 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. | [email protected] |
| 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 protected], 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 | The customer’s email address. | [email protected] | |
| 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”: “[email protected]”,”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. | [email protected] |
| 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, [email protected], 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 |