Shopify
## Columns
| Type | Name | Description |
| ---- | -------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| | date\_day | Day for which the shop activity is being measured. |
| | shop\_id | The ID for the shop. A 64-bit unsigned integer. |
| | name | The name of the shop. |
| | domain | The shop's domain. |
| | is\_deleted | Boolean representing whether the record was soft-deleted in Shopify. |
| | currency | The three-letter code (ISO 4217 format) for the shop's default currency. |
| | enabled\_presentment\_currencies | An array of of enabled currencies (ISO 4217 format) that the shop accepts. Merchants can enable currencies from their Shopify Payments settings in the Shopify Admin. |
| | iana\_timezone | The name of the timezone assigned by the [IANA](https://www.iana.org/time-zones). |
| | created\_at | The date and time (ISO 8601) when the shop was created. |
| | count\_orders | Count of the distinct orders placed on this day. |
| | count\_line\_items | Count of the line items included in orders placed on this day. |
| | count\_customers | Count of distinct customers who placed an order on this day. |
| | count\_customer\_emails | Count of distinct customer email addresses who placed an order on this day. |
| | order\_adjusted\_total | Order total adjusted for refunds and other adjustments. The calculation used for this field is as follows: total price listed on the original order (including shipping costs and discounts) + adjustments + adjustments tax - total refunds - refunds tax The order\_adjusted\_total will equate to the total sales - refunds listed within the transactions table for the order (after currency exchange). |
| | avg\_order\_value | Average adjusted total per order placed on this day (in shop currency). |
| | shipping\_cost | The shipping cost of the orders placed on this day (in shop currency). |
| | order\_adjustment\_amount | Total adjustment amount (in shop currency) applied to the orders placed on this day. |
| | order\_adjustment\_tax\_amount | Total tax applied to adjustments (in shop currency) on the orders placed on this day. |
| | refund\_subtotal | Total refund amount applied to the orders placed on this day. |
| | refund\_total\_tax | Total tax applied to the refund on the orders placed on this day (in shop currency). |
| | total\_discounts | The total amount of the discount allocated to this day's orders in the shop's currency. |
| | shipping\_discount\_amount | The total amount of discount (in shop currency) allocated toward shipping for orders placed on this day. |
| | percentage\_calc\_discount\_amount | The total amount of discount (in shop currency) allocated via a percentage-based discount for orders placed on this day. |
| | fixed\_amount\_discount\_amount | The total amount of discount (in shop currency) allocated via a fixed-amount discount for orders placed on this day. |
| | count\_discount\_codes\_applied | Distinct discount codes applied by customers on orders for this day. |
| | count\_locations\_ordered\_from | Distinct locations with orders placed against them on this day. |
| | count\_orders\_with\_discounts | Count of orders in which a discount was applied. |
| | count\_orders\_with\_refunds | Count of orders in which there was a refund. |
| | first\_order\_timestamp | Timestamp of the first order of the day for the shop. |
| | last\_order\_timestamp | Timestamp of the last order of the day for the shop. |
| | quantity\_sold | Total quantity sold from the inventory level. Includes refunds. |
| | quantity\_refunded | The quantity of goods ORDERED on this day that have been refunded. |
| | quantity\_net | Net quantity sold from this shop on this day. Excludes refunds. |
| | count\_variants\_sold | Distinct product variants sold on this day (includes refunds). |
| | count\_products\_sold | Distinct products sold on this day (includes refunds). |
| | quantity\_gift\_cards\_sold | Quantity of gift cards sold on this day. |
| | quantity\_requiring\_shipping | Quantity of goods sold on this day that require shipping. |
| | count\_abandoned\_checkouts | Count of abandoned checkouts on this day. |
| | count\_customers\_abandoned\_checkout | Count of distinct customers who abandoned checkouts on this day. |
| | count\_customer\_emails\_abandoned\_checkout | Count of distinct customer emails who abandoned checkouts on this day. |
| | count\_fulfillment\_attempted\_delivery | Count of distinct fulfillments on this day where the delivery of the shipment was attempted, but unable to be completed. |
| | count\_fulfillment\_delivered | Count of successful distinct fulfillments successfully delivered on this day. |
| | count\_fulfillment\_failure | Count of failed distinct fulfillments on this day. Something went wrong when pulling tracking information for the shipment, such as the tracking number was invalid or the shipment was canceled. |
| | count\_fulfillment\_in\_transit | Count of distinct fulfillments in transit on this day. Each shipment is being transported between shipping facilities on the way to its destination. |
| | count\_fulfillment\_out\_for\_delivery | Count of distinct fulfillments being delivered to their final destination. |
| | count\_fulfillment\_ready\_for\_pickup | Count of distinct fulfillments ready for pickup at a shipping depot. |
| | count\_fulfillment\_picked\_up | Count of distinct fulfillments successfully picked up on this day. |
| | count\_fulfillment\_label\_printed | Count of distinct fulfillments for which a purchased shipping label has been printed on this day. |
| | count\_fulfillment\_label\_purchased | Count of distinct fulfillments for which a shipping label has been purchased (but not printed yet) on this day. |
| | count\_fulfillment\_confirmed | Count of confirmed distinct fulfillments. This is the default status when no other information is available about a fulfillment. |
| | avg\_line\_item\_count | Average line item count for orders placed on this day. |
| | avg\_discount | Average total discount placed on orders on this day (in shop currency). |
| | avg\_shipping\_discount\_amount | Average discount amount (in shop currency) allocated toward shipping on orders placed on this day. |
| | avg\_percentage\_calc\_discount\_amount | Average discount amount (in shop currency) allocated via a percentage-based-discount on orders placed on this day. |
| | avg\_fixed\_amount\_discount\_amount | Average discount amount (in shop currency) allocated via a fixed-amount-discount on orders placed on this day. |
| | avg\_quantity\_sold | Average quantity sold per order on this day. Includes refunds. (in shop currency) |
| | avg\_quantity\_net | Average net quantity sold per order on this day. Excludes refunds. (in shop currency) |
| | source\_relation | The schema or database this record came from if you are making use of the `shopify_union_schemas` or `shopify_union_databases` variables, respectively. Empty string if you are not using either of these variables to union together multiple Shopify connectors. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/shopify-daily-shop.md?ask=