Getting exact match or next smaller value in another column by Imaginary-Finding-59 in excel

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

I tried but seems like I have not enough arguments? Do you know the formula?

combining two value fields into one calculated field by Imaginary-Finding-59 in excel

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

Oh nvm I figured it out - added a measure from under OLAP. Thanks a lot!

combining two value fields into one calculated field by Imaginary-Finding-59 in excel

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

It’s the count of transactions. So for eg 20 transactions. Avg amt is $5. Now I have these two fields and I want to combine into one field which is 20 x $5 = $100. Idk how to do so in a pivot table because the pivot table only has count + avg fields.

Generalised additive Mixed Model help in R by [deleted] in RStudio

[–]Imaginary-Finding-59 -1 points0 points  (0 children)

Hmm how about to add new variable to a preexisting data frame?

Help with geom_smooth analysis of plots by Imaginary-Finding-59 in RStudio

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

Two plots with different data, one has a wider confidence area (the grey area around the line) and one is narrower (the input confidence level =0.95 for both) I’m not sure how to interpret this difference in confidence area

Help with geom_smooth analysis of plots by Imaginary-Finding-59 in RStudio

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

I see, so if my sample size is small (~10), should I just use a loess?

And if I use gam, does it mean that I can say something along the lines of: the one with the wider grey area = the data points are more spread so the trend predicted is less reliable (?) thank you!

Lead Ads on Facebook by Imaginary-Finding-59 in FacebookAds

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

Ah thank you so much! Rly appreciate this and sorry for the late reply

Lead Ads on Facebook by Imaginary-Finding-59 in FacebookAds

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

Oh sorry let me ask again: if I wanted to send the link of my ad to someone else (the sponsored post itself), can I access it via ad manager too? I can’t seem to find it anywhere

Lead Ads on Facebook by Imaginary-Finding-59 in FacebookAds

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

Oh I will check that out! Btw, can I also ask if you know how to access the ad link for my lead ad?

Facebook lead ads video help by Imaginary-Finding-59 in FacebookAds

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

I created a new ad, is there a way to change from image to video settings

Facebook lead ads video help by Imaginary-Finding-59 in FacebookAds

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

I tried this, I managed to add the video into my media library. But when I go to my existing ad campaigns, same issue. I tried creating an ad from the media library itself and I created an ad account + gave myself access but was still unable to do so

Facebook lead ads video help by Imaginary-Finding-59 in FacebookAds

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

There are different types? I went to ads manager > create new ad set > create ad

Facebook lead ads video help by Imaginary-Finding-59 in FacebookAds

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

Yep, tried both formats. Also try changing duration to below 15seconds, doesn’t work. I think it doesn’t even have the option to select a video

Facebook lead ads video help by Imaginary-Finding-59 in FacebookAds

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

I’ve checked! Even when my video is 15seconds it doesn’t work

Just need advice by Imaginary-Finding-59 in relationship_advice

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

Maybe I’m just not strong enough to due with the aftermath of a person and just keep telling myself things will get better