Integration: Twitter

This article will help you learn about how Daasity replicates data from Twitter, limitations to the data we can extract and where the data is stored in the Twitter schema.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration.

Integration Availability

This integration is available for:

  • Pro V2

NOTE: You are considered V2 if...

  • You are a Growth customer
  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to Support@Daasity.com 

API Endpoints

The Daasity Twitter extractor is built based on this Twitter API documentation. The following endpoints are used by Daasity to replicate data from Twitter:

Entity Relationship Diagram (ERD)

The embedded diagram houses the ERD for the Daasity Twitter integration illustrating the different tables and keys to join across tables.  Hover over the embedded diagram to reveal controls to zoom and scroll.

Twitter Schema

The Daasity Twitter extractor creates these tables using the endpoints and replication methods listed.  The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

Accounts Media

  • Endpoint: Account Media
  • Update Method: TRUNCSERT
  • Table Name: twitter.accounts_media
JSON Element Database Column
twitter_account_id account_id
id id
media_url media_url
creative_type creative_type
media_key media_key
created_at created_at
updated_at updated_at
deleted deleted
MD5(twitter_account_id + id) __sync_key

 

Accounts

  • Endpoint: Accounts
  • Update Method: TRUNCSERT
  • Table Name: twitter.accounts
JSON Element Database Column
name name
business_name business_name
timezone timezone
timezone_switch_at timezone_switch_at
country_code country_code
id id
industry_type industry_type
business_id business_id
approval_status approval_status
created_at created_at
updated_at updated_at
deleted deleted
MD5(id) __sync_key

 

Campaign Not Servable Reasons

  • Endpoint: Campaigns
  • Update Method: TRUNCSERT
  • Table Name: twitter.campaign_not_servable_reasons
JSON Element Database Column
id campaign_id
reason reason
MD5(twitter_account_id + id + reason) __sync_key

 

Campaigns

  • Endpoint: Campaigns
  • Update Method: TRUNCSERT
  • Table Name: twitter.campaigns
JSON Element Database Column
twitter_account_id account_id
name name
servable servable
purchase_order_number purchase_order_number
effective_status effective_status
daily_budget_amount_local_micro daily_budget_amount_local_micro
funding_instrument_id funding_instrument_id
duration_in_days duration_in_days
standard_delivery standard_delivery
total_budget_amount_local_micro total_budget_amount_local_micro
id id
entity_status entity_status
frequency_cap frequency_cap
currency currency
created_at created_at
updated_at updated_at
deleted deleted
MD5(twitter_account_id + id) __sync_key

 

Line Item Categories

  • Endpoint: Line Items
  • Update Method: TRUNCSERT
  • Table Name: twitter.line_item_categories
JSON Element Database Column
id line_item_id
category category
MD5(twitter_account_id + id + category) __sync_key

 

Line Item Placements

  • Endpoint: Line Items
  • Update Method: TRUNCSERT
  • Table Name: twitter.line_item_placements
JSON Element Database Column
id line_item_id
placement placement
MD5(twitter_account_id + id + placement) __sync_key

 

Line Items

  • Endpoint: Line Items
  • Update Method: TRUNCSERT
  • Table Name: twitter.line_items
JSON Element Database Column
twitter_account_id account_id
advertiser_user_id advertiser_user_id
name name
start_time start_time
bid_amount_local_micro bid_amount_local_micro
advertiser_domain advertiser_domain
target_cpa_local_micro target_cpa_local_micro
primary_web_event_tag primary_web_event_tag
goal goal
product_type product_type
end_time end_time
funding_instrument_id funding_instrument_id
bid_strategy bid_strategy
duration_in_days duration_in_days
total_budget_amount_local_micro total_budget_amount_local_micro
objective objective
id id
entity_status entity_status
automatic_tweet_promotion automatic_tweet_promotion
frequency_cap frequency_cap
android_app_store_identifier android_app_store_identifier
ios_app_store_identifier ios_app_store_identifier
currency currency
pay_by pay_by
campaign_id campaign_id
creative_source creative_source
audience_expansion audience_expansion
created_at created_at
updated_at updated_at
deleted deleted
MD5(twitter_account_id + campaign_id + id) __sync_key

 

