Subject: UltraCart - Update on Data Warehouse (BigQuery)
From: UltraCart Support Team <[email-masked]>
To: Deeksha Dadu <[email-masked]>
Date: Thu, 13 Jan 2022 20:21:24 +0000

Quickly setup and manage large amounts of customer, item, order and auto order
data using UltraCarts Big Data features!

Data Warehouse(BigQuery)

New Tables!

Just like Christmas... only better! We're now sending even more actionable data
over to BigQuery. The available dataset has been expanded to include Affiliate
information, StoreFront data, Auto Orders, Upsell data, and more.

Information about auto orderTable Name: auto_orders

Information about customersTable Name: customers

Information about itemsTable Name: items

Information about ordersTable Name: orders

NEW Information about affiliatesTable Name: affiliate

NEW Information about affiliate clicks and interactionsTable Name:
affiliate_click

NEW Information about the Affiliate ledgerTable Name: affiliate_ledger

NEW Information about the rotating gateway transaction history Table Name:
rotating_transaction_gateway_history

NEW Information about screen recordingTable Name: screen_recording

NEW Information about StoreFrontsTable Name: storefront

NEW Information about StoreFront experiments Table Name: storefront_experiment

NEW Information about StoreFront Upsell PathsTable Name: storefront_upsell_path

NEW Information about StoreFront Upsell Path OffersTable Name:
storefront_upsell_offer

NEW Information about StoreFront Upsell OfferTable Name:
storefront_upsell_offer_event

NEW Information about TowerData Email IntelligenceTable Name:
towerdata_email_intelligence

What is a Data Warehouse?

A data warehouse is an enterprise grade system that is used for reporting and
data analysis as a core component of business intelligence. Data warehouses are
the central repositories where data from one or more different sources are
brought together for analysis.

Learn More ( https://ultracart.atlassian.net/wiki/spaces/ucdoc/pages/994705409/Data+Warehouse+BigQuery?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Data+Warehouse+with+Big+Query+-+Update&utm_content=1b85b5f5-f629-4819-9e47-5d4553457943%7Cde98145c-d2c7-4bdf-8221-ec41f796177b%7C1f01a00e-895f-4e74-bfd9-e27444d5bfbd%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 )

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

Step 1Google Cloud Configuration

Get started by creating a project within Google Cloud. Set up Google BigQuery, a
Cloud Storage bucket and a service account with proper permissions.

Google Cloud Config Docs ( https://ultracart.atlassian.net/wiki/spaces/ucdoc/pages/994705409/Data+Warehouse+BigQuery?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Data+Warehouse+with+Big+Query+-+Update&utm_content=1b85b5f5-f629-4819-9e47-5d4553457943%7Cde98145c-d2c7-4bdf-8221-ec41f796177b%7C1f01a00e-895f-4e74-bfd9-e27444d5bfbd%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6#Google-Cloud-Configuration )

Step 2UltraCart Configuration

Connect your BigQuery dataset, Cloud Storage bucket and assign your tables, then
activate the feature in UltraCart and you're good to go!

UltraCart Set Up Docs ( https://ultracart.atlassian.net/wiki/spaces/ucdoc/pages/994705409/Data+Warehouse+BigQuery?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Data+Warehouse+with+Big+Query+-+Update&utm_content=1b85b5f5-f629-4819-9e47-5d4553457943%7Cde98145c-d2c7-4bdf-8221-ec41f796177b%7C1f01a00e-895f-4e74-bfd9-e27444d5bfbd%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6#UltraCart-Configuration )

How does UltraCart Data Warehouse work?

UltraCart keeps your data warehouse fresh with the latest changes using secure
communication with your Google Cloud project.

What UltraCart plans support it?

At this time, only large and enterprise plans support this feature.

What does UltraCart Data Warehouse cost?

Free with your large or enterprise plan!

More FAQ ( https://ultracart.atlassian.net/wiki/spaces/ucdoc/pages/994705409/Data+Warehouse+BigQuery?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Data+Warehouse+with+Big+Query+-+Update&utm_content=1b85b5f5-f629-4819-9e47-5d4553457943%7Cde98145c-d2c7-4bdf-8221-ec41f796177b%7C1f01a00e-895f-4e74-bfd9-e27444d5bfbd%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6#FAQ )

Pro Services

Need some help getting started? UltraCart can help you get up and running
quickly. We're here to assist you with general account information, payment
processing configuration, StoreFront set up, basic shipping set up, and more.

Contact Pro Services ( https://www.ultracart.com/help/pro-services.html?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Data+Warehouse+with+Big+Query+-+Update&utm_content=1b85b5f5-f629-4819-9e47-5d4553457943%7Cde98145c-d2c7-4bdf-8221-ec41f796177b%7C1f01a00e-895f-4e74-bfd9-e27444d5bfbd%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 )

| Home ( https://www.ultracart.com?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Data+Warehouse+with+Big+Query+-+Update&utm_content=1b85b5f5-f629-4819-9e47-5d4553457943%7Cde98145c-d2c7-4bdf-8221-ec41f796177b%7C1f01a00e-895f-4e74-bfd9-e27444d5bfbd%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 ) | Login ( https://secure.ultracart.com?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Data+Warehouse+with+Big+Query+-+Update&utm_content=1b85b5f5-f629-4819-9e47-5d4553457943%7Cde98145c-d2c7-4bdf-8221-ec41f796177b%7C1f01a00e-895f-4e74-bfd9-e27444d5bfbd%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 ) | Docs ( https://docs.ultracart.com?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Data+Warehouse+with+Big+Query+-+Update&utm_content=1b85b5f5-f629-4819-9e47-5d4553457943%7Cde98145c-d2c7-4bdf-8221-ec41f796177b%7C1f01a00e-895f-4e74-bfd9-e27444d5bfbd%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 ) | Support (
[email-masked]?utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Data+Warehouse+with+Big+Query+-+Update&utm_content=1b85b5f5-f629-4819-9e47-5d4553457943%7Cde98145c-d2c7-4bdf-8221-ec41f796177b%7C1f01a00e-895f-4e74-bfd9-e27444d5bfbd%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6
) |

Copyright © 2021 UltraCart, All rights reserved.

No longer want to receive these emails? You can unsubscribe here ( https://marketing.ultracart.com/checkout/unsubscribeLoad.do?espCommseqUuid=1f01a00e-895f-4e74-bfd9-e27444d5bfbd&espCommseqStepUuid=de98145c-d2c7-4bdf-8221-ec41f796177b&espCommseqEmailUuid=1b85b5f5-f629-4819-9e47-5d4553457943&espCustomerUuid=c74e4fad-38be-43f0-9e32-d0dc24e764d6&utm_source=ultracart&utm_medium=email&utm_campaign=UltraCart+-+Data+Warehouse+with+Big+Query+-+Update&utm_content=1b85b5f5-f629-4819-9e47-5d4553457943%7Cde98145c-d2c7-4bdf-8221-ec41f796177b%7C1f01a00e-895f-4e74-bfd9-e27444d5bfbd%7Cc74e4fad-38be-43f0-9e32-d0dc24e764d6 ).

ultracart.com - , Merced, CA 95340