Hello,
I have a query to get Device type for 4 campaigns in a single Account:
'segments.device '
'FROM campaign WHERE campaign.id =%s ') % account_campaign
When searching in UI for Device I can see all 4 Campaigns have devices 'Computers', 'Mobile phones', 'Tablets'.
However my 'query_device' return MOBILE, DESKTOP, and TABLET for three of the Campaigns and returns nothing and no rows of data for the fourth campaign.
The exact same list of campaign Ids are returning the correct data for other values and the devices are all set at the Campaign Level.
Is there another way to query the Devices used in a Campaign?
I'm missing something but I don't know what..
Best,
Dylan