Field group | Field | Type | Data type | Description |
|---|---|---|---|---|
| Contact insights | Contacts count | METRIC | INTEGER | Number of contacts |
| Opportunity insights | Opportunities count | METRIC | INTEGER | Number of opportunities |
| Opportunity insights | Opportunity monetary value | METRIC | CURRENCY | Monetary value of the opportunity |
| Opportunity insights | Opportunities open count | METRIC | INTEGER | Number of opportunities with status Open |
| Opportunity insights | Opportunities won count | METRIC | INTEGER | Number of opportunities with status Won |
| Opportunity insights | Opportunities lost count | METRIC | INTEGER | Number of opportunities with status Lost |
| Opportunity insights | Opportunities abandoned count | METRIC | INTEGER | Number of opportunities with status Abandoned |
| Opportunity insights | Opportunities won value | METRIC | CURRENCY | Total monetary value of won opportunities |
| Conversation insights | Conversations count | METRIC | INTEGER | Number of conversations |
| Conversation insights | Conversation unread count | METRIC | INTEGER | Number of unread messages in the conversation |
| Invoice insights | Invoices count | METRIC | INTEGER | Number of invoices |
| Invoice insights | Invoice total | METRIC | CURRENCY | Total amount of the invoice |
| Invoice insights | Invoice amount paid | METRIC | CURRENCY | Amount paid for the invoice |
| Invoice insights | Invoice amount due | METRIC | CURRENCY | Amount due for the invoice |
| Invoice insights | Total summary sub total | METRIC | CURRENCY | Sub total amount for the invoice total summary |
| Invoice insights | Total summary discount | METRIC | CURRENCY | Discount amount for the invoice total summary |
| Invoice insights | Invoice total summary tax | METRIC | CURRENCY | Tax amount for the invoice total summary |
| Invoice insights | Invoices paid count | METRIC | INTEGER | Number of invoices with status Paid |
| Invoice insights | Invoices sent count | METRIC | INTEGER | Number of invoices with status Sent |
| Invoice insights | Invoices partially paid count | METRIC | INTEGER | Number of invoices with status Partially Paid |
| Invoice insights | Invoices void count | METRIC | INTEGER | Number of invoices with status Void |
| Order insights | Orders count | METRIC | INTEGER | Number of orders |
| Order insights | Order amount | METRIC | CURRENCY | Amount of the order |
| Order insights | Order subtotal | METRIC | CURRENCY | Subtotal of the order |
| Order insights | Order discount | METRIC | CURRENCY | Discount applied to the order |
| Order insights | Order total products | METRIC | INTEGER | Total number of products in the order |
| Order insights | Order onetime products | METRIC | INTEGER | Onetime products in the order |
| Order insights | Order recurring products | METRIC | INTEGER | Recurring products in the order |
| Transaction insights | Transactions count | METRIC | INTEGER | Number of transactions |
| Transaction insights | Transaction amount | METRIC | CURRENCY | Amount of the transaction |
| Transaction insights | Transaction amount refunded | METRIC | CURRENCY | Amount refunded for the transaction |
| Transaction insights | Transactions succeeded count | METRIC | INTEGER | Number of transactions with status Succeeded |
| Transaction insights | Transactions failed count | METRIC | INTEGER | Number of transactions with status Failed |
| Subscription insights | Subscriptions count | METRIC | INTEGER | Number of subscriptions |
| Subscription insights | Subscription amount | METRIC | CURRENCY | Amount of the subscription |
| Subscription insights | Subscriptions active count | METRIC | INTEGER | Number of subscriptions with status Active |
| Subscription insights | Subscriptions cancelled count | METRIC | INTEGER | Number of subscriptions with status Cancelled |
| Appointment insights | Appointments count | METRIC | INTEGER | Number of appointments |
| Appointment insights | Appointments confirmed count | METRIC | INTEGER | Number of appointments with status Confirmed |
| Appointment insights | Appointments showed count | METRIC | INTEGER | Number of appointments with status Showed |
| Appointment insights | Appointments no-show count | METRIC | INTEGER | Number of appointments with status No-Show |
| Appointment insights | Appointments cancelled count | METRIC | INTEGER | Number of appointments with status Cancelled |
| Task insights | Tasks count | METRIC | INTEGER | Number of tasks |
| Task insights | Tasks completed count | METRIC | INTEGER | Number of completed tasks |
| Task insights | Tasks pending count | METRIC | INTEGER | Number of tasks not yet completed |
| Forms insights | Forms count | METRIC | INTEGER | Number of forms |
| Form submission insights | Form submissions count | METRIC | INTEGER | Number of form submissions |
| Surveys insights | Surveys count | METRIC | INTEGER | Number of surveys |
| Survey submission insights | Survey submissions count | METRIC | INTEGER | Number of survey submissions |
| Workflows insights | Workflows count | METRIC | INTEGER | Number of workflows |
| Tags insights | Tags count | METRIC | INTEGER | Number of tags |
| Time | Year | DIMENSION | YEAR | Calendar year |
| Time | Year month | DIMENSION | YEAR_MONTH | Calendar year and month |
| Time | Year month number | DIMENSION | YEAR_MONTH_NUMBER | Year and month as YYYY-MM |
| Time | Month | DIMENSION | MONTH_NAME | Calendar month name (e.g. January) |
| Time | Month number | DIMENSION | MONTH | Month of the year as a number (1-12) |
| Time | Week number(sun - sat) | DIMENSION | WEEK_NUMBER | Week number of the year, with weeks starting on Sunday |
| Time | Week number(mon - sun) | DIMENSION | WEEK_ISO_NUMBER | ISO week number of the year, with weeks starting on Monday |
| Time | Week start date(sun - sat) | DIMENSION | WEEK_START_DATE | Start date (Sunday) of the week the record falls in |
| Time | Week start date(mon - sun) | DIMENSION | WEEK_ISO_START_DATE | Start date (Monday) of the ISO week the record falls in |
| Time | Date | DIMENSION | DATE | Calendar date (YYYY-MM-DD) the record falls on |
| Location | Location name | DIMENSION | STRING | Name of the location |
| Location | Location ID | DIMENSION | STRING | Location's unique identifier (GoHighLevel sub-account ID) |
| Location | Location address | DIMENSION | STRING | Address of the location |
| Location | Location business address | DIMENSION | STRING | Business address associated with the location |
| Location | Location business city | DIMENSION | CITY | Business city associated with the location |
| Location | Location business country | DIMENSION | COUNTRY | Business country associated with the location |
| Location | Location business logo URL | DIMENSION | IMAGE_URL | Business logo URL associated with the location |
| Location | Location business name | DIMENSION | STRING | Business name associated with the location |
| Location | Business postal code | DIMENSION | STRING | Business postal code associated with the location |
| Location | Location business state | DIMENSION | REGION | Business state associated with the location |
| Location | Location business timezone | DIMENSION | STRING | Business timezone associated with the location |
| Location | Location business website | DIMENSION | URL | Business website associated with the location |
| Location | Location city | DIMENSION | CITY | City of the location |
| Location | Location company ID | DIMENSION | STRING | Company ID associated with the location |
| Location | Location country | DIMENSION | COUNTRY | Country of the location |
| Location | Location domain | DIMENSION | STRING | Domain of the location |
| Location | Location email | DIMENSION | STRING | Email associated with the location |
| Location | Location first name | DIMENSION | STRING | First name associated with the location |
| Location | Location last name | DIMENSION | STRING | Last name associated with the location |
| Location | Location logo URL | DIMENSION | IMAGE_URL | Logo URL of the location |
| Location | Location phone | DIMENSION | STRING | Phone number associated with the location |
| Location | Location postal code | DIMENSION | STRING | Postal code of the location |
| Location | Allow duplicate contact | DIMENSION | BOOLEAN | Indicates if the location allows duplicate contacts |
| Location | Allow duplicate opportunity | DIMENSION | BOOLEAN | Indicates if the location allows duplicate opportunities |
| Location | Disable contact timezone | DIMENSION | BOOLEAN | Indicates if the contact timezone is disabled for the location |
| Location | Location social blog RSS | DIMENSION | URL | Blog RSS URL associated with the location |
| Location | Social Facebook URL | DIMENSION | URL | Facebook URL associated with the location |
| Location | Location social Foursquare | DIMENSION | URL | Foursquare URL associated with the location |
| Location | Social Google places ID | DIMENSION | STRING | Google Places ID associated with the location |
| Location | Location social Google plus | DIMENSION | URL | Google Plus URL associated with the location |
| Location | Location social Instagram | DIMENSION | URL | Instagram URL associated with the location |
| Location | Location social LinkedIn | DIMENSION | URL | LinkedIn URL associated with the location |
| Location | Location social Pinterest | DIMENSION | URL | Pinterest URL associated with the location |
| Location | Location social Twitter | DIMENSION | URL | Twitter URL associated with the location |
| Location | Location social Yelp | DIMENSION | URL | Yelp URL associated with the location |
| Location | Location social YouTube | DIMENSION | URL | YouTube URL associated with the location |
| Location | Location state | DIMENSION | REGION | State of the location |
| Location | Location timezone | DIMENSION | STRING | Timezone of the location |
| Location | Location website | DIMENSION | URL | Website of the location |
| Location | Allow Facebook name merge | DIMENSION | BOOLEAN | Indicates if the location allows Facebook name merge |
| Location | Location reseller | DIMENSION | STRING | Reseller details of the location as a JSON string |
| Contact | Contact name | DIMENSION | STRING | Contact's full name. Derived in Cube by combining first and last name (not stored). |
| Contact | Contact ID | DIMENSION | STRING | Contact's unique identifier |
| Contact | Contact first name | DIMENSION | STRING | Contact's first name |
| Contact | Contact last name | DIMENSION | STRING | Contact's last name |
| Contact | Contact additional emails | DIMENSION | STRING | Contact's additional emails |
| Contact | Contact additional phones | DIMENSION | STRING | Contact's additional phone numbers |
| Contact | Contact address | DIMENSION | STRING | Contact's address |
| Contact | Contact assigned to | DIMENSION | STRING | User assigned to the contact |
| Contact | Contact business ID | DIMENSION | STRING | Contact's business ID |
| Contact | Contact business name | DIMENSION | STRING | Contact's business name |
| Contact | Contact city | DIMENSION | CITY | Contact's city |
| Contact | Contact company name | DIMENSION | STRING | Contact's company name |
| Contact | Contact country | DIMENSION | COUNTRY | Contact's country |
| Contact | Contact created date | DIMENSION | DATE | Date when the contact was added |
| Contact | Contact created datetime | DIMENSION | DATETIME | Date and time when the contact was added |
| Contact | Contact date of birth | DIMENSION | DATE | Contact's date of birth |
| Contact | Contact updated date | DIMENSION | DATE | Date when the contact was last updated |
| Contact | Contact updated datetime | DIMENSION | DATETIME | Date and time when the contact was last updated |
| Contact | Contact DND | DIMENSION | BOOLEAN | Contact's Do Not Disturb status |
| Contact | Contact DND settings | DIMENSION | STRING | Contact's Do Not Disturb settings per channel as a JSON string |
| Contact | Contact email | DIMENSION | STRING | Contact's email address |
| Contact | Contact followers | DIMENSION | STRING | Followers of the contact |
| Contact | Contact keyword | DIMENSION | STRING | Search keyword associated with the contact |
| Contact | Contact last activity date | DIMENSION | DATE | Date of the contact's last activity |
| Contact | Contact last activity datetime | DIMENSION | DATETIME | Date and time of the contact's last activity |
| Contact | Contact phone | DIMENSION | STRING | Contact's phone number |
| Contact | Contact phone label | DIMENSION | STRING | Contact's phone label |
| Contact | Contact postal code | DIMENSION | STRING | Contact's postal code |
| Contact | Contact source | DIMENSION | STRING | Contact's source |
| Contact | Contact state | DIMENSION | REGION | Contact's state |
| Contact | Contact tags | DIMENSION | STRING | Contact's tags |
| Contact | Contact type | DIMENSION | STRING | Contact's type |
| Contact | Contact valid email | DIMENSION | STRING | Contact's valid email |
| Contact | Contact visitor ID | DIMENSION | STRING | Unique ID assigned to each live chat visitor |
| Contact | Contact website | DIMENSION | URL | Contact's website |
| Contact | Contact custom fields | DIMENSION | STRING | Raw custom field values of the contact as a JSON string |
| Contact | Contact attribution URL | DIMENSION | URL | First-touch attribution session URL of the contact |
| Contact | Attribution campaign | DIMENSION | STRING | First-touch attribution campaign of the contact |
| Contact | Attribution campaign ID | DIMENSION | STRING | First-touch attribution campaign ID of the contact |
| Contact | Attribution UTM source | DIMENSION | STRING | First-touch attribution UTM source of the contact |
| Contact | Attribution UTM medium | DIMENSION | STRING | First-touch attribution UTM medium of the contact |
| Contact | Attribution UTM content | DIMENSION | STRING | First-touch attribution UTM content of the contact |
| Contact | Attribution referrer | DIMENSION | STRING | First-touch attribution referrer of the contact |
| Contact | Contact attribution medium | DIMENSION | STRING | First-touch attribution medium of the contact |
| Contact | Contact attribution GCLID | DIMENSION | STRING | First-touch attribution Google click ID of the contact |
| Contact | Contact attribution FBCLID | DIMENSION | STRING | First-touch attribution Facebook click ID of the contact |
| Contact | Last attribution URL | DIMENSION | URL | Last-touch attribution session URL of the contact |
| Contact | Last attribution campaign | DIMENSION | STRING | Last-touch attribution campaign of the contact |
| Contact | Last attribution campaign ID | DIMENSION | STRING | Last-touch attribution campaign ID of the contact |
| Contact | Last attribution UTM source | DIMENSION | STRING | Last-touch attribution UTM source of the contact |
| Contact | Last attribution UTM medium | DIMENSION | STRING | Last-touch attribution UTM medium of the contact |
| Contact | Last attribution UTM content | DIMENSION | STRING | Last-touch attribution UTM content of the contact |
| Contact | Last attribution referrer | DIMENSION | STRING | Last-touch attribution referrer of the contact |
| Contact | Last attribution medium | DIMENSION | STRING | Last-touch attribution medium of the contact |
| Contact | Last attribution GCLID | DIMENSION | STRING | Last-touch attribution Google click ID of the contact |
| Contact | Last attribution FBCLID | DIMENSION | STRING | Last-touch attribution Facebook click ID of the contact |
| Contact | Contact timezone | DIMENSION | STRING | Contact's timezone |
| Contact | Contact SSN | DIMENSION | STRING | Contact's SSN |
| Contact | Contact attachments | DIMENSION | STRING | Contact's attachments |
| Contact | Contact attributions | DIMENSION | STRING | All attribution sources of the contact as a JSON string |
| Contact | Contact attribution MSCLKID | DIMENSION | STRING | First-touch attribution Microsoft click ID of the contact |
| Contact | Contact attribution DCLID | DIMENSION | STRING | First-touch attribution DoubleClick ID of the contact |
| Contact | Contact attribution FBC | DIMENSION | STRING | First-touch attribution Facebook click cookie (fbc) of the contact |
| Contact | Contact attribution FBP | DIMENSION | STRING | First-touch attribution Facebook browser cookie (fbp) of the contact |
| Contact | Attribution FB event ID | DIMENSION | STRING | First-touch attribution Facebook event ID of the contact |
| Contact | Attribution user agent | DIMENSION | STRING | First-touch attribution user agent of the contact |
| Contact | Contact attribution IP | DIMENSION | STRING | First-touch attribution IP address of the contact |
| Contact | Attribution medium ID | DIMENSION | STRING | First-touch attribution medium ID of the contact |
| Contact | Contact last attribution MSCLKID | DIMENSION | STRING | Last-touch attribution Microsoft click ID of the contact |
| Contact | Contact last attribution DCLID | DIMENSION | STRING | Last-touch attribution DoubleClick ID of the contact |
| Contact | Contact last attribution FBC | DIMENSION | STRING | Last-touch attribution Facebook click cookie (fbc) of the contact |
| Contact | Contact last attribution FBP | DIMENSION | STRING | Last-touch attribution Facebook browser cookie (fbp) of the contact |
| Contact | Last attribution FB event ID | DIMENSION | STRING | Last-touch attribution Facebook event ID of the contact |
| Contact | Last attribution user agent | DIMENSION | STRING | Last-touch attribution user agent of the contact |
| Contact | Contact last attribution IP | DIMENSION | STRING | Last-touch attribution IP address of the contact |
| Contact | Last attribution medium ID | DIMENSION | STRING | Last-touch attribution medium ID of the contact |
| Opportunity | Opportunity name | DIMENSION | STRING | Name of the opportunity |
| Opportunity | Opportunity ID | DIMENSION | STRING | Opportunity's unique identifier |
| Opportunity | Opportunity assigned to | DIMENSION | STRING | User assigned to the opportunity |
| Opportunity | Opportunity contact ID | DIMENSION | STRING | Contact ID associated with the opportunity |
| Opportunity | Opportunity created date | DIMENSION | DATE | Date when the opportunity was created |
| Opportunity | Opportunity created datetime | DIMENSION | DATETIME | Date and time when the opportunity was created |
| Opportunity | External object ID | DIMENSION | STRING | External object ID associated with the opportunity |
| Opportunity | Last action date | DIMENSION | DATE | Date of the last action on the opportunity |
| Opportunity | Last action datetime | DIMENSION | DATETIME | Date and time of the last action on the opportunity |
| Opportunity | Last stage change date | DIMENSION | DATE | Date of the last stage change of the opportunity |
| Opportunity | Last stage change datetime | DIMENSION | DATETIME | Date and time of the last stage change of the opportunity |
| Opportunity | Last status change date | DIMENSION | DATE | Date of the last status change of the opportunity |
| Opportunity | Last status change datetime | DIMENSION | DATETIME | Date and time of the last status change of the opportunity |
| Opportunity | Opportunity lost reason ID | DIMENSION | STRING | Lost reason ID of the opportunity |
| Opportunity | Opportunity pipeline ID | DIMENSION | STRING | Pipeline ID of the opportunity |
| Opportunity | Pipeline stage ID | DIMENSION | STRING | Pipeline stage ID of the opportunity |
| Opportunity | Pipeline stage UID | DIMENSION | STRING | Pipeline stage UID of the opportunity |
| Opportunity | Opportunity source | DIMENSION | STRING | Source of the opportunity |
| Opportunity | Opportunity status | DIMENSION | STRING | Status of the opportunity |
| Opportunity | Opportunity updated date | DIMENSION | DATE | Date when the opportunity was last updated |
| Opportunity | Opportunity updated datetime | DIMENSION | DATETIME | Date and time when the opportunity was last updated |
| Opportunity | Opportunity custom fields | DIMENSION | STRING | Raw custom field values of the opportunity as a JSON string |
| Opportunity | Opportunity followers | DIMENSION | STRING | Followers of the opportunity |
| Opportunity | Opportunity index version | DIMENSION | STRING | Search index version of the opportunity |
| Pipeline | Pipeline ID | DIMENSION | STRING | Pipeline's unique identifier |
| Pipeline | Pipeline name | DIMENSION | STRING | Name of the pipeline |
| Pipeline | Pipeline show in funnel | DIMENSION | BOOLEAN | Indicates if the pipeline is shown in the funnel view |
| Pipeline | Pipeline show in pie chart | DIMENSION | BOOLEAN | Indicates if the pipeline is shown in the pie chart view |
| Pipeline | Pipeline stage ID | DIMENSION | STRING | Unique identifier of the pipeline stage |
| Pipeline | Pipeline stage name | DIMENSION | STRING | Name of the pipeline stage |
| Pipeline | Pipeline stage position | DIMENSION | INTEGER | Position of the stage within the pipeline |
| Pipeline | Pipeline color render mode | DIMENSION | STRING | How pipeline/stage colors are rendered (dot, bg-tint, none) |
| Pipeline | Stage show in funnel | DIMENSION | BOOLEAN | Indicates if the pipeline stage is shown in the funnel view |
| Pipeline | Stage show in pie chart | DIMENSION | BOOLEAN | Indicates if the pipeline stage is shown in the pie chart view |
| Conversation | Conversation ID | DIMENSION | STRING | Conversation's unique identifier |
| Conversation | Conversation assigned to | DIMENSION | STRING | User assigned to the conversation |
| Conversation | Conversation company name | DIMENSION | STRING | Company name of the contact in the conversation |
| Conversation | Conversation contact ID | DIMENSION | STRING | ID of the contact associated with the conversation |
| Conversation | Conversation created date | DIMENSION | DATE | Date when the conversation was added |
| Conversation | Conversation created datetime | DIMENSION | DATETIME | Date and time when the conversation was added |
| Conversation | Conversation updated date | DIMENSION | DATE | Date when the conversation was last updated |
| Conversation | Conversation updated datetime | DIMENSION | DATETIME | Date and time when the conversation was last updated |
| Conversation | Conversation email | DIMENSION | STRING | Email of the contact in the conversation |
| Conversation | Conversation followers | DIMENSION | STRING | Followers of the conversation |
| Conversation | Conversation full name | DIMENSION | STRING | Full name of the contact in the conversation |
| Conversation | Last message internal comment | DIMENSION | BOOLEAN | Indicates if the last message is an internal comment |
| Conversation | Last manual message date | DIMENSION | DATE | Date of the last manual message in the conversation |
| Conversation | Last manual message datetime | DIMENSION | DATETIME | Date and time of the last manual message in the conversation |
| Conversation | Last message body | DIMENSION | STRING | Body of the last message in the conversation |
| Conversation | Last message date | DIMENSION | DATE | Date of the last message in the conversation |
| Conversation | Last message datetime | DIMENSION | DATETIME | Date and time of the last message in the conversation |
| Conversation | Last message direction | DIMENSION | STRING | Direction of the last message in the conversation |
| Conversation | Last message type | DIMENSION | STRING | Type of the last message in the conversation |
| Conversation | Last outbound message action | DIMENSION | STRING | Action of the last outbound message in the conversation |
| Conversation | Conversation phone | DIMENSION | STRING | Phone number of the contact in the conversation |
| Conversation | Conversation phone label | DIMENSION | STRING | Phone label of the contact in the conversation |
| Conversation | Conversation tags | DIMENSION | STRING | Tags associated with the conversation |
| Conversation | Conversation type | DIMENSION | STRING | Type of the conversation |
| User | User name | DIMENSION | STRING | Name of the user. Derived in Cube by combining first and last name (not stored). |
| User | User ID | DIMENSION | STRING | User's unique identifier |
| User | User first name | DIMENSION | STRING | First name of the user |
| User | User last name | DIMENSION | STRING | Last name of the user |
| User | User deleted | DIMENSION | BOOLEAN | Indicates if the user is deleted |
| User | User email | DIMENSION | STRING | Email of the user |
| User | User extension | DIMENSION | STRING | Phone extension of the user |
| User | User permissions | DIMENSION | STRING | Feature permissions of the user as a JSON string |
| User | User phone | DIMENSION | STRING | Phone number of the user |
| User | User platform language | DIMENSION | STRING | Platform language preference of the user |
| User | User role | DIMENSION | STRING | Role of the user (admin or user) |
| User | User role location ids | DIMENSION | STRING | Location IDs the user's role applies to, as a JSON string |
| User | User role type | DIMENSION | STRING | Role type of the user (account or agency) |
| User | User scopes | DIMENSION | STRING | OAuth scopes granted to the user |
| User | User LC phone | DIMENSION | STRING | LC Phone inbound phone number settings of the user as a JSON string |
| User | Role restrict sub account | DIMENSION | BOOLEAN | Indicates if the user's role is restricted to specific sub-accounts |
| Invoice | Invoice name | DIMENSION | STRING | Name of the invoice |
| Invoice | Invoice ID | DIMENSION | STRING | Invoice's unique identifier |
| Invoice | Automatic taxes calculated | DIMENSION | BOOLEAN | Indicates if automatic taxes have been calculated for the invoice |
| Invoice | Automatic taxes enabled | DIMENSION | BOOLEAN | Indicates if automatic taxes are enabled for the invoice |
| Invoice | Invoice business name | DIMENSION | STRING | Business name shown on the invoice |
| Invoice | Invoice contact details | DIMENSION | STRING | Contact details associated with the invoice |
| Invoice | Invoice contact email | DIMENSION | STRING | Email of the contact associated with the invoice |
| Invoice | Invoice contact ID | DIMENSION | STRING | ID of the contact associated with the invoice |
| Invoice | Invoice contact name | DIMENSION | STRING | Name of the contact associated with the invoice |
| Invoice | Invoice created date | DIMENSION | DATE | Date when the invoice was created |
| Invoice | Invoice created datetime | DIMENSION | DATETIME | Date and time when the invoice was created |
| Invoice | Invoice currency | DIMENSION | STRING | Currency of the invoice |
| Invoice | Invoice discount | DIMENSION | STRING | Discount applied to the invoice |
| Invoice | Invoice discount type | DIMENSION | STRING | Type of the discount applied to the invoice (percentage or fixed) |
| Invoice | Invoice discount value | DIMENSION | FLOAT | Value of the discount applied to the invoice |
| Invoice | Invoice due date | DIMENSION | DATE | Date when the invoice is due |
| Invoice | Invoice issue date | DIMENSION | DATE | Date when the invoice was issued |
| Invoice | Invoice items | DIMENSION | STRING | List of items included in the invoice |
| Invoice | Invoice live mode | DIMENSION | BOOLEAN | Indicates if the invoice is in live mode |
| Invoice | Invoice number | DIMENSION | STRING | Number of the invoice |
| Invoice | Invoice payment schedule | DIMENSION | STRING | Payment schedule for the invoice |
| Invoice | Invoice status | DIMENSION | STRING | Status of the invoice |
| Invoice | Invoice title | DIMENSION | STRING | Title of the invoice |
| Invoice | Invoice updated date | DIMENSION | DATE | Date when the invoice was last updated |
| Invoice | Invoice updated datetime | DIMENSION | DATETIME | Date and time when the invoice was last updated |
| Invoice | Invoice business logo URL | DIMENSION | IMAGE_URL | Business logo URL shown on the invoice |
| Invoice | Invoice business phone | DIMENSION | STRING | Business phone number shown on the invoice |
| Invoice | Invoice business website | DIMENSION | URL | Business website shown on the invoice |
| Invoice | Business address line 1 | DIMENSION | STRING | Business address line 1 shown on the invoice |
| Invoice | Business address line 2 | DIMENSION | STRING | Business address line 2 shown on the invoice |
| Invoice | Invoice business city | DIMENSION | CITY | Business city shown on the invoice |
| Invoice | Invoice business state | DIMENSION | REGION | Business state shown on the invoice |
| Invoice | Invoice business country | DIMENSION | COUNTRY_CODE | Business country code shown on the invoice |
| Invoice | Business postal code | DIMENSION | STRING | Business postal code shown on the invoice |
| Invoice | Invoice contact phone | DIMENSION | STRING | Phone number of the contact associated with the invoice |
| Invoice | Contact company name | DIMENSION | STRING | Company name of the contact associated with the invoice |
| Invoice | Contact address line 1 | DIMENSION | STRING | Address line 1 of the contact associated with the invoice |
| Invoice | Contact address line 2 | DIMENSION | STRING | Address line 2 of the contact associated with the invoice |
| Invoice | Invoice contact city | DIMENSION | CITY | City of the contact associated with the invoice |
| Invoice | Invoice contact state | DIMENSION | REGION | State of the contact associated with the invoice |
| Invoice | Invoice contact country | DIMENSION | COUNTRY_CODE | Country code of the contact associated with the invoice |
| Invoice | Invoice contact postal code | DIMENSION | STRING | Postal code of the contact associated with the invoice |
| Invoice | Reminders configuration | DIMENSION | STRING | Reminders configuration of the invoice as a JSON string |
| Order | Order ID | DIMENSION | STRING | Order's unique identifier |
| Order | Order contact ID | DIMENSION | STRING | Contact ID associated with the order |
| Order | Order coupon code | DIMENSION | STRING | Coupon code applied to the order |
| Order | Order created date | DIMENSION | DATE | Date when the order was created |
| Order | Order created datetime | DIMENSION | DATETIME | Date and time when the order was created |
| Order | Order created by | DIMENSION | STRING | User who created the order |
| Order | Order currency | DIMENSION | STRING | Currency of the order |
| Order | Order fulfillment status | DIMENSION | STRING | Fulfillment status of the order |
| Order | Order live mode | DIMENSION | BOOLEAN | Indicates if the order is in live mode |
| Order | Order source ID | DIMENSION | STRING | Source ID of the order |
| Order | Order source meta | DIMENSION | STRING | Source metadata of the order |
| Order | Order source name | DIMENSION | STRING | Source name of the order |
| Order | Order source sub type | DIMENSION | STRING | Source sub-type of the order |
| Order | Order source type | DIMENSION | STRING | Source type of the order |
| Order | Order status | DIMENSION | STRING | Status of the order |
| Order | Order updated date | DIMENSION | DATE | Date when the order was last updated |
| Order | Order updated datetime | DIMENSION | DATETIME | Date and time when the order was last updated |
| Transaction | Transaction ID | DIMENSION | STRING | Transaction's unique identifier |
| Transaction | Transaction charge ID | DIMENSION | STRING | Charge ID associated with the transaction |
| Transaction | Transaction charge snapshot | DIMENSION | STRING | Charge snapshot associated with the transaction |
| Transaction | Transaction contact ID | DIMENSION | STRING | Contact ID associated with the transaction |
| Transaction | Transaction created date | DIMENSION | DATE | Date when the transaction was created |
| Transaction | Transaction created datetime | DIMENSION | DATETIME | Date and time when the transaction was created |
| Transaction | Transaction created by | DIMENSION | STRING | User who created the transaction |
| Transaction | Transaction currency | DIMENSION | STRING | Currency of the transaction |
| Transaction | Transaction entity ID | DIMENSION | STRING | Entity ID of the transaction |
| Transaction | Entity source ID | DIMENSION | STRING | Entity source ID of the transaction |
| Transaction | Entity source meta | DIMENSION | STRING | Entity source metadata of the transaction |
| Transaction | Entity source name | DIMENSION | STRING | Entity source name of the transaction |
| Transaction | Entity source sub type | DIMENSION | STRING | Entity source sub-type of the transaction |
| Transaction | Entity source type | DIMENSION | STRING | Entity source type of the transaction |
| Transaction | Transaction entity type | DIMENSION | STRING | Entity type of the transaction |
| Transaction | Transaction fulfilled date | DIMENSION | DATE | Date when the transaction was fulfilled |
| Transaction | Transaction fulfilled datetime | DIMENSION | DATETIME | Date and time when the transaction was fulfilled |
| Transaction | Transaction IP address | DIMENSION | STRING | IP address associated with the transaction |
| Transaction | Transaction live mode | DIMENSION | BOOLEAN | Indicates if the transaction is in live mode |
| Transaction | Merged from contact ID | DIMENSION | STRING | Merged from contact ID associated with the transaction |
| Transaction | Transaction payment method | DIMENSION | STRING | Payment method used for the transaction |
| Transaction | Payment provider account | DIMENSION | STRING | Payment provider connected account of the transaction |
| Transaction | Payment provider type | DIMENSION | STRING | Payment provider type of the transaction |
| Transaction | Transaction status | DIMENSION | STRING | Status of the transaction |
| Transaction | Transaction subscription ID | DIMENSION | STRING | Subscription ID associated with the transaction |
| Transaction | Transaction updated date | DIMENSION | DATE | Date when the transaction was last updated |
| Transaction | Transaction updated datetime | DIMENSION | DATETIME | Date and time when the transaction was last updated |
| Subscription | Subscription ID | DIMENSION | STRING | Subscription's unique identifier |
| Subscription | Subscription contact ID | DIMENSION | STRING | Contact ID associated with the subscription |
| Subscription | Subscription currency | DIMENSION | STRING | Currency of the subscription |
| Subscription | Subscription status | DIMENSION | STRING | Status of the subscription |
| Subscription | Subscription live mode | DIMENSION | BOOLEAN | Indicates if the subscription is in live mode |
| Subscription | Subscription entity type | DIMENSION | STRING | Entity type of the subscription |
| Subscription | Subscription entity ID | DIMENSION | STRING | Entity ID of the subscription |
| Subscription | Entity source type | DIMENSION | STRING | Entity source type of the subscription |
| Subscription | Entity source name | DIMENSION | STRING | Entity source name of the subscription |
| Subscription | Payment provider type | DIMENSION | STRING | Payment provider type of the subscription |
| Subscription | Subscription created date | DIMENSION | DATE | Date when the subscription was created |
| Subscription | Subscription created datetime | DIMENSION | DATETIME | Date and time when the subscription was created |
| Subscription | Subscription updated date | DIMENSION | DATE | Date when the subscription was last updated |
| Subscription | Subscription updated datetime | DIMENSION | DATETIME | Date and time when the subscription was last updated |
| Subscription | Subscription created by | DIMENSION | STRING | User who created the subscription |
| Subscription | Entity source ID | DIMENSION | STRING | Entity source ID of the subscription |
| Subscription | Entity source meta | DIMENSION | STRING | Entity source metadata of the subscription as a JSON string |
| Subscription | Provider subscription ID | DIMENSION | STRING | Payment provider subscription ID of the subscription |
| Subscription | Subscription snapshot | DIMENSION | STRING | Snapshot of the subscription as a JSON string |
| Subscription | Payment provider account | DIMENSION | STRING | Payment provider connected account of the subscription |
| Subscription | Subscription IP address | DIMENSION | STRING | IP address from where the subscription was initiated |
| Appointment | Appointment ID | DIMENSION | STRING | Appointment's unique identifier |
| Appointment | Appointment title | DIMENSION | STRING | Title of the appointment |
| Appointment | Appointment calendar ID | DIMENSION | STRING | Calendar ID of the appointment |
| Appointment | Appointment contact ID | DIMENSION | STRING | Contact ID associated with the appointment |
| Appointment | Appointment group ID | DIMENSION | STRING | Calendar group ID of the appointment |
| Appointment | Appointment status | DIMENSION | STRING | Status of the appointment (new, confirmed, cancelled, showed, noshow, invalid) |
| Appointment | Assigned user ID | DIMENSION | STRING | User assigned to the appointment |
| Appointment | Appointment users | DIMENSION | STRING | Users associated with the appointment |
| Appointment | Appointment address | DIMENSION | STRING | Address of the appointment |
| Appointment | Appointment notes | DIMENSION | STRING | Notes of the appointment |
| Appointment | Appointment is recurring | DIMENSION | BOOLEAN | Indicates if the appointment is recurring |
| Appointment | Appointment RRULE | DIMENSION | STRING | Recurrence rule (iCalendar RFC 5545) of the recurring appointment |
| Appointment | Appointment start date | DIMENSION | DATE | Date the appointment starts |
| Appointment | Appointment start datetime | DIMENSION | DATETIME | Start time of the appointment |
| Appointment | Appointment end date | DIMENSION | DATE | Date the appointment ends |
| Appointment | Appointment end datetime | DIMENSION | DATETIME | End time of the appointment |
| Appointment | Appointment created date | DIMENSION | DATE | Date when the appointment was added |
| Appointment | Appointment created datetime | DIMENSION | DATETIME | Date and time when the appointment was added |
| Appointment | Appointment updated date | DIMENSION | DATE | Date when the appointment was last updated |
| Appointment | Appointment updated datetime | DIMENSION | DATETIME | Date and time when the appointment was last updated |
| Appointment | Created by source | DIMENSION | STRING | Source that created the appointment |
| Appointment | Created by user ID | DIMENSION | STRING | ID of the user who created or updated the appointment |
| Appointment | Appointment master event ID | DIMENSION | STRING | Master event ID for recurring appointment occurrences |
| Appointment | Appointment description | DIMENSION | STRING | Description of the appointment |
| Appointment | Assigned resources | DIMENSION | STRING | IDs of resources (rooms and/or equipment) assigned to the appointment as a JSON string |
| Calendar | Calendar ID | DIMENSION | STRING | Calendar's unique identifier |
| Calendar | Calendar name | DIMENSION | STRING | Name of the calendar |
| Calendar | Calendar description | DIMENSION | STRING | Description of the calendar |
| Calendar | Calendar type | DIMENSION | STRING | Type of the calendar (round_robin, event, class_booking, collective, service_booking, personal) |
| Calendar | Calendar widget type | DIMENSION | STRING | Widget type of the calendar |
| Calendar | Calendar event type | DIMENSION | STRING | Event type of the calendar |
| Calendar | Calendar event title | DIMENSION | STRING | Event title template of the calendar |
| Calendar | Calendar event color | DIMENSION | STRING | Event color of the calendar |
| Calendar | Calendar is active | DIMENSION | BOOLEAN | Indicates if the calendar is active |
| Calendar | Calendar group ID | DIMENSION | STRING | Group ID of the calendar |
| Calendar | Calendar slug | DIMENSION | STRING | Slug of the calendar |
| Calendar | Calendar slot duration | DIMENSION | INTEGER | Slot duration of the calendar |
| Calendar | Calendar slot interval | DIMENSION | INTEGER | Slot interval of the calendar |
| Calendar | Calendar slot buffer | DIMENSION | INTEGER | Slot buffer of the calendar |
| Calendar | Calendar auto confirm | DIMENSION | BOOLEAN | Indicates if bookings on the calendar are auto-confirmed |
| Calendar | Calendar allow reschedule | DIMENSION | BOOLEAN | Indicates if the calendar allows rescheduling |
| Calendar | Calendar allow cancellation | DIMENSION | BOOLEAN | Indicates if the calendar allows cancellation |
| Calendar | Is live payment mode | DIMENSION | BOOLEAN | Indicates if the calendar is in live payment mode |
| Calendar | Calendar sticky contact | DIMENSION | BOOLEAN | Indicates if sticky contact is enabled for the calendar |
| Calendar | Calendar widget slug | DIMENSION | STRING | Widget slug of the calendar |
| Calendar | Calendar team members | DIMENSION | STRING | Team members of the calendar as a JSON string |
| Calendar | Calendar open hours | DIMENSION | STRING | Standard availability open hours of the calendar as a JSON string |
| Calendar | Calendar availability type | DIMENSION | INTEGER | Availability type of the calendar (0 = open hours, 1 = custom availabilities) |
| Calendar | Calendar form ID | DIMENSION | STRING | Form ID attached to the calendar |
| Calendar | Calendar enable recurring | DIMENSION | BOOLEAN | Indicates if recurring appointments are enabled for the calendar |
| Calendar | Calendar slot duration unit | DIMENSION | STRING | Unit for the calendar slot duration (mins or hours) |
| Calendar | Calendar slot interval unit | DIMENSION | STRING | Unit for the calendar slot interval (mins or hours) |
| Calendar | Calendar slot buffer unit | DIMENSION | STRING | Unit for the calendar slot buffer (mins or hours) |
| Calendar | Calendar pre buffer | DIMENSION | INTEGER | Pre-buffer time added before an appointment |
| Calendar | Calendar pre buffer unit | DIMENSION | STRING | Unit for the calendar pre-buffer (mins or hours) |
| Calendar | Appointment per slot | DIMENSION | INTEGER | Maximum bookings per slot on the calendar |
| Calendar | Appointment per day | DIMENSION | INTEGER | Maximum appointments that can be booked per day on the calendar |
| Calendar | Allow booking after | DIMENSION | INTEGER | Minimum scheduling notice for booking events on the calendar |
| Calendar | Allow booking after unit | DIMENSION | STRING | Unit for the minimum scheduling notice (hours, days, weeks, months) |
| Calendar | Calendar allow booking for | DIMENSION | INTEGER | Duration for which booking is allowed on the calendar |
| Calendar | Allow booking for unit | DIMENSION | STRING | Unit for the duration for which booking is allowed (days, weeks, months) |
| Calendar | Calendar notes | DIMENSION | STRING | Notes configured on the calendar |
| Calendar | Calendar pixel ID | DIMENSION | STRING | Tracking pixel ID configured on the calendar |
| Calendar | Calendar guest type | DIMENSION | STRING | Guest type of the calendar (count_only or collect_detail) |
| Calendar | Calendar availabilities | DIMENSION | STRING | Custom availabilities of the calendar as a JSON string |
| Calendar | Calendar recurring configuration | DIMENSION | STRING | Recurring appointment configuration of the calendar as a JSON string |
| Task | Task ID | DIMENSION | STRING | Task's unique identifier |
| Task | Task title | DIMENSION | STRING | Title of the task |
| Task | Task body | DIMENSION | STRING | Body of the task |
| Task | Task assigned to | DIMENSION | STRING | User assigned to the task |
| Task | Task contact ID | DIMENSION | STRING | Contact ID associated with the task |
| Task | Task completed | DIMENSION | BOOLEAN | Indicates if the task is completed |
| Task | Task due date | DIMENSION | DATE | Date the task is due |
| Task | Task due datetime | DIMENSION | DATETIME | Date and time when the task is due |
| Task | Task created date | DIMENSION | DATE | Date when the task was added |
| Task | Task created datetime | DIMENSION | DATETIME | Date and time when the task was added |
| Task | Task updated date | DIMENSION | DATE | Date when the task was last updated |
| Task | Task updated datetime | DIMENSION | DATETIME | Date and time when the task was last updated |
| Task | Task deleted | DIMENSION | BOOLEAN | Indicates if the task is deleted |
| Task | Task business ID | DIMENSION | STRING | Business ID associated with the task |
| Form | Form ID | DIMENSION | STRING | Form's unique identifier |
| Form | Form name | DIMENSION | STRING | Name of the form |
| Form submission | Form submission ID | DIMENSION | STRING | Form submission's unique identifier |
| Form submission | Form submission contact ID | DIMENSION | STRING | Contact ID associated with the form submission |
| Form submission | Form submission form ID | DIMENSION | STRING | Form ID associated with the form submission |
| Form submission | Form submission name | DIMENSION | STRING | Name captured in the form submission |
| Form submission | Form submission email | DIMENSION | STRING | Email captured in the form submission |
| Form submission | Form submission created date | DIMENSION | DATE | Date when the form submission was created |
| Form submission | Form submission created datetime | DIMENSION | DATETIME | Date and time when the form submission was created |
| Form submission | Event source | DIMENSION | STRING | Attribution source of the form submission event |
| Form submission | Event medium | DIMENSION | STRING | Attribution medium of the form submission event |
| Form submission | Event ad source | DIMENSION | STRING | Ad source of the form submission event |
| Form submission | Event medium ID | DIMENSION | STRING | Attribution medium ID of the form submission event |
| Form submission | Event referrer | DIMENSION | STRING | Referrer of the form submission event |
| Form submission | Event page URL | DIMENSION | URL | Page URL of the form submission event |
| Form submission | Event page title | DIMENSION | STRING | Page title of the form submission event |
| Form submission | Form submission event type | DIMENSION | STRING | Type of the form submission event |
| Form submission | Event domain | DIMENSION | STRING | Domain of the form submission event |
| Form submission | Form submission event FBC | DIMENSION | STRING | Facebook click cookie (fbc) of the form submission event |
| Form submission | Form submission event FBP | DIMENSION | STRING | Facebook browser cookie (fbp) of the form submission event |
| Form submission | Event FB event ID | DIMENSION | STRING | Facebook event ID of the form submission event |
| Form submission | Form submission others | DIMENSION | STRING | Full raw others payload of the form submission as a JSON string |
| Survey | Survey ID | DIMENSION | STRING | Survey's unique identifier |
| Survey | Survey name | DIMENSION | STRING | Name of the survey |
| Survey submission | Survey submission ID | DIMENSION | STRING | Survey submission's unique identifier |
| Survey submission | Contact ID | DIMENSION | STRING | Contact ID associated with the survey submission |
| Survey submission | Survey submission survey ID | DIMENSION | STRING | Survey ID associated with the survey submission |
| Survey submission | Survey submission name | DIMENSION | STRING | Name captured in the survey submission |
| Survey submission | Survey submission email | DIMENSION | STRING | Email captured in the survey submission |
| Survey submission | Created date | DIMENSION | DATE | Date when the survey submission was created |
| Survey submission | Survey submission created datetime | DIMENSION | DATETIME | Date and time when the survey submission was created |
| Survey submission | Event source | DIMENSION | STRING | Attribution source of the survey submission event |
| Survey submission | Event medium | DIMENSION | STRING | Attribution medium of the survey submission event |
| Survey submission | Event referrer | DIMENSION | STRING | Referrer of the survey submission event |
| Survey submission | Event page URL | DIMENSION | URL | Page URL of the survey submission event |
| Survey submission | Survey submission others | DIMENSION | STRING | Full raw others payload of the survey submission as a JSON string |
| Workflow | Workflow ID | DIMENSION | STRING | Workflow's unique identifier |
| Workflow | Workflow name | DIMENSION | STRING | Name of the workflow |
| Workflow | Workflow status | DIMENSION | STRING | Status of the workflow |
| Workflow | Workflow version | DIMENSION | INTEGER | Version number of the workflow |
| Workflow | Workflow created date | DIMENSION | DATE | Date when the workflow was created |
| Workflow | Workflow created datetime | DIMENSION | DATETIME | Date and time when the workflow was created |
| Workflow | Workflow updated date | DIMENSION | DATE | Date when the workflow was last updated |
| Workflow | Workflow updated datetime | DIMENSION | DATETIME | Date and time when the workflow was last updated |
| Tag | Tag ID | DIMENSION | STRING | Tag's unique identifier |
| Tag | Tag name | DIMENSION | STRING | Name of the tag |