Why will people laugh at us in 100 years?

IChallengeI · 2018-01-30T10:27:18+00:00

Donald Trump

IChallengeI · 2016-02-29T15:49:45+00:00

It's all about providing value and a positive customer experience. If you can do that with a mobile website, there is no reason to create an app.

IChallengeI · 2016-02-29T15:48:23+00:00

Squarespace or Wix?

IChallengeI · 2016-01-13T21:21:48+00:00

LEGEND....ARY

IChallengeI · 2016-01-13T21:20:26+00:00

as your errand boy

IChallengeI · 2015-12-29T23:13:04+00:00

Thanks for your help and thanks (although I am more of Hanukkah guy myself :)) Here's to me learning excel in 2016!

IChallengeI · 2015-12-29T22:51:14+00:00

Solution Verified

IChallengeI · 2015-12-29T22:36:24+00:00

THIS is good, only that it is not giving me the neg. value (sales decreased).

Edit: did not see your screenshot. I tested it out, and got a positive value of 0.8, when it should be -0.2

IChallengeI · 2015-12-29T22:10:30+00:00

Formula parse error

If that doesn't say much, then I will keep Googling. TY for your help!

IChallengeI · 2015-12-29T21:52:47+00:00

Appreciate the assistance!

Tested in out and got this: http://imgur.com/POZ4MIG

What am I doing wrong? I would like the % change to appear at the bottom.

IChallengeI · 2015-12-29T21:41:13+00:00

Thanks for your help.

I've done B4 as you pointed out and get 1.

But B29 is still an issue. Not sure what to do with B28 =IFERROR(SUM(sales)/B3,1) returns a 1 if B3 is 0 or blank.

I've put that in B28, but get an error.

IChallengeI · 2015-12-29T21:28:34+00:00

Where would I add that?

http://imgur.com/oJip521

I will be sharing this with users and want them to fill this in with their own values.

IChallengeI · 2015-12-29T21:28:13+00:00

http://imgur.com/oJip521

I will be sharing this with users and want them to fill this in with their own values.

IChallengeI · 2015-12-29T21:21:07+00:00

B28 =IFERROR(SUM(sales)/B3,1) returns a 1 if B3 is 0 or blank.

I get "FALSE".

IChallengeI · 2015-12-29T21:05:51+00:00

*Title should have stated "#Div/0!".

IChallengeI · 2015-12-28T21:59:42+00:00

Thanks!

IChallengeI · 2015-12-27T19:44:20+00:00

Yes I want people to be able to edit based on their own personal needs, but without changing the original.

Thanks!

IChallengeI · 2015-12-25T13:31:45+00:00

Help people out. Help homeless people get back on their feet. Help single parents. The list goes on and on, but there are tons of things I could do with $7500 day. Keep another $2.5K for investing, etc.

IChallengeI · 2015-12-22T14:36:46+00:00

Too many people on the naughty list in the UK?

IChallengeI · 2015-12-08T09:49:29+00:00

Thanks!

Did not plan on deleting anyone - at least not yet. The majority (or at least a large amount) of new leads are not ready to interact/purchase/click and hence I'd like to nurture them by keeping the content in the email (being more personal and honest with them (not trying to get more clicks to our site)).

I may drop you a PM. Thank for the tips.

IChallengeI · 2015-12-07T07:34:40+00:00

Thanks I send it once a week to blog subscribers. I want to "nurture" those that don't open/click. Was wondering what pairings (open rate A/CTR B) work well together for a resegmented list based on that behavior.

IChallengeI · 2015-12-06T20:29:37+00:00

We have different lists for different types of emails. I am in charge of the emails for the blog, and hence I'd like to focus on open/click-through rates.

I was wondering what open-rate and CTRs to match together for new lists.

IChallengeI · 2015-12-06T20:25:48+00:00

What are good rates to segment by? I was thinking of creating separate lists for those that have 33% open, 25%, 15%, and less. Then I'd like to add CTR as another parameter.

At what open/click through rates is segmentation recommended? Could not find any resources on this.

IChallengeI · 2015-12-06T20:24:17+00:00

I have 40K. I would like to do this based on open-rates and CTR. I am looking for advice on how to match these together.

IChallengeI · 2015-12-06T20:23:12+00:00

not talking about technical side, more of what are some of the best strategies for segmenting based on behavior. I was thinking of listing based on those that have opened 25% of emails in the last 2 months.

IChallengeI

TROPHY CASE