Media Creatives

  • Endpoint: Media Creatives
  • Update Method: TRUNCSERT
  • Table Name: twitter.media_creatives
JSON Element Database Column
twitter_account_id account_id
line_item_id line_item_id
landing_url landing_url
creative_type creative_type
id id
entity_status entity_status
account_media_id account_media_id
approval_status approval_status
created_at created_at
updated_at updated_at
deleted deleted
MD5(twitter_account_id + line_item_id + id) __sync_key

 

Promoted Accounts

  • Endpoint: Promoted Accounts
  • Update Method: TRUNCSERT
  • Table Name: twitter.promoted_accounts
JSON Element Database Column
twitter_account_id account_id
line_item_id line_item_id
user_id user_id
id id
entity_status entity_status
approval_status approval_status
created_at created_at
updated_at updated_at
deleted deleted
MD5(twitter_account_id + line_item_id + id) __sync_key

 

Promoted Tweets

  • Endpoint: Promoted Tweets
  • Update Method: TRUNCSERT
  • Table Name: twitter.promoted_tweets
JSON Element Database Column
twitter_account_id account_id
line_item_id line_item_id
id id
entity_status entity_status
approval_status approval_status
tweet_id tweet_id
created_at created_at
updated_at updated_at
deleted deleted
MD5(twitter_account_id + line_item_id + id) __sync_key

 

Stats Active Entities

  • Endpoint: Active Entities
  • Update Method: TRUNCSERT
  • Table Name: twitter.stats_active_entities
JSON Element Database Column
twitter_account_id account_id
entity_id entity_id
entity entity
activity_start_time activity_start_time
activity_end_time activity_end_time
MD5(twitter_account_id + entity_id + entity) __sync_key

 

Stats Active Entity Placement

  • Endpoint: Active Entities
  • Update Method: TRUNCSERT
  • Table Name: twitter.stats_active_entity_placement
JSON Element Database Column
twitter_account_id account_id
entity_id entity_id
entity entity
placement placement
MD5(twitter_account_id + entity_id + placement) __sync_key

 

Stats Metric Groups

  • Endpoint: Analytics
  • Update Method: TRUNCSERT
  • Table Names:
    • twitter.stats_campaigns, twitter.stats_campaigns_stg,
    • twitter.stats_line_items, twitter.stats_line_items_stg,
    • twitter.stats_media_creatives, twitter.stats_media_creatives_stg
    • twitter.stats_promoted_accounts, twitter.stats_promoted_accounts_stg
    • twitter.stats_promoted_tweets, twitter.stats_promoted_tweets_stg

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

 

The following metrics are extracted from the Analytics API Endpoint and can be queried at the Campaign, Line Item, Media Creative, Promoted Account, and Promoted Tweet level for all Stats tables listed. The metric groups extracted are Engagement, Billing, Video, Media, Web Conversion, Mobile Conversion, Lifetime Value Mobile Conversion. The metrics within these groups are:

Metric Group JSON Element Database Column
Engagement engagements metrics_engagements
impressions metrics_impressions
retweets metrics_retweets
metrics_retweets metrics_replies
likes metrics_likes
follows metrics_follows
card_engagements metrics_card_engagements
clicks metrics_clicks
app_clicks metrics_app_clicks
url_clicks metrics_url_clicks
qualified_impressions metrics_qualified_impressions
tweets_send metrics_tweets_send
unfollows metrics_unfollows
poll_card_vote metrics_poll_card_vote
carousel_swipes metrics_carousel_swipes
carousel_swipes metrics_carousel_swipes
Billing billed_engagements metrics_billed_engagements
billed_charge_local_micro metrics_billed_charge_local_micro
Video video_total_views metrics_video_total_views
video_views_25 metrics_video_views_25
video_views_50 metrics_video_views_50
video_views_75 metrics_video_views_75
video_views_100 metrics_video_views_100
video_cta_clicks metrics_video_cta_clicks
video_content_starts metrics_video_content_starts
video_3s100pct_views metrics_video_3s100pct_views
video_6s_views metrics_video_6s_views
video_15s_views metrics_video_15s_views
Media media_views metrics_media_views
media_engagements metrics_media_engagements

Web Conversion







































 

 

