Skip to content

Matatika/dbt-tap-google-analytics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

26 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

GitHub licensedbt logo and version

dbt-tap-google-analytics

This dbt package contains models for Matatika's tap-google-analytics.

The main focus of the package is to transform and clean up the Google Analytics data into usable analytics models.

This package along with the Analyze Bundle are designed intended to work together to provide instant insights on the Matatika Platform.

model description
google_analytics_active_user_stats Active user stats for the day, week, two week, four week and monthly time frames.
google_analytics_daily_active_users Daily total active users.
google_analytics_devices Daily user stats by user devices.
google_analytics_four_weekly_active_users Four weekly total active users.
google_analytics_locations Daily user stats by user location.
google_analytics_monthly_active_users Monthly total active users.
google_analytics_monthly_comparison_stats Monthly user stats.
google_analytics_pages Daily page stats.
google_analytics_traffic_sources Daily traffic sources stats.
google_analytics_two_weekly_active_users Two weekly total active users.
google_analytics_website_overview Daily website overview stats.
google_analytics_weekly_active_users Weekly total active users.

Installation Instructions

Check dbt Hub for the latest installation instructions, or read the dbt docs for more information on installing packages.

Include in your packages.yml

packages:
  - package: Matatika/dbt-tap-google-analytics
    version: [">=0.1.0", "<1.0.0"]

or

packages:
  - git: https://github.com/Matatika/dbt-tap-google-analytics.git

One time setup (after creating a python virtual environment)

```
pip install dbt
dbt deps
```

development

```
dbt test
```

Database Support

This package has been tested on Postgres and Snowflake.

Cloud hosting and SaaS

Deploy on the Matatika Platform within minutes. www.matatika.com

Contributions

Additional contributions to this package are very welcome! Please create issues or open PRs against master. Check out this post on the best workflow for contributing to a package.

Resources:

Original Project

This dbt project was originally created by Meltano and their repository for the project can be found on gitlab: dbt-tap-google-analytics