Anyone you choose, even when they don't have access to AdWords. And with the recently improved AdWords CM integration in Data Studio, it's very easy to select only accounts from a CM to include (provided they use the same currency). 2. Create a custom heatmap chart Tables are great, but they can take a while to read and understand. If you want to combine the level of detail gained from a table with easy-to-understand data visualization, try a custom heatmap table. You can build the table with up to 10 levels of segmentation to get a very granular view.
For example, use lots of segments and color coding to quickly identify parts of an account that could be optimized. 3. View Third-Party Call Tracking Data Although Data Studio does not integrate directly with call tracking providers, you can still include this type of data jewelry retouching service if you manage it on your own SQL servers or in a Google spreadsheet. The graph above is an example I created using call tracking data from CallRail, which I added to a Google sheet with Zapier. This data can then be rendered in a variety of interesting ways.
Here I show both a graph with the number of calls received each day and the overall total for the last 30 days. Since each call is a row on the spreadsheet, to get the call count I used one of my favorite features in Data Studio: custom calculations to sum it all up. Specifically, I used the COUNT(Date) formula to get the total number of calls per day. 4. Use calculated fields to show your account size There are a few nifty functions that can help calculate new metrics from the underlying data in Data Studio. For example, use the COUNT (ad group) function to display the number of ad groups.