conversion_purchases.order_quantity_engagement metrics_conversion_purchases_order_quantity_engagement
conversion_purchases.sale_amount_engagement metrics_conversion_purchases_sale_amount_engagement
conversion_purchases.sale_amount_view metrics_conversion_purchases_sale_amount_view
conversion_purchases.post_view metrics_conversion_purchases_post_view
conversion_purchases.order_quantity metrics_conversion_purchases_order_quantity
conversion_purchases.assisted metrics_conversion_purchases_assisted
conversion_purchases.post_engagement metrics_conversion_purchases_post_engagement
conversion_purchases.sale_amount metrics_conversion_purchases_sale_amount
conversion_purchases.metric metrics_conversion_purchases_metric
conversion_purchases.order_quantity_view metrics_conversion_purchases_order_quantity_view
conversion_sign_ups.order_quantity_engagement metrics_conversion_sign_ups_order_quantity_engagement
conversion_sign_ups.sale_amount_engagement metrics_conversion_sign_ups_sale_amount_engagement
conversion_sign_ups.sale_amount_view metrics_conversion_sign_ups_sale_amount_view
conversion_sign_ups.post_view metrics_conversion_sign_ups_post_view
conversion_sign_ups.order_quantity metrics_conversion_sign_ups_order_quantity
conversion_sign_ups.assisted metrics_conversion_sign_ups_assisted
conversion_sign_ups.post_engagement metrics_conversion_sign_ups_post_engagement
conversion_sign_ups.sale_amount metrics_conversion_sign_ups_sale_amount
conversion_sign_ups.metric metrics_conversion_sign_ups_metric
conversion_sign_ups,order_quantity_view metrics_conversion_sign_ups_order_quantity_view
conversion_site_visits.order_quantity_engagement metrics_conversion_site_visits_order_quantity_engagement
conversion_site_visits.sale_amount_engagement metrics_conversion_site_visits_sale_amount_engagement
conversion_site_visits.sale_amount_view metrics_conversion_site_visits_sale_amount_view
conversion_site_visits.post_view metrics_conversion_site_visits_post_view
conversion_site_visits.order_quantity metrics_conversion_site_visits_order_quantity
conversion_site_visits.post_engagement metrics_conversion_site_visits_post_engagement
conversion_site_visits.sale_amount metrics_conversion_site_visits_sale_amount
conversion_site_visits.metric metrics_conversion_site_visits_metric
conversion_site_visits.order_quantity_view metrics_conversion_site_visits_order_quantity_view
conversion_downloads.order_quantity_engagement metrics_conversion_downloads_order_quantity_engagement
conversion_downloads.sale_amount_engagement metrics_conversion_downloads_sale_amount_engagement
conversion_downloads.sale_amount_view metrics_conversion_downloads_sale_amount_view
conversion_downloads.post_view metrics_conversion_downloads_post_view
conversion_downloads.order_quantity metrics_conversion_downloads_order_quantity
conversion_downloads.post_engagement metrics_conversion_downloads_post_engagement
conversion_downloads.sale_amount metrics_conversion_downloads_sale_amount
conversion_downloads.metric metrics_conversion_downloads_metric
conversion_downloads.order_quantity_view metrics_conversion_downloads_order_quantity_view
conversion_custom.order_quantity_engagement metrics_conversion_custom_order_quantity_engagement
conversion_custom.sale_amount_engagement metrics_conversion_custom_sale_amount_engagement
conversion_custom.sale_amount_view metrics_conversion_custom_sale_amount_view
conversion_custom.post_view metrics_conversion_custom_post_view
conversion_custom.order_quantity metrics_conversion_custom_order_quantity
conversion_custom.post_engagement metrics_conversion_custom_post_engagement
conversion_custom.sale_amount metrics_conversion_custom_sale_amount
conversion_custom.metric metrics_conversion_custom_metric
conversion_custom.order_quantity_view metrics_conversion_custom_order_quantity_view3-90

 

 

 

 

Mobile Conversion


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

