Marketing teams require consistent analytics to spot trends and judge performance. Beyond that, deeper analytics enable marketers to better understand their customers – who they are, their potential value, and how to maximize that value. This involves getting the right data, into the right format, and then presenting it in a way that is easy to understand and encourages deeper investigation.
How can you get the right data needed, keep it up-to-date, and present it in easy-to-read dashboards? Watch a recording of “5 Key Marketing Analytics and How to Get the Data” and find out.
The webinar recording covers how you can use Alteryx and Tableau to:
- Blend data from your CRM, marketing automation system and Excel spreadsheets
- Cleanse and prepare your data for visualization
- Create dashboards and visualizations that can drive your team’s marketing decisions
Want to jump directly to the attendees’ questions? Continuing reading for a recap of participants questions, as addressed by the session speakers.
Q: What are some examples of how companies are doing spatial analytics with Alteryx and Tableau?
A: One example includes McDonald’s and specific drive time analysis. When selecting a retail location, McDonald’s looks at potential customers within a 5 or 8 minute drive time to a location, and with this data, they are able to predict the revenue and profitability potential of a store. They can also look at nearby competing stores to get a better understanding of what market share they can take.
Telecommunications companies use spatial analytics to determine where to place cell towers. They determine where their most valuable customers are in relation to dropped call locations to determine which tower location would have the greatest impact on profitability for the organization.
It’s clear geospatial data combined with customer data can be very powerful for larger organizations, but the benefit extends to a micro level as well. For example, geospatial data is being used for in-store fraud detection by Alteryx clients. Prescription fraud can be detected using data on where a doctor is located compared to where a prescription is filled and the location of the pharmacy.
Tableau is great for visualizing spatial analytics for these examples and more, helping users quickly understand what the data is sharing through its visualizations.
Q: Can Alteryx export in a format other than Tableau?
A: Yes, Alteryx can output data into spreadsheet formats, databases or you can go directly from Alteryx to Tableau. There are number of options for architecting your flow based on what your organization is trying to achieve.
Q: If a survey has been outsourced, does Alteryx box in the quant vendor to provide the raw data in the Tableau format?
A: Alteryx is vendor agnostic for survey data. We can work with data in whatever shape it comes in, i.e. CVS, SPSS or Excel files. Combine this with Tableau’s visualizations and their ability to make exploring and questioning data easier, and you really get to a point where you can draw great insights from the survey quickly.
Q: Can data from a paper and pencil survey be keyed in into Alteryx?
A: Alteryx does not have built-in OCR functionality so someone would have to key the data into an electronic format for analytics in Alteryx.
Now that you are caught up on the webinar Q&A, take the next steps and discover the power of Alteryx and Tableau together for yourself.
Ready to start generating deeper insights faster with Alteryx and Tableau?
The Alteryx Starter Kit for Tableau is a great way to get going with data workflows, similar to those Chris shared during the webinar. Download your Starter Kit at www.alteryx.com/kit.
Not ready to get started quite yet?
Check out our weekly demo of Alteryx for Tableau – every Thursday at 11 am PST. In the 30 minute demo, you’ll get a deeper look at how Alteryx self-service data blending and advanced analytics complements Tableau visualizations. Register today!
