Every users' RevCent data is securely stored within Google BigQuery, an enterprise level big data warehouse in the cloud. RevCent immediately streams updates to BigQuery when changes occur within a users' account, ensuring up to date metrics. BigQuery was built to handle petabyte sized queries, ensuring all of your data is queryable regardless of total dataset size.
RevCent users have the ability to run SQL queries on their data using the RevCent API, within AI Assistant steps via system tools, directly using the RevCent MCP or granting BigQuery access to their own Google account.
Download the tables.json file to view all available tables, schemas and respective fields.
Note: Data stored in BigQuery is immutable. DML statements and table modifications are not possible.
RevCent integrates directly with BigQuery, constantly updating user data for up to date reporting capabilities.
There are many ways to utilize the data stored in your BigQuery dataset. Below are a few examples.
There are multiple ways to run a query on your data, either directly or indirectly, using natural language or raw SQL.
Use natural language and the RevCent MCP. Connect the MCP to your AI chat/harness to have your AI generate a proper SQL statement. Useful for wanting metrics when chatting with AI, automating third party AI Agents and more.
Use natural language within an AI Assistant step, which the AI will convert to a proper SQL statement. Useful for automating reports, analyze metrics, etc.
Run a raw SQL query using the API via the BigQueryRunQuery operation. You must create the SQL statement from scratch utilizing the available table schemas. Run the operation with your raw sql as the bigquery_sql property.
Run a raw SQL query within the Google BigQuery UI. Grant yourself or trusted individuals direct access to your BigQuery dataset via the BigQuery Access tool in the RevCent web app. This gives you the ability to run raw SQL and even grant third party analytics services access to your data. Warning: granting access will make all of your RevCent data available to individuals or third parties you give access to.
The following tables are contained within each users' individual BigQuery dataset. Access tables via the “revcent.user.table_name” when running SQL queries. Use the API to get a list of tables , or download the BigQuery tables.json file containing all tables and their schemas. AI Assistants and the MCP server also includes the GetBigQueryTables operation for proper SQL generation when using natural language to SQL.
The following tables are available within a users' BigQuery dataset. Download the tables.json file to view individual table schemas their and respective fields.
| Name | ID | Description | SQL |
|---|---|---|---|
| AI Assistant | ai_assistant | The AI assistant table contains all AI assistants created. | `revcent.user.ai_assistant` |
| AI Voice Agent | ai_voice_agent | The AI voice agent table contains all AI voice agents created. | `revcent.user.ai_voice_agent` |
| AI Voice Call | ai_voice_call | The AI voice call table contains all AI voice calls created. An AI voice call is created when an outbound or inbound call occurs, and is associated with an AI Voice Agent. | `revcent.user.ai_voice_call` |
| API Call | api_call | The API call table contains all API calls created | `revcent.user.ai_voice_call` |
| Campaign | campaign | The campaign table contains all campaigns created. A campaign is created by the user and is a mechanism for organizing sales and their origin. | `revcent.user.campaign` |
| Chargeback | chargeback | The chargeback table contains all chargebacks created. A chargeback is created either manually or via API. | `revcent.user.chargeback` |
| Check | check | The check table contains all checks created. A check is created when a sale is created with a payment type of check_direct. | `revcent.user.check` |
| Coupon | coupon | The coupon table contains all coupons created. A coupon is created by the user with specific discount settings and usage periods. | `revcent.user.coupon` |
| Customer | customer | The customer table contains all customers created. A customer can be created manually, via API or automatically during a purchase attempt. | `revcent.user.customer` |
| Customer Card | customer_card | The customer card table contains all customer cards created. A customer card can be created manually or is automatically created during a purchase attempt. Does not contain sensitive information such as raw card numbers. | `revcent.user.customer_card` |
| Customer Group | customer_group | The customer group table contains all customer groups created. A customer group is created by the user to segment customers based on specific qualifiers and values. | `revcent.user.customer_group` |
| Discount | discount | The discount table contains all discounts created. A discount is created either manually, via API sales calls, or via a coupon. | `revcent.user.discount` |
| Fraud Detection | fraud_detection | The fraud detection table contains all fraud detections created. A fraud detection is created either manually, by a third party or when the internal anti-fraud system, Sentinel, detects a fraudulent purchase attempt. | `revcent.user.fraud_detection` |
| Fulfillment Account | fulfillment_account | The fulfillment account table contains all fulfillment accounts created. A fulfillment account is created by the user and is associated with a third party fulfillment center. | `revcent.user.fulfillment_account` |
| Gateway | gateway | The gateway table contains all gateways created. A gateway is created by the user and is associated with a third party credit card merchant account. | `revcent.user.gateway` |
| Note | note | The note table contains all notes created. A note is created using the API or within the web app. | `revcent.user.note` |
| Offline Payment | offline_payment | The offline payment table contains all offline payments created. An offline payment is created when a sale with a payment type of "offline_payment" is sold to a customer. Offline payments may also be from Affirm, Klarna, AfterPay, Sezzle and other third party alternate payment providers. | `revcent.user.offline_payment` |
| Payment Profile | payment_profile | The payment profile table contains all payment profiles created by the user. A payment profile is a credit card transaction routing mechanism, allowing a user to strategically route payment requests to specific merchant gateways. | `revcent.user.payment_profile` |
| PayPal Account | paypal_account | The PayPal account table contains all PayPal accounts added by the user. | `revcent.user.paypal_account` |
| PayPal Dispute | paypal_dispute | The PayPal dispute table contains all PayPal disputes created. | `revcent.user.paypal_dispute` |
| PayPal Transaction | paypal_transaction | The PayPal transaction table contains all PayPal transactions created. A PayPal transaction is created when a sale with payment type paypal is created. | `revcent.user.paypal_transaction` |
| Pending Refund | pending_refund | The pending refund table, a.k.a refund table, contains all refunds created. | `revcent.user.pending_refund` |
| Product | product | The product table contains all products created. A product is a line item which is purchased during a sale, and every sale must have at least one product. Products can create subscriptions, trials or be unbundled at time of sale or fulfillment. | `revcent.user.product` |
| Product Group | product_group | The product group table contains all product groups created. A product group is a way to organizing related products for multi product management, filtering and more. | `revcent.user.product_group` |
| Product Sale | product_sale | The product sale table contains all product sales created. A product sale is the line item purchase of a specific product within an individual sale, i.e. a line item within a sale. The product sale entity allows advanced metrics on a product specific level. | `revcent.user.product_sale` |
| Sale | sale | The sale table contains all sales created. A sale is created when a customer attempts to purchase one or more products. | `revcent.user.sale` |
| Salvage Transaction | salvage_transaction | The salvage transaction table contains all salvage transactions created. A salvage transaction is created when a credit card transaction is fully or partially declined. Salvage transactions allow the user to recoup/recover revenue at a later date. | `revcent.user.salvage_transaction` |
| Shipping | shipping | The shipping table contains all shipments created. A shipment is created when a shippable product is sold to a customer in a sale, subscription renewal or trial expiration. | `revcent.user.shipping` |
| Subscription | subscription | The subscription table contains all subscriptions created. A subscription is created when a product with an associated subscription profile is sold to a customer in a sale. | `revcent.user.subscription` |
| Subscription Profile | subscription_profile | The subscription profile table contains all subscription profiles created by the user. Every subscription has an associated subscription profile which determines the renewal cycle for said subscriptions. | `revcent.user.subscription_profile` |
| Subscription Renewal | subscription_renewal | The subscription renewal table contains subscription renewals created when a specific subscription renewal cycle determines a recurring transaction should be processed. The renewal cycle settings are described in the associated subscription profile for the parent subscription. | `revcent.user.subscription_renewal` |
| Tax | tax | The tax table contains tax created during an initial sale, renewal, trial expiration or salvage transaction. | `revcent.user.tax` |
| Third Party Shop | third_party_shop | The third party shop table contains shopping cart domains and/or stores added to RevCent by the user. | `revcent.user.third_party_shop` |
| Tracking Domain | tracking_domain | The tracking domain table contains tracking domains added to RevCent by the user. A tracking domain is a specific user domain which has the RevCent tracking snippet installed. Used for tracking conversions between visitors and sales. | `revcent.user.tracking_domain` |
| Tracking Entry | tracking_entry | The tracking entry table contains individual page visits by a tracking visitor to a specific tracking domain. | `revcent.user.tracking_entry` |
| Tracking Visitor | tracking_visitor | The tracking visitor table consists of visitors to a specific user domain tracked by RevCent for conversion statistics and anti-fraud. | `revcent.user.tracking_visitor` |
| Transaction | transaction | The transaction table consists of credit card transactions processed with a specific merchant gateway, either as a capture or a refund. | `revcent.user.transaction` |
| Trial | trial | The trial table contains all trials created. A trial is created when a product with a trial period setting is sold to a customer in a sale. | `revcent.user.trial` |
| User | user | The user table contains users associated with the RevCent account, including account owner, administrator, supervisors and employees. | `revcent.user.user` |