mobile_conversion_spent_credits.post_view metrics_mobile_conversion_spent_credits_post_view
mobile_conversion_spent_credits.order_quantity metrics_mobile_conversion_spent_credits_order_quantity
mobile_conversion_spent_credits.assisted metrics_mobile_conversion_spent_credits_assisted
mobile_conversion_spent_credits.post_engagement metrics_mobile_conversion_spent_credits_post_engagement
mobile_conversion_spent_credits.sale_amount metrics_mobile_conversion_spent_credits_sale_amount
mobile_conversion_installs.skan.post_view metrics_mobile_conversion_installs_skan_post_view
mobile_conversion_installs.skan.post_engagement metrics_mobile_conversion_installs_skan_post_engagement
mobile_conversion_installs.post_view metrics_mobile_conversion_installs_post_view
mobile_conversion_installs.order_quantity metrics_mobile_conversion_installs_order_quantity
mobile_conversion_installs.assisted metrics_mobile_conversion_installs_assisted
mobile_conversion_installs.post_engagement metrics_mobile_conversion_installs_post_engagement
mobile_conversion_installs.sale_amount metrics_mobile_conversion_installs_sale_amount
mobile_conversion_content_views.post_view metrics_mobile_conversion_content_views_post_view
mobile_conversion_content_views.order_quantity metrics_mobile_conversion_content_views_order_quantity
mobile_conversion_content_views.assisted metrics_mobile_conversion_content_views_assisted
mobile_conversion_content_views.post_engagement metrics_mobile_conversion_content_views_post_engagement
mobile_conversion_content_views.sale_amount metrics_mobile_conversion_content_views_sale_amount
mobile_conversion_add_to_wishlists.post_view metrics_mobile_conversion_add_to_wishlists_post_view
mobile_conversion_add_to_wishlists.order_quantity metrics_mobile_conversion_add_to_wishlists_order_quantity
mobile_conversion_add_to_wishlists.assisted metrics_mobile_conversion_add_to_wishlists_assisted
mobile_conversion_add_to_wishlists.post_engagement metrics_mobile_conversion_add_to_wishlists_post_engagement
mobile_conversion_add_to_wishlists.sale_amount metrics_mobile_conversion_add_to_wishlists_sale_amount
mobile_conversion_checkouts_initiated.post_view metrics_mobile_conversion_checkouts_initiated_post_view
mobile_conversion_checkouts_initiated.order_quantity metrics_mobile_conversion_checkouts_initiated_order_quantity
mobile_conversion_checkouts_initiated.assisted metrics_mobile_conversion_checkouts_initiated_assisted
mobile_conversion_checkouts_initiated.post_engagement metrics_mobile_conversion_checkouts_initiated_post_engagement
mobile_conversion_checkouts_initiated.sale_amount metrics_mobile_conversion_checkouts_initiated_sale_amount
mobile_conversion_reservations.post_view metrics_mobile_conversion_reservations_post_view
mobile_conversion_reservations.order_quantity metrics_mobile_conversion_reservations_order_quantity
mobile_conversion_reservations.assisted metrics_mobile_conversion_reservations_assisted
mobile_conversion_reservations.post_engagement metrics_mobile_conversion_reservations_post_engagement
mobile_conversion_reservations.sale_amount metrics_mobile_conversion_reservations_sale_amount
mobile_conversion_tutorials_completed.post_view metrics_mobile_conversion_tutorials_completed_post_view
mobile_conversion_tutorials_completed.order_quantity metrics_mobile_conversion_tutorials_completed_order_quantity
mobile_conversion_tutorials_completed.assisted metrics_mobile_conversion_tutorials_completed_assisted
mobile_conversion_tutorials_completed.post_engagement metrics_mobile_conversion_tutorials_completed_post_engagement
mobile_conversion_tutorials_completed.sale_amount metrics_mobile_conversion_tutorials_completed_sale_amount
mobile_conversion_achievements_unlocked.post_view metrics_mobile_conversion_achievements_unlocked_post_view
mobile_conversion_achievements_unlocked.order_quantity metrics_mobile_conversion_achievements_unlocked_order_quantity
mobile_conversion_achievements_unlocked.assisted metrics_mobile_conversion_achievements_unlocked_assisted
mobile_conversion_achievements_unlocked.post_engagement metrics_mobile_conversion_achievements_unlocked_post_engagement
mobile_conversion_achievements_unlocked.sale_amount metrics_mobile_conversion_achievements_unlocked_sale_amount
mobile_conversion_searches.post_view metrics_mobile_conversion_searches_post_view
mobile_conversion_searches.order_quantity metrics_mobile_conversion_searches_order_quantity
mobile_conversion_searches.assisted metrics_mobile_conversion_searches_assisted
mobile_conversion_searches.post_engagement metrics_mobile_conversion_searches_post_engagement
mobile_conversion_searches.sale_amount metrics_mobile_conversion_searches_sale_amount
mobile_conversion_add_to_carts.post_view metrics_mobile_conversion_add_to_carts_post_view
mobile_conversion_add_to_carts.order_quantity metrics_mobile_conversion_add_to_carts_order_quantity
mobile_conversion_add_to_carts.assisted metrics_mobile_conversion_add_to_carts_assisted
mobile_conversion_add_to_carts.post_engagement metrics_mobile_conversion_add_to_carts_post_engagement
mobile_conversion_add_to_carts.sale_amount metrics_mobile_conversion_add_to_carts_sale_amount
mobile_conversion_payment_info_additions.post_view metrics_mobile_conversion_payment_info_additions_post_view
mobile_conversion_payment_info_additions.order_quantity metrics_mobile_conversion_payment_info_additions_order_quantity
mobile_conversion_payment_info_additions.assisted metrics_mobile_conversion_payment_info_additions_assisted
mobile_conversion_payment_info_additions.post_engagement metrics_mobile_conversion_payment_info_additions_post_engagement
mobile_conversion_payment_info_additions.sale_amount metrics_mobile_conversion_payment_info_additions_sale_amount
mobile_conversion_re_engages.post_view metrics_mobile_conversion_re_engages_post_view
mobile_conversion_re_engages.order_quantity metrics_mobile_conversion_re_engages_order_quantity
mobile_conversion_re_engages.assisted metrics_mobile_conversion_re_engages_assisted
mobile_conversion_re_engages.post_engagement metrics_mobile_conversion_re_engages_post_engagement
mobile_conversion_re_engages.sale_amount metrics_mobile_conversion_re_engages_sale_amount
mobile_conversion_shares.post_view metrics_mobile_conversion_shares_post_view
mobile_conversion_shares.order_quantity metrics_mobile_conversion_shares_order_quantity
mobile_conversion_shares.assisted metrics_mobile_conversion_shares_assisted
mobile_conversion_shares.post_engagement metrics_mobile_conversion_shares_post_engagement
mobile_conversion_shares.sale_amount metrics_mobile_conversion_shares_sale_amount
mobile_conversion_rates.post_view metrics_mobile_conversion_rates_post_view
mobile_conversion_rates.order_quantity metrics_mobile_conversion_rates_order_quantity
mobile_conversion_rates.assisted metrics_mobile_conversion_rates_assisted
mobile_conversion_rates.post_engagement metrics_mobile_conversion_rates_post_engagement
mobile_conversion_rates.sale_amount metrics_mobile_conversion_rates_sale_amount
mobile_conversion_logins.post_view metrics_mobile_conversion_logins_post_view
mobile_conversion_logins.order_quantity metrics_mobile_conversion_logins_order_quantity
mobile_conversion_logins.assisted metrics_mobile_conversion_logins_assisted
mobile_conversion_logins.post_engagement metrics_mobile_conversion_logins_post_engagement
mobile_conversion_logins.sale_amount metrics_mobile_conversion_logins_sale_amount
mobile_conversion_updates.post_view metrics_mobile_conversion_updates_post_view
mobile_conversion_updates.order_quantity metrics_mobile_conversion_updates_order_quantity
mobile_conversion_updates.assisted metrics_mobile_conversion_updates_assisted
mobile_conversion_updates.post_engagement metrics_mobile_conversion_updates_post_engagement
mobile_conversion_updates.sale_amount metrics_mobile_conversion_updates_sale_amount
mobile_conversion_levels_achieved.post_view  metrics_mobile_conversion_levels_achieved_post_view
mobile_conversion_levels_achieved.order_quantity metrics_mobile_conversion_levels_achieved_order_quantity
mobile_conversion_levels_achieved.assisted metrics_mobile_conversion_levels_achieved_post_engagement
mobile_conversion_levels_achieved.post_engagement metrics_mobile_conversion_levels_achieved_post_engagement
mobile_conversion_levels_achieved.sale_amount metrics_mobile_conversion_levels_achieved_sale_amount
mobile_conversion_invites.post_view metrics_mobile_conversion_invites_post_view
mobile_conversion_invites.order_quantity metrics_mobile_conversion_invites_order_quantity
mobile_conversion_invites.assisted metrics_mobile_conversion_invites_assisted
mobile_conversion_invites.post_engagement metrics_mobile_conversion_invites_post_engagement
mobile_conversion_invites.sale_amount metrics_mobile_conversion_invites_sale_amount
mobile_conversion_key_page_views.post_view metrics_mobile_conversion_key_page_views_post_view
mobile_conversion_key_page_views.post_engagement metrics_mobile_conversion_key_page_views_post_engagement
mobile_conversion_downloads.post_view metrics_mobile_conversion_downloads_post_view
mobile_conversion_downloads.sale_amount metrics_mobile_conversion_downloads_sale_amount
mobile_conversion_downloads.post_engagement metrics_mobile_conversion_downloads_post_engagement
mobile_conversion_downloads.order_quantity metrics_mobile_conversion_downloads_order_quantity
mobile_conversion_purchases.skan.post_view metrics_mobile_conversion_purchases_skan_post_view
mobile_conversion_purchases.skan.post_engagement metrics_mobile_conversion_purchases_skan_post_engagement
mobile_conversion_purchases.post_view metrics_mobile_conversion_purchases_post_view
mobile_conversion_purchases.order_quantity metrics_mobile_conversion_purchases_order_quantity
mobile_conversion_purchases.assisted metrics_mobile_conversion_purchases_assisted
mobile_conversion_purchases.post_engagement sale_amount
mobile_conversion_purchases.sale_amount metrics_mobile_conversion_purchases_sale_amount
mobile_conversion_sign_ups.post_view metrics_mobile_conversion_sign_ups_post_view
mobile_conversion_sign_ups.order_quantity metrics_mobile_conversion_sign_ups_order_quantity
mobile_conversion_sign_ups.assisted metrics_mobile_conversion_sign_ups_assisted
mobile_conversion_sign_ups.post_engagement metrics_mobile_conversion_sign_ups_post_engagement
mobile_conversion_sign_ups.sale_amount metrics_mobile_conversion_sign_ups_sale_amount
mobile_conversion_site_visits.order_quantity metrics_mobile_conversion_site_visits_order_quantity
mobile_conversion_site_visits.post_engagement metrics_mobile_conversion_site_visits_post_engagement
mobile_conversion_site_visits.post_view metrics_mobile_conversion_site_visits_post_view
mobile_conversion_site_visits.sale_amount metrics_mobile_conversion_site_visits_sale_amount

 

 

