Schema Information for Snapchat Ads
Schema Information for Snapchat Ads
In this article, we will look at the schema information of the supported APIs and tables for Snapchat Ads.
Find the links to other articles related to Snapchat Ads Below:
Tables/APIs Supported
The following are the Tables or APIs associated with the Snapchat Ads connector.
Ad_Account
Purpose: This API retrieves all ad accounts for the specified Organization.
Source API Documentation: Ad_Account
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| updated_at | TIMESTAMP |
| created_at | TIMESTAMP |
| name | STRING |
| type | STRING |
| status | STRING |
| organization_id | STRING |
| funding_source_ids | STRING |
| currency | STRING |
| timezone | STRING |
| advertiser_organization_id | STRING |
| billing_center_id | STRING |
| billing_type | STRING |
| cell_ids | STRING |
| agency_representing_client | BOOLEAN |
| client_paying_invoices | BOOLEAN |
Organizations
Purpose: This API retrieves all organizations.
Source API Documentation: Organizations
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| updated_at | TIMESTAMP |
| created_at | TIMESTAMP |
| name | STRING |
| country | STRING |
| postal_code | STRING |
| locality | STRING |
| contact_name | STRING |
| contact_email | STRING |
| contact_phone | STRING |
| address_line_1 | STRING |
| administrative_district_level_1 | STRING |
| accepted_term_version | STRING |
| contact_phone_optin | BOOLEAN |
| configuration_settings | RECORD |
| type | STRING |
| state | STRING |
| business_type | STRING |
| roles | STRING |
| ad_accounts | RECORD |
| my_display_name | STRING |
| my_invited_email | STRING |
| my_member_id | STRING |
| createdByCaller | BOOLEAN |
| configuration_settings.notifications_enabled | BOOLEAN |
| ad_accounts.id | STRING |
| ad_accounts.updated_at | TIMESTAMP |
| ad_accounts.created_at | TIMESTAMP |
| ad_accounts.name | STRING |
| ad_accounts.type | STRING |
| ad_accounts.status | STRING |
| ad_accounts.currency | STRING |
| ad_accounts.timezone | STRING |
| ad_accounts.roles | STRING |
AdSquad_AdAccount
Purpose: This API retrieves all ad squads within a specified ad account.
Source API Documentation: AdSquad_AdAccount
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| updated_at | TIMESTAMP |
| created_at | TIMESTAMP |
| name | STRING |
| status | STRING |
| campaign_id | STRING |
| type | STRING |
| targeting | RECORD |
| targeting_reach_status | STRING |
| placement_v2 | RECORD |
| billing_event | STRING |
| auto_bid | BOOLEAN |
| target_bid | BOOLEAN |
| bid_strategy | STRING |
| daily_budget_micro | NUMERIC |
| start_time | TIMESTAMP |
| optimization_goal | STRING |
| pixel_id | STRING |
| delivery_constraint | STRING |
| pacing_type | STRING |
| child_ad_type | STRING |
| forced_view_setting | STRING |
| creation_state | STRING |
| delivery_status | STRING |
| skadnetwork_properties | RECORD |
| delivery_properties_version | NUMERIC |
| end_time | TIMESTAMP |
| deleted | BOOLEAN |
| targeting.regulated_content | BOOLEAN |
| targeting.demographics | RECORD |
| targeting.demographics.min_age | STRING |
| targeting.demographics.operation | STRING |
| targeting.geos | RECORD |
| targeting.geos.country_code | STRING |
| targeting.geos.operation | STRING |
| targeting.enable_targeting_expansion | BOOLEAN |
| targeting.auto_expansion_options | RECORD |
| targeting.auto_expansion_options.interest_expansion_option | RECORD |
| targeting.auto_expansion_options.interest_expansion_option.enabled | BOOLEAN |
| targeting.auto_expansion_options.custom_audience_expansion_option | RECORD |
| targeting.auto_expansion_options.custom_audience_expansion_option.enabled | BOOLEAN |
| placement_v2.config | STRING |
| skadnetwork_properties.status | STRING |
AllCampaigns_AdAccount
Purpose: This API retrieves all campaigns within a specified ad account.
Source API Documentation: AllCampaigns_AdAccount
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| updated_at | TIMESTAMP |
| created_at | TIMESTAMP |
| name | STRING |
| ad_account_id | STRING |
| status | STRING |
| objective | STRING |
| start_time | TIMESTAMP |
| buy_model | STRING |
| delivery_status | STRING |
| creation_state | STRING |
Ads_AdAccount
Purpose: This API retrieves all Ads under a specified Ad account.
Source API Documentation: Ads_AdAccount
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| updated_at | TIMESTAMP |
| created_at | TIMESTAMP |
| name | STRING |
| ad_squad_id | STRING |
| creative_id | STRING |
| status | STRING |
| type | STRING |
| render_type | STRING |
| review_status | STRING |
| delivery_status | STRING |
| deleted | BOOLEAN |
AdAccountStats
Purpose: This API retrieves the spend metric for the specified Ad Account, the spend metric is the only metric available for the ad account entity.
Source API Documentation: AdAccountStats
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| type | STRING |
| granularity | STRING |
| start_time | TIMESTAMP |
| end_time | TIMESTAMP |
| finalized_data_end_time | TIMESTAMP |
| timeseries | RECORD |
| timeseries.start_time | TIMESTAMP |
| timeseries.end_time | TIMESTAMP |
| timeseries.stats | RECORD |
| timeseries.stats.spend | NUMERIC |
CampaignStats_Country
Purpose: This API retrieves stats for the specified campaign, with metrics broken down by country.
Source API Documentation: CampaignStats_Country
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| type | STRING |
| granularity | STRING |
| swipe_up_attribution_window | STRING |
| view_attribution_window | STRING |
| start_time | TIMESTAMP |
| end_time | TIMESTAMP |
| finalized_data_end_time | TIMESTAMP |
| conversion_data_processed_end_time | TIMESTAMP |
| timeseries | RECORD |
| timeseries.start_time | TIMESTAMP |
| timeseries.end_time | TIMESTAMP |
| timeseries.dimension_stats | RECORD |
| timeseries.dimension_stats.swipes | NUMERIC |
| timeseries.dimension_stats.quartile_1 | NUMERIC |
| timeseries.dimension_stats.quartile_2 | NUMERIC |
| timeseries.dimension_stats.quartile_3 | NUMERIC |
| timeseries.dimension_stats.view_completion | NUMERIC |
| timeseries.dimension_stats.attachment_total_view_time_millis | NUMERIC |
| timeseries.dimension_stats.frequency | NUMERIC |
| timeseries.dimension_stats.swipe_up_percent | NUMERIC |
| timeseries.dimension_stats.attachment_frequency | NUMERIC |
| timeseries.dimension_stats.uniques | NUMERIC |
| timeseries.dimension_stats.attachment_uniques | NUMERIC |
| timeseries.dimension_stats.spend | NUMERIC |
| timeseries.dimension_stats.view_time_millis | NUMERIC |
| timeseries.dimension_stats.video_views | NUMERIC |
| timeseries.dimension_stats.country | STRING |
| timeseries.dimension_stats.total_impressions | NUMERIC |
| timeseries.dimension_stats.paid_impressions | NUMERIC |
| timeseries.dimension_stats.screen_time_millis | NUMERIC |
| timeseries.dimension_stats.shares | NUMERIC |
| timeseries.dimension_stats.ios_installs | NUMERIC |
| timeseries.dimension_stats.android_installs | NUMERIC |
| timeseries.dimension_stats.total_installs | NUMERIC |
| timeseries.dimension_stats.conversion_purchases | NUMERIC |
| timeseries.dimension_stats.conversion_purchases_value | NUMERIC |
| timeseries.dimension_stats.conversion_save | NUMERIC |
| timeseries.dimension_stats.conversion_save_value | NUMERIC |
| timeseries.dimension_stats.conversion_start_checkout | NUMERIC |
| timeseries.dimension_stats.conversion_start_checkout_value | NUMERIC |
| timeseries.dimension_stats.conversion_add_cart | NUMERIC |
| timeseries.dimension_stats.conversion_add_cart_value | NUMERIC |
| timeseries.dimension_stats.conversion_view_content | NUMERIC |
| timeseries.dimension_stats.conversion_view_content_value | NUMERIC |
| timeseries.dimension_stats.conversion_add_billing | NUMERIC |
| timeseries.dimension_stats.conversion_add_billing_value | NUMERIC |
| timeseries.dimension_stats.conversion_searches | NUMERIC |
| timeseries.dimension_stats.conversion_searches_value | NUMERIC |
| timeseries.dimension_stats.conversion_level_completes | NUMERIC |
| timeseries.dimension_stats.conversion_level_completes_value | NUMERIC |
| timeseries.dimension_stats.conversion_app_opens | NUMERIC |
| timeseries.dimension_stats.conversion_app_opens_value | NUMERIC |
| timeseries.dimension_stats.conversion_page_views | NUMERIC |
| timeseries.dimension_stats.conversion_page_views_value | NUMERIC |
| timeseries.dimension_stats.conversion_subscribe | NUMERIC |
| timeseries.dimension_stats.conversion_subscribe_value | NUMERIC |
| timeseries.dimension_stats.conversion_ad_click | NUMERIC |
| timeseries.dimension_stats.conversion_ad_click_value | NUMERIC |
| timeseries.dimension_stats.conversion_ad_view | NUMERIC |
| timeseries.dimension_stats.conversion_ad_view_value | NUMERIC |
| timeseries.dimension_stats.conversion_complete_tutorial | NUMERIC |
| timeseries.dimension_stats.conversion_complete_tutorial_value | NUMERIC |
| timeseries.dimension_stats.conversion_invite | NUMERIC |
| timeseries.dimension_stats.conversion_invite_value | NUMERIC |
| timeseries.dimension_stats.conversion_login | NUMERIC |
| timeseries.dimension_stats.conversion_login_value | NUMERIC |
| timeseries.dimension_stats.conversion_share | NUMERIC |
| timeseries.dimension_stats.conversion_share_value | NUMERIC |
| timeseries.dimension_stats.conversion_reserve | NUMERIC |
| timeseries.dimension_stats.conversion_reserve_value | NUMERIC |
| timeseries.dimension_stats.conversion_achievement_unlocked | NUMERIC |
| timeseries.dimension_stats.conversion_achievement_unlocked_value | NUMERIC |
| timeseries.dimension_stats.conversion_add_to_wishlist | NUMERIC |
| timeseries.dimension_stats.conversion_add_to_wishlist_value | NUMERIC |
| timeseries.dimension_stats.conversion_spend_credits | NUMERIC |
| timeseries.dimension_stats.conversion_spend_credits_value | NUMERIC |
| timeseries.dimension_stats.conversion_rate | NUMERIC |
| timeseries.dimension_stats.conversion_rate_value | NUMERIC |
| timeseries.dimension_stats.conversion_start_trial | NUMERIC |
| timeseries.dimension_stats.conversion_start_trial_value | NUMERIC |
| timeseries.dimension_stats.conversion_list_view | NUMERIC |
| timeseries.dimension_stats.conversion_list_view_value | NUMERIC |
| timeseries.dimension_stats.custom_event_1 | NUMERIC |
| timeseries.dimension_stats.custom_event_1_value | NUMERIC |
| timeseries.dimension_stats.custom_event_2 | NUMERIC |
| timeseries.dimension_stats.custom_event_2_value | NUMERIC |
| timeseries.dimension_stats.custom_event_3 | NUMERIC |
| timeseries.dimension_stats.custom_event_3_value | NUMERIC |
| timeseries.dimension_stats.custom_event_4 | NUMERIC |
| timeseries.dimension_stats.custom_event_4_value | NUMERIC |
| timeseries.dimension_stats.custom_event_5 | NUMERIC |
| timeseries.dimension_stats.custom_event_5_value | NUMERIC |
CampaignStats
Purpose: This API retrieves stats for the specified campaign
Source API Documentation: CampaignStats
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| type | STRING |
| granularity | STRING |
| start_time | TIMESTAMP |
| end_time | TIMESTAMP |
| finalized_data_end_time | TIMESTAMP |
| conversion_data_processed_end_time | TIMESTAMP |
| timeseries | RECORD |
| timeseries.start_time | TIMESTAMP |
| timeseries.end_time | TIMESTAMP |
| timeseries.stats | RECORD |
| timeseries.stats.impressions | NUMERIC |
| timeseries.stats.swipes | NUMERIC |
| timeseries.stats.quartile_1 | NUMERIC |
| timeseries.stats.quartile_2 | NUMERIC |
| timeseries.stats.quartile_3 | NUMERIC |
| timeseries.stats.view_completion | NUMERIC |
| timeseries.stats.attachment_quartile_1 | NUMERIC |
| timeseries.stats.attachment_quartile_2 | NUMERIC |
| timeseries.stats.attachment_quartile_3 | NUMERIC |
| timeseries.stats.attachment_view_completion | NUMERIC |
| timeseries.stats.attachment_total_view_time_millis | NUMERIC |
| timeseries.stats.frequency | NUMERIC |
| timeseries.stats.avg_view_time_millis | NUMERIC |
| timeseries.stats.swipe_up_percent | NUMERIC |
| timeseries.stats.attachment_frequency | NUMERIC |
| timeseries.stats.attachment_avg_view_time_millis | NUMERIC |
| timeseries.stats.uniques | NUMERIC |
| timeseries.stats.attachment_impressions | NUMERIC |
| timeseries.stats.attachment_uniques | NUMERIC |
| timeseries.stats.earned_reach | NUMERIC |
| timeseries.stats.total_reach | NUMERIC |
| timeseries.stats.spend | NUMERIC |
| timeseries.stats.view_time_millis | NUMERIC |
| timeseries.stats.video_views | NUMERIC |
| timeseries.stats.video_views_time_based | NUMERIC |
| timeseries.stats.video_views_15s | NUMERIC |
| timeseries.stats.total_impressions | NUMERIC |
| timeseries.stats.earned_impressions | NUMERIC |
| timeseries.stats.paid_impressions | NUMERIC |
| timeseries.stats.screen_time_millis | NUMERIC |
| timeseries.stats.avg_screen_time_millis | NUMERIC |
| timeseries.stats.shares | NUMERIC |
| timeseries.stats.play_time_millis | NUMERIC |
| timeseries.stats.saves | NUMERIC |
| timeseries.stats.native_leads | NUMERIC |
| timeseries.stats.profile_clicks | NUMERIC |
| timeseries.stats.ios_installs | NUMERIC |
| timeseries.stats.android_installs | NUMERIC |
| timeseries.stats.total_installs | NUMERIC |
| timeseries.stats.conversion_purchases | NUMERIC |
| timeseries.stats.conversion_purchases_value | NUMERIC |
| timeseries.stats.conversion_save | NUMERIC |
| timeseries.stats.conversion_save_value | NUMERIC |
| timeseries.stats.conversion_start_checkout | NUMERIC |
| timeseries.stats.conversion_start_checkout_value | NUMERIC |
| timeseries.stats.conversion_add_cart | NUMERIC |
| timeseries.stats.conversion_add_cart_value | NUMERIC |
| timeseries.stats.conversion_view_content | NUMERIC |
| timeseries.stats.conversion_view_content_value | NUMERIC |
| timeseries.stats.conversion_add_billing | NUMERIC |
| timeseries.stats.conversion_add_billing_value | NUMERIC |
| timeseries.stats.conversion_searches | NUMERIC |
| timeseries.stats.conversion_searches_value | NUMERIC |
| timeseries.stats.conversion_level_completes | NUMERIC |
| timeseries.stats.conversion_level_completes_value | NUMERIC |
| timeseries.stats.conversion_app_opens | NUMERIC |
| timeseries.stats.conversion_app_opens_value | NUMERIC |
| timeseries.stats.conversion_page_views | NUMERIC |
| timeseries.stats.conversion_page_views_value | NUMERIC |
| timeseries.stats.conversion_subscribe | NUMERIC |
| timeseries.stats.conversion_subscribe_value | NUMERIC |
| timeseries.stats.conversion_ad_click | NUMERIC |
| timeseries.stats.conversion_ad_click_value | NUMERIC |
| timeseries.stats.conversion_ad_view | NUMERIC |
| timeseries.stats.conversion_ad_view_value | NUMERIC |
| timeseries.stats.conversion_complete_tutorial | NUMERIC |
| timeseries.stats.conversion_complete_tutorial_value | NUMERIC |
| timeseries.stats.conversion_invite | NUMERIC |
| timeseries.stats.conversion_invite_value | NUMERIC |
| timeseries.stats.conversion_login | NUMERIC |
| timeseries.stats.conversion_login_value | NUMERIC |
| timeseries.stats.conversion_share | NUMERIC |
| timeseries.stats.conversion_share_value | NUMERIC |
| timeseries.stats.conversion_reserve | NUMERIC |
| timeseries.stats.conversion_reserve_value | NUMERIC |
| timeseries.stats.conversion_achievement_unlocked | NUMERIC |
| timeseries.stats.conversion_achievement_unlocked_value | NUMERIC |
| timeseries.stats.conversion_add_to_wishlist | NUMERIC |
| timeseries.stats.conversion_add_to_wishlist_value | NUMERIC |
| timeseries.stats.conversion_spend_credits | NUMERIC |
| timeseries.stats.conversion_spend_credits_value | NUMERIC |
| timeseries.stats.conversion_rate | NUMERIC |
| timeseries.stats.conversion_rate_value | NUMERIC |
| timeseries.stats.conversion_start_trial | NUMERIC |
| timeseries.stats.conversion_start_trial_value | NUMERIC |
| timeseries.stats.conversion_list_view | NUMERIC |
| timeseries.stats.conversion_list_view_value | NUMERIC |
| timeseries.stats.custom_event_1 | NUMERIC |
| timeseries.stats.custom_event_1_value | NUMERIC |
| timeseries.stats.custom_event_2 | NUMERIC |
| timeseries.stats.custom_event_2_value | NUMERIC |
| timeseries.stats.custom_event_3 | NUMERIC |
| timeseries.stats.custom_event_3_value | NUMERIC |
| timeseries.stats.custom_event_4 | NUMERIC |
| timeseries.stats.custom_event_4_value | NUMERIC |
| timeseries.stats.custom_event_5 | NUMERIC |
| timeseries.stats.custom_event_5_value | NUMERIC |
AdStats
Purpose: This API retrieves stats for the specified Ad.
Source API Documentation: AdStats
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| type | STRING |
| granularity | STRING |
| start_time | TIMESTAMP |
| end_time | TIMESTAMP |
| finalized_data_end_time | TIMESTAMP |
| conversion_data_processed_end_time | TIMESTAMP |
| timeseries | RECORD |
| timeseries.start_time | TIMESTAMP |
| timeseries.end_time | TIMESTAMP |
| timeseries.stats | RECORD |
| timeseries.stats.impressions | NUMERIC |
| timeseries.stats.swipes | NUMERIC |
| timeseries.stats.quartile_1 | NUMERIC |
| timeseries.stats.quartile_2 | NUMERIC |
| timeseries.stats.quartile_3 | NUMERIC |
| timeseries.stats.view_completion | NUMERIC |
| timeseries.stats.attachment_quartile_1 | NUMERIC |
| timeseries.stats.attachment_quartile_2 | NUMERIC |
| timeseries.stats.attachment_quartile_3 | NUMERIC |
| timeseries.stats.attachment_view_completion | NUMERIC |
| timeseries.stats.attachment_total_view_time_millis | NUMERIC |
| timeseries.stats.frequency | NUMERIC |
| timeseries.stats.avg_view_time_millis | NUMERIC |
| timeseries.stats.swipe_up_percent | NUMERIC |
| timeseries.stats.attachment_frequency | NUMERIC |
| timeseries.stats.attachment_avg_view_time_millis | NUMERIC |
| timeseries.stats.uniques | NUMERIC |
| timeseries.stats.attachment_impressions | NUMERIC |
| timeseries.stats.attachment_uniques | NUMERIC |
| timeseries.stats.earned_reach | NUMERIC |
| timeseries.stats.total_reach | NUMERIC |
| timeseries.stats.spend | NUMERIC |
| timeseries.stats.view_time_millis | NUMERIC |
| timeseries.stats.video_views | NUMERIC |
| timeseries.stats.video_views_time_based | NUMERIC |
| timeseries.stats.video_views_15s | NUMERIC |
| timeseries.stats.total_impressions | NUMERIC |
| timeseries.stats.earned_impressions | NUMERIC |
| timeseries.stats.paid_impressions | NUMERIC |
| timeseries.stats.screen_time_millis | NUMERIC |
| timeseries.stats.avg_screen_time_millis | NUMERIC |
| timeseries.stats.shares | NUMERIC |
| timeseries.stats.play_time_millis | NUMERIC |
| timeseries.stats.saves | NUMERIC |
| timeseries.stats.native_leads | NUMERIC |
| timeseries.stats.profile_clicks | NUMERIC |
| timeseries.stats.ios_installs | NUMERIC |
| timeseries.stats.android_installs | NUMERIC |
| timeseries.stats.total_installs | NUMERIC |
| timeseries.stats.conversion_purchases | NUMERIC |
| timeseries.stats.conversion_purchases_value | NUMERIC |
| timeseries.stats.conversion_save | NUMERIC |
| timeseries.stats.conversion_save_value | NUMERIC |
| timeseries.stats.conversion_start_checkout | NUMERIC |
| timeseries.stats.conversion_start_checkout_value | NUMERIC |
| timeseries.stats.conversion_add_cart | NUMERIC |
| timeseries.stats.conversion_add_cart_value | NUMERIC |
| timeseries.stats.conversion_view_content | NUMERIC |
| timeseries.stats.conversion_view_content_value | NUMERIC |
| timeseries.stats.conversion_add_billing | NUMERIC |
| timeseries.stats.conversion_add_billing_value | NUMERIC |
| timeseries.stats.conversion_searches | NUMERIC |
| timeseries.stats.conversion_searches_value | NUMERIC |
| timeseries.stats.conversion_level_completes | NUMERIC |
| timeseries.stats.conversion_level_completes_value | NUMERIC |
| timeseries.stats.conversion_app_opens | NUMERIC |
| timeseries.stats.conversion_app_opens_value | NUMERIC |
| timeseries.stats.conversion_page_views | NUMERIC |
| timeseries.stats.conversion_page_views_value | NUMERIC |
| timeseries.stats.conversion_subscribe | NUMERIC |
| timeseries.stats.conversion_subscribe_value | NUMERIC |
| timeseries.stats.conversion_ad_click | NUMERIC |
| timeseries.stats.conversion_ad_click_value | NUMERIC |
| timeseries.stats.conversion_ad_view | NUMERIC |
| timeseries.stats.conversion_ad_view_value | NUMERIC |
| timeseries.stats.conversion_complete_tutorial | NUMERIC |
| timeseries.stats.conversion_complete_tutorial_value | NUMERIC |
| timeseries.stats.conversion_invite | NUMERIC |
| timeseries.stats.conversion_invite_value | NUMERIC |
| timeseries.stats.conversion_login | NUMERIC |
| timeseries.stats.conversion_login_value | NUMERIC |
| timeseries.stats.conversion_share | NUMERIC |
| timeseries.stats.conversion_share_value | NUMERIC |
| timeseries.stats.conversion_reserve | NUMERIC |
| timeseries.stats.conversion_reserve_value | NUMERIC |
| timeseries.stats.conversion_achievement_unlocked | NUMERIC |
| timeseries.stats.conversion_achievement_unlocked_value | NUMERIC |
| timeseries.stats.conversion_add_to_wishlist | NUMERIC |
| timeseries.stats.conversion_add_to_wishlist_value | NUMERIC |
| timeseries.stats.conversion_spend_credits | NUMERIC |
| timeseries.stats.conversion_spend_credits_value | NUMERIC |
| timeseries.stats.conversion_rate | NUMERIC |
| timeseries.stats.conversion_rate_value | NUMERIC |
| timeseries.stats.conversion_start_trial | NUMERIC |
| timeseries.stats.conversion_start_trial_value | NUMERIC |
| timeseries.stats.conversion_list_view | NUMERIC |
| timeseries.stats.conversion_list_view_value | NUMERIC |
| timeseries.stats.custom_event_1 | NUMERIC |
| timeseries.stats.custom_event_1_value | NUMERIC |
| timeseries.stats.custom_event_2 | NUMERIC |
| timeseries.stats.custom_event_2_value | NUMERIC |
| timeseries.stats.custom_event_3 | NUMERIC |
| timeseries.stats.custom_event_3_value | NUMERIC |
| timeseries.stats.custom_event_4 | NUMERIC |
| timeseries.stats.custom_event_4_value | NUMERIC |
| timeseries.stats.custom_event_5 | NUMERIC |
| timeseries.stats.custom_event_5_value | NUMERIC |
AdStats_Country
Purpose: This API retrieves stats for the specified Ad, with metrics broken down by country.
Source API Documentation: AdStats_Country
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| type | STRING |
| granularity | STRING |
| swipe_up_attribution_window | STRING |
| view_attribution_window | STRING |
| start_time | TIMESTAMP |
| end_time | TIMESTAMP |
| finalized_data_end_time | TIMESTAMP |
| conversion_data_processed_end_time | TIMESTAMP |
| timeseries | RECORD |
| timeseries.start_time | TIMESTAMP |
| timeseries.end_time | TIMESTAMP |
| timeseries.dimension_stats | RECORD |
| timeseries.dimension_stats.swipes | NUMERIC |
| timeseries.dimension_stats.quartile_1 | NUMERIC |
| timeseries.dimension_stats.quartile_2 | NUMERIC |
| timeseries.dimension_stats.quartile_3 | NUMERIC |
| timeseries.dimension_stats.view_completion | NUMERIC |
| timeseries.dimension_stats.attachment_total_view_time_millis | NUMERIC |
| timeseries.dimension_stats.frequency | NUMERIC |
| timeseries.dimension_stats.swipe_up_percent | NUMERIC |
| timeseries.dimension_stats.attachment_frequency | NUMERIC |
| timeseries.dimension_stats.uniques | NUMERIC |
| timeseries.dimension_stats.attachment_uniques | NUMERIC |
| timeseries.dimension_stats.spend | NUMERIC |
| timeseries.dimension_stats.view_time_millis | NUMERIC |
| timeseries.dimension_stats.video_views | NUMERIC |
| timeseries.dimension_stats.country | STRING |
| timeseries.dimension_stats.total_impressions | NUMERIC |
| timeseries.dimension_stats.paid_impressions | NUMERIC |
| timeseries.dimension_stats.screen_time_millis | NUMERIC |
| timeseries.dimension_stats.shares | NUMERIC |
| timeseries.dimension_stats.ios_installs | NUMERIC |
| timeseries.dimension_stats.android_installs | NUMERIC |
| timeseries.dimension_stats.total_installs | NUMERIC |
| timeseries.dimension_stats.conversion_purchases | NUMERIC |
| timeseries.dimension_stats.conversion_purchases_value | NUMERIC |
| timeseries.dimension_stats.conversion_save | NUMERIC |
| timeseries.dimension_stats.conversion_save_value | NUMERIC |
| timeseries.dimension_stats.conversion_start_checkout | NUMERIC |
| timeseries.dimension_stats.conversion_start_checkout_value | NUMERIC |
| timeseries.dimension_stats.conversion_add_cart | NUMERIC |
| timeseries.dimension_stats.conversion_add_cart_value | NUMERIC |
| timeseries.dimension_stats.conversion_view_content | NUMERIC |
| timeseries.dimension_stats.conversion_view_content_value | NUMERIC |
| timeseries.dimension_stats.conversion_add_billing | NUMERIC |
| timeseries.dimension_stats.conversion_add_billing_value | NUMERIC |
| timeseries.dimension_stats.conversion_searches | NUMERIC |
| timeseries.dimension_stats.conversion_searches_value | NUMERIC |
| timeseries.dimension_stats.conversion_level_completes | NUMERIC |
| timeseries.dimension_stats.conversion_level_completes_value | NUMERIC |
| timeseries.dimension_stats.conversion_app_opens | NUMERIC |
| timeseries.dimension_stats.conversion_app_opens_value | NUMERIC |
| timeseries.dimension_stats.conversion_page_views | NUMERIC |
| timeseries.dimension_stats.conversion_page_views_value | NUMERIC |
| timeseries.dimension_stats.conversion_subscribe | NUMERIC |
| timeseries.dimension_stats.conversion_subscribe_value | NUMERIC |
| timeseries.dimension_stats.conversion_ad_click | NUMERIC |
| timeseries.dimension_stats.conversion_ad_click_value | NUMERIC |
| timeseries.dimension_stats.conversion_ad_view | NUMERIC |
| timeseries.dimension_stats.conversion_ad_view_value | NUMERIC |
| timeseries.dimension_stats.conversion_complete_tutorial | NUMERIC |
| timeseries.dimension_stats.conversion_complete_tutorial_value | NUMERIC |
| timeseries.dimension_stats.conversion_invite | NUMERIC |
| timeseries.dimension_stats.conversion_invite_value | NUMERIC |
| timeseries.dimension_stats.conversion_login | NUMERIC |
| timeseries.dimension_stats.conversion_login_value | NUMERIC |
| timeseries.dimension_stats.conversion_share | NUMERIC |
| timeseries.dimension_stats.conversion_share_value | NUMERIC |
| timeseries.dimension_stats.conversion_reserve | NUMERIC |
| timeseries.dimension_stats.conversion_reserve_value | NUMERIC |
| timeseries.dimension_stats.conversion_achievement_unlocked | NUMERIC |
| timeseries.dimension_stats.conversion_achievement_unlocked_value | NUMERIC |
| timeseries.dimension_stats.conversion_add_to_wishlist | NUMERIC |
| timeseries.dimension_stats.conversion_add_to_wishlist_value | NUMERIC |
| timeseries.dimension_stats.conversion_spend_credits | NUMERIC |
| timeseries.dimension_stats.conversion_spend_credits_value | NUMERIC |
| timeseries.dimension_stats.conversion_rate | NUMERIC |
| timeseries.dimension_stats.conversion_rate_value | NUMERIC |
| timeseries.dimension_stats.conversion_start_trial | NUMERIC |
| timeseries.dimension_stats.conversion_start_trial_value | NUMERIC |
| timeseries.dimension_stats.conversion_list_view | NUMERIC |
| timeseries.dimension_stats.conversion_list_view_value | NUMERIC |
| timeseries.dimension_stats.custom_event_1 | NUMERIC |
| timeseries.dimension_stats.custom_event_1_value | NUMERIC |
| timeseries.dimension_stats.custom_event_2 | NUMERIC |
| timeseries.dimension_stats.custom_event_2_value | NUMERIC |
| timeseries.dimension_stats.custom_event_3 | NUMERIC |
| timeseries.dimension_stats.custom_event_3_value | NUMERIC |
| timeseries.dimension_stats.custom_event_4 | NUMERIC |
| timeseries.dimension_stats.custom_event_4_value | NUMERIC |
| timeseries.dimension_stats.custom_event_5 | NUMERIC |
| timeseries.dimension_stats.custom_event_5_value | NUMERIC |
AdSquadStats
Purpose: This API retrieves stats for the specified Ad Squad.
Source API Documentation: AdSquadStats
Primary Key: id - This is the unique identifier.
| Name | Data Type |
| id | STRING |
| type | STRING |
| granularity | STRING |
| start_time | TIMESTAMP |
| end_time | TIMESTAMP |
| finalized_data_end_time | TIMESTAMP |
| conversion_data_processed_end_time | TIMESTAMP |
| timeseries | RECORD |
| timeseries.start_time | TIMESTAMP |
| timeseries.end_time | TIMESTAMP |
| timeseries.stats | RECORD |
| timeseries.stats.impressions | NUMERIC |
| timeseries.stats.swipes | NUMERIC |
| timeseries.stats.quartile_1 | NUMERIC |
| timeseries.stats.quartile_2 | NUMERIC |
| timeseries.stats.quartile_3 | NUMERIC |
| timeseries.stats.view_completion | NUMERIC |
| timeseries.stats.attachment_quartile_1 | NUMERIC |
| timeseries.stats.attachment_quartile_2 | NUMERIC |
| timeseries.stats.attachment_quartile_3 | NUMERIC |
| timeseries.stats.attachment_view_completion | NUMERIC |
| timeseries.stats.attachment_total_view_time_millis | NUMERIC |
| timeseries.stats.frequency | NUMERIC |
| timeseries.stats.avg_view_time_millis | NUMERIC |
| timeseries.stats.swipe_up_percent | NUMERIC |
| timeseries.stats.attachment_frequency | NUMERIC |
| timeseries.stats.attachment_avg_view_time_millis | NUMERIC |
| timeseries.stats.uniques | NUMERIC |
| timeseries.stats.attachment_impressions | NUMERIC |
| timeseries.stats.attachment_uniques | NUMERIC |
| timeseries.stats.earned_reach | NUMERIC |
| timeseries.stats.total_reach | NUMERIC |
| timeseries.stats.spend | NUMERIC |
| timeseries.stats.view_time_millis | NUMERIC |
| timeseries.stats.video_views | NUMERIC |
| timeseries.stats.video_views_time_based | NUMERIC |
| timeseries.stats.video_views_15s | NUMERIC |
| timeseries.stats.total_impressions | NUMERIC |
| timeseries.stats.earned_impressions | NUMERIC |
| timeseries.stats.paid_impressions | NUMERIC |
| timeseries.stats.screen_time_millis | NUMERIC |
| timeseries.stats.avg_screen_time_millis | NUMERIC |
| timeseries.stats.shares | NUMERIC |
| timeseries.stats.play_time_millis | NUMERIC |
| timeseries.stats.saves | NUMERIC |
| timeseries.stats.native_leads | NUMERIC |
| timeseries.stats.profile_clicks | NUMERIC |
| timeseries.stats.ios_installs | NUMERIC |
| timeseries.stats.android_installs | NUMERIC |
| timeseries.stats.total_installs | NUMERIC |
| timeseries.stats.conversion_purchases | NUMERIC |
| timeseries.stats.conversion_purchases_value | NUMERIC |
| timeseries.stats.conversion_save | NUMERIC |
| timeseries.stats.conversion_save_value | NUMERIC |
| timeseries.stats.conversion_start_checkout | NUMERIC |
| timeseries.stats.conversion_start_checkout_value | NUMERIC |
| timeseries.stats.conversion_add_cart | NUMERIC |
| timeseries.stats.conversion_add_cart_value | NUMERIC |
| timeseries.stats.conversion_view_content | NUMERIC |
| timeseries.stats.conversion_view_content_value | NUMERIC |
| timeseries.stats.conversion_add_billing | NUMERIC |
| timeseries.stats.conversion_add_billing_value | NUMERIC |
| timeseries.stats.conversion_searches | NUMERIC |
| timeseries.stats.conversion_searches_value | NUMERIC |
| timeseries.stats.conversion_level_completes | NUMERIC |
| timeseries.stats.conversion_level_completes_value | NUMERIC |
| timeseries.stats.conversion_app_opens | NUMERIC |
| timeseries.stats.conversion_app_opens_value | NUMERIC |
| timeseries.stats.conversion_page_views | NUMERIC |
| timeseries.stats.conversion_page_views_value | NUMERIC |
| timeseries.stats.conversion_subscribe | NUMERIC |
| timeseries.stats.conversion_subscribe_value | NUMERIC |
| timeseries.stats.conversion_ad_click | NUMERIC |
| timeseries.stats.conversion_ad_click_value | NUMERIC |
| timeseries.stats.conversion_ad_view | NUMERIC |
| timeseries.stats.conversion_ad_view_value | NUMERIC |
| timeseries.stats.conversion_complete_tutorial | NUMERIC |
| timeseries.stats.conversion_complete_tutorial_value | NUMERIC |
| timeseries.stats.conversion_invite | NUMERIC |
| timeseries.stats.conversion_invite_value | NUMERIC |
| timeseries.stats.conversion_login | NUMERIC |
| timeseries.stats.conversion_login_value | NUMERIC |
| timeseries.stats.conversion_share | NUMERIC |
| timeseries.stats.conversion_share_value | NUMERIC |
| timeseries.stats.conversion_reserve | NUMERIC |
| timeseries.stats.conversion_reserve_value | NUMERIC |
| timeseries.stats.conversion_achievement_unlocked | NUMERIC |
| timeseries.stats.conversion_achievement_unlocked_value | NUMERIC |
| timeseries.stats.conversion_add_to_wishlist | NUMERIC |
| timeseries.stats.conversion_add_to_wishlist_value | NUMERIC |
| timeseries.stats.conversion_spend_credits | NUMERIC |
| timeseries.stats.conversion_spend_credits_value | NUMERIC |
| timeseries.stats.conversion_rate | NUMERIC |
| timeseries.stats.conversion_rate_value | NUMERIC |
| timeseries.stats.conversion_start_trial | NUMERIC |
| timeseries.stats.conversion_start_trial_value | NUMERIC |
| timeseries.stats.conversion_list_view | NUMERIC |
| timeseries.stats.conversion_list_view_value | NUMERIC |
| timeseries.stats.custom_event_1 | NUMERIC |
| timeseries.stats.custom_event_1_value | NUMERIC |
| timeseries.stats.custom_event_2 | NUMERIC |
| timeseries.stats.custom_event_2_value | NUMERIC |
| timeseries.stats.custom_event_3 | NUMERIC |
| timeseries.stats.custom_event_3_value | NUMERIC |
| timeseries.stats.custom_event_4 | NUMERIC |
| timeseries.stats.custom_event_4_value | NUMERIC |
| timeseries.stats.custom_event_5 | NUMERIC |
| timeseries.stats.custom_event_5_value | NUMERIC |