Welcome to Part 2 of our favorite Data Studio tips! If you missed part 1, check it out here - Data Studio Tips Part 1: Beginner. Custom Metrics & Dimensions It’s likely that at some point in your report creation, you’ll need a calculated metric or dimension that isn’t already included in your data set. Common ones are cost per lead (CPL) and click-through-rate (CTR), … [Read more...] about Data Studio Tips Part 2: Intermediate
Search Results for: excel
The Makeup Of An Effective PPC Report
If you do PPC, the odds are that you probably look at a million reports a day. You might look at reports from each channel interface, competitor reports, or big picture overall performance reports. A good report allows you to aggregate all of the important data, visualize performance in an easily digestible way, and draw insights that help you determine your strategy based on … [Read more...] about The Makeup Of An Effective PPC Report
Evaluation and Insights on LinkedIn Message Ads (InMail)
Do you ever find yourself inquiring about which ad format on LinkedIn is the most effective? Well, today, I’m going to break down my experience with one of the more heavily debated ad formats LinkedIn has to offer - the InMail, or should I say the newly rebranded Message Ad. I’ll be referring to these ads as InMails throughout this blog as I’m sure it's the term you’re all … [Read more...] about Evaluation and Insights on LinkedIn Message Ads (InMail)
Tips for Building Expansion Proposals
When things are going well it can be difficult to get the creative juices flowing and come up with your next brilliant move to expand your business’s marketing plan. Today, I’ll outline a few things that “past you” can do to make “future you” look like a genius with minimal effort. Keep track of your tangents Meetings can be an excellent petri dish for brainstorming. … [Read more...] about Tips for Building Expansion Proposals
Video Remarketing: LinkedIn vs. YouTube
By now, us savvy marketers know the big statistics around marketing videos to consumers: Nearly 50% of internet users look for videos related to a product or service before visiting a store - Hubspot65% of executives have gone to the marketer’s site and 39% have called them on the phone after watching a marketing video. (Forbes)52% of marketers say video is the type of … [Read more...] about Video Remarketing: LinkedIn vs. YouTube
Boosting Sales Consistently with the Right Product Video
Even today, people find it hard to trust online shopping. It makes sense, though: you can’t touch, try or test the product with your own hands. Not to mention that, all too often, you don’t get what you thought you would get. And is there anything more frustrating than that? Luckily, eCommerce marketers found a great solution to bridge the gap, foster trust, and prompt … [Read more...] about Boosting Sales Consistently with the Right Product Video
How To Merge PPC Data Across Platforms
“Data data everywhere, nor any report to view” Data comes in all shapes and sizes, from multiple platforms and in various formats. When it comes time to build a report or run an analysis, it oftentimes is very cumbersome to merge data sources. This post will describe common methods of PPC data aggregation. Combining Data In Google Sheets Perhaps the simplest method of … [Read more...] about How To Merge PPC Data Across Platforms
How To Set Up A Macro In Google Sheets
To Google Sheets! The cloud-based cause of, and solution to, all my work-related problems. It’s time again to bask in the glory of the macro. In my last post, How Excel Macros Save Digital Marketers Time, we discussed the various purposes and implementation methods of macros in Excel. In this post, we’ll be talking about the macro’s cooler, more modern brother, the Google … [Read more...] about How To Set Up A Macro In Google Sheets
3 Ways To Build Customer Loyalty During A Crisis
As we battle the current pandemic that is COVID-19, it’s important for marketers to keep their customers, or potential customers, at the forefront of their decision-making process. This might seem obvious so let me explain. When I say, “keep the customer at the forefront of the decision-making process,” it isn’t just about the “put the customer first” or “the customer … [Read more...] about 3 Ways To Build Customer Loyalty During A Crisis
How Data Science Can Improve PPC Performance
As machine learning and automation gain more of a stronghold in digital marketing, we need a way to analyse all the data we obtain. Data science does this by turning theories into tangible evidence. One data science term you might come across is big data. It refers to large and complex data sets used to identify trends and patterns that can help businesses make better, more … [Read more...] about How Data Science Can Improve PPC Performance
An Intro To Custom Reporting in Facebook Ads
Picture this: it’s the beginning of the month, you have a million different reports you need to compile for a million different accounts, and you’re short on time. Sound familiar? Okay so maybe you actually only need to pull a handful of reports. Well, today, I’ll walk you through the nifty feature that is Custom Reporting in Facebook Ads, and how you can use this tool to … [Read more...] about An Intro To Custom Reporting in Facebook Ads
The Top 50 Most Influential PPC Experts [2020]
Every year, PPC Hero releases The Top 25 Most Influential PPC Experts. We develop and share the Top 25 list to show our gratitude for those in our industry who continue to spend time and resources educating us and sharing insights to help us excel at our jobs. While you all anxiously await the Top 25 list (which will be released in a few weeks), we want to share the Top … [Read more...] about The Top 50 Most Influential PPC Experts [2020]