I am building an excel training programme for PPC (Paid Search, Social, Display, etc.) managers.

I am an excel aficionado and am a bit concerned about overdoing it. What do you think should be the main points to cover for people you have to optimise and report on Paid Media campaigns? #PPC #Excel #Reporting

Posting as :
works at
You are currently posting as works at

You’re not over doing it.
I’d say teach how to aggregate data, the. Vlookup to show select data and visualize it for executive reports and trends.

helpful

Thanks! What I meant by overdoing it is I want to get into power query/pivot, index/match functions, matching tables with join keys, etc. I felt that was super useful for me as a PPC manager. But it might be overkill.

Vlookup is required. These days google looker is almost a requirement as well.

I have made it 2003-2023 without power pivot but I would have loved that skill in the past.

Related Posts

Curious to hear everyone's "expectations" versus "reality" for their wedding day?
There's such an expectation around one's wedding day but not much discussion around how it's different from it

like

I write TV commercials, and since Bulova created the first TV ad, I’ve been interested in adding one to the collection. I know more about their ad history than the actual watches. Anyone have a recommendation?

like

How does approval process usually work with rolex ADs? I have a purchase history with a current AD and been on a waitlist for a while. Got a msg saying they have one in system and waiting to get approval to sell me one, but no promises. Does this mean I am likely to get one soon?

like

Walked into a Rolex AD yesterday just to browse. Walked out with this bad boy!

Post Photo
likefunny

What's dating like in SF? New to the area.

Anyone have advice on how to approach a re-applicant essay asking what you’ve done since you last applied? My only update is a promotion…

like

Informatica openings any?
9+ experience

like

Quitting my job soon and am thinking about becoming a therapist/counsellor for lawyers and other high stress professions. Taking a poll on whether you would be attracted to the idea of a therapist who worked in biglaw and could speak to burnout, perfectionism and other mental health issues we typically face as lawyers. Thanks :)

likehelpful

Will be moving to greater Denver area within the next year.
Looking for a good neighborhood with: 1) great schools; 2) less of a suburban feel. Suggestions?

like

How long does HSBC take to schedule interview after APTA test?

Just got an offer to a BB. How do I popcorn this into more?

like

What's everyone doing for the 4th?🇺🇸 🇺🇸 🇺🇸

like

What is your ideal salary and why? Curious to know if there is a magic number out there. Currently, I would like to make 150k+ by the time I’m in my 30s

likefunny

I brought my guitar to Iraq, it wasn't easy, but I managed to convince my commander to let me take it. I will never forget those days when we played our favorite country songs with my buddies.

like

Hi
Can anyone help me how should i explain my project on which i worked in my current company to the interviewer.would be very helpful if someone can help with the basic format from start to end or else can give example of their own project.

Thanks in advance

like

I’ll be giving my notice around when I have off for a long weekend & when I start my new job I have a vacation planned for a few days. Should I change my plans or keep my personal commitments?

like

I have an idea for an App, like a really great one, what do I do next? I’m not a developer or an entrepreneur.

likehelpful

Interesting choice of names 🤔

Post Photo
funnylike

Freelancers, for a month long project that you were interested in, for a small shop, do you cut your rate/accept a fee for the full 4 weeks? And if so, by how much feels comfortable/fair for both? Let’s say your average day rate was about 1k a day as a base for discussion.

like

Additional Posts in PPC

Looking to switch from SA360 to Skai based on the new experience basically being exactly what we get for free within the Google Ads UI current - any thoughts, forewarnings, experiences where you did this but ultimately went back to SA360?

Hi PPC Guru’s

I recently started a local store visit campaign but it’s not allowing me to optimize towards store visits. My Google rep doesn’t know what she’s doing I swear, she’s not had any answers and she’s the one the recommended we utilize this ad type. Any ideas why it’s not letting me optimize towards this? Get directions is what I currently have it set as and we are getting conversions but we really want the store visits. Thanks so much!!

Hey y'all. Haven't seen a PPC bowl yet. Let's talk awesome!

like

Ok.. I really want to get a search bowl going. Anyone interested? So here’s a topic we can start with: Does anyone still use Google’s enhanced PC?

like

An agency recommended we invest heavily in Smart campaigns in G.Ads. WTF?
Why am I paying this agency?

funny

Anyone hiring for PPC specialist? I have a former coworker looking for work. 100% remote…US citizen staying in Mexico.

like

Looking for a Supervisor to join our team here at Rain! Gig is 100% remote, flexible hours, really great team that ACTUALLY focuses on work life balance, working on some really cool large scale client across industries! 3-5 years experience managing people & within platforms, YouTube is a plus!

Looking for a paid search manager to join our media team! Headquarters located out of Baltimore, MD but the position has the flexibility to be completely remote. Looking for 3-5 years experience.

Dear Fishbowl PPCers I need your help!

A client is insisting we used Adobe bod manager for their campaigns, and neither me nor my team have experience with it.

We're also not on a timeline where we can really get up to speed on it ahead of a couple deadlines.

I've also argued for budget for external consulting hours and that's been disapproved.

I'm on my own. Or am I?

Hoping some kind soul with experience managing Google Ads through Adobe can help me out.

Continued...

Does anyone use Universal Local Campaigns? A client wants supplemental support for specific locations. I’ve never run a ULC campaign targeting a single location - any idea if this would compete with our existing campaigns targeting the same locations (we run campaigns targeting location groups by region)? Can a ULC targeting a single location see scale without sacrificing too much cost/store visit efficiency? Google Help articles are, unsurprisingly, no help.

I’ve been a search manager for 8 years. What kind of role can I take on at a place like Google etc ? I am trying to figure out what’s next for me. I’ve considered client side, a lot marketing director roles that I think could be a good fit but I feel lost. I am tired of no upward movement in my career.

Question for agency PPC experts. Who is responsible for your client's monthly paid ads budget? The PPC expert employee or someone else in the company keeps track of the budgets to not overspend?

Question for paid search experts who have big agency experienc (e.g. big 4, dentsu, etc.) - is it considered standard to use SKAG instead of STAG, and use alpha/beta structures?...even with the changes Google has made to phrase and exact match? The various agencies I've worked at (small agencies) never use that method.

If you were interviewing someone from a small agency and they said they didn't use those types of account structures, would you think they were inexperienced?

like

Can we use this comment to share salaries. I’m a strategist at a $65k salary. Promoted at 9months from $45k. A total of 1yr 4 months in the paid search space.

What do you all think of Google Performance Max?

like

Hey all. Paid search strat here. What would the salary expectations be for a senior strategist in nyc for paid search be? I started 06/2021 as a assistant then promoted to a strategist 05/2022. I’m at 65k.. so I wanted to see what I should ask for especially if I am being considered.

like

Looking for strong PPC managers for a fully remote role at our agency. If you’re experienced in the full Google Ads portfolio (search, display, YouTube) let’s talk!

Anyone have trouble explaining to clients that Position 1 all the time isn’t necessarily a strong strategy?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal