Snapchat Marketing connector

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

1. Sign up for Kaivo and create a workspace.
2. Ask us to enable the Snapchat Marketing connector for your workspace. You can reach our team from the chat in the app.
3. Choose which tables to sync.
4. Wait for the initial sync to finish.
5. 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.

How do I handle GDPR or data deletion requests?

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.

Related connectors

• 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.