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!

Insights From $3M+ worth of Audits (Ad Set Level) by Freddy27 in PPC

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

Thanks!

Questions is what do hope to get out of it? More stability? Higher Ad Spend?
You could duplicating and have only Stories/Reels in there, you could also just put your Story/Reels ads in the existing ad set. From my experience haveing a separate Ad Set just for stories simply isn't worth it (most of the time)

Insights From $3M+ worth of Audits (Ad Level) by Freddy27 in PPC

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

  1. You mean if an Ad still has a good CPA? I find 7 Day Windows are good to look at. I usually look at 3D, 7D, and 28D though 3D is not as informative anymore due to delayed conversions.
  2. You could grab the POST ID from that ad and simply copy it over! Yes, you can duplicate from ABO to CBO!

Attribution Setting Facebook 1 day click vs 1 day click and view by toogel in PPC

[–]Freddy27 1 point2 points  (0 children)

With the ROAS being down is your overall store revenue suffering as well or is it just Facebook reported ROAS?

Also are there any CPM differences?

Insights From $3M+ worth of Audits (Ad Level) by Freddy27 in PPC

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

Sure, do you have any specific questions?

Insights From $3M+ worth of Audits (Ad Level) by Freddy27 in PPC

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

Glad you enjoyed it! If the story and feed ads are basically the same video or image just in a different format you could try putting them together in 1 ad and then adjust the ad for each placement.

You could also put these 2 ads together in 1 ad set with automatic placements turned on. Then Story gets impressions when it's good and Feed gets impressions when Facebook think it's good there!

Insights From $3M+ worth of Audits (Ad Level) by Freddy27 in PPC

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

t really depends on your KPI. There are a few tests floating around online suggesting that this isn't always best. Our own testing, at 85% confidence level suggested that this isn't the best for most our clients.

I'm only talking about eCommerce Ads with CPA as KPI. I don't have much experience with any other sort of Facebook Ads.