Pinterest connector

Kaivo is a fully managed data platform that syncs your Pinterest 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 Pinterest connector

Sync your Pinterest boards, pins, campaigns, and ad performance into BigQuery with Kaivo to report organic and paid reach in one model.

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

Getting started with the Pinterest connector

1. Sign up for Kaivo and create a workspace.
2. Ask us to enable the Pinterest 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 Pinterest

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

Configuring the Pinterest connector

When you set up the connector, you provide:

Field	Description
Start Date
Any data before this date will not be fetched.

| | Status |

Filter ads, ad groups, and campaigns by status. Defaults to ACTIVE and PAUSED if not specified.

| | Custom Reports |

A list of custom ad statistics report configurations. Each entry must have a name and can include fields, breakdowns, or action breakdowns.

| | Account ID |

The Pinterest account ID to fetch data for.

|

Tables and columns synced from Pinterest

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

ad_account_analytics (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data entry
advertiser_id	STRING	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap set for the campaign
campaign_entity_status	FLOAT64	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap set for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Click-through rate related to specific actions
clickthrough_1_gross	FLOAT64	Gross click-through rate related to specific actions
clickthrough_2	FLOAT64	Secondary click-through rate related to specific actions
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Secondary click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per completed view in dollars
ecpcv_p95_in_dollar	FLOAT64	95th percentile effective cost per completed view in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

ad_accounts (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the ad account
name	STRING	The name of the ad account
owner__id	STRING	Unique identifier of the owner
owner__username	STRING	Username of the owner
country	STRING	The country associated with the ad account
currency	STRING	The currency used for billing in the ad account
updated_time	INT64	The timestamp showing when the ad account was last updated
created_time	INT64	The timestamp showing when the ad account was created
_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.

• ad_accounts__permissions (4 columns)

ad_analytics (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	The date for the data entry.
advertiser_id	STRING	The unique identifier of the advertiser.
ad_account_id	STRING	The unique identifier of the ad account.
ad_id	STRING	The unique identifier of the ad.
ad_group_entity_status	STRING	The status of the ad group entity.
ad_group_id	STRING	The unique identifier of the ad group.
campaign_daily_spend_cap	FLOAT64	The daily spend limit set for the campaign.
campaign_entity_status	FLOAT64	The status of the campaign entity.
campaign_id	FLOAT64	The unique identifier of the campaign.
campaign_lifetime_spend_cap	FLOAT64	The total spend limit set for the campaign.
campaign_name	STRING	The name of the campaign.
checkout_roas	FLOAT64	Return on ad spend for checkout conversions.
clickthrough_1	FLOAT64	Click-through conversions type 1.
clickthrough_1_gross	FLOAT64	Gross click-through conversions type 1.
clickthrough_2	FLOAT64	Click-through conversions type 2.
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars.
cpm_in_dollar	FLOAT64	Cost per mille in dollars.
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars.
ctr	FLOAT64	Click-through rate.
ctr_2	FLOAT64	Click-through rate 2.
ecpcv_in_dollar	FLOAT64	Effective cost per click view in dollars.
ecpcv_p95_in_dollar	FLOAT64	Effective cost per click view percentile 95 in dollars.
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars.
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars.
… and 90 more columns

ad_group_analytics (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	The date the data was collected.
advertiser_id	STRING	The ID of the advertiser associated with the ad group analytics data.
ad_account_id	STRING	The ID of the ad account associated with the ad group analytics data.
ad_id	STRING	The ID of the ad.
ad_group_entity_status	STRING	The status of the ad group entity.
ad_group_id	STRING	The ID of the ad group.
campaign_daily_spend_cap	FLOAT64	The daily spend cap set for the campaign.
campaign_entity_status	FLOAT64	The status of the campaign entity.
campaign_id	FLOAT64	The ID of the campaign.
campaign_lifetime_spend_cap	FLOAT64	The lifetime spend cap set for the campaign.
campaign_name	STRING	The name of the campaign.
checkout_roas	FLOAT64	Return on ad spend for checkout actions.
clickthrough_1	FLOAT64	Number of click-throughs type 1.
clickthrough_1_gross	FLOAT64	Gross count of click-throughs type 1.
clickthrough_2	FLOAT64	Number of click-throughs type 2.
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollar.
cpm_in_dollar	FLOAT64	Cost per mille in dollar.
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollar.
ctr	FLOAT64	Click-through rate.
ctr_2	FLOAT64	Click-through rate type 2.
ecpcv_in_dollar	FLOAT64	Effective cost per converted view in dollar.
ecpcv_p95_in_dollar	FLOAT64	Effective cost per converted view at 95th percentile in dollar.
ecpc_in_dollar	FLOAT64	Effective cost per click in dollar.
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollar.
… and 90 more columns

ad_group_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

ad_group_targeting_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

ad_groups (36 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name	STRING	The name of the ad group.
status	STRING	The current status of the ad group.
budget_in_micro_currency	FLOAT64	The budget amount in micro currency for the ad group.
bid_in_micro_currency	FLOAT64	The bid amount in micro currency for the ad group.
budget_type	STRING	The type of budget set for the ad group.
start_time	FLOAT64	The start time for the ad group to begin running.
end_time	FLOAT64	The end time for the ad group to run.
lifetime_frequency_cap	FLOAT64	The maximum number of times a user can be shown the ad during its lifetime.
auto_targeting_enabled	BOOL	Indicates if auto targeting is enabled for the ad group.
placement_group	STRING	The group of placements where the ad group is shown.
placement_traffic_type	STRING	The type of traffic the ad group targets.
pacing_delivery_type	STRING	The delivery type pacing for the ad group.
conversion_learning_mode_type	STRING	The learning mode type for conversion optimization.
summary_status	STRING	A summary status of the ad group.
feed_profile_id	STRING	The ID of the feed profile associated with the ad group.
campaign_id	STRING	The ID of the campaign to which the ad group belongs.
billable_event	STRING	The event for which the ad group is billed.
id	STRING	The unique identifier for the ad group.
type	STRING	The type of the ad group.
ad_account_id	STRING	The ID of the ad account associated with the ad group.
created_time	FLOAT64	The timestamp when the ad group was created.
updated_time	FLOAT64	The timestamp when the ad group was last updated.
optimization_goal_metadata__conversion_tag_v3_goal_metadata__attribution_windows__click_window_days	INT64	Number of days for click attribution window.
optimization_goal_metadata__conversion_tag_v3_goal_metadata__attribution_windows__engagement_window_days	INT64	Number of days for engagement attribution window.
… and 11 more columns

Nested subtables

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

• ad_groups__targeting_spec__property1 (4 columns)
• ad_groups__targeting_spec__property2 (4 columns)
• ad_groups__tracking_urls__impression (4 columns)
• ad_groups__tracking_urls__click (4 columns)
• ad_groups__tracking_urls__engagement (4 columns)
• ad_groups__tracking_urls__buyable_button (4 columns)
• ad_groups__tracking_urls__audience_verification (4 columns)

ads (24 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_group_id	STRING	The ID of the ad group to which the ad belongs.
android_deep_link	STRING	The deep link URL for Android devices.
click_tracking_url	STRING	The URL for tracking clicks on the ad.
creative_type	STRING	The type of creative used in the ad.
destination_url	STRING	The main destination URL of the ad.
ios_deep_link	STRING	The deep link URL for iOS devices.
is_pin_deleted	BOOL	A flag indicating if the ad is linked to a deleted pin.
is_removable	BOOL	A flag indicating if the ad is removable.
name	STRING	The name or title of the ad.
pin_id	STRING	The ID of the pin associated with the ad.
status	STRING	The current status of the ad.
view_tracking_url	STRING	The URL for tracking views of the ad.
lead_form_id	STRING	The ID of the lead form associated with the ad.
ad_account_id	STRING	The ID of the ad account associated with the ad data.
campaign_id	STRING	The ID of the campaign associated with the ad.
collection_items_destination_url_template	STRING	The template URL for destination pages of collection items.
created_time	INT64	The timestamp when the ad was created.
id	STRING	The unique ID of the ad.
review_status	STRING	The review status of the ad.
type	STRING	The type of the ad.
updated_time	INT64	The timestamp when the ad was last updated.
summary_status	STRING	The summarized status of the ad.
_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__carousel_android_deep_links (4 columns)
• ads__carousel_destination_urls (4 columns)
• ads__carousel_ios_deep_links (4 columns)
• ads__tracking_urls__impression (4 columns)
• ads__tracking_urls__click (4 columns)
• ads__tracking_urls__engagement (4 columns)
• ads__tracking_urls__buyable_button (4 columns)
• ads__tracking_urls__audience_verification (4 columns)
• ads__rejected_reasons (4 columns)
• ads__rejection_labels (4 columns)

advertiser_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

advertiser_targeting_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

audiences (22 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 for the advertising account associated with the audience.
id	STRING	Unique identifier for the audience.
name	STRING	The name given to the audience for identification.
audience_type	STRING	Type of audience data, such as website visitors, customer list, lookalike audience, etc.
description	STRING	Detailed information about the audience criteria and characteristics.
rule__country	STRING	The country criteria set for the audience.
rule__customer_list_id	STRING	Identifier for the customer list used as a criterion for the audience.
rule__engagement_type	STRING	The type of engagement tracked, such as clicks, likes, shares, etc.
rule__event	STRING	Specific event triggering engagement tracking.
rule__percentage	INT64	Percentage of similarity for lookalike audience criteria.
rule__prefill	BOOL	Option to automatically fill in missing data for the audience.
rule__retention_days	INT64	Number of days the audience data should be retained.
rule__visitor_source_id	STRING	Identifier for the visitor source used as a criterion for the audience.
rule__engager_type	INT64	Type of audience engagement, like active engagers, passive viewers, etc.
rule__ad_account_id	STRING	The unique identifier for the advertising account linked to the audience criteria.
size	INT64	Estimated size of the audience based on the specified criteria.
status	STRING	Current status of the audience, like active, paused, deleted, etc.
type	STRING	Type of audience data, such as saved audience, custom audience, etc.
created_timestamp	INT64	Timestamp indicating when the audience was created.
updated_timestamp	INT64	Timestamp indicating when the audience data 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.

• audiences__rule__engagement_domain (4 columns)

board_pins (19 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique identifier of the pin.
created_at	TIMESTAMP	The date and time when the pin was created.
creative_type	STRING	The type of creative content associated with the pin.
is_standard	BOOL	Indicates if the pin is a standard pin or a promoted pin.
is_owner	BOOL	Indicates if the current user is the owner of the pin.
dominant_color	STRING	The dominant color extracted from the pin’s image.
parent_pin_id	STRING	The unique identifier of the parent pin if this pin is a repin.
link	STRING	The URL link associated with the pin, if applicable.
title	STRING	The title or headline associated with the pin.
description	STRING	The textual description or caption associated with the pin.
alt_text	STRING	Alternate text for the pin image, used for accessibility and SEO purposes.
note	STRING	Any additional notes or comments added to the pin by users.
board_id	STRING	The unique identifier of the board to which the pin belongs.
board_section_id	STRING	The unique identifier of the section within the board where the pin is placed.
board_owner__username	STRING	The username of the board owner.
media__media_type	STRING	The type of media content, e.g., image, video, or gif.
has_been_promoted	BOOL	Indicates whether the pin has been promoted or sponsored.
_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.

• board_pins__product_tags (4 columns)

board_section_pins (27 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the pin.
created_at	TIMESTAMP	Date and time when the pin was created.
link	STRING	URL link associated with the pin.
title	STRING	Title or caption associated with the pin.
description	STRING	Textual description of the pin content or context.
alt_text	STRING	Alternate text describing the pin for accessibility purposes.
board_id	STRING	Unique identifier for the board the pin belongs to.
board_section_id	STRING	Unique identifier for the section within the board where the pin is categorized.
board_owner__username	STRING	Username of the owner of the board.
media__media_type	STRING	Type of media content associated with the pin.
media__images___150x150__width	INT64	Width of the image in 150x150 resolution.
media__images___150x150__height	INT64	Height of the image in 150x150 resolution.
media__images___150x150__url	STRING	URL of the image in 150x150 resolution.
media__images___400x300__width	INT64	Width of the image in 400x300 resolution.
media__images___400x300__height	INT64	Height of the image in 400x300 resolution.
media__images___400x300__url	STRING	URL of the image in 400x300 resolution.
media__images___600x__width	INT64	Width of the image in 600x resolution.
media__images___600x__height	INT64	Height of the image in 600x resolution.
media__images___600x__url	STRING	URL of the image in 600x resolution.
media__images___1200x__width	INT64	Width of the image in the specified resolution.
media__images___1200x__height	INT64	Height of the image in the specified resolution.
media__images___1200x__url	STRING	URL of the image in the specified resolution.
media__images__originals__width	INT64	Width of the original image.
media__images__originals__height	INT64	Height of the original image.
… and 2 more columns

board_sections (4 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name	STRING	The name of the board section.
id	STRING	The unique identifier for the board section.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

boards (13 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
owner__username	STRING	The username of the board owner.
name	STRING	The name/title of the board.
description	STRING	A brief description or summary of the board.
id	STRING	The unique identifier for the board.
privacy	STRING	The privacy settings of the board.
follower_count	INT64	The count of followers the board has.
collaborator_count	INT64	The number of collaborators involved in the board.
pin_count	INT64	The total number of pins in the board.
media__media_type	STRING	The type of media content associated with the board.
created_at	TIMESTAMP	The date and time when the board was created.
board_pins_modified_at	TIMESTAMP	The most recent date and time when the board’s pins were modified.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

campaign_analytics (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	The date for which the analytics data is recorded.
advertiser_id	FLOAT64	The unique identifier of the advertiser involved in the campaign.
ad_account_id	STRING	The unique identifier of the advertising account associated with the campaign.
ad_id	STRING	The unique identifier of the ad.
ad_group_entity_status	STRING	The current status of the ad group within the campaign.
ad_group_id	STRING	The unique identifier of the ad group within the campaign.
campaign_daily_spend_cap	FLOAT64	The daily spending limit set for the campaign.
campaign_entity_status	FLOAT64	The current status of the campaign.
campaign_id	FLOAT64	The unique identifier of the campaign.
campaign_lifetime_spend_cap	FLOAT64	The total spending limit set for the campaign.
campaign_name	STRING	The name of the campaign.
checkout_roas	FLOAT64	The return on ad spend (ROAS) related to checkout actions.
clickthrough_1	FLOAT64	The number of click-throughs for a specific action.
clickthrough_1_gross	FLOAT64	The gross number of click-throughs for a specific action, including duplicates.
clickthrough_2	FLOAT64	Another metric related to click-throughs.
cpc_in_micro_dollar	FLOAT64	The cost per click (CPC) in micro dollars.
cpm_in_dollar	FLOAT64	The cost per mille (CPM) in dollars.
cpm_in_micro_dollar	FLOAT64	The cost per mille (CPM) in micro dollars.
ctr	FLOAT64	The click-through rate (CTR) for the campaign.
ctr_2	FLOAT64	Another metric related to click-through rates.
ecpcv_in_dollar	FLOAT64	The effective cost per converted view in dollars.
ecpcv_p95_in_dollar	FLOAT64	The 95th percentile effective cost per converted view in dollars.
ecpc_in_dollar	FLOAT64	The effective cost per click in dollars.
ecpc_in_micro_dollar	FLOAT64	The effective cost per click in micro dollars.
… and 90 more columns

campaign_analytics_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

campaign_targeting_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

campaigns (18 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique identifier of the campaign.
ad_account_id	STRING	The unique identifier of the ad account associated with the campaign.
name	STRING	The name of the campaign.
status	STRING	The current status of the campaign.
lifetime_spend_cap	INT64	The maximum amount that can be spent for the lifetime of the campaign.
daily_spend_cap	INT64	The maximum amount that can be spent daily on the campaign.
order_line_id	STRING	The unique identifier of the order line associated with the campaign.
objective_type	STRING	The type of the campaign objective.
created_time	INT64	The timestamp indicating when the campaign was created.
updated_time	INT64	The timestamp indicating when the campaign was last updated.
type	STRING	The type of the campaign.
start_time	INT64	The timestamp indicating the start time of the campaign.
end_time	INT64	The timestamp indicating the end time of the campaign.
summary_status	STRING	The summary status of the campaign.
is_campaign_budget_optimization	BOOL	Indicates if campaign budget optimization is enabled.
is_flexible_daily_budgets	BOOL	Indicates if flexible daily budgets are enabled for the campaign.
_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__tracking_urls__impression (4 columns)
• campaigns__tracking_urls__click (4 columns)
• campaigns__tracking_urls__engagement (4 columns)
• campaigns__tracking_urls__buyable_button (4 columns)
• campaigns__tracking_urls__audience_verification (4 columns)

catalogs (7 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at	TIMESTAMP	The timestamp when the catalog was created.
id	STRING	Unique identifier of the catalog.
updated_at	TIMESTAMP	The timestamp when the catalog was last updated.
name	STRING	Name/title of the catalog.
catalog_type	STRING	The type of the catalog representing the content.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

catalogs_feeds (16 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at	TIMESTAMP	The date and time when the catalog was created
id	STRING	The unique identifier for the catalog
updated_at	TIMESTAMP	The date and time when the catalog was last updated
name	STRING	The name or title of the catalog
format	STRING	The format of the catalog data, e.g., JSON, XML
catalog_type	STRING	The type of catalog being fetched, e.g., product, service, event
location	STRING	The physical or digital location associated with the catalog
preferred_processing_schedule__time	STRING	The preferred processing time for items
preferred_processing_schedule__timezone	STRING	The timezone used for the processing schedule
status	STRING	The current status of the catalog, e.g., active, inactive
default_currency	STRING	The default currency used for pricing within the catalog
default_locale	STRING	The default locale for language and formatting within the catalog
default_country	STRING	The default country applicable to the catalog items
default_availability	STRING	The default availability status for items in the catalog
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

catalogs_product_groups (11 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at	INT64	The date and time when the catalog product group was created.
description	STRING	The description of the catalog product group.
feed_id	STRING	The ID of the feed associated with the catalog product group.
id	STRING	The unique identifier of the catalog product group.
is_featured	BOOL	Indicates whether the product group is featured or not.
name	STRING	The name of the catalog product group.
status	STRING	The status of the catalog product group.
type	STRING	The type of the catalog product group.
updated_at	INT64	The date and time when the catalog product group was last updated.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

conversion_tags (17 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_account_id	STRING	The ID of the advertising account associated with the conversion tag.
code_snippet	STRING	The JavaScript code snippet that needs to be placed on the website for tracking conversions.
enhanced_match_status	STRING	The status of enhanced match capabilities for the conversion tag.
id	STRING	The unique identifier of the conversion tag.
last_fired_time_ms	INT64	The timestamp of the last conversion event fired by the tag in milliseconds.
name	STRING	The name or label assigned to the conversion tag.
status	STRING	The current status of the conversion tag (e.g., active, inactive).
version	STRING	The version number or revision of the conversion tag.
configs__aem_enabled	BOOL	Indicates if Adobe Experience Manager integration is enabled for the conversion tag.
configs__md_frequency	FLOAT64	The frequency at which match data is processed for the conversion tag.
configs__aem_fnln_enabled	BOOL	Indicates if AEM Facebook Login integration is enabled for the conversion tag.
configs__aem_ph_enabled	BOOL	Indicates if AEM Phone integration is enabled for the conversion tag.
configs__aem_ge_enabled	BOOL	Indicates if AEM Google Events integration is enabled for the conversion tag.
configs__aem_db_enabled	BOOL	Indicates if AEM DoubleClick integration is enabled for the conversion tag.
configs__aem_loc_enabled	BOOL	Indicates if AEM Locations integration is enabled for the conversion tag.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

customer_lists (12 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ad_account_id	STRING	The ID of the advertising account associated with the customer list.
created_time	INT64	The timestamp indicating when the customer list was created.
id	STRING	The unique identifier of the customer list.
name	STRING	The name given to the customer list for identification.
num_batches	INT64	The number of batches used to upload user records for the customer list.
num_removed_user_records	INT64	The count of user records removed from the customer list.
num_uploaded_user_records	INT64	The total number of user records uploaded to the customer list.
status	STRING	The current status of the customer list, such as active, inactive, etc.
type	STRING	The type of customer list, which can be standard, hashed, etc.
updated_time	INT64	The timestamp indicating when the customer list was last updated.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

keyword_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

keywords (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
archived	BOOL	Indicates whether the keyword is archived or not.
id	STRING	The unique identifier for the keyword.
parent_id	STRING	The ID of the parent keyword if this is a child keyword.
parent_type	STRING	The type of the parent keyword if this is a child keyword (category, theme, etc).
type	STRING	The type of keyword (brand, generic, long-tail, etc).
bid	INT64	The bid value associated with the keyword for advertising purposes.
match_type	STRING	The type of matching used for the keyword (exact, phrase, broad, etc).
value	STRING	The actual text value of the keyword.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

pin_promotion_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

pin_promotion_targeting_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

product_group_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

product_group_targeting_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

product_item_report (115 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date	DATE	Date of the data record
advertiser_id	FLOAT64	Unique identifier for the advertiser
ad_account_id	STRING	Unique identifier for the ad account
ad_id	STRING	Unique identifier for the ad
ad_group_entity_status	STRING	Status of the ad group entity
ad_group_id	STRING	Unique identifier for the ad group
campaign_daily_spend_cap	FLOAT64	Daily spend cap for the campaign
campaign_entity_status	STRING	Status of the campaign entity
campaign_id	FLOAT64	Unique identifier for the campaign
campaign_lifetime_spend_cap	FLOAT64	Lifetime spend cap for the campaign
campaign_name	STRING	Name of the campaign
checkout_roas	FLOAT64	Return on ad spend for checkout actions
clickthrough_1	FLOAT64	Number of click-through events
clickthrough_1_gross	FLOAT64	Gross number of click-through events
clickthrough_2	FLOAT64	Second type of click-through events
cpc_in_micro_dollar	FLOAT64	Cost per click in micro dollars
cpm_in_dollar	FLOAT64	Cost per mille (cost per thousand impressions) in dollars
cpm_in_micro_dollar	FLOAT64	Cost per mille in micro dollars
ctr	FLOAT64	Click-through rate
ctr_2	FLOAT64	Second click-through rate
ecpcv_in_dollar	FLOAT64	Effective cost per conversion value in dollars
ecpcv_p95_in_dollar	FLOAT64	P95 percentile of effective cost per conversion value in dollars
ecpc_in_dollar	FLOAT64	Effective cost per click in dollars
ecpc_in_micro_dollar	FLOAT64	Effective cost per click in micro dollars
… and 90 more columns

user_account_analytics (13 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
data_status	STRING	The status of the data being fetched, such as ‘success’ or ‘error’.
date	DATE	The date corresponding to the analytics data.
metrics__engagement	FLOAT64	The level of user interaction or engagement with content.
metrics__clickthrough_rate	FLOAT64	The rate at which users clicked through to view content.
metrics__clickthrough	FLOAT64	The number of times users clicked through to view content.
metrics__closeup	FLOAT64	The number of close-up views of content.
metrics__closeup_rate	FLOAT64	The rate at which close-up views of content occurred.
metrics__engagement_rate	FLOAT64	The rate at which user engagement with content occurred.
metrics__save	FLOAT64	The number of times users saved or pinned content.
metrics__save_rate	FLOAT64	The rate at which content was saved or pinned by users.
metrics__impression	FLOAT64	The number of times content was displayed or viewed.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the Pinterest sync works

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Pinterest 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 Pinterest?

It depends on how much history is in your Pinterest 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 Pinterest’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 Pinterest, 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 Pinterest 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 Pinterest connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Pinterest data

Organic content

Use boards, board_pins, and board_sections to see which pins earn impressions and saves.

Ad performance

Use campaigns, ad_groups, and ad_accounts to track paid spend and return by campaign.

Product feeds

Use catalogs, catalogs_feeds, and catalogs_product_groups to check feed health and coverage.

Audience analysis

Use audiences and customer_lists to compare how targeting segments perform.

Use Pinterest data in your AI and BI tools

Once Pinterest 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 Pinterest 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 Pinterest 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.