UltraCart will handle the data transfer into BigQuery on an automated base. Businesses can then use the information to feed support systems, write reports, and join up with other data systems for operational analysis.
Working with a large historical data set across all our UltraCart accounts, the UltraCart integration with Google Big Query allows us complete freedom to design complex reporting using virtually any modern BI tool. Because BigQuery is designed as a massive scale data warehouse our monthly costs are less than $15 when working with records across all our UltraCart accounts.
Chris G. - Meliorra Brands
General order details: Date, ID, Items, Cost Details, and more.
General item details: SKUs, Descriptions, price, and more.
General customer details: Name, Email, Address, Orders and more.
General affiliate details: Name, Orders, Address, and more.
General StoreFront details: Experiments, Upsells, Events, and more.
General transaction gateway details: Transaction Gateway Name, Process Frequency, Process Value and more.
General screen recording details: Recording Date, Recording Duration, Recording User and more.
General towerdata intelligence information details: Household, Demographics, Interests and more.
Introduction UltraCart's Data Warehouse (BigQuery) feature allows for a business to quickly setup a data warehouse of their customers, items, orders and auto order information with Google's BigQuery database service.
Google Cloud Configuration Establishing a project within Google's cloud, setting up BigQuery, setting up a Storage bucket, and setting up a service account user with proper permissions.
UltraCart Account Configuration Once configured, the data warehouse should populate within one hour the first time.
Frequently Asked Questions How does this data warehouse work? What UltraCart plans support it? and more.
Sample Queries Active Auto Order Next Rebill, Revenue Per Item Over a Certain Time Period, Orders For Specific Items Shipped By a User on a Specific Date, and more.
The UltraCart Developer Account provides you with a sandbox to quickly and easily move forward without the typical account sharing roadblocks. StoreFronts within the developer account must remain locked until they are pushed to an active UltraCart account or the developer account is changed to a paid account.Get Started!