Snapchat Marketing connector

Set up the Snapchat Marketing connector in Kaivo: authentication, configuration, the 20 BigQuery tables it syncs, and answers to common questions.

Written By Lauri Raivio

Last updated 16 days ago

Kaivo is a fully managed data platform that syncs your Snapchat Marketing data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your marketing and sales data instead of moving it.

What is the Snapchat Marketing connector

Sync your Snapchat Marketing campaigns, ads, and performance stats into BigQuery with Kaivo to report social spend next to your other channels.

Category	Marketing & Sales
Authentication	OAuth
Setup	On request, contact us to enable it

Getting started with the Snapchat Marketing connector

Sign up for Kaivo and create a workspace.
Ask us to enable the Snapchat Marketing connector for your workspace. You can reach our team from the chat in the app.
Choose which tables to sync.
Wait for the initial sync to finish.
Query your data in BigQuery or your favourite AI or BI tool.

Authenticating Snapchat Marketing

Connect by signing in to your Snapchat Marketing account. Kaivo runs the connection for you, so you never share a password.

Configuring the Snapchat Marketing connector

When you set up the connector, you provide:

Field	Description
Start Date	Any data before this date will not be fetched.
Action Report Time	Specifies the principle for conversion reporting.
Swipe Up Attribution Window	Attribution window for swipe ups.
View Attribution Window	Attribution window for views.
Organization IDs	The IDs of the organizations to retrieve.
Ad Account IDs	The IDs of the ad accounts to retrieve.

Tables and columns synced from Snapchat Marketing

Kaivo syncs 20 tables from Snapchat Marketing into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

