![]() You can also download the results from the Query Explorer and view them in Excel. The Query Explorer will tell you (1) how many rows of results were available (even though it returns 10K rows max), and (2) whether or not the data was based on a sample. ![]() Pro Tip: Use the API Query Explorer! Enter the same date range, segment, dimensions, and metrics. The worst part is that Tableau doesn’t warn you when it returns incomplete or inaccurate, sampled data. If you ask for any segment of data that GA has to calculate by searching through a really large set (500,000 sessions or more), then GA will estimate total results based on a sample of that data. The GA connector is bound by the limits of the Google Analytics API, which means you can’t ask for more than 10,000 rows of data at a time. Wait, why can’t you ask for all the data? In a word: Limits. Tableau recognizes that it’s not a good idea to ask for ALL THE DATA – and Step 2 provides two ways to define a smaller data set. In Step 2, you have the option to “filter” your data. It’s a different story for Steps 2 and 3. Go fix the names so you can tell what they are! Common PitfallsĪbout the only thing that can go wrong in Step 1 is that your GA account has poorly named properties or views, but that’s not Tableau’s fault. Now you’re all set to start visualizing that data, right? Maybe. See what they did there? It’s easy as 1-2-3! Select the options presented as Steps 1, 2, and 3. Then tell Tableau what data you want to see. I’ll recap here, for reference later when I talk about the pitfalls.įirst, click “Connect to Data” and choose “Google Analytics” under More Servers… Sign in to the Google Account you use to access GA, and click “Allow” when Tableau asks for permission. ![]() The connection process may be found in several places online, including Tableau’s own documentation, of course. You give Tableau permission to access your GA data, and then describe the data you want. On the surface, connecting Tableau and Google Analytics looks straightforward and simple. In this post, I’ll show you how the connector is supposed to work – and then show you how it can go wrong. It’s not that the visualizations are disappointing – my Tableau dashboards are great for interacting with GA data, and my clients are delighted with them! The letdown was in the Tableau and Google Analytics connector. Tableau’s beautiful, interactive data visualizations long tempted me, but it wasn’t until they introduced the direct connection to Google Analytics that I finally took the bait. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |