Hi,
We have some campaigns running for a few months and we are able to query these campaigns' performance in CAMPAIGN_LOCATION_TARGET_REPORT. However, it doesn't return anything when we tried with GEO_PERFORMANCE_REPORT.
Query for CAMPAIGN_LOCATION_TARGET_REPORT:
>> select CampaignId, Id from CAMPAIGN_LOCATION_TARGET_REPORT during 20170901, 20171126
returns:
"CAMPAIGN_LOCATION_TARGET_REPORT (Sep 1, 2017-Nov 26, 2017)"
Campaign ID,Location
<campaign id>,2392
<campaign id>,2840
<campaign id>,2840
<campaign id>,2356
<campaign id>,2368
<campaign id>,2840
<campaign id>,2840
<campaign id>,2840
<campaign id>,2840
<campaign id>,2840
<campaign id>,2840
<campaign id>,2840
<campaign id>,2356
<campaign id>,2250
<campaign id>,2554
<campaign id>,2124
<campaign id>,2392
Total, --
Query for GEO_PERFORMANCE_REPORT:
>> select CityCriteriaId, CountryCriteriaId from GEO_PERFORMANCE_REPORT during 20170901, 20171126
>> returns:
"GEO_PERFORMANCE_REPORT (Sep 1, 2017-Nov 26, 2017)"
City,Country/Territory
Total, --
Can we get some instructions about what are we doing incorrectly please?
Thanks