welcome [tc18.tableau.com] · 2020-01-06 · use a service like ifttt to store data on google...
TRANSCRIPT
![Page 1: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/1.jpg)
![Page 2: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/2.jpg)
Welcome
![Page 3: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/3.jpg)
Rock your social media data with Tableau
# T C 1 8
# Ta b l e a u G e t s S o c i a l
Alexander Loth
@xlth
![Page 4: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/4.jpg)
http://bit.ly/tab-social
![Page 5: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/5.jpg)
![Page 6: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/6.jpg)
![Page 7: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/7.jpg)
![Page 8: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/8.jpg)
![Page 9: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/9.jpg)
Agenda
Step 1: Understand How to Succeed with Social Media
Step 2: Define Your Social Objectives and KPIs
Step 3: Assemble Your KPIs
Step 4: Connect Your Social Media with Tableau
Step 5: Apply Some Tips to Level Up
Step 6: Explore Social Media Listening
Step 7: Leverage your Analytics Tool Chain
Demo
![Page 10: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/10.jpg)
Step 1: Understand How to Succeed with Social Media
![Page 11: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/11.jpg)
Product
FinanceSales
Operations& IT
Social Media
Marketing
The Customer-Centric Data Strategy
#TC18 #TableauGetsSocial @xlth
![Page 12: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/12.jpg)
Develop a Strong Social Media Presence
#TC18 #TableauGetsSocial @xlth
![Page 13: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/13.jpg)
Post Regularly and in the Right Formats
#TC18 #TableauGetsSocial @xlth
![Page 14: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/14.jpg)
Post Regularly and in the Right Formats
#TC18 #TableauGetsSocial @xlth
![Page 15: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/15.jpg)
Step 2: Define Your Social Objectives and KPIs
![Page 16: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/16.jpg)
Relevant Metrics
#TC18 #TableauGetsSocial @xlth
![Page 17: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/17.jpg)
Social Objectives
Define specific KPIs for social media platforms
KPI objectives need to be measurable
Metrics should be in line with the business goals
#TC18 #TableauGetsSocial @xlth
![Page 18: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/18.jpg)
Relevant Metrics
BenchmarksFollowers, mentions
AudienceImpressions, reach, demographics, location, timing
EngagementsLikes, shares, views, comments, follows
ConversionsClicks, leads
OpportunitiesUser-generated links, related hashtags
SentimentBrand monitoring, negative feedback
#TC18 #TableauGetsSocial @xlth
![Page 19: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/19.jpg)
Audience
#TC18 #TableauGetsSocial @xlth
![Page 20: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/20.jpg)
Engagements
#TC18 #TableauGetsSocial @xlth
![Page 21: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/21.jpg)
Step 3: Assemble Your KPIs
![Page 22: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/22.jpg)
Marketing Program Effectiveness
• Social Reach = Total # of followers across all platforms
• Engagement = (# Shares + # Likes + # Comments + …)/ # Posts
#TC18 #TableauGetsSocial @xlth
![Page 23: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/23.jpg)
Brand Awareness and Reputation
#TC18 #TableauGetsSocial @xlth
![Page 24: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/24.jpg)
Lead Generation Effectiveness
#TC18 #TableauGetsSocial @xlth
![Page 25: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/25.jpg)
Step 4: Connect Your Social Media with Tableau
![Page 26: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/26.jpg)
How to Get Social Media in Tableau?
#TC18 #TableauGetsSocial @xlth
![Page 27: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/27.jpg)
How to Get Social Media in Tableau?
Option 1: Directly from the platformGet data directly from Facebook, Twitter, YouTube, and more
Option 2: Via web automationUse a service like IFTTT to store data on Google Sheets
Option 3: Via web data connectorUse Tableau’s web data connector
Option 4: Code your own solutionUse an API provided by the platform
Option 5: Via a third party platformGet data from an integrated social media platform, such as Talkwalker
#TC18 #TableauGetsSocial @xlth
![Page 28: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/28.jpg)
Option 1: Directly From the Platform
Twitter Snapchat Facebook
#TC18 #TableauGetsSocial @xlth
![Page 29: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/29.jpg)
Option 1: Directly From the Platform
#TC18 #TableauGetsSocial @xlth
![Page 30: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/30.jpg)
Option 2: Via Web Automation
#TC18 #TableauGetsSocial @xlth
![Page 31: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/31.jpg)
Option 2: Via Web Automation
#TC18 #TableauGetsSocial @xlth
![Page 32: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/32.jpg)
Option 3: Via Web Data Connector
Web Data Connector
#TC18 #TableauGetsSocial @xlth
![Page 33: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/33.jpg)
Option 3: Via Web Data Connector
#TC18 #TableauGetsSocial @xlth
![Page 34: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/34.jpg)
Option 4: Code Your Own Solution
Fetching tweets with R:
library(twitteR)
library(ROAuth)
setup_twitter_oauth("consumer_key", "consumer_secret",
"access_token", "access_secret")
tweets <- userTimeline("xlth", n = 3200)
tweets.df <- twListToDF(tweets)
write.csv(tweets.df, file="tweets.csv")
![Page 35: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/35.jpg)
Option 5: Via a Third Party Platform
![Page 36: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/36.jpg)
Option 5: Via a Third Party Platform
![Page 37: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/37.jpg)
Step 5: Apply some Tips to Level Up
![Page 38: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/38.jpg)
1. Gather Historic Data
#TC18 #TableauGetsSocial @xlth
![Page 39: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/39.jpg)
Twitter Stats
![Page 40: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/40.jpg)
2. It’s About Time!
#TC18 #TableauGetsSocial @xlth
![Page 41: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/41.jpg)
3. Be Consistent
Date
Channel
Content
Post type
Impressions, reach, likes, comments, shares, replies
#TC18 #TableauGetsSocial @xlth
![Page 42: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/42.jpg)
4. Think About Your Words
Small variations can make a difference! Example of A/B testing on Twitter content:
![Page 43: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/43.jpg)
4. Think About Your Words
Starting with a Call to Action (CtA) is always a good idea!
![Page 44: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/44.jpg)
5. Use Logical Calculations
#TC18 #TableauGetsSocial @xlth
![Page 45: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/45.jpg)
6. Design for Interactivity
#TC18 #TableauGetsSocial @xlth
![Page 46: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/46.jpg)
7. Use a Web Data Connector:Take Advantage of Our Community
Facebook Instagram Twitter
#TC18 #TableauGetsSocial @xlth
![Page 47: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/47.jpg)
8. Free Your Data!
#TC18 #TableauGetsSocial @xlth
![Page 48: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/48.jpg)
9. Don’t Forget to Localize Your Data
#TC18 #TableauGetsSocial @xlth
![Page 49: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/49.jpg)
10. Blend and Join Various Data Sources
#TC18 #TableauGetsSocial @xlth
![Page 50: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/50.jpg)
Step 6: Explore Social Media Listening
![Page 51: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/51.jpg)
![Page 52: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/52.jpg)
Explore Social Media Listening
#TC18 #TableauGetsSocial @xlth
![Page 53: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/53.jpg)
Step 7: Leverage Your Analytics Tool Chain
![Page 54: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/54.jpg)
Leverage Your Analytics Tool Chain
#TC18 #TableauGetsSocial @xlth
![Page 55: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/55.jpg)
Apply Text Mining
#TC18 #TableauGetsSocial @xlth
![Page 56: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/56.jpg)
Parse Messages with Regex
Extract URLs in Tableau with Regex:
REGEXP_EXTRACT(
[Post Message],
'((?:http|https)://(?:[\w_-]+(?:(?:\.[\w_-]+)+))(?:[\w.,@?^=%&:/~+#-]*[\w@?^=%&/~+#-]))'
)
![Page 57: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/57.jpg)
Use Your R and Python Skills
Unshorten URLs in Tableau with R:SCRIPT_STR('
newurl <- .arg1url <- ""while(url != newurl){
data <- system(toString(paste0("curl -I ", newurl)), intern=T)if(sum(grepl("location: ", tolower(data))) == 0){
url <- newurl}else{
data <- subset(data, tolower(substring(data, 1, 9))=="location:")stringurl <- substring(data[1], 11, nchar(data[1])-1)if(substring(stringurl, 1, 4)=="http"){
newurl <- stringurl}else{
url <- newurl}
}}return(newurl)
',ATTR([URL Extract]))
![Page 58: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/58.jpg)
Let’s See this in Tableau!
![Page 59: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/59.jpg)
![Page 60: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/60.jpg)
Please complete the
session survey from the
Session Details screen
in your TC18 app
![Page 61: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/61.jpg)
Thank you!
#TC18
#TableauGetsSocial
@xlth
http://bit.ly/tab-social
![Page 62: Welcome [tc18.tableau.com] · 2020-01-06 · Use a service like IFTTT to store data on Google Sheets Option 3: Via web data connector Use Tableau’s web data connector Option 4:](https://reader035.vdocuments.us/reader035/viewer/2022070718/5ede1e3fad6a402d66696839/html5/thumbnails/62.jpg)