Prebuilt Analytics using Shopify

Prebuilt Analytics using Shopify

Zoho Advanced Analytics app provides you in-depth e-commerce analytics on your store data in Shopify. With this connector, you can effectively track key business metrics such as product performance, shipment handling, customer preferences, order transactions, inventory management, and many more...

This app is bundled with 100+ pre-built reports and dashboards which give deep insights over your store data in great detail. 

  1. In what format will my Shopify data appear in the Zoho Advanced Analytics?
  2. What are the default reports and dashboards offered with this app?
  3. What are the default formulas available on setting up this app?
  4. Can I create my own reports in the Zoho Advanced Analytics app?
  5. Can I create my own query tables?
  6. Can I create my own custom formulas in the Zoho Advanced Analytics app?
  7. Can I add new data tables in this app to create reports & dashboards?
  8. Can I combine data from other sources with the data from Shopify to create reports and dashboards?
  9. Can I join data from multiple tables to create reports?

1. In what format will my Shopify data appear in Zoho Advanced Analytics?

Your Shopify data will be segregated into tables for easy analysis purposes. Each table in your Zoho Advanced Analytics Home page represents a module and each column in the table represents the fields on which you can create views.

The following data modules will be automatically synced to your Zoho Advanced Analytics app:

ModuleFields
Shop

Shop ID, Store Name, Email ID, Store Domain, Phone, Primary Locale, Created At, Updated At, Currency, Customer Email, TimeZone, Store Owner, Money Format, Weight Unit, Taxes Included, Tax Shipping, County Taxes, Plan Name, Has Discounts, Has GiftCards, Shopify Domain, Google Apps Domain, Eligible For Payments, Requires Extra Payments, Password Enabled, Has StoreFront, Finances, Primary Location ID, Checkout API Support, Multi Location Enabled, Setup Required, Force SSL, Pre Launch Enabled

Customer 

Customer ID, Email, Accepts Marketing, Created At, Updated At, First Name, Last Name, State, Note, Verified Email, Multipass Identifier, Tax Exempt, Phone, Tags, Currency, isDefault Address ID

Customer Address

Address ID, Customer ID, First Name, Last Name, Company, Address Line 1, Address Line 2, City, Province, Country, ZIP, Phone, isDefault

Product

Product ID, Product Name, HTML Body, Vendor, Product Type, Created At, Handle, Updated At, Published At, Template Suffix, Tags, Published Scope

Product Variants

Variant ID, Product ID, Variant Name, Price, SKU, Position, Inventory Policy, Compare At Price, Fulfillment Service, Inventory Management, Created At, Updated At, Taxable, Barcode, Weight in grams, Inventory Item ID, Inventory Quantity, Requires Shipping

Discounts 

Discount ID, Value Type, Value, Customer Selection, Target Type, Target Selection, Allocation Method, Allocation Limit, Once Per Customer, Usage Limit, Starts At, Ends At, Created At, Updated At, Code, Prerequisite Quantity, Entitled Quantity, Prerequisite Quantity Range, Prerequisite Subtotal Range, Prerequisite Shipping Range

Discount Entitled Products

Discount ID, Product ID

Discount Entitled Collections

Discount ID, Collection ID

Discount Entitled Country

Discount ID, Country ID

Discount Entitled Variants

Discount ID, Variant ID

Discount Prerequisite Collection

Discount ID, Collection ID

Discount Prerequisite Customers

Discount ID, Customer ID

Discount Prerequisite Product

Discount ID, Product ID

Discount Prerequisite Saved Searches

Discount ID, Saved Search ID

Discount Prerequisite Variants

Discount ID, Variant ID

Order 

Order ID, Email, Closed At, Created At, Updated At, Number, Note, Token, Gateway, Total Price, Subtotal Price, Total weight, Total Tax, Tax Included, Currency, Financial Status, Confirmed, Total Discount, Total Line Items Price, Cart Token, Accepts Marketing, Name, Referring Site, Landing Site, Canceled At, Cancel Reason, Total Price USD, Checkout Token, Reference, User ID, Location ID, Source Identifier, Source URL, Processed At, Device ID, Customer Locale, App ID, Landing Site Ref, Order Number, Customer ID, Payment Gateways, Processing Method, Source Name, Fulfillment Status, Tags, Contact Email, Order Status URL, Presentment Currency, Total Line Items Price Shop Amount, Total Line Items Price Shop Currency, Total Line Items Presentment Currency, Total Line Items Presentment Amount, Total Discount Shop Currency, Total Shipping Presentment Currency, Total Shipping Presentment Amount, Subtotal Price Set Shop Amount, Subtotal Price Set Shop Currency, Subtotal Price Set Presentment Currency, Subtotal Price Set Presentment Amount, Total Price Shop Amount, Total Price Shop Currency, Total Price Presentment Currency, Total Price Presentment Amount, Total Tip Received, Billing First Name, Billing Address Line 1, Billing Phone, Billing City, Billing Zip, Billing Province, Billing Country, Billing Last Name, Billing Address Line 2, Billing Company, Billing Latitude, Billing Longitude, Shipping First Name, Shipping Address Line 1, Shipping Phone, Shipping City, Shipping Zip, Shipping Province, Shipping Country, Shipping Last Name, Shipping Address Line 2, Shipping Company, Shipping Latitude, Shipping Longitude, Client Browser IP, Client Accept Language, Client User Agent, Client Session Hash

Order Line Items

Line Item ID, Order ID, Variant ID, Title, Quantity, Price, SKU, Vendor, Fulfillment Service, Product ID, Requires Shipping, Taxable, Gift Card, Variant Inventory Management, Product Exists, Fulfillable Quantity, Weight, Total Discount, Fulfillment Status, Price Shop Money, Price Presentment Money, Price Shop Currency, Price Presentment Currency, Discount Shop Money, Discount Presentment Money, Discount Shop Currency, Discount Presentment Currency

Order Line Item Properties

Order ID, Order Line Item ID, Name, Value

Order Line Items Tax

Lines Order ID, Order Line Item ID, Title, Price, Rate, Tax Shop Amount, Tax Presentment Amount, Tax Shop Currency, Tax Presentment Currency

Order Note Attributes

Order ID, Name, Value

Order Line Items Discount Allocations

Order ID, Order Line Item ID, Amount, Amount Shop Money, Amount Shop Currency, Amount Presentment Money, Amount Presentment Currency, Discount Application Index

Order Discount Applications

Order ID, Discount Allocation ID, Type, Value, Value Type, Allocation Method, Target Selection, Target Type, Code, Description

Order Shipping Lines Shipping

Line ID, Order ID, Price, Code, Source, Phone, Title, Requested Fulfillment Service ID, Discounted Price, Price set Shop Money, Price set Presentment Money, Price set Shop Currency, Price set Presentment Currency, Discount set Shop Money, Discount set Presentment Money, Discount set Shop Currency, Discount set Presentment Currency, Carrier Identifier

Order Shipping Line Tax Lines

Order ID, Order Line Item ID, Title, Price, Rate, Tax Shop Amount, Tax Presentment Amount, Tax Shop Currency, Tax Presentment Currency

Fulfillments

FulFillment ID, Order ID, Status, Created At, Updated At, Service, Tracking Company, Shipment Status, Location ID, Tracking Number, Tracking URL, Name, Testcase, Authorization

Fulfillments Line Items

Order ID, Fulfillment ID, Line Item ID, Variant ID, Title, Quantity, Price, SKU, Vendor, Fulfillment Service, Product ID, Requires Shipping, Taxable, Gift Card, Variant Inventory Management, Product Exists, Fulfillable Quantity, Weight, Total Discount, Fulfillment Status, Price Shop Money, Price Presentment Money, Price Shop Currency, Price Presentment Currency, Discount Shop Money, Discount Presentment Money, Discount Shop Currency, Discount Presentment Currency

Fulfillment Tracking Numbers

