如何使用Google Adwords API从竞选中获取负面关键字列表

Question

def retrieve_negative_keywords(report_utils)
  report_definition = {
    :selector => {
      :fields => ['CampaignId', 'Id', 'KeywordMatchType', 'KeywordText']
    },
    :report_name => 'Negative campaign keywords',
    :report_type => 'CAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT',
    :download_format => 'CSV',
    :date_range_type => 'TODAY',
    :include_zero_impressions => true
  }

  campaigns = {}

  report = report_utils.download_report(report_definition)
  # Slice off the first row (report name).
  report.slice!(0..report.index("\n"))

  CSV.parse(report, { :headers => true }) do |row|
    campaign_id = row['Campaign ID']

    # Ignore totals row.
    if row[0] != 'Total'
      campaigns[campaign_id] ||= Campaign.new(campaign_id)
      negative = Negative.from_csv_row(row)
      campaigns[campaign_id].negatives << negative
    end
  end

  return campaigns
end

report_query = (adwords.ReportQueryBuilder()
                        .Select('CampaignId', 'Id', 'KeywordMatchType', 'KeywordText')
                        .From('CAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT')
                        .During('LAST_7_DAYS')
                        .Build())

Answer 1

report_query = (googleads.adwords.ReportQueryBuilder()
                .Select('CampaignId', 'Id', 'KeywordMatchType', 'Criteria')
                .From('CAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT')
                .Build())