google/app-reporting-pack

Inconsistency issue - geo_performance

yershovkiril opened this issue · 1 comments

yershovkiril commented

app-reporting-pack/bq_queries/geo_performance.sql

Line 47 in 9821415

USING(ad_group_id, network, date, country_id)

this join brings duplicates and inconsistency in metrics, in particular costs value

AndreyMarkinPPC commented

Thanks for spotting this! Fixed in Remove duplicates from geo_performance table.