Tips and tricks

At Supermetrics, we're on a mission to make marketing data work more accessible to everyone – even more complex tasks like data transformation.Custom fields templates make the transformation features in Supermetrics even easier to use. Check out the short video below to see how 👇 P.S. The first three are based on the most popular transformations in Supermetrics, but let us know if you have a really impactful transformation that you'd like to see templatized!

Check out 3 easy tricks that’ll make a big difference for your reporting in Looker Studio 👇 Trick # 1. Use conditional formatting. You can use conditional formatting in tables or scorecards. It lets you quickly spot outliers in your data by highlighting them with a specific color. Example use case:  highlight when you’re over or under-pacing your monthly budget. You’ll find conditional formatting under the style panel: Trick #  2. Master report-level components. When you divide your dashboard  into multiple pages by the marketing channel or campaign, it’s important to keep it consistent and aligned with your brand. You should use similar elements on different pages—headlines, colors, or your logo.  The easiest way to manage these branding elements is to set them as report-level components. For example, if you edit the component on one page, it automatically copies the changes to each page. Trick # 3. Connect all your marketing platforms asap.  Connect all your data sources right from

Did you know that you can change the language of the fields in your Google Sheets report to the local language?  The report language setting in Supermetrics for Google Sheets translates the field names in your report to any language, making it easy to create a report in the local language.  The report language setting offers translations to 94 languages listed in the ISO 639-1 standard. Learn more about which languages are available. How to change the report language in Google Sheets? Go to the Supermetrics sidebar.  Select Options → select a target language from the Report language drop-down menu.  Note: This setting won't affect the language of the user interface of Google Sheets or the Supermetrics sidebar. Only the field names in the query results are translated into the target language.

Have you used Supermetrics for budget pacing? What kind of template have you created for it?My colleagues Courtney and Milja hosted a webinar recently about budget pacing best practises, and they shared a template that you can start using for your own budget pacing sheet. 🤩