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:
- Accounts
- Account Media
- Active Entities
- Analytics
- Campaigns
- Line Items
- Media Creatives
- Promoted Accounts
- Promoted Tweets
- Tweets
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
- Accounts
- Campaign Not Servable Reasons
- Campaigns
- Line Item Categories
- Line Item Placements
- Line Items
- Media Creatives
- Promoted Accounts
- Promoted Tweets
- Stats Active Entities
- Stats Active Entity Placement
- Stats Metric Groups
- Stats Campaigns
- Stats Line Items
- Stats Media Creatives
- Stats Promoted Accounts
- Stats Promoted Tweets
- Tweets
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: