By Alex Rolnik

Twitter Organic Tweets - Snowflake

Integrates with:

Twitter Organic Tweets use the associated Stats report as a base table and adds in the appropriate Entity Tables. Each Kit will have the Tweet Information and associated metrics including: number of clicks, impressions, spend, video_views, conversion values, purchases, replies, retweets, follows, likes, and engagement by date.

This Kit includes…

Twitter Organic Tweets Rivers

  • Data ingestion rivers for Accounts Entity, Cards Entity, Tweets Entity, Organic Tweets Stats
  • Master Orchestration River
  • This includes logic to Join Entity/Stats Tables
  • Output Tables:
    • twitter_entity_accounts
    • twitter_entity_cards
    • twitter_entity_tweets
    • twitter_stats_organictweets
    • twitter_organic_tweets_stats (entity and stats combined)

Minimum RPU Consumption: 5

You can find the full contents, data model documentation, and source fields used here.

Configuring this template for use

This Kit has 2 variables that are used to make the target dynamic. These will need to be added as global variables: {db_twitter} – Selected Database in Snowflake for Output {schema_twitter} – Selected Schema in Snowflake for Output

Minimize the firefighting.
Maximize ROI on pipelines.

icon icon