Denys NazarenkoDenis
NazarenkoDenis
/ chips.json
Last active
December 12, 2025 16:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "code": "top_customers", | |
| "label": "Top customers", | |
| "prompt": "'Sales by Customer' that helps identify the most loyal customers by showing each customer in a separate row with their complete sales performance.\nThe report displays sales data for the last 30 days, sorted by total sales in descending order (highest first) to highlight top performers.\nUse the 'orders' explore.\nInclude these fields: customer email, customer name, number of orders, total refund amount, total discounts, total net amount, total price, and average order value.\nAdd a date filter in the toolbar so users can adjust the time period." | |
| }, | |
| { | |
| "code": "top_products", | |
| "label": "Top products", | |
| "prompt": "'Sales by Product' that shows each product in a separate row.\nThe report displays sales data for the last 30 days, sorted by units sold in descending order (highest first) to show the most popular products first.\nUse the 'sales_by_item' explore.\nInclude these fields: product image, product name, number of |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <table width="100%" cellpadding="0" cellspacing="0" style="font-family: Arial, sans-serif; color: #222; line-height: 1.6; max-width: 600px; margin: auto;"> | |
| <tr> | |
| <td style="padding: 32px 24px;"> | |
| <h1 style="color: #19752c; margin-bottom: 8px;">mipler</h1> | |
| <p>Hi Oleksandr 👋</p> | |
| <p>Shopify’s default reports are a good starting point. <br> | |
| You get your revenue, orders, traffic… <br> | |
| But when you want to dig deeper — things get tricky.</p> |
NazarenkoDenis
/ schema.json
Created
January 28, 2025 11:47
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "tables": [ | |
| { | |
| "lineageID": "0b157755-1ac9-3457-97af-2535c3a3ca2c", | |
| "columns": [ | |
| { | |
| "lineageID": "1d2c1fd4-4185-4691-8657-323753d925c2", | |
| "name": "hs_code", | |
| "kind": "dimension", | |
| "dataType": "string", |
NazarenkoDenis
/ schema.json
Created
January 28, 2025 11:39
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "tables": [ | |
| { | |
| "lineageID": "0b157755-1ac9-3457-97af-2535c3a3ca2c", | |
| "columns": [ | |
| { | |
| "lineageID": "1d2c1fd4-4185-4691-8657-323753d925c2", | |
| "name": "hs_code", | |
| "kind": "dimension", | |
| "dataType": "string", |
NazarenkoDenis
/ products.product_type_upd
Created
January 23, 2025 16:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| case( | |
| or( | |
| products.name = "1 POUND BAKED SWEET POTATO FRIES", | |
| products.name = "1 POUND GRILLED BARBECUE CHICKEN BREAST", | |
| products.name = "1 POUND GRILLED FAJITA CHICKEN", | |
| products.name = "1 POUND GRILLED ITALIAN CHICKEN BREAST", | |
| products.name = "1 POUND GRILLED MEDITERRANEAN CHICKEN BREAST", | |
| products.name = "1 POUND OLIVE OIL GARLIC BROCCOLI", | |
| products.name = "1 POUND PLAIN JANE GRILLED CHICKEN BREAST", | |
| products.name = "1 POUND PULLED CHICKEN", |
NazarenkoDenis
/ order_items.product_types
Created
January 23, 2025 16:35
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| case( | |
| or( | |
| order_items.product_name = "1 POUND BAKED SWEET POTATO FRIES", | |
| order_items.product_name = "1 POUND GRILLED BARBECUE CHICKEN BREAST", | |
| order_items.product_name = "1 POUND GRILLED FAJITA CHICKEN", | |
| order_items.product_name = "1 POUND GRILLED ITALIAN CHICKEN BREAST", | |
| order_items.product_name = "1 POUND GRILLED MEDITERRANEAN CHICKEN BREAST", | |
| order_items.product_name = "1 POUND OLIVE OIL GARLIC BROCCOLI", | |
| order_items.product_name = "1 POUND PLAIN JANE GRILLED CHICKEN BREAST", | |
| order_items.product_name = "1 POUND PULLED CHICKEN", |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "explores": [ | |
| { | |
| "lineageID": "1fe426dd-c1f3-3d7c-af6b-22b233fa9aa4", | |
| "relationships": [ | |
| { | |
| "lineageID": "dea0031f-5c51-40e4-808d-02cdeb8b378f", | |
| "isRemoved": true | |
| }, | |
| { |
NazarenkoDenis
/ backup_of_schema.json
Created
November 28, 2024 09:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "explores": [ | |
| { | |
| "lineageID": "e57e9c44-7261-434d-8da9-e75f2ea27efd", | |
| "name": "payouts_upd", | |
| "label": "", | |
| "relationships": [ | |
| { | |
| "lineageID": "b58301d2-adfa-4397-861c-f73563f89134", | |
| "from": "fulfillment_items.fulfillment_id", |
NazarenkoDenis
/ 1.sql
Created
November 7, 2024 11:33
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| case( | |
| or( | |
| order_items.product_name = "1 POUND BAKED SWEET POTATO FRIES", | |
| order_items.product_name = "1 POUND GRILLED BARBECUE CHICKEN BREAST", | |
| order_items.product_name = "1 POUND GRILLED FAJITA CHICKEN", | |
| order_items.product_name = "1 POUND GRILLED ITALIAN CHICKEN BREAST", | |
| order_items.product_name = "1 POUND GRILLED MEDITERRANEAN CHICKEN BREAST", | |
| order_items.product_name = "1 POUND OLIVE OIL GARLIC BROCCOLI", | |
| order_items.product_name = "1 POUND PLAIN JANE GRILLED CHICKEN BREAST", | |
| order_items.product_name = "1 POUND PULLED CHICKEN", |
NazarenkoDenis
/ order_items.length
Last active
March 29, 2024 12:03
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| VAR l_from_variant_name = convert(regexp_match(order_items.variant_name, '\d{2,4}'), INT) | |
| VAR l_from_props = convert(case( | |
| not(is_empty(json_path(order_items.properties, "#(name=""Custom Length"").value"))), json_path(order_items.properties, "#(name=""Custom Length"").value"), | |
| not(is_empty(json_path(order_items.properties, "#(name=""Wunschlänge"").value"))), json_path(order_items.properties, "#(name=""Wunschlänge"").value"), | |
| not(is_empty(json_path(order_items.properties, "#(name=""Longueur sur mesure"").value"))), json_path(order_items.properties, "#(name=""Longueur sur mesure"").value"), | |
| not(is_empty(json_path(order_items.properties, "#(name=""Aangepaste lengte"").value"))), json_path(order_items.properties, "#(name=""Aangepaste lengte"").value"), | |
| not(is_empty(json_path(order_items.properties, "#(name=""Expédié après"").value"))), json_path(order_items.properties, "#(name=""Expédié après"").value"), | |
| not(is_empty(json_path(order_items.properties, "#(name=""Anpassad längd"").value"))), json_path(orde |
NewerOlder