Transform PPC Data into a Striking Pivot Table: AIMCLEAR‘s Deep in the Sheets (Episode 13)
Tune in for the final installation of our five-part Excel series on converting raw data into a presentable format. This week’s episode of Deep in the Sheets provides formatting tips to create stunning representations of your data. Follow along as we add style, color and font to really make data pop in an Excel spreadsheet. Enjoy […]
PPC Pivot Tables & Charts: AIMCLEAR‘s Deep in the Sheets (Episode 12)
Continuing our pivot table series, this week’s episode of Deep in the Sheets shares how to efficiently organize data in pivot tables. Pivot charts arrange data in a visually appealing format and convey statistical changes over time. In this episode, we’ll also dive into: Return on Ad Spend (ROAS) Cost Over Time Distribution of Quality of Leads Tune in […]
Calculate Fields for a Pivot Table: AIMCLEAR‘s Deep in the Sheets (Episode 11)
Using the raw data from our last episode of Deep in the Sheets, we’ll show you how to use calculated fields in Excel pivot tables during this week’s episode. Watch the video to learn how to create calculated fields for: Click-through rate Conversion rate Return on ad spend (ROAS) Return per thousand impressions (RPI) In […]
Understand Raw Data with Pivot Tables: AIMCLEAR‘s Deep in the Sheets (Episode 10)
In this week’s episode of Deep in the Sheets, we discuss Part 2 in our series about taking a document from raw data to sharing-ready through pivot tables. In particular, we walk the PPC pro through how to: Formulate months as rows Integrate lead quality Determine quantity of leads Use filters to better understand data […]
Prepping Data for Proper Pivot Tables: AIMCLEAR‘s Deep in the Sheets (Episode 9)
Our next venture in Deep in the Sheets will feature a series of videos that transform raw data from your spreadsheet to beautiful, presentation-ready style. In this episode, we’ll walk you through how to prepare your data ahead of time to maximize the effectiveness of pivot tables through column grouping for pivots. Follow along as […]
Increase PPC Workflow in a Snap! AIMCLEAR‘s Deep in the Sheets (Episode #8)
In this episode of Deep in the Sheets, Megan Demarais, AIMCLEAR SEM Account Manager, recounts 15 Excel hacks that increase PPC workflow. Here’s what you can expect to learn: Automatically sum Network days function (determine how many weekdays in a particular month) “CTRL” “PLUS” Repeating a formula in multiple cells Copying patterns Tabbing between worksheets […]
Visualized Budget Pacing (Episode #7) – AIMCLEAR‘s Deep in the Sheets
Today’s episode of Deep in the Sheets illustrates how to manage and track your budget to ensure ideal pacing throughout any given time frame. Dion Plakos explains how to identify whether you are spending budget too quickly or if you should allocate more dollars throughout any PPC campaign by following this nifty Excel guide. Easily […]
Negative Keyword Research Simplified (Episode #6) – AIMCLEAR‘s Deep in the Sheets
This episode of Deep In The Sheets covers how to simplify extensive negative keyword research with a large query set. Using a scraping tool known as ScrapeBox, we document suggested search query ideas from Google and/or YouTube suggestions. This specialized research allows us to provide targeting fodder for search campaigns or as negative keywords that do not match our targeting criteria. […]
How to Calculate CPI (Episode #5) – AIMCLEAR‘s Deep in the Sheets
In this episode of Deep in the Sheets we examine how to effectively calculate ad creative performance using conversions per 1000 impressions (CPI). CPI gives you the ability to take into account multiple performance metrics, in this case click-through rate and conversion rate to understand how one ad creative stacks up against another. The formula […]
AIMCLEAR Presents Deep in the Sheets: An Excel-Focused Video Series for PPC Practitioners
A deep understanding of Excel is key to a PPC manager’s ability to view and analyze data in a way that results actionable outcomes. That’s why we’ve created a new web series, Deep in the Sheets, beginning with the first five #TASTY hacks below! For PPC newbies and advanced pros alike, Deep in the Sheets […]