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 |
AllCampagins_AdAccount
Purpose: This API retrieves all campaigns within a specified ad account.
Source API Documentation: AllCampagins_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 |
CampaginStats_Country
Purpose: This API retrieves stats for the specified campaign, with metrics broken down by country.
Source API Documentation: CampaginStats_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 |
CampaginStats
Purpose: This API retrieves stats for the specified campaign
Source API Documentation: CampaginStats
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 |