Aamir2786/marketing_analytics

Md Aamir Sohel Ansari

Firstly I ingested Salesforce and Marketo data present in Google sheets to Bigquery using Fivetran connectors as well as Destinations.
I used dbt for the transformation, test and documentation required for the analysis. I created this repository to maintain data models for the analysis and also grant Fivetran access so that we can schedule our pipelines.
Finally, I can define upstream Fivetran connectors as source, set up dbt to transform, clean and aggregate this data and schedule pipeline run in Fivetran against our Bigquery destinations.
Later on, we can connect BI tools with Bigquery destinations to visualize our metrics.
Like this project
0

Posted Nov 15, 2023

Marketing Analytics Solution Using Fivetran and dbt - GitHub - Aamir2786/marketing_analytics: Marketing Analytics Solution Using Fivetran and dbt

A/B Testing Impact of Google’s ConsumerSDK on our metrics
A/B Testing Impact of Google’s ConsumerSDK on our metrics
Captain Acquisition end-to-end dashboard
Captain Acquisition end-to-end dashboard
Diagnostic framework for High Accuracy Pickups (HAPs)
Diagnostic framework for High Accuracy Pickups (HAPs)