Hi Team,
I have SQL database to pull UTM data. We have many data. Clients want to pull the top 20 based on some UTM parameters combination. They have provided that combination in Google sheet.I want to use that google sheet as lookup sheet and pull the metrics values from my SQLfor that combination.
So i have used my tableau linking key between google sheet and sql is
SQLLinking condition
lower(utmsource+utmmedium+utmcampagin+utmcontent) ==>
GooglesheetLinking
if [Exclude UTM Content?]='N' then
LOWER([UTM Source])+ LOWER([UTM Medium])+
LOWER([UTM Campaign])+ LOWER([UTM Content])
else LOWER([UTM Source])+ LOWER([UTM Medium])+ LOWER([UTM Campaign])
END
For the above condition i can get quotes for exclude utm content=N. But issue in getting quotes for the below campagins
XXX_26
XXX_21_22
Goodgirl26
2025calendar
2026calendar
Thanks,
Maya
#Tableau Desktop & Web Authoring
@Maya Mayabalan Hi, the simple way to get your data and the metrics you need would be to add both data source as connections in Tableau. Then use built in relationship model to get your data, it's performance effective as well. Read more: https://help.tableau.com/current/pro/desktop/en-us/relate_tables.htm
