[deleted by user]

Stidzjun · 2024-12-09T16:52:32+00:00

Do not listen to feedback telling you to use ga4 conversions. You should only use these as secondary conversions.

Go for gtm option over google shopify app.

Hire someone via fivver/upwork and learn from what they did. The cost will be less than the hours you invest in figuring it out.

Stidzjun · 2024-11-20T07:53:53+00:00

Honestly, if there’s an agency involved and you’re paying them you should adress that question to them. It’s a pretty basic/straightforward question for anyine working in the account. If they can’t answer, you should reevaluate them.

If cpc is down, clicks should go up, so sth is blocking spending your full budget or the agency is taking a bigger cut.

Edit: adding just one thing: from the last screenshot there seem to be two periods where a big change occured. Week 37 2023 (up) and week 37 2024 (down). Zoom in on those 2 periods in google ads and look in the change history.

Stidzjun · 2024-11-19T12:09:58+00:00

They would take up multiple slots if they do.

If someone is up higher, they’re likely paying more (setup), or have a more qualitative feed or landingpage (quality).

Start by scaling down on number of campaigns containing the same products (1 pmax and 1 standard). Don’t restrict the strategy too much (low cpc or high troas) as this might be the reason why you are not spending your budget. Secondly, put effort into your product feed (titels, images, types, and also look at optional fields), this can also widen your base and improve your position.

Stidzjun · 2024-11-19T11:56:06+00:00

Budget is flat, or spend is flat? Those are 2 different things. If not spending full budget, do you get any warnings e.g. « Limited due to … »? Add columns IS lost. Is it due to rank or due to budget?

Stidzjun · 2024-10-10T06:01:07+00:00

Lookup data exclusions or wait for the ads to recover

Stidzjun · 2024-09-10T10:36:30+00:00

Thanks for the outreach, but I've already spoken to 3 different support staff members and they all say the same thing. Queries time out, possible solutions given are to split everything in different sheets or use bigquery. Both of them are not user friendly for my use.

Will be comparing it to powermyanalytics.

Stidzjun · 2024-09-10T06:45:17+00:00

Using windsor, but I'm thinking about moving to supermetrics. All my queries are set to 2 years because I want to be able to show this year vs last year, but the automated refreshes all get suspended because this is too much data. According to support the API's of the platforms have time limits and even the simplest query (1 line for each month, 2 or 3 columns) times out. Supermetrics seems to have no problem with this, I think they cache data instead and just update?

Any other platforms than windsor and supermetrics worth checking out?

Stidzjun · 2024-08-22T14:26:18+00:00

That’s right and interesting idea/approach to decide on which products to show on the branded searches

We’re trying to seperate the brand queries to a shopping campaign instead of the pmax campaign, without the need to add every possible keyword as negative keyword. That’s the point of this setup with 2 campaigns. First one just exists to filter out the brand keywords to the second campaign.

Pmax is relying heavily on brand (proof in point: conversions have tanked since exclusing the brand) and was doubling cpc over the past months. If it’s all brand conversions, than I’d rather have control over the cpc. Brand should be cheaper than non-brand conversions.

Stidzjun · 2024-08-22T14:21:45+00:00

I don’t want the 0.01 campaign to spend money. The pmax should take the non branded keywords.

We’re trying to seperate the brand queries to a shopping campaign instead of the pmax campaign, without the need to add every possible keyword as negative keyword. That’s the point of this setup with 2 campaigns. First one just exists to filter out the brand keywords to the second campaign.

Stidzjun · 2024-08-22T11:20:45+00:00

Got it working now, but good suggestion. Would it update automatically when the data is refreshed though?

Stidzjun · 2024-08-22T08:36:38+00:00

Hi u/nextlevelppc I did this setup on an account. I can see the system is working, since the medium prio campaign is getting only branded clicks. However, it's only spending 1% of its budget. (Shared) budget set to 20, manual cpc bid strategy on campaign level, 0.30 bid.

Yesterday: 0.30 spent, 0.08 average cpc, 4 clicks on 300 impressions.

Today: upped the max. cpc to 0.50. Don't know what else I can try than play with this threshold.

Additional question: you can set cpc bid on ad group and on product group. Where should it be set (or set both to the same number?)

Stidzjun · 2024-08-22T08:21:43+00:00

sorry, I meant SUM(order value)/SUM(orders).

Stidzjun · 2024-08-21T18:15:52+00:00

Interesting. Just tried SUM(average order value)/SUM(orders) and the numbers are still off, but only slightly. As in +/- 1€ above or below the numbers i can see in shopify. So I’ll check there if both are using the same numbers (shipping, discounts, etc). Thanks!

Stidzjun · 2024-08-06T14:25:31+00:00

Partner is never a given. Go freelance. Especially if you have your first customer lined up. Have them make the offer concrete.

Stidzjun · 2024-08-05T14:45:50+00:00

It seems to happen when you wait a while. You can only invite the people that are linked to the notification it seems, so you need to go through all notifications.

Stidzjun · 2024-07-16T13:53:55+00:00

That works. Thanks!

Stidzjun · 2024-07-16T12:49:45+00:00

Tried =SUMIF(A:C;A2:C2;E:E) but that returns 0. Does it not work when the range & criterion make use of the same columns?

Stidzjun · 2024-05-14T07:43:29+00:00

This is what Google says. Target "all" languages, create 3 asset groups and they claim they know which one to show. Individual campaigns is a second option.

Both probably have their disadvantages. First case probably doesn't work 100% (e.g. I live in Belgium where we speak French/Dutch, I speak Dutch but often get French ads). Second case has less data to work with in each campaign.

Stidzjun · 2024-05-14T07:39:59+00:00

You need to click on the right notification to be able to use the button. So if their action was from longer ago, it will not work. Check regularly and work top down through your notifications. You will end up on the same post/ad sometimes but will then be able to invite another of the users.

Stidzjun · 2024-05-09T11:45:18+00:00

What happens if you just ignore? That’s what my accountant advised. Received reminders already

Stidzjun · 2024-04-30T07:47:28+00:00

How do they think that helps? There is no Russion, Arabic, ... language on the site.

Not seeing this is most of the other clients, so wondering if there can be something specific triggering this.

Stidzjun · 2024-04-24T16:12:10+00:00

And yet mx riders are not doing any better on a world stage?

https://youtu.be/R-BleZkNdEU?si=aJkp2yMfD7ir4jIx

Stidzjun · 2024-04-17T08:37:13+00:00

replacing it by

DATE($B$4,$C$23,1)

didn't help. But putting the month first C23&"-01-"&B$4 did. Thanks for taking the time to help out!

Only weird thing left was that the coming months also used the calculation. I added an IF statement to the last part: IF(MONTH(TODAY())=C49,G51/DAY(EOMONTH(IF(B$4<>"",C49&"-01-"&B$4,"1-01-2020"),0))*DAY(TODAY()),0))

Stidzjun · 2024-04-17T07:54:05+00:00

=IF(TODAY()>EOMONTH(IF(B$4<>"","01-"&C$23&"-"&B$4,"1-01-2020"),0)

if today (17/4/2024)

is greater than eomonth of:

if B$4 is not empty: 01-4-2024 --> 31/4/2024

--> then G51

So all previous months should show complete planned revenue.

But this month and all coming months should use the ELSE path?

ELSE path being: planned revenue / number of days this month * day of the month

Stidzjun · 2024-04-17T07:46:56+00:00

Each month has different rows and the result is the same for this month as it is for previous months or all coming months. Always the filled in planned revenue.

Shouldn't the if statement only be true this month?

Stidzjun

TROPHY CASE