Icon

Sales Eq New_​mktpl

PASO 2

OM MOL

OM Retail

OM Producto

PASO 0

Poner Fecha Lunes inicio año Anterior

PASO 1: Actualizar Executing User

PASO 2.5: DESCARGAR INFO DE TRÁFICO EN LOOKER

REBAJAS

GUARDAR EXCEL BRIDGE

CHECKS

CHECK ÚLTIMA SEMANA

MIRAR QUE EN NINGUNA SEMANA FALTEN DATOS

CHECK TIENDAS TRÁFICO

CHECK TODAS SEMANAS

REVISAR EN LOOKER QUE LOS DATOS CUADRAN

AÑO + SEMANAS REBAJAS TEMP

CORNERS ITALIA Y MÉXICO

TRÁFICO OL

TIENDAS

TIPO DE CAMBIO

CALC. BRIDGE

TicketsTotal - pesos
Math Formula
GroupBy
Joiner
CHECK DATOS
Column Expressions (legacy)
Column Filter
GroupBy
SemanaISO53
Math Formula
Excel Writer
Gestión Agrupada
Rule Engine
AñoISO53
Math Formula
Tickets = Tickets RC
Rule Engine
Género Agrupado
Rule Engine
Column Resorter
Table Column to Variable
Math Formula
DoW
Date&Time Part Extractor
Rule Engine
Rule Engine
Rule Engine
Math Formula
GroupBy
DoW
Date&Time Part Extractor
Column Rename (deprecated)
Double to Integer
Joiner
Joiner
Missing Value
Missing Value
Joiner
Semana
Math Formula
Año
Math Formula
Column Resorter
Trafico Bruto
Rule Engine
Tiendas OL
Rule Engine
Tickets Bruto
Rule Engine
Tickets RC
Rule Engine
Column Filter
Missing Value
GroupBy
Column Renamer
Rule Engine
Column Renamer
Rule Engine
Venta PVP € tc Cte _Neto
Math Formula
Joiner
TEEN
Pivot
MAN
Pivot
Column Renamer
Rule Engine
Column Renamer
GroupBy
WOMAN
Pivot
Rule Engine
HOME
Pivot
Tráfico
DB Query Reader
Missing Value
Joiner
KIDS
Pivot
Joiner
devos S/N
Pivot
Venta (sin IVA)_ Neto
Math Formula
Missing Value
Venta €_ Neto
Math Formula
Column Rename (deprecated)
Uds_ Neto
Math Formula
Joiner
Coste Fact_ Neto
Math Formula
Mg Bruto Fact_ Neto
Math Formula
vta divisa_ Neto
Math Formula
Venta FP_ Bruto
Math Formula
Extract year and ISO week from date column
Date&Time Part Extractor
String to Date&Time
Concatenate
Column Renamer
GroupBy
Column Renamer
Column Renamer
GroupBy
Extract year and ISO week from date column
Date&Time Part Extractor
String to Date&Time
GroupBy
Column Filter
String Manipulation
Column Renamer
Cross Joiner
Rule Engine
Rule Engine
Column Filter
Column Filter
Column Filter
Column Filter
SharePoint Online Connector
Table Row to Variable
TC
Column Filter
DoW
Date&Time Part Extractor
SemanaISO53
Math Formula
Node 2993
Rule Engine
Column Rename (deprecated)
Todo es bruto = N
Rule Engine
Missing Value
AñoISO53
Math Formula
- dias
Rule Engine
Consulta 0
DB Query Reader
Rule Engine
Math Formula
Elimina filas sin país
Missing Value
Missing Value
Facturación_ Neto
Math Formula
Excel Reader
Column Filter
Gestion Agrupada
Rule Engine
TC
DB Query Reader
GroupBy
Microsoft Authenticator
Excel Writer
GroupBy
Date&Time Shift (deprecated)
HOY
Create Date&Time Range (deprecated)
Date&Time to String (deprecated)
Number to String
GroupBy
Joiner
GroupBy
Joiner
SharePoint Online Connector
Column Rename (deprecated)
Microsoft Authenticator
Credentials Configuration
TRÁFICO*
Math Formula
RC
Math Formula
Double to Integer
RC_LY
Math Formula
Pivot
TRÁFICO*_LY
Math Formula
UPT
Math Formula
String to Number
Missing Value
Rule Engine
no hace nada
GroupBy
online
GroupBy
%DTO
Math Formula
Column Rename (deprecated)
PM FP_LY
Math Formula
RC_LY
Math Formula
TRÁFICO*_LY
Math Formula
Rule Engine
TRÁFICO*
Math Formula
Date&Time Part Extractor
RC
Math Formula
Credentials Configuration
%DTO_LY
Math Formula
Row Splitter (deprecated)
Venta PVP € tc Cte _Bruto
Math Formula
Missing Value
Pivot
Concatenate
Column Rename (deprecated)
CALCULOS IMPACTOS
Column Expressions (legacy)
Column Resorter
TC_DesagrupadoPaís
Math Formula
DB Connector
UPT_LY
Math Formula
Max Año/semana
GroupBy
Column Filter
PM FP
Math Formula
Double to Integer
DEVOS_LY
Math Formula
DEVOS
Math Formula
Max Año
GroupBy
GroupBy
errores = 0
Missing Value
físicas sin línea
GroupBy
CALCULOS VENTA
Column Expressions (legacy)
Joiner
PM CC_LY
Math Formula
PM CC FP_LY
Math Formula
CALCULOS IMPACTOS
Column Expressions (legacy)
GroupBy
Joiner
Rule Engine
GroupBy
Row Filter (deprecated)
Max semana CY
GroupBy
Column Renamer
Joiner
GroupBy
Total - Sin Linea
DB Query Reader
Rule Engine
Violeta -> Woman
Rule Engine
Gestion
Rule Engine
Canal
Rule Engine
Missing Value
Desglose Linea
DB Query Reader
GroupBy
CALCULOS IMPACTOS NETA
Column Expressions (legacy)
Column Filter
CHECK DATOS
Column Expressions (legacy)
CALCULOS VTA NETA
Column Expressions (legacy)
Missing Value
GroupBy
Number Rounder
Rule Engine
Column Renamer
Column Resorter
CALCULOS VTA NETA
Column Expressions (legacy)
CALCULOS IMPACTOS NETA
Column Expressions (legacy)
UPT
Math Formula
Missing Value
Sales Eq
Column Resorter
Joiner
GroupBy
Column Rename (deprecated)
Rule-based Row Filter
GroupBy
Pivot
Double to Integer
GroupBy
Column Filter
PM FP
Math Formula
Column Renamer
Rule Engine
UPT_LY
Math Formula
Cross Joiner
Column Filter
Number Rounder
MAESTRO LXL
Excel Reader
Column Resorter
Missing Value
Rule Engine
GroupBy
Joiner
Double to Integer
Joiner
Joiner
Column Rename (deprecated)
SEMANAS REBAJAS
Table Creator
Double to Integer
Column Rename (deprecated)
Joiner
Joiner
GroupBy
Joiner
Double to Integer
Rule Engine
Missing Value
Column Rename (deprecated)
Rule Engine
Double to Integer
GroupBy
Rule Engine
Column Rename (deprecated)
Date&Time Range Creator
Rule Engine
Column Rename (deprecated)
Row Filter
Column Filter
Rule Engine
Missing Value
Excluir Marketplace
Row Filter (deprecated)
Año Comparable Anterior
Math Formula
GroupBy
Column Rename (deprecated)
Row Filter (deprecated)
Joiner
Double to Integer
Joiner
Incidencias tráfico
Excel Reader
Column Filter
Consulta 1
DB Query Reader
Año Actual
Row Filter (deprecated)
Tiendas
DB Query Reader
Math Formula
Semanas Pasadas/Futuras
Rule Engine
Rule Engine
Table Creator
PM FP_LY
Math Formula
Joiner
Missing Value
Column Rename (deprecated)
Joiner
Rule Engine
Column Renamer
Double to Integer
Excluir Futuras
Row Filter (deprecated)
Joiner
String to Number
DEVOS
Math Formula
DEVOS_LY
Math Formula
%DTO
Math Formula
%DTO_LY
Math Formula
errores = 0
Missing Value
saber si es multilinea
Math Formula (Multi Column)
Consulta1
DB Query Reader
CALCULOS VENTA
Column Expressions (legacy)
Excluir Marketplace
Row Filter (deprecated)
Math Formula
Consulta 0
DB Query Reader
Eliminamos <2022
Rule-based Row Filter
PM CC_LY
Math Formula
PM CC FP_LY
Math Formula

Nodes

Extensions

Links