Order ID, Fulfillment ID, Tracking Number

Fulfillment Tracking URLs

Order ID, Fulfillment ID, Tracking URL

Smart Collections

Smart Collection ID, Collection Name, Collection Handle, Updated At, HTML Body, Published At, Sort Order, Template Suffix, Disjunctive, Published Scope

Collections

Collection ID, Collection Name, Collection Handle, Updated At, HTML Body, Published At, Sort Order, Template Suffix, Published Scope

Refunds

Refund ID, Order ID, Created At, Note, User ID, Processed At, Restock

Refund Order Adjustments Order 

Adjustment ID, Order ID, Refund ID, Amount, Tax Amount, Kind, Reason, Amount Shop money, Amount Shop currency, Amount Presentment money, Amount Presentment currency, Tax Shop money, Tax Shop currency, Tax Presentment money, Tax Presentment currency

Order Transactions

Transaction ID, Order ID, Kind, Gateway, Status, Message, Created At, Test, Authorization, Location ID, User ID, Parent ID, Processed At, Device ID, Source Name, Amount, Currency, Refund ID

Refund Line Items 

Order ID, Refund Line Item ID, Refund ID, Quantity, Order Line Item ID, Location ID, Restock Type, Subtotal, Total Tax, Subtotal Shop Money, Subtotal Shop Currency, Subtotal Presentment Money, Subtotal Presentment Currency, Total Tax Shop Money, Total Tax Shop Currency, Total Presentment Money, Total Presentment Currency

Order Line Items Discount Allocations

Order ID, Order Line Item ID, Amount, Amount Shop Money, Amount Shop Currency, Amount Presentment Money, Amount Presentment Currency, Discount Application Index

Tender Transactions

Transaction ID, Order ID, Amount, Currency, User ID, Test, Processed At, Remote Reference, Payment Method, Payment Credit Card Number, Payment Card Company

Collection Products

ID, Collection ID, Product ID, Created At,Updated At, Position, Sort Value

Events 

Event ID, Subject ID, Created At, Subject Type, Action, Body, Message, Author, Description, Path

Countries

Country ID, Name, Tax, Tax Name, Code

Shop Location

Location ID, Shop Name, Address Line 1, Address Line 2, City, ZIP, Province, Country, Phone, Created At, Updated At, Legacy, Active

Provinces

Country ID, Province ID, Name, Tax, Tax Name, Code, Tax Type, Tax Percentage

Draft Orders

Draft Order ID, Note, Email, Taxes Included, Currency, Subtotal Price, Total Tax, Total Price, Invoice Sent At, Created At, Updated At, Tax Exempt, Completed At, Name, Status, Shipping First Name, Shipping Address Line 1, Shipping Phone, Shipping City, Shipping Zip, Shipping Province, Shipping Country, Shipping Last Name, Shipping Address Line 2, Shipping Company, Shipping Latitude, Shipping Longitude, Billing First Name, Billing Address Line 1, Billing Phone, Billing City, Billing Zip, Billing Province, Billing Country, Billing Last Name, Billing Address Line 2, Billing Company, Billing Latitude, Billing Longitude, Invoice URL, Applied Discount Description, Applied Discount Value, Applied Discount Title, Applied Discount Amount, Applied Discount Value Type, Order ID, Shipping Line Handle, Shipping Line Title, Shipping Line Price, Shipping Line Custom, Tags, Customer ID

Draft Order Line Items

Draft Order Line Item ID, Draft Order ID, Variant ID, Product ID, Title, SKU, Vendor, Price, Quantity, Requires Shipping, Taxable, Gift Card, Fulfillment Service, Weight, Name, Custom, Applied Discount Title, Applied Discount Description, Applied Discount Value, Applied Discount Value Type, Applied Discount Amount

Draft Order Tax Lines Draft

Order ID, Title, Price, Rate

Draft Order Note Attributes

Draft Order ID, Name, Value

Draft Order Line Items Tax Lines

Draft Order Line Item ID, Price, Title, Rate, Draft Order ID

