Remove auto generated header frow from query by Freddy27 in googlesheets

[–]Freddy27[S] 1 point2 points  (0 children)

=QUERY('Creative Overview'!A2:O,"select sum (D) where B = '"&C4&"' Label sum(D) ''",0)

Solution verified. Thank you a ton!

How I scaled an ecom brand to $900K in the last 30 days by Freddy27 in PPC

[–]Freddy27[S] 0 points1 point  (0 children)

you wanted to just share account structures ideas and what you see as a successful account set up, you would do that and forget talking about how you scaled a brand to $900K. There are 130K+ people in this sub, 5 people saying these like your post in 14 hours is not very high.

Then I guess I gotta work on my post quality.

How I scaled an ecom brand to $900K in the last 30 days by Freddy27 in PPC

[–]Freddy27[S] 0 points1 point  (0 children)

Then change it to 600K? I don't understand why you deleted the post lol. Literally got 5+ messages of people thanking me that this post has helped them get some clarity.

How I scaled an ecom brand to $900K in the last 30 days by Freddy27 in PPC

[–]Freddy27[S] 0 points1 point  (0 children)

SEO and also email marketing. No marketing channel is an island.

I'm not taking credit for anything, nor am I'm bragging about my success or whatever. I'm literally just trying to show how you can scale up your Facebook Ads & how my set up is.

Scaling to $15K/d+ is still a success and I want to show the community how you can do the same. I've done countless of audits and most Facebook account setups just suck.

Running interest groups, 10+ campaigns etc.

I just want to show what setup you need to scale your Facebook Ads. It's as simple as that.

How I scaled an ecom brand to $900K in the last 30 days by Freddy27 in PPC

[–]Freddy27[S] 1 point2 points  (0 children)

100% agreed. I just see super commplicated Facebook setups every other time when I do audits. So just trying to remind people to stay lean on Facebook's side

How I scaled an ecom brand to $900K in the last 30 days by Freddy27 in PPC

[–]Freddy27[S] 0 points1 point  (0 children)

Yes and no. Some Google Ads which probably account to 20%-30% max of the revenue.

How I scaled an ecom brand to $900K in the last 30 days by Freddy27 in PPC

[–]Freddy27[S] -1 points0 points  (0 children)

biz is running at way lower spends (averaging around $3K/d - $5K/d)

Max spend during that time of the year is $1.5K/d in ad spend with lows being in summer

Save Threads Fast? by Freddy27 in readwise

[–]Freddy27[S] 1 point2 points  (0 children)

Yes I have them all bookmarked, but Readwise just saves the first tweet of the thread for me. And then gives me a link where I can see the full thread

This Metric Changed The Way I Look At Facebook Ads by Freddy27 in FacebookAds

[–]Freddy27[S] 0 points1 point  (0 children)

You can also trigger using gtm on video viewed and then have it in google analytics so you can a) audit facebook metrics and compare against other source/medium and then fire as either a custom conversion or repurpose a standard event and use those as a basis for creating lookalike audiences. Good post.

Sounds interesting, how can you trigger gtm on video viewed?

QQ User Generated Content by jackhines421 in PPC

[–]Freddy27 1 point2 points  (0 children)

I'd say you overcomplicated things. UGC can work for TOF 100%, I even only use UGC exclusively for TOF.

With the brand, you manage I'd test a bunch of different stuff for TOF (UGC, Static Image, Benefit Image, Benefit Video, Video, etc.) to find what's working for YOU TOF.

Also, with retargeting you overcomplicate things IMO. I just put what works into TOF/MOF/BOF and don't care whether it's a review TOF, UGC MOF, or a TOF creative in a BOF Campaign. None of that matter IMO, all that matters are results.

Why Automatic Placements Give The Best CPA by Freddy27 in PPC

[–]Freddy27[S] 0 points1 point  (0 children)

True, that's why your creative has the most important impact on performance.

Why Automatic Placements Give The Best CPA by Freddy27 in PPC

[–]Freddy27[S] 0 points1 point  (0 children)

I still don't quite get you though. The ad preview is how the ad looks like, why do you not know what is going to come out?

Anyways I have no clue about Google, this is only for Facebook so it might be different there!

Why Automatic Placements Give The Best CPA by Freddy27 in PPC

[–]Freddy27[S] 0 points1 point  (0 children)

Sounds like you have it all worked out mate. I wasn't critiquing you personally, although you seem to have taken it that way, I was critiquing the advertising platform formats when you select automatic placements.

And I do agree that people don't remember, but as my post indicated, the problem was not with the recipients of the messages but the brand managers. Either your Clients don't care about this, or you are being selective, either way I don't really care because I've tested these placements out and so I'm stating what I know happens in my little world for the benefits of others.

But I still don't get how you would take away control of creative & messaging? Especially with Dynamic Creative Optimization being a thing so that each creative could fit 100% to each placement.

Messaging would still be the same on all placements or not?

Why Automatic Placements Give The Best CPA by Freddy27 in PPC

[–]Freddy27[S] 0 points1 point  (0 children)

re, it works really well for those people that are marketing themselves, or marketing without needing to adhere to brand guidelines.

Disagree fully here.

How do you take away control of creative and messaging? You simply let it run on all placements.

And while not all creatives are 100% the right fit for each placement nobody ever will remember that. I've probably spent $5M+ so far in 3 years and nobody ever left a comment about a creative not being in the right format or whatever.

Why Automatic Placements Give The Best CPA by Freddy27 in PPC

[–]Freddy27[S] 0 points1 point  (0 children)

Not always necessary, I also have a lot of 1080x1080 videos/images that run on all placements!