Lifetime Value Mobile Conversion


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

mobile_conversion_lifetime_value_purchases.order_quantity metrics_mobile_conversion_lifetime_value_purchases_order_quantity
mobile_conversion_lifetime_value_purchases.metric metrics_mobile_conversion_lifetime_value_purchases_metric
mobile_conversion_lifetime_value_purchases.sale_amount metrics_mobile_conversion_lifetime_value_purchases_sale_amount
mobile_conversion_lifetime_value_sign_ups.order_quantity metrics_mobile_conversion_lifetime_value_sign_ups_order_quantity
mobile_conversion_lifetime_value_sign_ups.metric metrics_mobile_conversion_lifetime_value_sign_ups_metric
mobile_conversion_lifetime_value_sign_ups.sale_amount metrics_mobile_conversion_lifetime_value_sign_ups_sale_amount
mobile_conversion_lifetime_value_updates.order_quantity metrics_mobile_conversion_lifetime_value_updates_order_quantity
mobile_conversion_lifetime_value_updates.sale_amount metrics_mobile_conversion_lifetime_value_updates_sale_amount
mobile_conversion_lifetime_value_updates.metric metrics_mobile_conversion_lifetime_value_updates_metric
mobile_conversion_lifetime_value_tutorials_completed.order_quantity metrics_mobile_conversion_lifetime_value_tutorials_completed_order_quantity
mobile_conversion_lifetime_value_tutorials_completed.metric metrics_mobile_conversion_lifetime_value_tutorials_completed_metric
mobile_conversion_lifetime_value_tutorials_completed.sale_amount metrics_mobile_conversion_lifetime_value_tutorials_completed_sale_amount
mobile_conversion_lifetime_value_reservations.order_quantity metrics_mobile_conversion_lifetime_value_reservations_order_quantity
mobile_conversion_lifetime_value_reservations.sale_amount metrics_mobile_conversion_lifetime_value_reservations_sale_amount
mobile_conversion_lifetime_value_reservations.metric metrics_mobile_conversion_lifetime_value_reservations_metric
mobile_conversion_lifetime_value_add_to_carts.order_quantity metrics_mobile_conversion_lifetime_value_add_to_carts_order_quantity
mobile_conversion_lifetime_value_add_to_carts.metric metrics_mobile_conversion_lifetime_value_add_to_carts_metric
mobile_conversion_lifetime_value_add_to_carts.sale_amount metrics_mobile_conversion_lifetime_value_add_to_carts_sale_amount
mobile_conversion_lifetime_value_add_to_wishlists.sale_amount metrics_mobile_conversion_lifetime_value_add_to_wishlists_sale_amount
mobile_conversion_lifetime_value_add_to_wishlists.order_quantity metrics_mobile_conversion_lifetime_value_add_to_wishlists_order_quantity
mobile_conversion_lifetime_value_add_to_wishlists.metric metrics_mobile_conversion_lifetime_value_add_to_wishlists_metric
mobile_conversion_lifetime_value_checkouts_initiated.order_quantity metrics_mobile_conversion_lifetime_value_checkouts_initiated_order_quantity
mobile_conversion_lifetime_value_checkouts_initiated.metric metrics_mobile_conversion_lifetime_value_checkouts_initiated_metric
mobile_conversion_lifetime_value_checkouts_initiated.sale_amount metrics_mobile_conversion_lifetime_value_checkouts_initiated_sale_amount
mobile_conversion_lifetime_value_levels_achieved.order_quantity metrics_mobile_conversion_lifetime_value_levels_achieved_order_quantity
mobile_conversion_lifetime_value_levels_achieved.metric metrics_mobile_conversion_lifetime_value_levels_achieved_metric
mobile_conversion_lifetime_value_levels_achieved.sale_amount metrics_mobile_conversion_lifetime_value_levels_achieved_sale_amount
mobile_conversion_lifetime_value_achievements_unlocked.order_quantity metrics_mobile_conversion_lifetime_value_achievements_unlocked_order_quantity
mobile_conversion_lifetime_value_achievements_unlocked.metric metrics_mobile_conversion_lifetime_value_achievements_unlocked_metric
mobile_conversion_lifetime_value_achievements_unlocked.sale_amount metrics_mobile_conversion_lifetime_value_achievements_unlocked_sale_amount
mobile_conversion_lifetime_value_shares.order_quantity metrics_mobile_conversion_lifetime_value_shares_order_quantity
mobile_conversion_lifetime_value_shares.sale_amount metrics_mobile_conversion_lifetime_value_shares_sale_amount
mobile_conversion_lifetime_value_shares.metric metrics_mobile_conversion_lifetime_value_shares_metric
mobile_conversion_lifetime_value_invites.sale_amount metrics_mobile_conversion_lifetime_value_invites_sale_amount
mobile_conversion_lifetime_value_invites.metric metrics_mobile_conversion_lifetime_value_invites_metric
mobile_conversion_lifetime_value_invites.order_quantity metrics_mobile_conversion_lifetime_value_invites_order_quantity
mobile_conversion_lifetime_value_payment_info_additions.sale_amount metrics_mobile_conversion_lifetime_value_payment_info_additions_sale_amount
mobile_conversion_lifetime_value_payment_info_additions.order_quantity metrics_mobile_conversion_lifetime_value_payment_info_additions_order_quantity
mobile_conversion_lifetime_value_payment_info_additions.metric metrics_mobile_conversion_lifetime_value_payment_info_additions_metric
mobile_conversion_lifetime_value_spent_credits.order_quantity metrics_mobile_conversion_lifetime_value_spent_credits_order_quantity
mobile_conversion_lifetime_value_spent_credits.metric metrics_mobile_conversion_lifetime_value_spent_credits_metric
mobile_conversion_lifetime_value_spent_credits.sale_amount metrics_mobile_conversion_lifetime_value_spent_credits_sale_amount
mobile_conversion_lifetime_value_rates.metric metrics_mobile_conversion_lifetime_value_rates_metric
mobile_conversion_lifetime_value_rates.order_quantity metrics_mobile_conversion_lifetime_value_rates_order_quantity
mobile_conversion_lifetime_value_rates.sale_amount metrics_mobile_conversion_lifetime_value_rates_sale_amount
mobile_conversion_lifetime_value_logins.metric metrics_mobile_conversion_lifetime_value_logins_metric
mobile_conversion_lifetime_value_logins.order_quantity metrics_mobile_conversion_lifetime_value_logins_order_quantity
mobile_conversion_lifetime_value_logins.sale_amount metrics_mobile_conversion_lifetime_value_logins_sale_amount
mobile_conversion_lifetime_value_content_views.sale_amount metrics_mobile_conversion_lifetime_value_content_views_sale_amount
mobile_conversion_lifetime_value_content_views.metric metrics_mobile_conversion_lifetime_value_content_views_metric
mobile_conversion_lifetime_value_content_views.order_quantity metrics_mobile_conversion_lifetime_value_content_views_order_quantity
mobile_conversion_lifetime_value_searches.order_quantity metrics_mobile_conversion_lifetime_value_searches_order_quantity
mobile_conversion_lifetime_value_searches.sale_amount metrics_mobile_conversion_lifetime_value_searches_sale_amount
mobile_conversion_lifetime_value_searches.metric metrics_mobile_conversion_lifetime_value_searches_metric

 