Draft Order Line Item Properties

Draft Order Line Item ID, Name, Value, Draft Order ID

Customer Saved Searches

Saved Search ID, Name, Created At, Updated At, Query

Abandoned Checkouts

Checkout ID, Token, Cart Token, Email, Gateway, Accepts Marketing, Created At, Updated At, Landing Site, Note, Referring Site, Is Taxes Included, Total Weight, Currency, Completed At, Closed At, User ID, Location ID, Source Identifier, Source URL, Device ID, Phone, Customer Locale, Name, Source, Abandoned Checkout URL, Source Name, PResentment Currency, Total Discount, Total Line Item Price, Total Price, Total Tax, Subtotal Price, Billing First Name, Billing Address Line 1, Billing Phone, Billing City, Billing Zip, Billing Province, Billing Country, Billing Last Name, Billing Address Line 2, Billing Company, Billing Latitude, Billing Longitude, Shipping First Name, Shipping Address Line 1, Shipping Phone, Shipping City, Shipping Zip, Shipping Province, Shipping Country, Shipping Last Name, Shipping Address Line 2, Shipping Company, Shipping Latitude, Shipping Longitude

Abandoned Checkout Note Attributes

Checkout ID, Name, Value

Abandoned Checkout Shipping Lines

Checkout ID, Code, Price, Source, Checkout Shipping Line ID

Abandoned Checkout Line Items

Checkout ID, Key, Line Item ID, Destination Location ID, Fulfillment Service, Is Gift Card, Weight, Origin Location ID, Product ID, Quantity, Requires Shipping, SKU, Is Taxable, Title, Variant ID

Abandoned Checkout Discount Codes

Checkout ID, Code, Amount, Discount Type

Abandoned Checkout Tax Lines

Checkout ID, Price, Rate, Title 

Abandoned Checkout Line Items Tax Lines

Checkout ID, Checkout Line Item ID, Price, Position, Rate, Title, Source, Zone, Compare At

Abandoned Checkout Line Items Applied Discounts

Checkout ID, Checkout Line Item ID, Discount ID, Description, Created At, Amount

Abandoned Checkout Line Items Properties

Checkout ID, Checkout Line Item ID, Name, Value Billing First Name

2. What are the default reports & dashboards created by this app?

When you setup/configure the Zoho Advanced Analytics Connector, 100+ default reports & dashboards are automatically created. These hand-picked reports will provide you with in-depth details about the product. 

The listicle below lists the offered pre-built reports and dashboards in Zoho Advanced Analytics.

3. What are the default formulas available on setting up this app?

Formulas, as the name indicates, are calculations that help you derive key business metrics that can be used for reporting and analysis. Zoho Analytics provides a powerful formula engine to create any type of calculations required, to enable creating the required reports.

Refer to Adding Formulas in Zoho Advanced Analytics to know more.

4. Can I create my own reports in the Zoho Advanced Analytics app?

Yes, you can create your desired reports in Zoho Advanced Analytics. Refer Create Your Own section to know more.

5. Can I create my own query tables?

Yes, you can create your own query tables to combine data from one or more tables and create specific data views using the standard SQL SELECT queries. Refer to Query Tables section to know more.

6. Can I create my own custom formulas in the Zoho Advanced Analytics?

Yes, you can create your own formulas and achieve desired calculations and output using our advanced formula engine. Refer to Adding Formulas section to know more.

7. Can I add new data tables in this app to create reports & dashboards?

Yes, you can add new data tables. Click Create > New Table/Import Data to add a new table alongside the existing tables in your home page.

8. Can I combine data from other sources with the data from Shopify to create reports and dashboards?

Yes, you can combine your Shopify data with the data available on your files and feeds.

9. Can I join data from multiple tables to create reports?

Yes, you can join the data from multiple tables to create reports in the Zoho Advanced Analytics. By default, all your tables will be auto-joined. You can also establish a connection between multiple tables, using our look-up columns feature.

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: support@zohoanalytics.com