{"queries":[{"id":"forecast","compiledQueryString":"SELECT type, amount, Month, status FROM (\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*5.3 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*5 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n) AS subquery\nORDER BY order_col, Month","inputQueryString":"SELECT type, amount, Month, status FROM (\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*5.3 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*5 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n) AS subquery\nORDER BY order_col, Month","compiled":false,"inline":true},{"id":"pl","compiledQueryString":"select type, amount, Month from (\n select 'ebitda' as type, cast(pl_ebitda as float4) as amount, cast(Month as date) as Month, 1 as order_col from bigquery.pl\n union all\n select 'opex' as type, cast(pl_opex as float4) as amount, cast(Month as date) as Month, 2 as order_col from bigquery.pl\n union all\n select 'transaction' as type, cast(pl_transaction_costs_b2c as float4) as amount, cast(Month as date) as Month, 3 as order_col from bigquery.pl\n union all\n select 'marketing' as type, cast(pl_marketing_costs_b2c as float4) as amount, cast(Month as date) as Month, 4 as order_col from bigquery.pl\n union all\n select 'logistics' as type, cast(pl_logistic_costs_b2c as float4) as amount, cast(Month as date) as Month, 5 as order_col from bigquery.pl\n union all\n select 'cogs' as type, cast(pl_cogs_b2c as float4) as amount, cast(Month as date) as Month, 6 as order_col from bigquery.pl\n) as subquery\norder by order_col","inputQueryString":"select type, amount, Month from (\n select 'ebitda' as type, cast(pl_ebitda as float4) as amount, cast(Month as date) as Month, 1 as order_col from bigquery.pl\n union all\n select 'opex' as type, cast(pl_opex as float4) as amount, cast(Month as date) as Month, 2 as order_col from bigquery.pl\n union all\n select 'transaction' as type, cast(pl_transaction_costs_b2c as float4) as amount, cast(Month as date) as Month, 3 as order_col from bigquery.pl\n union all\n select 'marketing' as type, cast(pl_marketing_costs_b2c as float4) as amount, cast(Month as date) as Month, 4 as order_col from bigquery.pl\n union all\n select 'logistics' as type, cast(pl_logistic_costs_b2c as float4) as amount, cast(Month as date) as Month, 5 as order_col from bigquery.pl\n union all\n select 'cogs' as type, cast(pl_cogs_b2c as float4) as amount, cast(Month as date) as Month, 6 as order_col from bigquery.pl\n) as subquery\norder by order_col","compiled":false,"inline":true},{"id":"big_pl","compiledQueryString":"select \nsum(cast(pl_ebitda as float4)) as ebitda,\nsum(cast(pl_cogs_b2c as float4)) as cogs,\nsum(cast(pl_logistic_costs_b2c as float4)) as logistics,\nsum(cast(pl_marketing_costs_b2c as float4)) as marketing,\nsum(cast(pl_transaction_costs_b2c as float4)) as transaction,\nsum(cast(pl_opex as float4)) as opex\nfrom bigquery.pl","inputQueryString":"select \nsum(cast(pl_ebitda as float4)) as ebitda,\nsum(cast(pl_cogs_b2c as float4)) as cogs,\nsum(cast(pl_logistic_costs_b2c as float4)) as logistics,\nsum(cast(pl_marketing_costs_b2c as float4)) as marketing,\nsum(cast(pl_transaction_costs_b2c as float4)) as transaction,\nsum(cast(pl_opex as float4)) as opex\nfrom bigquery.pl","compiled":false,"inline":true},{"id":"summary","compiledQueryString":"select * from (SELECT type, amount, Month, status FROM (\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*5.3 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*5 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n) AS subquery\nORDER BY order_col, Month) where Month between '${inputs.date.start}' and '${inputs.date.end}'","inputQueryString":"select * from ${forecast} where Month between '${inputs.date.start}' and '${inputs.date.end}'","compiled":true,"inline":true},{"id":"income","compiledQueryString":"select * from (SELECT type, amount, Month, status FROM (\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*5.3 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*5 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n) AS subquery\nORDER BY order_col, Month) where type='Income' and Month>='2024-01-01'","inputQueryString":"select * from ${forecast} where type='Income' and Month>='2024-01-01'","compiled":true,"inline":true},{"id":"expenses","compiledQueryString":"select * from (SELECT type, amount, Month, status FROM (\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*5.3 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*5 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n) AS subquery\nORDER BY order_col, Month) where type='Expenses' and Month>='2024-01-01'","inputQueryString":"select * from ${forecast} where type='Expenses' and Month>='2024-01-01'","compiled":true,"inline":true},{"id":"ebitda","compiledQueryString":"select * from (SELECT type, amount, Month, status FROM (\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*3.4 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'actuals' AS status \n FROM bigquery.pl\n WHERE Month < date_trunc('month', current_date)\n UNION ALL\n SELECT 'Income' AS type, \n CAST(pl_revenues_b2c AS float4)*5.3 AS amount, \n CAST(Month AS date) AS Month, \n 1 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'Expenses' AS type, \n (CAST(pl_cogs_b2c AS float4)*3.4 + \n CAST(pl_transaction_costs_b2c AS float4)*3.4 + \n CAST(pl_logistic_costs_b2c AS float4)*3.4 + \n CAST(pl_marketing_costs_b2c AS float4)*3.4 + \n CAST(pl_opex AS float4)*3.4) AS amount, \n CAST(Month AS date) AS Month, \n 2 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n UNION ALL\n SELECT 'EBITDA' AS type, \n CAST(pl_ebitda AS float4)*5 AS amount, \n CAST(Month AS date) AS Month, \n 3 AS order_col, \n 'forecast' AS status \n FROM bigquery.pl_forecast\n) AS subquery\nORDER BY order_col, Month) where type='EBITDA' and Month>='2024-01-01'","inputQueryString":"select * from ${forecast} where type='EBITDA' and Month>='2024-01-01'","compiled":true,"inline":true},{"id":"marges","compiledQueryString":"select type, amount, Month from (\n select 'COGS' as type, cast(pl_cogs_b2c_pct as float4) as amount, cast(Month as date) as Month, 5 as order_col from bigquery.pl\n union all\n select 'Logistics' as type, cast(pl_logistic_costs_b2c_pct as float4) as amount, cast(Month as date) as Month, 4 as order_col from bigquery.pl\n union all\n select 'Marketing' as type, cast(pl_marketing_costs_b2c_pct as float4) as amount, cast(Month as date) as Month, 3 as order_col from bigquery.pl\n union all\n select 'Transaction' as type, cast(pl_transaction_costs_b2c_pct as float4) as amount, cast(Month as date) as Month, 2 as order_col from bigquery.pl\n union all\n select 'OPEX' as type, cast(pl_opex_pct as float4) as amount, cast(Month as date) as Month, 1 as order_col from bigquery.pl\n) as subquery\norder by order_col","inputQueryString":"select type, amount, Month from (\n select 'COGS' as type, cast(pl_cogs_b2c_pct as float4) as amount, cast(Month as date) as Month, 5 as order_col from bigquery.pl\n union all\n select 'Logistics' as type, cast(pl_logistic_costs_b2c_pct as float4) as amount, cast(Month as date) as Month, 4 as order_col from bigquery.pl\n union all\n select 'Marketing' as type, cast(pl_marketing_costs_b2c_pct as float4) as amount, cast(Month as date) as Month, 3 as order_col from bigquery.pl\n union all\n select 'Transaction' as type, cast(pl_transaction_costs_b2c_pct as float4) as amount, cast(Month as date) as Month, 2 as order_col from bigquery.pl\n union all\n select 'OPEX' as type, cast(pl_opex_pct as float4) as amount, cast(Month as date) as Month, 1 as order_col from bigquery.pl\n) as subquery\norder by order_col","compiled":false,"inline":true}]}

P&L

Income

Expenses

EBITDA

OPEX in details

Expenses share