Introduction
Datasources and destinations
- Find all the data sources available at www.catchr.io/connectors
- Find all the destinations available at www.catchr.io/destinations
EXPLORE YOUR DATA
Metrics & dimensions
Find the fields you need for your next report.
15 metrics97 dimensions
112 fields
| Field | Details |
|---|---|
Active Whether the customer is active. | Field IDcustomer/active |
Amount Amount of the invoice line. | Field IDinvoice_line/amount |
Apply Tax After Discount Whether taxes are applied after discount. | Field IDinvoice/apply_tax_after_discount |
Billing Address City City of the billing address. | Field IDcustomer/billing_addr_city |
Billing Address Country Country of the billing address. | Field IDcustomer/billing_addr_country |
Billing Address Line 1 First line of the billing address. | Field IDcustomer/billing_addr_line_1 |
Billing Address Postal Code Postal code of the billing address. | Field IDcustomer/billing_addr_postal_code |
Billing Address Region State or region of the billing address. | Field IDcustomer/billing_addr_country_sub_division_code |
Company Address City City of the company address. | Field IDcompany_info/company_addr_city |
Company Address Country Country of the company address. | Field IDcompany_info/company_addr_country |
Company Address Line 1 First line of the company address. | Field IDcompany_info/company_addr_line_1 |
Company Address Postal Code Postal code of the company address. | Field IDcompany_info/company_addr_postal_code |
Company Address Region State or region of the company address. | Field IDcompany_info/company_addr_country_sub_division_code |
Company ID QuickBooks company identifier. | Field IDcompany_info/id |
Company Info Last Updated Time Last update timestamp for the company info. | Field IDcompany_info/last_updated_time |
Company Info Name Display name of the QuickBooks company. | Field IDcompany_info/company_name |
Country Country configured on the company. | Field IDcompany_info/country |
Customer Balance Open balance on the customer. | Field IDcustomer/balance |
Customer Communication Email Email used for customer communication. | Field IDcompany_info/customer_communication_email |
Customer Company Name Company name of the customer. | Field IDcustomer/company_name |
Customer Create Time Creation timestamp of the customer. | Field IDcustomer/create_time |
Customer Currency Currency used by the customer. | Field IDcustomer/currency_ref |
Customer ID Unique QuickBooks customer identifier. | Field IDcustomer/id |
Customer Last Updated Time Last update timestamp of the customer. | Field IDcustomer/last_updated_time |
Customer Memo Memo displayed to the customer. | Field IDinvoice/customer_memo |
Customer Sync Token QuickBooks sync token. | Field IDcustomer/sync_token |
Date Year, month, and day. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY |
Day of the month Day of the year | Field ID_NORMALIZED_DATE_FIELD_DAY |
Day of the week Week of the year | Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK |
Deposit Deposit amount recorded on the invoice. | Field IDinvoice/deposit |
Deposit Account ID Identifier of the deposit account. | Field IDpayment/deposit_to_account_id |
Deposit Account Name Name of the deposit account. | Field IDpayment/deposit_to_account_name |
Description Description of the invoice line. | Field IDinvoice_line/description |
Display Name Display name of the customer. | Field IDcustomer/display_name |
Document Number Invoice document number. | Field IDinvoice/doc_number |
Due Date Due date of the invoice. | Field IDinvoice/due_date |
Email Primary company email. | Field IDcompany_info/email |
Email Status Email delivery status of the invoice. | Field IDinvoice/email_status |
Expense Account ID Identifier of the linked expense account. | Field IDinvoice_line/expense_account_id |
Expense Account Name Name of the linked expense account. | Field IDinvoice_line/expense_account_name |
Family Name Last name of the customer. | Field IDcustomer/family_name |
Fiscal Year Start Month Month when the fiscal year starts. | Field IDcompany_info/fiscal_year_start_month |
Fully Qualified Name Fully qualified customer name. | Field IDcustomer/fully_qualified_name |
Given Name First name of the customer. | Field IDcustomer/given_name |
Home Total Amount Home currency total amount. | Field IDinvoice/home_total_amount |
Hour of the day Hour of the day | Field ID_NORMALIZED_DATE_FIELD_HOUR |
Invoice Balance Remaining balance on the invoice. | Field IDinvoice/balance |
Invoice Create Time Creation timestamp of the invoice. | Field IDinvoice/create_time |
Invoice Currency Currency used by the invoice. | Field IDinvoice/currency_ref |
Invoice Customer Name Name of the related customer. | Field IDinvoice/customer_name |
Invoice Document Number Document number of the related invoice. | Field IDinvoice_line/invoice_doc_number |
Invoice Exchange Rate Exchange rate on the invoice. | Field IDinvoice/exchange_rate |
Invoice ID Unique QuickBooks invoice identifier. | Field IDinvoice/id |
Invoice Last Updated Time Last update timestamp of the invoice. | Field IDinvoice/last_updated_time |
Invoice Line Count Number of lines on the invoice. | Field IDinvoice/line_count |
Invoice Line Create Time Creation timestamp of the related invoice. | Field IDinvoice_line/create_time |
Invoice Line Customer Name Name of the related customer. | Field IDinvoice_line/customer_name |
Invoice Line ID Synthetic identifier for the invoice line. | Field IDinvoice_line/id |
Invoice Line Last Updated Time Last update timestamp of the related invoice. | Field IDinvoice_line/last_updated_time |
Invoice Line Transaction Date Transaction date of the related invoice. | Field IDinvoice_line/txn_date |
Invoice Private Note Private note of the invoice. | Field IDinvoice/private_note |
Invoice Sync Token QuickBooks sync token. | Field IDinvoice/sync_token |
Invoice Total Amount Total amount of the invoice. | Field IDinvoice/total_amount |
Invoice Transaction Date Invoice transaction date. | Field IDinvoice/txn_date |
Legal Name Legal company name. | Field IDcompany_info/legal_name |
Line ID Identifier of the line in QuickBooks. | Field IDinvoice_line/line_id |
Line Number Position of the line on the invoice. | Field IDinvoice_line/line_num |
Line Type Detail type of the line. | Field IDinvoice_line/line_type |
Mobile Phone Mobile phone number of the customer. | Field IDcustomer/mobile_free_form_number |
Month and day Month and day | Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY |
Month of the year Month of the year | Field ID_NORMALIZED_DATE_FIELD_MONTH |
Payment Create Time Creation timestamp of the payment. | Field IDpayment/create_time |
Payment Currency Currency used by the payment. | Field IDpayment/currency_ref |
Payment Customer Name Name of the related customer. | Field IDpayment/customer_name |
Payment Exchange Rate Exchange rate on the payment. | Field IDpayment/exchange_rate |
Payment ID Unique QuickBooks payment identifier. | Field IDpayment/id |
Payment Last Updated Time Last update timestamp of the payment. | Field IDpayment/last_updated_time |
Payment Line Count Number of linked lines on the payment. | Field IDpayment/line_count |
Payment Method ID Identifier of the related payment method. | Field IDpayment/payment_method_id |
Payment Method Name Name of the related payment method. | Field IDpayment/payment_method_name |
Payment Private Note Private note of the payment. | Field IDpayment/private_note |
Payment Sync Token QuickBooks sync token. | Field IDpayment/sync_token |
Payment Total Amount Total payment amount. | Field IDpayment/total_amount |
Payment Transaction Date Payment transaction date. | Field IDpayment/txn_date |
Phone Number Primary company phone number. | Field IDcompany_info/phone_number |
Primary Email Primary email address of the customer. | Field IDcustomer/primary_email_addr |
Primary Phone Primary phone number of the customer. | Field IDcustomer/primary_phone_free_form_number |
Print Status Print status of the invoice. | Field IDinvoice/print_status |
Process Payment Whether the payment should be processed. | Field IDpayment/process_payment |
Quarter of the year Quarter of the year | Field ID_NORMALIZED_DATE_FIELD_QUARTER |
Sales Item ID Identifier of the related sales item. | Field IDinvoice_line/sales_item_item_id |
Sales Item Name Name of the related sales item. | Field IDinvoice_line/sales_item_item_name |
Sales Item Quantity Quantity of the sales item. | Field IDinvoice_line/sales_item_qty |
Sales Item Tax Code Tax code applied on the sales item. | Field IDinvoice_line/sales_item_tax_code |
Sales Item Unit Price Unit price of the sales item. | Field IDinvoice_line/sales_item_unit_price |
Service Date Service date of the sales item. | Field IDinvoice_line/sales_item_service_date |
Shipping Address City City of the shipping address. | Field IDcustomer/shipping_addr_city |
Shipping Address Country Country of the shipping address. | Field IDcustomer/shipping_addr_country |
Shipping Address Line 1 First line of the shipping address. | Field IDcustomer/shipping_addr_line_1 |
Shipping Address Postal Code Postal code of the shipping address. | Field IDcustomer/shipping_addr_postal_code |
Shipping Address Region State or region of the shipping address. | Field IDcustomer/shipping_addr_country_sub_division_code |
Supported Languages Languages enabled on the company. | Field IDcompany_info/supported_languages |
Total Tax Total tax amount. | Field IDinvoice/total_tax |
Unapplied Amount Unapplied amount remaining on the payment. | Field IDpayment/unapplied_amount |
Website Website URL configured on the company. | Field IDcompany_info/web_addr_uri |
Week of the year Week of the year | Field ID_NORMALIZED_DATE_FIELD_WEEK |
Week of the year (start Sunday) Week of the year | Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY |
Year Year such as 2017. | Field ID_NORMALIZED_DATE_FIELD_YEAR |
Year month Year and month. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH |
Year month day hour Year, month, day, and hour. | Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR |
Year Quarter Year and quarter. | Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER |
Year week Year and week. | Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK |
No matching fields
Try another search or reset your filters.
Explore destinations for your data
AI
Claude
Ask Claude about your Marketing data.
View connector
AI
ChatGPT
Ask ChatGPT about your Marketing data.
View connector
Spreadsheet
Excel
Easily track, report, and analyze your marketing KPIs in Excel.
View connector
Data lake
Azure Blob Storage
Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
View connector
Data lake
Google Cloud Storage
Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
View connector
Data lake
Amazon S3
Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
View connector
Data warehousing
Snowflake
Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
View connector
Data warehousing
Amazon Redshift
Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
View connector
Data warehousing
Azure SQL
Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
View connector
Data warehousing
PostgreSQL
Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
View connector
Data warehousing
MySQL
Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
View connector
Visualization
Tableau
Empower your marketing teams with seamless data transfer to Tableau.
View connector
Visualization
Power BI
Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
View connector
Data warehousing
Big Query
Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
View connector
Visualization
Data Studio (formerly Looker Studio)
Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
View connector
Spreadsheet
Google Sheets
Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.
View connector