text: {% macro stitch_adwords_campaigns() %}
  
      {{ adapter.dispatch('stitch_adwords_campaigns', 'adwords')() }}
  
  {% endmacro %}
  
  
  {% macro default__stitch_adwords_campaigns() %}
  
  with campaigns_source as (
  
      select * from {{ var('campaigns_table') }}
  
  ),
  
  campaigns_renamed as (
  
      select 
  
          id as campaign_id,
          name,
          adservingoptimizationstatus as ad_serving_optimization_status,
          advertisingchanneltype as advertising_channel_type,
          basecampaignid as base_campaign_id,
          campaigntrialtype as campaign_trial_type,
          startdate as start_date,
          enddate as end_date,
          servingstatus as serving_status,
          status,
          "_SDC_CUSTOMER_ID" as account_id
  
      from campaigns_source
  
  )
  
  select * from campaigns_renamed
  
  {% endmacro %}
  