深圳智汇创想科技有限公司

[步骤]

SD、SB有天数的字段用的14，SP有天数的字段用的是7

SELECT
ad.customerid,
ad.`OrderSourceId`,
ad.sku,
rp.`ReportDate`,
CONVERT ( rp.`ReportDate`, DATE ) 报告日期,
sum( rp.`Impressions` ) 曝光量,
sum( rp.`Clicks` ) 点击量,
sum( rp.`AttributedConversions14d` ) 出单数,
sum( rp.AttributedConversions14dSameSku ),
sum( rp.`AttributedSales14d` ) 销售额,
sum( rp.`Cost` ) CPC,
min( rp.Currency ) 币种,
min( rp.`tocnyexchangerate` ) 人民币汇率,
min( rp.`tousdexchangerate` ) 美元汇率,
CURRENT_TIMESTAMP 
FROM
aad_sdcampaign_productad ad
LEFT JOIN aad_report_sdproductad rp ON ad.`OrderSourceId` = rp.`OrderSourceId` 
AND ad.`CampaignId` = rp.CampaignId 
AND ad.`AdGroupId` = rp.AdGroupId 
AND ad.`AdId` = rp.AdId 
WHERE
ad.OrderSourceId IN ( 16332 ) -- and rp.StorageTime ='${startTime}' and rp.StorageTime <='${endTime}'

AND rp.reportdate = 20241115 
AND ad.sku = 'CA-DKQO-QK7C' 
AND rp.reportdate IS NOT NULL 
GROUP BY
ad.customerid,
ad.`OrderSourceId`,
ad.sku,
rp.`ReportDate`

[结果]

[期望]