adaccounts (17 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	The type or category of the ad account.
`advertiser_organization_id`	`STRING`	The ID of the organization that is advertising on the platform.
`agency_representing_client`	`BOOL`	The agency representing the client for ad account management.
`billing_center_id`	`STRING`	The ID of the billing center associated with the ad account.
`billing_type`	`STRING`	The type of billing arrangement for the ad account.
`client_paying_invoices`	`BOOL`	Indicates if the client is responsible for paying the invoices.
`created_at`	`STRING`	The timestamp when the ad account was created.
`currency`	`STRING`	The currency used for financial transactions within the ad account.
`id`	`STRING`	The unique identifier for the ad account.
`name`	`STRING`	The name or title of the ad account.
`organization_id`	`STRING`	The ID of the organization that owns the ad account.
`regulations__restricted_delivery_signals`	`BOOL`	Signals or content types subject to delivery restrictions.
`status`	`STRING`	The current status or state of the ad account.
`timezone`	`STRING`	The timezone setting for the ad account operations.
`updated_at`	`STRING`	The timestamp when the ad account details were last updated.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

adaccounts__funding_source_ids (4 columns)

adaccounts_stats_daily (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

adaccounts_stats_hourly (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

adaccounts_stats_lifetime (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

ads (12 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	The type or category of the ad.
`ad_squad_id`	`STRING`	The unique identifier of the ad squad this ad belongs to.
`created_at`	`STRING`	The date and time when the ad was created.
`creative_id`	`STRING`	The unique identifier of the creative content used in the ad.
`id`	`STRING`	The unique identifier of the ad.
`name`	`STRING`	The name or title of the ad.
`render_type`	`STRING`	The type of rendering used for the ad.
`review_status`	`STRING`	The review status of the ad.
`status`	`STRING`	The current status of the ad.
`updated_at`	`STRING`	The date and time when the ad was last updated.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

ads__delivery_status (4 columns)
ads__review_status_reasons (4 columns)

ads_stats_daily (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

ads_stats_hourly (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

ads_stats_lifetime (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

adsquads (32 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of the ad squad.
`auto_bid`	`BOOL`	Indicates whether the ad squad is using auto-bidding for its bids.
`bid_strategy`	`STRING`	Specifies the bidding strategy used by the ad squad.
`billing_event`	`STRING`	Defines the billing event for the ad squad.
`campaign_id`	`STRING`	ID of the campaign associated with the ad squad.
`child_ad_type`	`STRING`	Type of child ads under the ad squad.
`created_at`	`STRING`	Timestamp indicating when the ad squad was created.
`creation_state`	`STRING`	Current state of the ad squad creation process.
`daily_budget_micro`	`INT64`	Daily budget in micro currency units for the ad squad.
`delivery_constraint`	`STRING`	Constraints applied to the delivery of the ad squad.
`delivery_properties_version`	`INT64`	Version of delivery properties for the ad squad.
`end_time`	`STRING`	End time for the ad squad's run.
`forced_view_setting`	`STRING`	Setting to force views for the ad squad.
`id`	`STRING`	Unique identifier for the ad squad.
`lifetime_budget_micro`	`INT64`	Total budget in micro currency units for the lifetime of the ad squad.
`name`	`STRING`	Name of the ad squad.
`optimization_goal`	`STRING`	Goal used for optimizing ad delivery.
`pacing_type`	`STRING`	Type of pacing applied to the ad squad's delivery.
`placement`	`STRING`	Ad placement settings for the ad squad.
`skadnetwork_properties__ecid_enrollment_status`	`STRING`	Status of ECID enrollment.
`skadnetwork_properties__enable_skoverlay`	`BOOL`	Option to enable SKOverlay.
`skadnetwork_properties__status`	`STRING`	Current status of SKAdNetwork.
`start_time`	`STRING`	Start time for the ad squad's run.
`status`	`STRING`	Current status of the ad squad.
... and 7 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

adsquads__delivery_status (4 columns)
adsquads__event_sources__place (4 columns)
adsquads__targeting__demographics (3 columns)
adsquads__targeting__geos (5 columns)
adsquads__targeting__interests (4 columns)
adsquads__targeting__interests__category_id (4 columns)
adsquads__targeting__locations (4 columns)
adsquads__targeting__locations__circles (8 columns)

adsquads_stats_daily (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

adsquads_stats_hourly (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

adsquads_stats_lifetime (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

campaigns (12 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`ad_account_id`	`STRING`	The unique identifier of the advertising account associated with the campaign.
`buy_model`	`STRING`	The purchasing model used for the campaign (e.g., auction, reach and frequency).
`created_at`	`STRING`	The timestamp indicating when the campaign was created.
`creation_state`	`STRING`	The current state of the campaign creation process.
`id`	`STRING`	The unique identifier of the campaign.
`name`	`STRING`	The name assigned to the campaign for easy identification.
`objective`	`STRING`	The primary goal or objective of the campaign.
`start_time`	`STRING`	The starting date and time for the campaign to begin running.
`status`	`STRING`	The current status of the campaign (e.g., paused, active).
`updated_at`	`STRING`	The timestamp indicating when the campaign was last updated.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

campaigns__delivery_status (4 columns)

campaigns_stats_daily (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

campaigns_stats_hourly (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

campaigns_stats_lifetime (77 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	Type of data entry.
`android_installs`	`FLOAT64`	Total number of installs on Android devices.
`attachment_avg_view_time_millis`	`FLOAT64`	Average time in milliseconds a viewer spends viewing an attachment.
`attachment_frequency`	`FLOAT64`	Frequency of attachment views.
`attachment_impressions`	`FLOAT64`	Total number of times an attachment is displayed to users.
`attachment_quartile_1`	`FLOAT64`	First quartile of attachment viewing time.
`attachment_quartile_2`	`FLOAT64`	Second quartile of attachment viewing time.
`attachment_quartile_3`	`FLOAT64`	Third quartile of attachment viewing time.
`attachment_total_view_time_millis`	`FLOAT64`	Total time in milliseconds viewers spend on attachment views.
`attachment_uniques`	`FLOAT64`	Unique viewers of attachments.
`attachment_view_completion`	`FLOAT64`	Percentage of attachment views that are completed.
`avg_screen_time_millis`	`FLOAT64`	Average time in milliseconds users spent on the screen.
`avg_view_time_millis`	`FLOAT64`	Average time in milliseconds viewers spend on viewing content.
`conversion_achievement_unlocked`	`FLOAT64`	Number of times achievements are unlocked.
`conversion_ad_click`	`FLOAT64`	Number of ad clicks recorded.
`conversion_ad_view`	`FLOAT64`	Number of ad views.
`conversion_add_billing`	`FLOAT64`	Conversion events where billing information is added.
`conversion_add_cart`	`FLOAT64`	Conversion events where items are added to cart.
`conversion_add_to_wishlist`	`FLOAT64`	Conversion events where items are added to the wishlist.
`conversion_app_opens`	`FLOAT64`	Number of times the app is opened.
`conversion_complete_tutorial`	`FLOAT64`	Number of completed tutorials.
`conversion_invite`	`FLOAT64`	Number of invitations sent by users.
`conversion_level_completes`	`FLOAT64`	Number of game levels completed.
`conversion_list_view`	`FLOAT64`	Number of views on the list content.
... and 52 more columns

creatives (25 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	The type or category of the creative
`ad_account_id`	`STRING`	The ID of the advertising account linked to the creative
`ad_product`	`STRING`	The type of Snapchat advertising product used for the creative
`ad_to_place_properties__place_id`	`STRING`	The ID of the place where the ad is to be displayed
`brand_name`	`STRING`	The name of the brand associated with the creative
`call_to_action`	`STRING`	The call to action prompt for the creative
`created_at`	`STRING`	The timestamp indicating when the creative was created
`forced_view_eligibility`	`STRING`	Whether the creative is eligible for forced views
`headline`	`STRING`	The headline or title of the creative
`id`	`STRING`	The unique identifier of the creative
`name`	`STRING`	The name or title given to the creative
`packaging_status`	`STRING`	The status of the packaging for the creative
`render_type`	`STRING`	The type of rendering used for the creative
`review_status`	`STRING`	The overall review status of the creative
`review_status_details`	`STRING`	Additional details related to the review status
`shareable`	`BOOL`	Indicates if the creative is shareable
`top_snap_crop_position`	`STRING`	The crop position for the top snap of the creative
`top_snap_media_id`	`STRING`	The ID of the media file for the top snap
`updated_at`	`STRING`	The timestamp indicating when the creative was last updated
`web_view_properties__allow_snap_javascript_sdk`	`BOOL`	Whether to allow the use of Snap JavaScript SDK in the web view
`web_view_properties__block_preload`	`BOOL`	Indicates if preloading is blocked for the web view
`web_view_properties__url`	`STRING`	The URL to be loaded in the web view
`web_view_properties__use_immersive_mode`	`BOOL`	Whether to use immersive mode in the web view
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

creatives__web_view_properties__deep_link_urls (4 columns)

media (16 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	The type of media (e.g., image, video).
`ad_account_id`	`STRING`	The unique identifier of the ad account associated with the media.
`created_at`	`STRING`	The timestamp when the media was created.
`download_link`	`STRING`	The link to download the media file.
`duration_in_seconds`	`FLOAT64`	The duration of the media in seconds.
`file_name`	`STRING`	The name of the media file.
`file_size_in_bytes`	`INT64`	The file size of the media in bytes.
`hash`	`STRING`	The hash value of the media file for identification purposes.
`id`	`STRING`	The unique identifier of the media.
`is_demo_media`	`BOOL`	Indicates if the media is a demo or not.
`media_status`	`STRING`	The status of the media (e.g., active, inactive).
`name`	`STRING`	The name or title of the media.
`updated_at`	`STRING`	The timestamp when the media was last updated.
`visibility`	`STRING`	The visibility settings of the media (e.g., public, private).
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

media__media_usages (4 columns)

organizations (23 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`type`	`STRING`	The type or category of the organization.
`accepted_term_version`	`STRING`	The version of the terms and conditions accepted by the organization.
`address_line_1`	`STRING`	The first line of the organization's address.
`administrative_district_level_1`	`STRING`	The first-level administrative district of the organization's location.
`configuration_settings__notifications_enabled`	`BOOL`	Flag indicating if notifications are enabled for the organization.
`contact_email`	`STRING`	The email address used for contact purposes.
`contact_name`	`STRING`	The name of the contact person within the organization.
`contact_phone`	`STRING`	The phone number of the contact person within the organization.
`contact_phone_optin`	`BOOL`	Flag indicating if contact person has opted in for phone contact.
`country`	`STRING`	The country where the organization is located.
`created_by_caller`	`BOOL`	Record of the creator of the organization within the system.
`created_at`	`STRING`	Timestamp indicating the creation date of the organization record.
`id`	`STRING`	Unique identifier for the organization record.
`locality`	`STRING`	The locality or city where the organization is situated.
`my_display_name`	`STRING`	The public display name of the organization.
`my_invited_email`	`STRING`	Email address of the member invited to the organization.
`my_member_id`	`STRING`	Unique identifier of the member within the organization.
`name`	`STRING`	The name of the organization.
`postal_code`	`STRING`	The postal code of the organization's location.
`state`	`STRING`	The state or region where the organization is located.
`updated_at`	`STRING`	Timestamp indicating the last update date of the organization record.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

organizations__roles (4 columns)

segments (15 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`description`	`STRING`	Brief description of the segment.
`ad_account_id`	`STRING`	The unique identifier for the ad account associated with the segment.
`approximate_number_users`	`INT64`	Approximate number of users within the segment.
`created_at`	`STRING`	The date and time when the segment was created.
`id`	`STRING`	Unique identifier for the segment.
`name`	`STRING`	Name or title of the segment.
`organization_id`	`STRING`	Unique identifier for the organization to which the segment belongs.
`retention_in_days`	`INT64`	Number of days for which the segment data is retained.
`source_type`	`STRING`	Type of the source data used to create the segment.
`status`	`STRING`	Current status of the segment (e.g., active, inactive).
`targetable_status`	`STRING`	Status indicating whether the segment can be targeted in marketing campaigns.
`updated_at`	`STRING`	The date and time when the segment was last updated.
`upload_status`	`STRING`	Status of the segment upload process (e.g., pending, completed).
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

segments__visible_to (4 columns)

How the Snapchat Marketing sync works

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Snapchat Marketing supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won't get duplicate rows.

Frequently asked questions

How long does the initial sync take for Snapchat Marketing?

It depends on how much history is in your Snapchat Marketing account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they're much faster.

Can I sync only some tables or columns?

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don't select are never copied to your warehouse.

What happens when Snapchat Marketing's schema changes?

New fields are never added automatically. You choose which fields to sync, so data you haven't selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table's sync mode: full-refresh tables always match what's currently in Snapchat Marketing, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Snapchat Marketing instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Snapchat Marketing connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Snapchat Marketing data

Campaign performance

Use campaigns, adsquads, and ads with their stats streams to track spend and results.

Creative comparison

Use creatives and media to see which assets perform and which are worn out.

Time-based trends

Use the hourly, daily, and lifetime stats streams to compare short and long term trends.

Cross-channel reporting

Report Snapchat next to your other ad platforms in one model rather than separate tools.

Use Snapchat Marketing data in your AI and BI tools

Once Snapchat Marketing data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here's how the most common destinations work with Snapchat Marketing data.

Claude

Use Kaivo's MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Power BI

Microsoft's BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Data Studio

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

Tableau

The premium analytics standard, with native BigQuery integration. Setup guide →

Google Sheets

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Excel

Connect via Power Query's BigQuery connector. Setup guide →

Metabase

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Snapchat Marketing connector pricing and plan details.

Google Ads: Sync Google Ads to BigQuery.
Custobar: Sync Custobar to BigQuery.
Google Search Console: Sync Google Search Console to BigQuery.
HubSpot: Sync HubSpot to BigQuery.
Adform: Sync Adform to BigQuery.
Amplitude: Sync Amplitude to BigQuery.

Was this helpful?

Still need help? Share an idea

What is the Snapchat Marketing connector

Getting started with the Snapchat Marketing connector

Authenticating Snapchat Marketing

Configuring the Snapchat Marketing connector

Tables and columns synced from Snapchat Marketing

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

How the Snapchat Marketing sync works

Frequently asked questions

How long does the initial sync take for Snapchat Marketing?

Can I sync only some tables or columns?

What happens when Snapchat Marketing's schema changes?

How do I handle GDPR or data deletion requests?

Common use cases for Snapchat Marketing data

Campaign performance

Creative comparison

Time-based trends

Cross-channel reporting

Use Snapchat Marketing data in your AI and BI tools

Claude

Power BI

Data Studio

Tableau

Google Sheets

Excel

Metabase

Related connectors