Schema Information for Snapchat Ads

Need help with something?

Talk to data expert

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 DocumentationAd_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