Denys NazarenkoDenis
NazarenkoDenis
/ chips.json
Last active
November 25, 2025 10:12
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
| { | |
| "reports": [ | |
| { | |
| "id": "top_customers", | |
| "label": "Top customers", | |
| "report_title": "Sales by Customer", | |
| "variations": [ | |
| { | |
| "id": "top_customers__revenue", | |
| "metric_id": "revenue", |
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