How Can I Get Google Ads Negative Keyword Lists?

Question

Which Fivetran tables contain data about Google Ads negative keyword lists?

Environment

Connector: Google Ads

Answer

We store data for negative keyword lists in the following tables:

SHARED_SET_HISTORY: Contains records for shared sets, including those containing negative keywords.
SHARED_CRITERION_HISTORY: Contains the individual criteria (keywords) within each shared set.
CAMPAIGN_SHARED_SET_HISTORY: Links shared sets to campaigns, indicating which shared sets apply to which campaigns.

To retrieve negative keyword lists:

Join SHARED_SET_HISTORY to SHARED_CRITERION_HISTORY using the shared_set_id column to retrieve the keywords in each shared set.
Filter SHARED_SET_HISTORY for shared sets where the type column is set to NEGATIVE_KEYWORDS.
(Optional) Join CAMPAIGN_SHARED_SET_HISTORY using the shared_set_id column to identify the campaigns associated with each negative keyword list.

When the type column in the SHARED_SET_HISTORY table is set to NEGATIVE_KEYWORDS, each associated row in the SHARED_CRITERION_HISTORY table represents a negative keyword in that list.