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.
20 metrics112 dimensions
132 fields
| Field | Details |
|---|---|
Account Name Name of the account used for the payment. Example: Business Bank Account | Field IDpayment/account_name |
Account Number User-defined account number for the contact. Example: ACC-100 | Field IDcontact/account_number |
Accounts Payable Outstanding Outstanding payable balance for the contact. Example: 231.60 | Field IDcontact/accounts_payable_outstanding |
Accounts Payable Overdue Overdue payable balance for the contact. Example: 360.00 | Field IDcontact/accounts_payable_overdue |
Accounts Receivable Outstanding Outstanding receivable balance for the contact. Example: 760.00 | Field IDcontact/accounts_receivable_outstanding |
Accounts Receivable Overdue Overdue receivable balance for the contact. Example: 920.00 | Field IDcontact/accounts_receivable_overdue |
Amount Payment amount recorded in Xero. Example: 46.00 | Field IDpayment/amount |
Amount Credited Amount credited against the invoice. Example: 0.00 | Field IDinvoice/amount_credited |
Amount Due Remaining amount due on the invoice. Example: 115.00 | Field IDinvoice/amount_due |
Amount Paid Amount already paid on the invoice. Example: 46.00 | Field IDinvoice/amount_paid |
Bank Account Details Bank account details stored on the contact. Example: 12-1234-1234567-00 | Field IDcontact/bank_account_details |
Base Currency Base currency configured on the organisation. Example: NZD | Field IDorganisation/base_currency |
Class Subscription class used by the organisation. Example: PREMIUM | Field IDorganisation/class |
Contact Has Attachments Whether the contact has attachments in Xero. Example: false | Field IDcontact/has_attachments |
Contact ID Unique Xero contact identifier. Example: 5cc8cf28-567e-4d43-b287-687cfcaec47c | Field IDcontact/id |
Contact Name Full contact or company name. Example: Katherine Warren | Field IDcontact/name |
Contact Number External contact code used in Xero. Example: CONTACT-100 | Field IDcontact/contact_number |
Contact Status Current status of the contact. Example: ACTIVE | Field IDcontact/status |
Contact Tax Number Tax number stored on the contact. Example: GB123456789 | Field IDcontact/tax_number |
Contact Updated Date UTC Timestamp when the contact was last updated. Example: 2017-08-22T18:49:04+00:00 | Field IDcontact/updated_date_utc |
Country Code Country code of the organisation. Example: NZ | Field IDorganisation/country_code |
Created Date UTC Timestamp when the organisation was created. Example: 2016-02-18T22:29:53+00:00 | Field IDorganisation/created_date_utc |
Currency Code Currency code used by the invoice. Example: NZD | Field IDinvoice/currency_code |
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 |
Default Phone Default phone number for the contact. Example: 847-1294 | Field IDcontact/default_phone |
Default Purchases Tax Default purchase tax display mode. Example: Tax Exclusive | Field IDorganisation/default_purchases_tax |
Default Sales Tax Default sales tax display mode. Example: Tax Exclusive | Field IDorganisation/default_sales_tax |
Description Description of the invoice line item. Example: Monthly subscription | Field IDinvoice_line/description |
Discount Rate Discount rate applied to the line. Example: 10.0 | Field IDinvoice_line/discount_rate |
Due Date Invoice due date. Example: 2018-12-30T00:00:00+00:00 | Field IDinvoice/due_date |
Edition Product edition used by the organisation. Example: BUSINESS | Field IDorganisation/edition |
Email Address Primary email address for the contact. Example: kat.warren@clampett.com | Field IDcontact/email_address |
End Of Year Lock Date Date after which end-of-year transactions are locked. Example: 2018-12-31T00:00:00+00:00 | Field IDorganisation/end_of_year_lock_date |
Financial Year End Day Day used to end the financial year. Example: 31 | Field IDorganisation/financial_year_end_day |
Financial Year End Month Month used to end the financial year. Example: 3 | Field IDorganisation/financial_year_end_month |
First Name First name for the contact. Example: Katherine | Field IDcontact/first_name |
Fully Paid On Date Date when the invoice became fully paid. Example: 2018-11-29T00:00:00+00:00 | Field IDinvoice/fully_paid_on_date |
Has Errors Whether Xero reported validation errors on the invoice. Example: false | Field IDinvoice/has_errors |
Hour of the day Hour of the day | Field ID_NORMALIZED_DATE_FIELD_HOUR |
Invoice Contact Name Name of the related contact. Example: Barney Rubble-83203 | Field IDinvoice/contact_name |
Invoice Currency Rate Exchange rate used by the invoice. Example: 1.000000 | Field IDinvoice/currency_rate |
Invoice Date Invoice issue date. Example: 2018-10-20T00:00:00+00:00 | Field IDinvoice/date |
Invoice Date (Invoice Line) Date of the related invoice. Example: 2018-10-20T00:00:00+00:00 | Field IDinvoice_line/invoice_date |
Invoice Has Attachments Whether the invoice has attachments. Example: false | Field IDinvoice/has_attachments |
Invoice ID Unique Xero invoice identifier. Example: 046d8a6d-1ae1-4b4d-9340-5601bdf41b87 | Field IDinvoice/id |
Invoice Line Account Code Account code linked to the invoice line. Example: 200 | Field IDinvoice_line/account_code |
Invoice Line Account ID Account identifier linked to the invoice line. Example: 5690f1e8-1d02-4893-90c2-ee1a69eff942 | Field IDinvoice_line/account_id |
Invoice Line Contact Name Name of the related contact. Example: Barney Rubble-83203 | Field IDinvoice_line/contact_name |
Invoice Line ID Synthetic identifier for the invoice line row. Example: 046d8a6d-1ae1-4b4d-9340-5601bdf41b87_00000000-0000-0000-0000-000000000001 | Field IDinvoice_line/id |
Invoice Line Updated Date UTC Timestamp when the related invoice was last updated. Example: 2018-10-20T09:16:30+00:00 | Field IDinvoice_line/updated_date_utc |
Invoice Number Human-readable invoice number. Example: INV-0002 | Field IDinvoice/invoice_number |
Invoice Number (Invoice Line) Invoice number for the related invoice. Example: INV-0002 | Field IDinvoice_line/invoice_number |
Invoice Reference Reference stored on the invoice. Example: Red Fish, Blue Fish | Field IDinvoice/reference |
Invoice Status Current invoice status. Example: PAID | Field IDinvoice/status |
Invoice Type Invoice type returned by Xero. Example: ACCREC | Field IDinvoice/type |
Invoice Updated Date UTC Timestamp when the invoice was last updated. Example: 2018-10-20T09:16:30+00:00 | Field IDinvoice/updated_date_utc |
Is Customer Whether the contact is marked as a customer. Example: true | Field IDcontact/is_customer |
Is Demo Company Whether the connected organisation is a demo company. Example: false | Field IDorganisation/is_demo_company |
Is Discounted Whether the invoice includes discounts. Example: false | Field IDinvoice/is_discounted |
Is Reconciled Whether the payment is reconciled. Example: false | Field IDpayment/is_reconciled |
Is Supplier Whether the contact is marked as a supplier. Example: true | Field IDcontact/is_supplier |
Item Code Inventory or item code linked to the line. Example: SKU-001 | Field IDinvoice_line/item_code |
Last Name Last name for the contact. Example: Warren | Field IDcontact/last_name |
Legal Name Legal name shown on Xero reports. Example: Demo Company (NZ) | Field IDorganisation/legal_name |
Line Amount Total amount for the invoice line. Example: 40.00 | Field IDinvoice_line/line_amount |
Line Amount Type Tax calculation mode for invoice lines. Example: Exclusive | Field IDinvoice/line_amount_type |
Line Item Count Number of line items returned on the invoice. Example: 3 | Field IDinvoice/line_item_count |
Line Item ID Xero identifier for the invoice line item. Example: 00000000-0000-0000-0000-000000000000 | Field IDinvoice_line/line_item_id |
Merged To Contact ID Destination contact when this contact was merged. Example: 3ec601ad-eddc-4ccb-a8ac-736e88293b1b | Field IDcontact/merged_to_contact_id |
Mobile Phone Mobile phone number for the contact. Example: 0211234567 | Field IDcontact/mobile_phone |
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 |
Option Count Number of tracking options returned for the category. Example: 4 | Field IDtracking_category/option_count |
Organisation ID Unique Xero organisation identifier. Example: b2c885a9-4bb9-4a00-9b6e-6c2bf60b1a2b | Field IDorganisation/id |
Organisation Name Display name of the organisation in Xero. Example: Demo Company (NZ) | Field IDorganisation/name |
Organisation Status Current organisation status. Example: ACTIVE | Field IDorganisation/organisation_status |
Organisation Tax Number Tax registration number on the organisation. Example: 071-138-054 | Field IDorganisation/tax_number |
Organisation Type Organisation entity type in Xero. Example: COMPANY | Field IDorganisation/organisation_type |
Payment Account Code Code of the account used for the payment. Example: 970 | Field IDpayment/account_code |
Payment Account ID Identifier of the account used for the payment. Example: 5690f1e8-1d02-4893-90c2-ee1a69eff942 | Field IDpayment/account_id |
Payment Currency Rate Exchange rate applied to the payment. Example: 1.000000 | Field IDpayment/currency_rate |
Payment Date Date when the payment was recorded. Example: 2018-11-29T00:00:00+00:00 | Field IDpayment/date |
Payment ID Unique Xero payment identifier. Example: 99ea7f6b-c513-4066-bc27-b7c65dcd76c2 | Field IDpayment/id |
Payment Invoice Number Number of the related invoice. Example: INV-0002 | Field IDpayment/invoice_number |
Payment Reference Reference saved on the payment. Example: Stripe payout 1234 | Field IDpayment/reference |
Payment Status Current payment status. Example: AUTHORISED | Field IDpayment/status |
Payment Type Payment type returned by Xero. Example: ACCRECPAYMENT | Field IDpayment/payment_type |
Payment Updated Date UTC Timestamp when the payment was last updated. Example: 2018-10-20T09:16:32+00:00 | Field IDpayment/updated_date_utc |
Pays Tax Whether the organisation is registered for tax. Example: true | Field IDorganisation/pays_tax |
Period Lock Date Date after which historical transactions are locked. Example: 2018-12-31T00:00:00+00:00 | Field IDorganisation/period_lock_date |
Postal City City from the postal address. Example: Palo Alto | Field IDcontact/postal_city |
Postal Country Country from the postal address. Example: United States | Field IDcontact/postal_country |
Postal Postal Code Postal code from the postal address. Example: 94020 | Field IDcontact/postal_postal_code |
Postal Region Region from the postal address. Example: CA | Field IDcontact/postal_region |
Purchases Default Line Amount Type Default purchase line amount type for the contact. Example: INCLUSIVE | Field IDcontact/purchases_default_line_amount_type |
Quantity Quantity on the invoice line. Example: 2.0 | Field IDinvoice_line/quantity |
Quarter of the year Quarter of the year | Field ID_NORMALIZED_DATE_FIELD_QUARTER |
Repeating Invoice ID Identifier of the linked repeating invoice. Example: 428c0d75-909f-4b04-8403-a48dc27283b0 | Field IDinvoice/repeating_invoice_id |
Sales Default Line Amount Type Default sales line amount type for the contact. Example: INCLUSIVE | Field IDcontact/sales_default_line_amount_type |
Sales Tax Basis Sales tax basis for the organisation. Example: PAYMENTS | Field IDorganisation/sales_tax_basis |
Sales Tax Period Sales tax reporting period. Example: TWOMONTHS | Field IDorganisation/sales_tax_period |
Sent To Contact Whether the invoice was sent to the contact. Example: true | Field IDinvoice/sent_to_contact |
Short Code Short code used by the organisation. Example: !mBdtL | Field IDorganisation/short_code |
Street City City from the street address. Example: London | Field IDcontact/street_city |
Street Country Country from the street address. Example: United Kingdom | Field IDcontact/street_country |
Street Postal Code Postal code from the street address. Example: SW1A 1AA | Field IDcontact/street_postal_code |
Street Region Region from the street address. Example: Greater London | Field IDcontact/street_region |
Subtotal Subtotal before tax on the invoice. Example: 40.00 | Field IDinvoice/sub_total |
Tax Amount Tax amount on the invoice line. Example: 6.00 | Field IDinvoice_line/tax_amount |
Tax Type Tax type applied on the invoice line. Example: OUTPUT | Field IDinvoice_line/tax_type |
Timezone Timezone configured for the organisation. Example: NEWZEALANDSTANDARDTIME | Field IDorganisation/timezone |
Total Total invoice amount including tax. Example: 46.00 | Field IDinvoice/total |
Total Tax Total tax amount on the invoice. Example: 6.00 | Field IDinvoice/total_tax |
Tracking Category ID Unique Xero tracking category identifier. Example: 22f10184-0deb-44ae-a312-b1f6ea70e51f | Field IDtracking_category/id |
Tracking Category Name Name of the tracking category. Example: Department | Field IDtracking_category/name |
Tracking Category Status Current status of the tracking category. Example: ACTIVE | Field IDtracking_category/status |
Tracking Option ID Unique Xero tracking option identifier. Example: dc54c220-0140-495a-b925-3246adc0075f | Field IDtracking_option/tracking_option_id |
Tracking Option Name Name of the tracking option. Example: East | Field IDtracking_option/name |
Tracking Option Row ID Synthetic identifier for the tracking option row. Example: 22f10184-0deb-44ae-a312-b1f6ea70e51f_dc54c220-0140-495a-b925-3246adc0075f | Field IDtracking_option/id |
Tracking Option Status Current status of the tracking option. Example: ACTIVE | Field IDtracking_option/status |
Tracking Option Tracking Category Name Name of the related tracking category. Example: Department | Field IDtracking_option/tracking_category_name |
Unit Amount Unit amount on the invoice line. Example: 20.00 | Field IDinvoice_line/unit_amount |
Version Xero regional version for the organisation. Example: NZ | Field IDorganisation/version |
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