How can i get the targeted locations for an campaign like the settings page

2022-12-01 Thread Mohammad si abbou
I'm using the geo_target_constant to fetch the targeted locations for a campaign and it's working, but the results are not the way I want them to be, for example, if I target a country it shows all the Provinces and cities... instead of getting the country. I want it to show results like the on

Re: How can i get the targeted locations for an campaign like the settings page

2022-12-07 Thread Mohammad si abbou
yes indeed, I'm using geo_target_constant.canonical_name but it's not what I'm looking for, it returns the results in the picture , it shoud return "Turkey" only like it does in the settings page (the previous pictrure) if there is any way to do that? same thing for the others [image: Screensh

Re: How can i get the targeted locations for an campaign like the settings page

2022-12-07 Thread Mohammad si abbou
yes, I'm using geo_target_constant.canonical_name, I think the problem is from my query can you help me with that ? , here is the query : SELECT geo_target_constant.target_type, geo_target_constant.status, geo_target_constant.parent_geo_target, geo_target_constant.parent_geo_target, geo_target_

Get Install , cost/install , in-app actions, cost/in-app actions from campaigns

2024-02-05 Thread Mohammad si abbou
Hello, I'm seeking assistance in retrieving results for the keys displayed in the attached image related to campaigns. Despite dedicating two days to research, I haven't been able to find the solution I need. [image: Screenshot_20240205_120856.png] I would really appreciate your help, thanks in a