{
  "streams": [
    {
      "stream": {
        "name": "ad_group_ad_report",
        "json_schema": {
          "$schema": "http://json-schema.org/draft-07/schema#",
          "type": "object",
          "properties": {
            "ad_group_ad.ad.legacy_responsive_display_ad.accent_color": {
              "type": [
                "null",
                "string"
              ]
            },
            "customer.currency_code": {
              "type": [
                "null",
                "string"
              ]
            },
            "customer.descriptive_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "customer.time_zone": {
              "type": [
                "null",
                "string"
              ]
            },
            "metrics.active_view_cpm": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.active_view_ctr": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.active_view_impressions": {
              "type": [
                "null",
                "integer"
              ]
            },
            "metrics.active_view_measurability": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.active_view_measurable_cost_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "metrics.active_view_measurable_impressions": {
              "type": [
                "null",
                "integer"
              ]
            },
            "metrics.active_view_viewability": {
              "type": [
                "null",
                "number"
              ]
            },
            "ad_group_ad.ad_group": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group.name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group.status": {
              "type": [
                "null",
                "string"
              ]
            },
            "segments.ad_network_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad_strength": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.type": {
              "type": [
                "null",
                "string"
              ]
            },
            "metrics.all_conversions_from_interactions_rate": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.all_conversions_value": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.all_conversions": {
              "type": [
                "null",
                "number"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "ad_group_ad.ad.added_by_google_ads": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "metrics.average_cost": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.average_cpc": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.average_cpe": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.average_cpm": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.average_cpv": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.average_page_views": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.average_time_on_site": {
              "type": [
                "null",
                "number"
              ]
            },
            "ad_group.base_ad_group": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.base_campaign": {
              "type": [
                "null",
                "string"
              ]
            },
            "metrics.bounce_rate": {
              "type": [
                "null",
                "number"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.business_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.id": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.name": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.status": {
              "type": [
                "null",
                "string"
              ]
            },
            "metrics.clicks": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.policy_summary.approval_status": {
              "type": [
                "null",
                "string"
              ]
            },
            "metrics.conversions_from_interactions_rate": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.conversions_value": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.conversions": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.cost_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "metrics.cost_per_all_conversions": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.cost_per_conversion": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.cost_per_current_model_attributed_conversion": {
              "type": [
                "null",
                "number"
              ]
            },
            "ad_group_ad.ad.final_mobile_urls": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.final_urls": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.tracking_url_template": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.url_custom_parameters": {
              "type": [
                "null",
                "array"
              ]
            },
            "metrics.cross_device_conversions": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.ctr": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.current_model_attributed_conversions_value": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.current_model_attributed_conversions": {
              "type": [
                "null",
                "number"
              ]
            },
            "segments.date": {
              "type": [
                "null",
                "string"
              ],
              "format": "datetime"
            },
            "segments.day_of_week": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.description": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.text_ad.description1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.text_ad.description2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.device_preference": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.display_url": {
              "type": [
                "null",
                "string"
              ]
            },
            "metrics.engagement_rate": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.engagements": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.logo_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.marketing_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_dynamic_search_ad.description": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.description2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.headline_part3": {
              "type": [
                "null",
                "string"
              ]
            },
            "customer.id": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.format_setting": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.header_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.teaser.logo_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "metrics.gmail_forwards": {
              "type": [
                "null",
                "integer"
              ]
            },
            "metrics.gmail_saves": {
              "type": [
                "null",
                "integer"
              ]
            },
            "metrics.gmail_secondary_clicks": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.gmail_ad.teaser.business_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.teaser.description": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.teaser.headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.text_ad.headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.headline_part1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.headline_part2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.id": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.image_ad.image_url": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.image_ad.pixel_height": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.image_ad.pixel_width": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.image_ad.mime_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.image_ad.name": {
              "type": [
                "null",
                "string"
              ]
            },
            "metrics.impressions": {
              "type": [
                "null",
                "integer"
              ]
            },
            "metrics.interaction_rate": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.interaction_event_types": {
              "type": [
                "null",
                "array"
              ]
            },
            "metrics.interactions": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.long_headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.main_color": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text_color": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image_headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image_description": {
              "type": [
                "null",
                "string"
              ]
            },
            "segments.month": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.accent_color": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.allow_flexible_color": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.business_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.call_to_action_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.descriptions": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.price_prefix": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.promo_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.format_setting": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.headlines": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.logo_images": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.square_logo_images": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.long_headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.main_color": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.marketing_images": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.square_marketing_images": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.youtube_videos": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.path1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.path2": {
              "type": [
                "null",
                "string"
              ]
            },
            "metrics.percent_new_visitors": {
              "type": [
                "null",
                "number"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.price_prefix": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.promo_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "segments.quarter": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_search_ad.descriptions": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.responsive_search_ad.headlines": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.responsive_search_ad.path1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_search_ad.path2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.short_headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.status": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.system_managed_resource_source": {
              "type": [
                "null",
                "string"
              ]
            },
            "metrics.top_impression_percentage": {
              "type": [
                "null",
                "number"
              ]
            },
            "ad_group_ad.ad.app_ad.descriptions": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.app_ad.headlines": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.app_ad.html5_media_bundles": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.app_ad.images": {
              "type": [
                "null",
                "array"
              ]
            },
            "ad_group_ad.ad.app_ad.mandatory_ad_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.app_ad.youtube_videos": {
              "type": [
                "null",
                "array"
              ]
            },
            "metrics.value_per_all_conversions": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.value_per_conversion": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.value_per_current_model_attributed_conversion": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.video_quartile_p100_rate": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.video_quartile_p25_rate": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.video_quartile_p50_rate": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.video_quartile_p75_rate": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.video_view_rate": {
              "type": [
                "null",
                "number"
              ]
            },
            "metrics.video_views": {
              "type": [
                "null",
                "integer"
              ]
            },
            "metrics.view_through_conversions": {
              "type": [
                "null",
                "integer"
              ]
            },
            "segments.week": {
              "type": [
                "null",
                "string"
              ]
            },
            "segments.year": {
              "type": [
                "null",
                "integer"
              ]
            }
          }
        },
        "supported_sync_modes": [
          "full_refresh",
          "incremental"
        ],
        "source_defined_cursor": true,
        "default_cursor_field": [
          "segments.date"
        ]
      },
      "sync_mode": "incremental",
      "cursor_field": [],
      "destination_sync_mode": "append_dedup",
      "primary_key": [
        [
          "ad_group_ad.ad.id"
        ],
        [
          "segments.date"
        ]
      ]
    },
    {
      "stream": {
        "name": "click_view",
        "json_schema": {
          "$schema": "http://json-schema.org/draft-07/schema#",
          "type": "object",
          "properties": {
            "click_view.gclid": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.id": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group.id": {
              "type": [
                "null",
                "integer"
              ]
            },
            "segments.date": {
              "type": [
                "null",
                "string"
              ]
            },
            "customer.id": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.name": {
              "type": [
                "null",
                "string"
              ]
            }
          }
        },
        "supported_sync_modes": [
          "full_refresh",
          "incremental"
        ],
        "source_defined_cursor": true,
        "default_cursor_field": [
          "segments.date"
        ]
      },
      "sync_mode": "incremental",
      "cursor_field": [],
      "destination_sync_mode": "append_dedup",
      "primary_key": [
        [
          "click_view.gclid"
        ],
        [
          "segments.date"
        ]
      ]
    },
    {
      "stream": {
        "name": "ad_group_ads",
        "json_schema": {
          "$schema": "http://json-schema.org/draft-07/schema#",
          "type": "object",
          "properties": {
            "ad_group_ad.ad.added_by_google_ads": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "ad_group_ad.ad.app_ad.descriptions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.app_ad.headlines": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.app_ad.html5_media_bundles": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.app_ad.images": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.app_ad.mandatory_ad_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.app_ad.youtube_videos": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.app_engagement_ad.descriptions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.app_engagement_ad.headlines": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.app_engagement_ad.images": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.app_engagement_ad.videos": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.call_ad.business_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.call_tracked": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "ad_group_ad.ad.call_ad.conversion_action": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.conversion_reporting_state": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.country_code": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.description1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.description2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.disable_call_conversion": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "ad_group_ad.ad.call_ad.headline1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.headline2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.path1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.path2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.phone_number": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.call_ad.phone_number_verification_url": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.device_preference": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.display_upload_ad.display_upload_product_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.display_upload_ad.media_bundle": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.display_url": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_dynamic_search_ad.description": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_dynamic_search_ad.description2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.description": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.description2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.headline_part1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.headline_part2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.headline_part3": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.path1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.expanded_text_ad.path2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.final_app_urls": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.final_mobile_urls": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.final_url_suffix": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.final_urls": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.gmail_ad.header_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image_description": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text_color": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.url_collection_id": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.marketing_image_headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.product_images": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.gmail_ad.product_videos": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.gmail_ad.teaser.business_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.teaser.description": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.teaser.headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.gmail_ad.teaser.logo_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.hotel_ad": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.id": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.image_ad.image_url": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.image_ad.mime_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.image_ad.name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.image_ad.pixel_height": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.image_ad.pixel_width": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.image_ad.preview_image_url": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.image_ad.preview_pixel_height": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.image_ad.preview_pixel_width": {
              "type": [
                "null",
                "integer"
              ]
            },
            "ad_group_ad.ad.legacy_app_install_ad": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.accent_color": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.business_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.description": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.format_setting": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.logo_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.long_headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.main_color": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.marketing_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.price_prefix": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.promo_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.short_headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.local_ad.call_to_actions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.local_ad.descriptions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.local_ad.headlines": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.local_ad.logo_images": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.local_ad.marketing_images": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.local_ad.path1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.local_ad.path2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.local_ad.videos": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.resource_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.accent_color": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.allow_flexible_color": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.business_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.call_to_action_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.control_spec.enable_asset_enhancements": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.control_spec.enable_autogen_video": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.descriptions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.responsive_display_ad.format_setting": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.headlines": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.responsive_display_ad.logo_images": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.responsive_display_ad.long_headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.main_color": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.marketing_images": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.responsive_display_ad.price_prefix": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.promo_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_display_ad.square_logo_images": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.responsive_display_ad.square_marketing_images": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.responsive_display_ad.youtube_videos": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.responsive_search_ad.descriptions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.responsive_search_ad.headlines": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.responsive_search_ad.path1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.responsive_search_ad.path2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.shopping_comparison_listing_ad.headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.shopping_product_ad": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.shopping_smart_ad": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.smart_campaign_ad.descriptions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.smart_campaign_ad.headlines": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.system_managed_resource_source": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.text_ad.description1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.text_ad.description2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.text_ad.headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.tracking_url_template": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.type": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.url_collections": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.url_custom_parameters": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.video_ad.discovery.description1": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.video_ad.discovery.description2": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.video_ad.discovery.headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.video_ad.in_stream.action_button_label": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.video_ad.in_stream.action_headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.video_ad.out_stream.description": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.video_ad.out_stream.headline": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad.video_responsive_ad.call_to_actions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.video_responsive_ad.companion_banners": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.video_responsive_ad.descriptions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.video_responsive_ad.headlines": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.video_responsive_ad.long_headlines": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad.video_responsive_ad.videos": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.ad_group": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.ad_strength": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.labels": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.policy_summary.approval_status": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.policy_summary.policy_topic_entries": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "ad_group_ad.policy_summary.review_status": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.resource_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad.status": {
              "type": [
                "null",
                "string"
              ]
            }
          }
        },
        "supported_sync_modes": [
          "full_refresh",
          "incremental"
        ],
        "source_defined_cursor": true,
        "default_cursor_field": [
          "segments.date"
        ]
      },
      "sync_mode": "incremental",
      "cursor_field": [],
      "destination_sync_mode": "append_dedup",
      "primary_key": [
        [
          "ad_group_ad.ad.id"
        ]
      ]
    },
    {
      "stream": {
        "name": "campaigns",
        "json_schema": {
          "$schema": "http://json-schema.org/draft-07/schema#",
          "type": "object",
          "properties": {
            "campaign.accessible_bidding_strategy": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.ad_serving_optimization_status": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.advertising_channel_sub_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.advertising_channel_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.app_campaign_setting.app_id": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.app_campaign_setting.app_store": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.app_campaign_setting.bidding_strategy_goal_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.base_campaign": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.bidding_strategy": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.bidding_strategy_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.campaign_budget": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.commission.commission_rate_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.dynamic_search_ads_setting.domain_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.dynamic_search_ads_setting.feeds": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "campaign.dynamic_search_ads_setting.language_code": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.dynamic_search_ads_setting.use_supplied_urls_only": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "campaign.end_date": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.excluded_parent_asset_field_types": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "campaign.experiment_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.final_url_suffix": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.frequency_caps": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "campaign.geo_target_type_setting.negative_geo_target_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.geo_target_type_setting.positive_geo_target_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.hotel_setting.hotel_center_id": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.id": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.labels": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "campaign.local_campaign_setting.location_source_type": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.manual_cpc.enhanced_cpc_enabled": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "campaign.manual_cpm": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.manual_cpv": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.maximize_conversion_value.target_roas": {
              "type": [
                "null",
                "number"
              ]
            },
            "campaign.maximize_conversions.target_cpa": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.name": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.network_settings.target_content_network": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "campaign.network_settings.target_google_search": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "campaign.network_settings.target_partner_search_network": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "campaign.network_settings.target_search_network": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "campaign.optimization_goal_setting.optimization_goal_types": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "campaign.optimization_score": {
              "type": [
                "null",
                "number"
              ]
            },
            "campaign.payment_mode": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.percent_cpc.cpc_bid_ceiling_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.percent_cpc.enhanced_cpc_enabled": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "campaign.real_time_bidding_setting.opt_in": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "campaign.resource_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.selective_optimization.conversion_actions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "campaign.serving_status": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.shopping_setting.campaign_priority": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.shopping_setting.enable_local": {
              "type": [
                "null",
                "boolean"
              ]
            },
            "campaign.shopping_setting.merchant_id": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.shopping_setting.sales_country": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.start_date": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.status": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.target_cpa.cpc_bid_ceiling_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.target_cpa.cpc_bid_floor_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.target_cpa.target_cpa_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.target_cpm": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.target_impression_share.cpc_bid_ceiling_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.target_impression_share.location": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.target_impression_share.location_fraction_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.target_roas.cpc_bid_ceiling_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.target_roas.cpc_bid_floor_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.target_roas.target_roas": {
              "type": [
                "null",
                "number"
              ]
            },
            "campaign.target_spend.cpc_bid_ceiling_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.target_spend.target_spend_micros": {
              "type": [
                "null",
                "integer"
              ]
            },
            "campaign.targeting_setting.target_restrictions": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "campaign.tracking_setting.tracking_url": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.tracking_url_template": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.url_custom_parameters": {
              "type": [
                "null",
                "array"
              ],
              "items": {
                "type": "string"
              }
            },
            "campaign.vanity_pharma.vanity_pharma_display_url_mode": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.vanity_pharma.vanity_pharma_text": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign.video_brand_safety_suitability": {
              "type": [
                "null",
                "string"
              ]
            }
          }
        },
        "supported_sync_modes": [
          "full_refresh",
          "incremental"
        ],
        "source_defined_cursor": true,
        "default_cursor_field": [
          "segments.date"
        ]
      },
      "sync_mode": "incremental",
      "cursor_field": [],
      "destination_sync_mode": "append_dedup",
      "primary_key": [
        [
          "campaign.id"
        ]
      ]
    },
    {
      "stream": {
        "name": "campaign_labels",
        "json_schema": {
          "$schema": "http://json-schema.org/draft-07/schema#",
          "type": "object",
          "properties": {
            "campaign.resource_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "campaign_label.resource_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "label.name": {
              "type": [
                "null",
                "string"
              ]
            },
            "label.resource_name": {
              "type": [
                "null",
                "string"
              ]
            }
          }
        },
        "supported_sync_modes": [
          "full_refresh"
        ],
        "source_defined_primary_key": [
          [
            "campaign_label.resource_name"
          ]
        ]
      },
      "sync_mode": "incremental",
      "cursor_field": [],
      "destination_sync_mode": "append_dedup",
      "primary_key": [
        [
          "campaign_label.resource_name"
        ]
      ]
    },
    {
      "stream": {
        "name": "ad_group_ad_labels",
        "json_schema": {
          "$schema": "http://json-schema.org/draft-07/schema#",
          "type": "object",
          "properties": {
            "ad_group_ad.ad.resource_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_ad_label.resource_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "label.name": {
              "type": [
                "null",
                "string"
              ]
            },
            "label.resource_name": {
              "type": [
                "null",
                "string"
              ]
            }
          }
        },
        "supported_sync_modes": [
          "full_refresh"
        ],
        "source_defined_primary_key": [
          [
            "ad_group_ad_label.resource_name"
          ]
        ]
      },
      "sync_mode": "incremental",
      "cursor_field": [],
      "destination_sync_mode": "append_dedup",
      "primary_key": [
        [
          "ad_group_ad_label.resource_name"
        ]
      ]
    },
    {
      "stream": {
        "name": "ad_group_labels",
        "json_schema": {
          "$schema": "http://json-schema.org/draft-07/schema#",
          "type": "object",
          "properties": {
            "ad_group.resource_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "ad_group_label.resource_name": {
              "type": [
                "null",
                "string"
              ]
            },
            "label.name": {
              "type": [
                "null",
                "string"
              ]
            },
            "label.resource_name": {
              "type": [
                "null",
                "string"
              ]
            }
          }
        },
        "supported_sync_modes": [
          "full_refresh"
        ],
        "source_defined_primary_key": [
          [
            "ad_group_label.resource_name"
          ]
        ]
      },
      "sync_mode": "incremental",
      "cursor_field": [],
      "destination_sync_mode": "append_dedup",
      "primary_key": [
        [
          "ad_group_label.resource_name"
        ]
      ]
    }
  ]
}