Stats Campaigns

  • Endpoint: Analytics
  • Update Method: TRUNCSERT
  • Table Name: twitter.stats_campaigns
JSON Element Database Column
MD5(twitter_account_id + id) __sync_key
twitter_account_id account_id
id id
segment segment
placement placement
start_time start_time
end_time end_time
metric_groups[] All columns specified in Stats Metric Groups schema

 

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

 

Stats Line Items

  • Endpoint: Analytics
  • Update Method: TRUNCSERT
  • Table Name: twitter.stats_line_items
JSON Element Database Column
MD5(twitter_account_id + id) __sync_key
twitter_account_id account_id
id id
segment segment
placement placement
start_time start_time
end_time end_time
metric_groups[] All columns specified in Stats Metric Groups schema

 

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

 

Stats Media Creatives

  • Endpoint: Analytics
  • Update Method: TRUNCSERT
  • Table Name: twitter.stats_media_creatives
JSON Element Database Column
MD5(twitter_account_id + id) __sync_key
twitter_account_id account_id
id id
segment segment
placement placement
start_time start_time
end_time end_time
metric_groups[] All columns specified in Stats Metric Groups schema

 

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

 

Stats Promoted Accounts

  • Endpoint: Analytics
  • Update Method: TRUNCSERT
  • Table Name: twitter.stats_promoted_accounts
