Twitter Organic Tweets - Snowflake
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