Data Science at Sephora

Thu, Sep 8, 2016

Images are now preloading thumbnails

Images are using placeholders to diplay low quality thumbnails while downloading the real files.

TableOfContents

LatestPosts

Wed, Jan 23, 2019

bigquery

Wed, Jan 23, 2019

Categories

Wed, Jan 23, 2019

Data Science at Sephora

Wed, Jan 23, 2019

Posts

Wed, Jan 23, 2019

sql

Wed, Jan 23, 2019

The SQL Query Writing Commandments

Hi everyone, Wether you are newbie SQL writer, an experimented BigQuery novelist with a volatile memory, or a visitor in quest of good practices, this article is for you ! So here is the situation: after hours of thinking and writing and testing, you have came up with a cool query that you are super proud of, a query that shows exactly the insights you were looking for, a query to make queries great again.

Wed, Oct 17, 2018

aero

Wed, Oct 17, 2018

Aero gets a flaming hot update

Hi all ! A few weeks ago, Aero, our in-house campaign management tool got a huuge update, not only enabling razor-sharp tracking, but also improving communication with our external vendors, and clear repartition of roles along the creation of campaigns flow. Tracking enabled for groups of campaigns, and refined down to email creative precision, with each intermediate level tracked as well (campaign, ad, segment, slice). You can now know where do your customers come from at each level of grain !

Tue, Mar 27, 2018

Say hi to Dibblr !

Hey you, do you like big queries ? Big big queries, so big they can’t even fit in a CSV file ? We, in the data team, know the trouble. And we have a solution. As you may know, on Google BigQuery, queries that have more than 10.000 rows cannot be directly exported as CSV files. On top of that, if your query includes a nested field, it won’t be able to export the result as a CSV file regardless of its size.

Wed, Mar 7, 2018

Red Zone Calendar in Aero

This article explains how to use the Red Zone Calendar in our in-house campaign management tool, Aero. A campaign is considered red zone if the estimated traffic is sufficiently high that it will be necessary to notify the tech team and allow them to scale in advance. Get the Red Zone Calendar Are you here to get the Red Zone Calendar generated by Aero ? You are on the right post, follow me !

category

aero bigquery sql google-analytics analytics colors spider cheetah crm domo

tag

© 2019 Data Science at Sephora