OCT 8, 2021

Twitter Organic Tweets use the associated Stats report as a base table and adds in the appropriate Entity Tables. This Kit will have 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 Kit for use


In this Kit, there are two variables that need to be initialized to make for dynamic use of the target configuration. 

  • {Dataset_Twitter_Organic} is used in all Target configurations and queries as the target dataset ID.
  • {Twitter_Ads_Failure_Group} is used as the alert email address(es) for when a river fails (optional).
  • {gcs_file_zone} is used as the File Zone Bucket for all Google BigQuery Target configurations. This variable should already be populated in your Rivery account as long as a Google BigQuery connection has previously been created. 

Go to the Variables menu on the left side navigation bar and create variables for Dataset_Twitter_Organic and Twitter_Ads_Failure_Group. Then fill in the values as the Google BigQuery dataset ID where you would like the data to land and the email address(es) to which you would like the failure emails sent.


Kits are imported with ‘blank’ source and target connections. In order to use the Kit, you have two options:

  • Swap out blank connections with existing connections
  • Add credentials to the blank connections that come with the imported Kit

Have questions about this Kit?

Set up a meeting with a Rivery solutions engineer.

Consult with us

Lets us show you why the world's top brands choose Rivery.
icon icon