［参考情報］

• レポートテンプレートのイメージ
• BigQuery の出力イメージ

GROUP=report_group_default
PERIOD_START=from,month,1,1
PERIOD_END=from,month,0,-1

ASPECT=report_aspect_none

SEGMENT=
SELECTOR=
FROM_LEVEL=campaigns
DAILY_LEVEL=any
SHOW_HEADER=report_show_header_none
SHOW_ALL_ASPECT_ROWS=false
SUM=report_sum_none
OUTPUT_FORMAT=sql
OUTPUT_CODE=utf8
FLAT=false

TEXT_BODY=${
CREATE TABLE IF NOT EXISTS
`#{@node.bq_dataset_name}.campaigns_daily`
(
Date DATE,
Media STRING,
Account STRING,
AccountID STRING,
Campaign STRING,
CampaignID STRING,
CampaignType STRING,
Impressions INT64,
Clicks INT64,
Cost NUMERIC,
Conversions NUMERIC,
)
PARTITION BY `Date`
CLUSTER BY `Client_ID`
;
}
${IMC_END_TAG}

# DELETE

GROUP=report_group_default
PERIOD_START=from,day,29,0
PERIOD_END=from,day,0,0

ASPECT=report_aspect_daily
SERIES=report_series_none
SEGMENT=report_segment_none
SELECTOR=
FROM_LEVEL=campaigns
DAILY_LEVEL=any
ANTE_FILTER=report_ante_filter_none
MEDI_FILTER=report_medi_filter_none
POST_FILTER=report_post_filter_none
ROUND_UP=report_round_up_none
SHOW_HEADER=report_show_header_none
SHOW_SEGMENT=report_show_segment_none_by_aspect
SHOW_SERIES=report_show_series_none
SHOW_ALL_ASPECT_ROWS=false
SHOW_SUM=report_show_sum_none
WRAP_ROWS=false
FLAT=false

OUTPUT_FORMAT=sql
OUTPUT_CODE=utf8
CHUNK_ROWS=1000

TEXT_HEAD=${
DELETE from `#{@node.bq_dataset_name}.campaigns_daily` where date in (
}
TEXT_BODY=${
PARSE_DATE(‘%Y/%m/%d’, #{t @data[0]})
}
TEXT_BCAT=,
TEXT_FOOT=${
);
}
${IMC_END_TAG}

# INSERT

GROUP=report_group_default
PERIOD_START=from,day,29,0
PERIOD_END=from,day,0,0

ASPECT=report_aspect_campaigns
SERIES=report_series_daily

SEGMENT=report_segment_none
SELECTOR=
DAILY_LEVEL=any
FROM_LEVEL=campaigns
ANTE_FILTER=report_ante_filter_none
MEDI_FILTER=report_medi_filter_none
POST_FILTER=report_post_filter_custom:”(SUM(report_imps)>0 OR SUM(report_clicks)>0 OR SUM(report_cost)>0 OR SUM(report_conv_t)>0)”
ROUND_UP=report_round_up_none
SHOW_SEGMENT=report_show_segment_none
SHOW_SERIES=report_show_series_none
SHOW_ALL_ASPECT_ROWS=false
SHOW_SUM=report_show_sum_none
SHOW_HEADER=report_show_header_none
WRAP_ROWS=false

FLAT=true

OUTPUT_FORMAT=sql
OUTPUT_CODE=utf8
CHUNK_ROWS=1000

TEXT_HEAD=${
INSERT `#{@node.bq_dataset_name}.campaigns_daily` (Date,Media,Account,AccountID,Campaign,CampaignID,CampaignType,Impressions,Clicks,Cost,Conversions) VALUES
}
TEXT_BODY=${
(#{t @data[:bq_report_date]},#{t @data[:media_type]},#{t @data[:bq_ac_name]},#{t @data[:account_id]},#{t @data[:bq_cp_name]},#{t @data[:campaign_id]},#{t @data[:cp_type]},#{t @data[:report_imps]},#{t @data[:report_clicks]},#{t @data[:report_cost]},#{t @data[:report_conv_t]})
}
TEXT_BCAT=,
TEXT_FOOT=${
;
}
${IMC_END_TAG}