JSON Element Database Column
MD5(twitter_account_id + id) __sync_key
twitter_account_id account_id
id id
segment segment
placement placement
start_time start_time
end_time end_time
metric_groups[] All columns specified in Stats Metric Groups schema

 

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.


Stats Promoted Tweets

  • Endpoint: Analytics
  • Update Method: TRUNCSERT
  • Table Name: twitter.stats_promoted_tweets
JSON Element Database Column
MD5(twitter_account_id + id) __sync_key
twitter_account_id account_id
id id
segment segment
placement placement
start_time start_time
end_time end_time
metric_groups[] All columns specified in Stats Metric Groups schema

 

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.


Tweets

  • Endpoint: Tweets
  • Update Method: TRUNCSERT
  • Table Name: twitter.tweets
JSON Element Database Column
twitter_account_id account_id
id id
retweeted retweeted
name name
conversation_settings conversation_settings
source source
favorite_count favorite_count
in_reply_to_user_id in_reply_to_user_id
truncated truncated
retweet_count retweet_count
scheduled_status scheduled_status
in_reply_to_status_id in_reply_to_status_id
possibly_sensitive possibly_sensitive
nilcast nilcast
created_at created_at
scheduled_at scheduled_at
tweet_type tweet_type
favorited favorited
card_uri card_uri
full_text full_text
lang lang
in_reply_to_screen_name in_reply_to_screen_name
user::id user_id
MD5(twitter_account_id + id) __sync_key

 

Related Resources: