Best Of
Re: Filter by Section of Dataset (Bonus point question!)
You could create a new column that concatenates "Section" and "State" and filter based on that, using the "Fixed" calculations to calculate percent increase. CONCAT(Section, State). Then you can filter on "A-Texas", "B-North Carolina", and "C-Kansas".
Re: End of query request - what is wrong
Where is this query being used? In general the syntax looks odd, if you care about the specific invoice numbers the general MySQL query would be:
SELECT *
FROM CHARGE_DETAIL
WHERE INVOICE_NUMBER IN (217653436,
217668183,
819802440,
820092602)
Does this helps?
Re: Color Series in Lat/Long Map
Is there any update on this enhancement? I have been limited by this issue for sometime due to my series being 'Green', 'Yellow' or 'Red' based on location performance and not being able to match the rating with the actual color. Very confusing to the business.
Re: Filter by Section of Dataset (Bonus point question!)
It might help if you flesh out your example a bit more. Based on what I understand, it sounds like you could create two table cards for your dashboard and two filter cards, and then you could edit the interactions on the filter cards using the "change interactions" menu to select which filter applies to which table card.
Re: Facebook ads connector not returning conversions and conversion value?
Hi @pauljames
Are your campaigns going across iOS and non-iOS devices? Facebook recently changed how their aggregate inline-conversion metrics are done across both platforms. Essentially conversions are missing if going across platforms.
From their documentation:
Facebook will no longer be able to aggregate non-inline conversion metric values across iOS 14.5 and non-iOS 14.5 campaigns due to differences in attribution logic. Querying across iOS 14.5 and non-iOS 14.5 campaigns will result in no data getting returned for non-inline conversion metrics such as app installs and purchases. Inline event metrics like impressions, link clicks, and video views, however, can still be aggregated. Please visit our changelog for more information.
Re: Filter by Section of Dataset (Bonus point question!)
@jmmc I think Fixed Functions might be useful in your case. You can set it up to where only certain fields can be filtered.
Ashleigh
Re: Help connecting to Google Ad Manager CreativeService needed
Google typically has a really good Python packages which help to connect to their APIs. Has your dev team looked into using ?
You could pair it with pydomo to upload the data into Domo.