Hey, 3 questions
1. how can i show in a table only camapaigns that are active? (by delivery)
2. how can i add a dimension/metric of start date so i can sort the campaigns table by their start date?
3. i want to see the ads of the campaigns themselves: image + text, or at least a link to the ad preview, how can i do that?
- update -
I have a campaign table with a filer of campaign status = ACTIVE
but I still see campaigns that are not active, also i see the same campaign duplicated in the table over and over again.
How can I fix the bug/issue?
(BTW I succeeded in adding start date dimension)
#1 - You should be able to add a filter for "Campaign status (effective status)" to the table and set it to "Equal to" ACTIVE. Inactive campaigns shouldn't show at all, but those paused can and this should remove them.
#2 - The Dimension "Start Date" should be the one you need.
#3 - This is not possible, yet. Google just added expanded image functionality to Data Studio this week though, so we are investigating if we can pull the images from the data sources to make this possible. Keep an eye out for this feature in the near future.
For the status issue, what's the full query you are trying to use?