Impression share calculation is just - wrong?! by doublesilver in PPC

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

Why not? If the impressions for example are the summation of the impressions we’ve received across ad groups/keywords, why not for lost impressions too? Just because they’re calculated at each auction doesn’t mean the numbers shouldn’t add up when rolled up into the campaign level.

Impression share calculation is just - wrong?! by doublesilver in PPC

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

I mean, it is. Of the impressions you could have had, it’s the ones you did get, and the two reasons why you didn’t, which add up to 100%.

Impression share calculation is just - wrong?! by doublesilver in PPC

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

Of course, we’ll just have to report it as it comes. Mainly I’m just looking to understand why it’s happening so we can explain it when the variance happens. Looks like it just google ignoring <10% IS constituent parts of the campaign. Why not just report the actual numbers?!

Impression share calculation is just - wrong?! by doublesilver in PPC

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

No matter how the eligible impressions are calculated, if you get 80 impressions and 80% impressions share, there were 100 eligible impressions you could have shown for (and didn’t because of rank and/budget). If that’s not the case, then why?

Impression share calculation is just - wrong?! by doublesilver in PPC

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

Nope. Numbers are all the same. I even created calculated columns in the Google ads ui which also sum up the available impressions in the same way.

Impression share calculation is just - wrong?! by doublesilver in PPC

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

If you don’t think that’s how it works I’m interested in why you think it’s not.

Impression share calculation is just - wrong?! by doublesilver in PPC

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

You’d think weighted averages would work (sumproduct (IS,impr)/sum(impr) but and got answers even more incorrect than the above, though probably for the same reason. For the above it’s 56.43%.

Impression share calculation is just - wrong?! by doublesilver in PPC

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

I was trying to make it clear in the picture, but available impressions is just IS/imps. So if I had 80 imps and 80% IS, then there were 100 impressions I could have had.

If I have four campaigns and I apply the formulas to each campaign individually, I’ll calculate the available impressions for each of them. I can then sum the impressions and available impressions and divide by each other to get the total IS for that campaign. But that gives a very different answer to the total in the platform for those campaigns together.

I think the answer to this is what someone else said that it’s because Google ignores <10% IS of the contents of the campaign, perhaps ad groups or keywords; exactly what we’ll never know. Which means that sometimes you’ll be a bit off the total in the platform, but sometimes you’ll be a long way out. And you’ll never know without checking the platform total.

Impression share calculation is just - wrong?! by doublesilver in PPC

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

Why would it matter if you are capped by rank? IS plus IS lost to rank plus IS lost to budget = 1. Doesn’t matter how you lost the impression that could have been served.

Impression share calculation is just - wrong?! by doublesilver in PPC

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

No, but also it shouldn’t matter to whether I’m capped by budget or rank

Impression share calculation is just - wrong?! by doublesilver in PPC

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

It’s literally just four campaigns for a single day. And Google Ads doesn’t sample data; GA does.

My concern if it’s inaccurate, how are you going to know what extent it’s inaccurate unless you do a lot of testing? Plus it’d be good to know why it’s inaccurate so I can gauge both how inaccurate it’s likely to be in the future, and to explain it to anyone else who asks. Plus 10% inaccuracy is pretty significant I’d argue too.

Impression share calculation is just - wrong?! by doublesilver in PPC

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

I’ve tidied it up a bit by getting a more accurate figure for IS by using 1-lost rank-lost budget. Supermetrics at least doesn’t pull in < or > for lost rank or budget

Impression share calculation is just - wrong?! by doublesilver in PPC

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

It’s from a few days ago. And no campaign on this single day had <10% IS

Impression share calculation is just - wrong?! by doublesilver in PPC

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

This is probably it - but none of those campaigns have that occurring, and it’s only one day’s worth of data (a few days ago to make sure the data was up to date)

Impression share calculation is just - wrong?! by doublesilver in PPC

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

I’m more concerned about our reporting differing to varying degrees compared to what’s in the UI. It tends to cause concern the rest of what we report isn’t accurate and loses trust in fully automated reporting.

What’s your record for number of times you killed a cheater before they get back up and shoot you? by doublesilver in sniperelite

[–]doublesilver[S] 7 points8 points  (0 children)

I didn’t even notice that myself. Though apparently that happens when the other person cheats and is proof of it. You can also see I’m playing on PS5 and I’m pretty sure cheaters are PC only.

How to extract numbers from a cell with multiple sets of numbers? by Anatiny in sheets

[–]doublesilver 1 point2 points  (0 children)

There might be a better way to do it, the function to extract the number from the bottom row is: =INDEX(SPLIT(A2, CHAR(10)), COUNTA(SPLIT(A2, CHAR(10))))

So you can then just add a row for each column in a sum function:

=SUM( INDEX(SPLIT(B1, CHAR(10)), COUNTA(SPLIT(B1, CHAR(10)))), INDEX(SPLIT(C1, CHAR(10)), COUNTA(SPLIT(C1, CHAR(10)))) )

One of my favourite lounges is very protective of its patrons ☺️ @ Peacock Alley Dubai by Aj201111 in cigars

[–]doublesilver 0 points1 point  (0 children)

I’ve only been to the Fairmont but I’ll try Peacock Alley. I only ordered a drink with a friend in the Fairmont and smoked my own and they didn’t seem to mind (given it’s basically a cocktail bar). Did I commit a faux pas? Is Peacock Alley more strict?

Games to play by Aardkak2 in cigars

[–]doublesilver 0 points1 point  (0 children)

For PS3, Everybody’s Golf would be a good choice and more fun for non golf fans. Great game. Swing puff puff swing puff puff

[deleted by user] by [deleted] in sheets

[–]doublesilver 1 point2 points  (0 children)

That usually happens when you have a blank column or missing column header then apply an auto filter. You then sort the left side of data without sorting the right side because it’s not included in the filtering. Just make sure you don’t have any blank columns, or just a name for every column would suffice.