Jul 18, 2022
In Wellness Forum
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. Then, apply a data filter jewelry retouching service to a variable such as ad group status to show how many are active, paused, or deleted. In this example, we calculated the number of active ad groups in an account, as well as the number of keywords that currently have a Quality Score of 6, and what is the highest and lowest Quality Score. for any active keyword in the account. . 5. Eliminate reporting complexity by standardizing campaign names Account managers use different campaign naming conventions depending on the strategy of their account structure. For example, someone using an alpha/beta structure might name one campaign "Widgets - Alpha" and another "Widgets - Beta". The recipient of a report is probably only confused when they see your naming convention, so why not standardize the names?