Skip to content

Analytics Mayhem

Data finds a way

  • What is Adobe Analytics
  • Adobe Analytics & Tealium Consulting
  • GitHub
  • LinkedIn
  • Mail
Konstantinos
Papadopoulos

Digital Analytics &
Data Specialist

Recent Posts

  • Adobe Analytics VISTA Rules data issues December 13, 2021
  • Statistical Significance in AB Testing March 15, 2021
  • Propensity Score Matching in Python January 3, 2021
  • Adobe Analytics – Reports API using OAuth & Python September 27, 2020
  • Adobe Analytics data – Reports API v2.0 & Python June 14, 2020
  • Apache Airflow and DBT on Docker Compose May 11, 2020
  • Schedule dbt models with Apache Airflow April 6, 2020
  • Incremental dbt models using Adobe Analytics Clickstream February 16, 2020

Interesting read

Machine Learning based F1 race prediction engine

Tags

  • abtesting
  • adobeAnalytics
  • airflow
  • analysis
  • bigQuery
  • clustering
  • cookies
  • crossDevice
  • dataFeeds
  • dbt
  • googleCloudPlatform
  • javascript
  • localStorage
  • measurement
  • postgresql
  • python
  • segments
  • sql
  • tealium

Tag: bigQuery

Schedule dbt models with Apache Airflow

Schedule dbt models with Apache Airflow

Working with dbt certainly makes the life of an analyst much better. It brings a certain structure that without a framework is difficult to achieve. One aspect however that I find lacking in dbt is monitoring the ongoing execution and … Read the rest

Posted on April 6, 2020July 11, 2021Categories dbt, Google BigQueryTags airflow, bigQuery, dbt
Incremental dbt models using Adobe Analytics Clickstream

Incremental dbt models using Adobe Analytics Clickstream

In the previous article (Adobe Analytics Clickstream data with dbt & SQL) I discussed how to start with dbt and build basic models using Adobe Analytics Clickstream data. This time will dive into a more useful feature. Creating incremental dbt … Read the rest

Posted on February 16, 2020July 11, 2021Categories dbtTags bigQuery, dataFeeds, dbt
Adobe Analytics Clickstream data with dbt & SQL – Guide

Adobe Analytics Clickstream data with dbt & SQL – Guide

Have previously elaborated on both the usefulness of working with raw clickstream data and how powerful I consider dbt (data build tool) in managing SQL models. This time I will take a more practical approach to go through the basic … Read the rest

Posted on January 12, 2020July 11, 2021Categories ClickstreamTags adobeAnalytics, bigQuery, dataFeeds, dbt, sql
Model Adobe Analytics Data in BigQuery with dbt – Into

Model Adobe Analytics Data in BigQuery with dbt – Into

Working with the raw Adobe Analytics data is always both interesting and challenging. One of the reasons is that Adobe (and all analytics vendors) have trained us to have easy access to multiple reports and metrics. However those rely on … Read the rest

Posted on October 27, 2019July 11, 2021Categories Adobe Analytics, Google BigQueryTags adobeAnalytics, bigQuery, dataFeeds, dbt
Data Feeds & Clustering BigQuery tables

Data Feeds & Clustering BigQuery tables

Clustering in BigQuery

BigQuery is well-known for being lighting fast in terms of processing enormous volumes of data. There is no doubt about this. We, as product users, have a few options in our disposal to achieve so. First and … Read the rest

Posted on August 20, 2019July 11, 2021Categories Adobe Analytics, Google BigQueryTags bigQuery, clustering, dataFeeds
Advanced cases of Adobe Clickstream with BigQuery

Advanced cases of Adobe Clickstream with BigQuery

In the previous post provided a few basic examples on how to start your journey analysing Adobe Analytics Clickstream Data Feeds in BigQuery. This time going to complete the remaining points of the agenda. Overall we have:

  1. Hit-based segments (part
… Read the rest
Posted on February 25, 2019July 11, 2021Categories Adobe AnalyticsTags adobeAnalytics, bigQuery, dataFeeds, sql
Adobe Analytics Clickstream & BigQuery introduction

Adobe Analytics Clickstream & BigQuery introduction

In the previous post tried to elaborate on the main steps involved in loading Adobe Analytics clickstream data from Data Feeds into BigQuery. If you missed it and you are not sure how to start experimenting yourselves, have a look … Read the rest

Posted on February 11, 2019July 11, 2021Categories Adobe AnalyticsTags adobeAnalytics, bigQuery, dataFeeds, segments, sql
Load Data Feeds to Google BigQuery

Load Data Feeds to Google BigQuery

Adobe Analytics reporting solutions (i.e. Reports & Analytics, Analysis Workspace, Report Builder or Data Warehouse) offer a wide range of options to view, understand and analyse your data. Admittedly, this covers the majority of most peoples’ data needs. However there … Read the rest

Posted on December 17, 2018July 11, 2021Categories Adobe AnalyticsTags adobeAnalytics, bigQuery, dataFeeds, googleCloudPlatform, python
Proudly powered by WordPress