A brief history of

Data!

Everything starts with

Interactions

Then comes the

Collection

Databases

Logs

Google Analytics

Google BigQuery

Demo 

SELECT
  timestamp(utc_usec_to_month(createdAt)) month,
  round(sum(totals.validNetRevenue)) net_revenue,
  sum(totals.validOrders) orders,
FROM dwh.orders
WHERE createdAt >= utc_usec_to_year(current_date())
GROUP BY 1
ORDER BY 1 DESC
                    

SELECT
  device.browser browser,
  sum(totals.visits) sessions,
  sum(totals.pageviews) pageviews,
FROM (
  table_date_range(
    [luxola.com:luxola-analytics:50639087.ga_sessions_],
    timestamp(date_add(utc_usec_to_week(current_date(), 0), -1, 'week')),
    timestamp(utc_usec_to_week(current_date(), 0))
  )
)
GROUP BY 1
ORDER BY 2 DESC
                    

SELECT
  timestamp(date_start) date,
  sum(integer(impressions)) impressions,
  sum(clicks) clicks,
  round(sum(clicks) / sum(integer(impressions)), 4) ctr,
FROM [luxola.com:luxola-analytics:facebook.insights]
WHERE timestamp(date_start) >= date_add(current_date(), -1, 'week')
GROUP BY 1
ORDER BY 1 DESC

Now we have Data, we have to

Use it

Business Intelligence

  • Reporting
  • Monitoring
  • Automation
  • Visualization
  • Business insights
  • Links with retail*

Colors

Demo 
-- [TEST Daily net revenue
SELECT
    timestamp(date(o.createdAt)) date,
    o.address.country country,
    round(sum(o.totals.netRevenue)) net
FROM
    [dwh.orders] o
WHERE
    o.isValid
    and date(o.createdAt) >= DATE(STRFTIME_UTC_USEC(date_add(current_date(), -1, 'DAY'), '%Y-%m-01'))
    and date(o.createdAt) < current_date()
GROUP BY
    date, country
ORDER BY
    date, country

Dashboard Month to date

Marketing Intelligence

  • Attribution models
  • Customer journeys
  • Campaign performances
  • Ad management
  • Creative relevancy

Aero

Demo

Links

Next campaign

Campaign 842

Report

Next steps

  • Integrate the designers / copywriters to the flow
  • Build more reports / recommandations about the campaigns
  • How will the retail team interact with Aero?

Artificial Intelligence

  • Machine learning
  • Recommendations
  • Search & sort
  • Complementary purchases
  • Similar products
  • Lead scoring*
  • Sentiment analysis*

Annexes

Data Flow

2 playgrounds

Warehousing

Warehousing

Fun