text:
Business Of eCommerce
eCommerce tips, tricks, strategies and tactics to help new and experienced retailers start, launch or grow their eCommerce Business
Suggest a guest
Posted on July 14, 2020 July 14, 2020 by Charles
Selling on Amazon in 2020 (E134)
Carolyn Lowe
Co-Founder of ROI Swift
Sponsored Product
Sponsored Brands
Product Display Advertising
Sponsored Brand Video
Make sure you have text over
Not as effective
Good for less than $100 AOV
$400 AOV
Retargeted on Amazon properties
69% of Amazon Searches are non-brand
70% of Amazon Users don't make it past page 1
Start with auto campaign
ASIN Product Targeting
Find all products with a higher price and lower stars
Used to have a 35k Min ad spend
Use Certified Agency Partners
Agencies have access to betas
SnapChat – Low CPC in 2020
TicTac – Testing now
Drip – Get a free demo of Drip using this coupon code!
Spark Shipping – Dropshipping Automation
Carolyn is the co-founded ROI Swift an agency that she started in 2015 which helps consumer
brands with Amazon, Paid Ads for Facebook/Instagram, and
Paid Search.
https://roiswift.com
Transcript :
Charles (00:00):
In this episode of the Business of eCommerce. I talk with Carolyn Lowe about selling on Amazon in 2020. This is a business we commerce episode one 34.
Welcome to the Business eCommerce, the show that helps eCommerce retailers start launch and grow their eCommerce business. I'm your host, Charles pesky. Now I'm going to tell you what's Carolyn Lowe. Carolyn is a cofounder of ROI Swift and agency that she sided into 2015 to help consumer brands with Amazon paid Facebook and Instagram ads and paid search as Carolina show today to talk about as a retailer, what you should know, selling an Amazon in 2020. So Hey Carolyn, how are you doing today? Great. How are you Charles? Great to have you on the show and yeah, I'm doing well. I here in the COVID world, I saw, I normally have to watch on video. I normally shave every morning and my dollar shave club razor broken half this morning. So waiting for a new one. So if you're watching on YouTube and you wondering why I have a bed, that's why, so we'll see how fast dollar shave club ships. That's all I'm doing. So how about yourself?
Carolyn (01:11):
I'm doing well. It's just hot, hot and humid in Austin, Texas. It's pretty much summer here, so I'm happy to be inside.
Nice. We're just talking like the razor because I can't run out and just buy a razor, this COVID world. We were talking before the show about Amazon and just some of the changes that have been affected recently. Shipping times, logistics I've have a few guests on and just going to talk about recently, it feels like 2012. Like the entire world is like shifted and the way I'm seeing it is this could be not a temporary thing. This could be the new norm. I think there's a lot of retailers now we work with have that. Let's talk with someone the other day and they're like, yeah, we're doing black Friday numbers. I'm like, Oh, that's great. They're like, yeah. Every day though, like every single day is like basically black Friday. And I think for certain folks, this is a new norm. And we've been talking about, you kinda mentioned Amazon has some big weaknesses that have been shown right in the past three, four months at this point. So could you kind of talk about those?
Yeah, I think there's a few things. So Amazon's competitive advantage was always that they could get it there faster and cheaper than, than retail. Right? So you would get, when I had young kids, I had a subscribe and save subscription for diapers and I wouldn't have to run out to target and go get diapers every month diapers would appear and I wouldn't have to go pack up my kid and go get them. And now, as you've seen, you know, target Walmart, they have curbside, they have online shopping, they have much faster delivery and they're finally taking advantage of their competitive advantage, which is they have all that inventory within five miles of you. So Amazon is opening a lot more fulfillment centers. They've gone to one day, one day for a bunch of customers. So if you're a seller on Amazon and you have enough inventory, you can actually, your products are one day or same day eligible.
This was of course pre COVID, obviously prioritizing certain products now, but and the other big thing is in grocery. So Amazon actually lowered fees last the last couple of years in grocery down to 8%, from 15% to try and capture more of those folks because you can't be profitable, right. Selling a jar of peanut butter online and paying 15% to Amazon plus shipping fees. So they're getting, I think much better about about trying to take what used to be their competitive advantage and find a way to win again against retail. You know, I think Charles, like, I think you've probably seen the news about Walmart and Shopify as well, right?
Yeah. It's definitely a Shopify from the big hat literally pops up every day now on the massive growth as well in this stock and just kind of how everything shifted there. Yeah.
Yes. And I would say, you know, 90% of our eCommerce clients are on Shopify. If someone comes to us on big commerce or Magento, we sort of we'll work with them, but it's definitely 10 times harder than on Shopify. So I think Walmart has gotten real smart about about what's going on and bringing those smaller retailers to Walmart that don't want to give up their sales and give up the customer to Amazon. I mean, obviously that's the downside of Amazon is Amazon owns the customer. You don't own the customer as a small brand. And so that's what, you know, Amazon is like the devil you devil you have to deal with sometimes if you're a consumer brand and you're sold in retail for these smaller emerging brands on Shopify, I think the Walmart Shopify partnership is very interesting where it gives them a platform, but they can still own the own the customer.
So actually when I talk a bit about that partnership, because I I saw briefly, but do you know the, kind of the details on how that works?
Yeah. It sort of at a high level where they're allowing Shopify folks onto their Walmart platform. So Walmart and target, you know, it's always been interesting to me that they allow that they've started to allow third party sellers. So target allows advertising. So you can run advertising on target and not be sold in target. So I always thought that was strange that you're on target and they would let somebody else advertise a competing product. But you know, when you look at the advertising market Amazon is now surpassed Microsoft Microsoft's being platform. Amazon recently did 4 billion in advertising. So that's, that's like another whole company just in Amazon advertising. And I think that the Walmart Shopify will be very similar, rare Shopify merchants can advertise on Walmart and they'll pay a referral fee.
Gotcha. Yeah. And the benefit of you're doing that, you're growing your brand because so right now people don't know each other with Amazon and not everyone kind of does this little sneaky thing on here. Like put something in the box of like, Hey, this is actually like XYZ seller, not supposed to do that. You could probably get blacklisted for that. But also the email address you don't capture like, like everything is kind of Amazon's property and you're just, you're really there as a retailer to fulfill the order. But with Walmart, they're giving, they're giving you the full customer details and then you can market to our customer again, upsell later on like a post purchase sort of thing. So you have access to all of that now.
Exactly. And I think it's a great market for them because you know, this as a software guru is that once you just took that up, I mean, in my Dell days, I had to deal with retail link with, with Sam's club. And that was like a complete and total nightmare. But I mean, you know, they've picked, they've picked a winning eCommerce platform. And so, you know, basically any Shopify person and, and making it simple for those Shopify businesses to get out there on Walmart and Walmart's were realizing, Hey, you know, we don't want to take all this inventory and we don't want to hold all this inventory sort of like Amazon think about like the Costco model too, right? I've worked with Costco from my Dell days and, you know, they make all their money on membership fees. So I think Walmart will be the same. Hey, we don't have to carry all this inventory. We don't have to hold it. We can just make referral fees for people to list on our platform. And I think, I think it's a smart move on, on Walmart's part
Today's episode is sponsored by drip, drip. It's a world's first e-commerce CRM and a tool that I personally use for email marketing and automation. Now, if you're running an eCommerce store, you need to have drip to try. And here's why drip offers one click integrations for both Shopify and Magento. There's robust segmentation, personalization, and revenue dashboards. To give you an overview of how your automation emails are performing. One of my favorite features of drip is the visual workflow builder. It gives you a super easy way to build out your automation world visually and see the entire process. It lets you get started quickly, but also build very complex automation rules. It's powerful, but also easy to learn. Unlike a lot of email tools and offer the same type of automation to get a demo of drip today, you can go head over to drip.com/boe. That's drip.com/b O E.
Now onto the show. Yeah, we'll choose your type business model. Right? Cause now right now Walmart has to directly negotiate with custom buyers, get the cheap product cheapest they can, and it's on them, right? To always be pushing, pushing, pushing back. Now they don't really cause they kind of saw what Amazon did. They don't have to, the retailers will basically compete against one another. And Amazon and Walmart gets to just list it. They get their cut. So even if you're a retailer and you're selling at a loss, they still do well. So it kind of gives you that, but if they're giving you the customer at checkout, that allows you either, if you're selling very, very small margins, you could still have that customer and look at their total, like lifespan of them sell them a product, you know, next month remarket to them, that sort of thing. So you have access to all that now. So you can actually, as a retailer, it's still make money even with those tight margins, which is pretty neat.
Yes, exactly. And you don't have to go spend on paid search and paid social, although that's our business. You don't have to go spend on paid search and paid social to go get those folks to come to your site. They're already on Walmart. So you can, again, Amazon has 3 million shoppers you know, Walmart, I don't know the exact number of their.com shoppers, but it's a lot bigger than, you know, your own Shopify site.
Yeah. Well, that's always the benefit, right? If you're selling your own little.com, your Shopify big commerce, and you're trying to just get, you know, attract people, you can go to someone and get ads, but it's just, it's an uphill battle, right? And at first, if you don't have any sort of big ad budget, you're just cluttering for each customer. Verse, you go on Amazon, Walmart, you just list a product. If you're a competitive price wise and you have, okay, write-ins, you're going to get sales just like automatic you'll stack, moving product. And the neat part about that is it allows you to, well first just move some product through. But the benefit of doing that is you can then go back to your suppliers and say, Hey, we're actually, you know, buying X amount per month from you. And then next month it's double batch.
You could start moving some numbers and then you have some negotiating power because at first, when you're selling, you know, your handful of orders, you really can't go to suppliers and push back. But the nice part of the marketplace is, is it's not just, Hey, you get this tiny little margin, but it makes you actually a lot more profitable on your main channel, which I've always found that trick kinda once people realize Ash like, okay, you can sell, raise it, the margins over there, but it makes you more profitable all around, which is pretty useful.
Yeah, absolutely. So I think that that's also a really smart and it's also less risk for, for brands because it's really only you're paying when you make a sale, right? So you're paying that commission on sales. You're not paying it on advertising or because I've done that with some of our brands we've worked with in the past. So target uses Critio. They were using Credio for third party advertising. And so you could sign up with Critio and basically run ads to show up higher on target. And we tested it and spent a bunch of money and it wasn't, it wasn't that great. So I don't love third-party advertising. That's just her impressions that isn't per sale. I don't love, you know, I don't love the platforms for certain of these that don't do as good of a job on you know, cost per impressions. And that's why on Amazon, we really prefer the sponsored products where you're paying cost per click versus some of other advertising on Amazon, which is on Amazon and off Amazon, which is much more traditional display. And doesn't perform as well as the cost per click on Amazon advertise.
So it's only the, on Amazon, it's only sponsored products at a CPC
Sponsored products, sponsored brands. So that, that one that you see at the top, that's got three normally it's like three products at the top sponsored brands, or you'll see that at the bottom as well. So those and product display ads. So if you go to a product page for, you know that great tee shirt you're wearing and you see an ad for somebody else's red, t-shirt that's product display advertising. So those three are all costs per cost per click. And then some of the ones that are like Amazon retargeting, where Amazon does retargeting off of Amazon for you across the web. Some of those are, you know, they get less and less effective once you leave the platform. So the most we've seen the most effective ROI is all those sponsored products, sponsored brands and product display ads even sponsored brand video is doing really well for a lot of our clients where you're going through the search results. And there's a video ad rather than just a static product ad. Those are doing really well for, for our clients. And then off Amazon, we see that the return on ad spend goes down significantly once it's, you know, even retargeting doesn't do as well off Amazon.
Really. So the retail I'm always surprised. I'm surprised to hear you say that because you always have retargeting is like, just do it. It's always, always profitable, just do retargeting, but you haven't found that with Amazon retargeting,
You haven't found it to be as effective. The interesting thing is that it really depends on the price point. We see this on Shopify sites too, on, on our paid search and paid social products with less than a hundred dollars AOV have obviously a much quicker time to purchase. So like one of our clients has a $40 AOV and 85% of their people purchase within 24 hours or not at all. So that's where, you know, we'll have a retargeting strategy where we'll only retarget for a day or two, right? Someone that we worked with that has a $400 AOV, we'll follow them around for 30 days because you don't tend to drop $400 on a pair of boots, you know, that day. So you want to think about it. You want to look, looks more. The interesting thing about Amazon is 69% of the searches on Amazon are non-brand.
So they're not looking for, you know, Brooks running shoes, you know, most of the time maybe they are looking for you know, I just bought a ring light on Amazon because of all these working from home and my light is lousy at home. And so I was searching for ring light and I wasn't searching for a brand name. So I think that that's really interesting that, you know, you can capture a lot of that, but we've seen, yeah, retargeting works on Amazon, but it doesn't work as well as say, if you're on your Shopify site and you do retargeting on like Facebook or Instagram that tend to have a better return on ad spend than Amazon retargeting.
Is it, is it just the way Amazon's actually running the retargeting? Like how, like where, what channels they actually retargeting on when they run Amazon retargeting? Like, what is it, what does it get displayed?
So that's a great question. It gets displayed. It depends on the type of one you're doing, but it, you can, you can get retargeted on Amazon properties. So Amazon prime video, Amazon Kindles, Amazon fires, all of those. You can also get retargeted on Google. So you're paying a bit of a, excuse me, bit of a markup.
Okay. I see. So they're so they're marketing. So they just basically buying ad words at that point and retargeting you there and charging you a little bit extra and you probably lose a little control. I'm guessing when you do it that way
You do, and you don't have a lot of insights. So do do yourself a favor, go look at something on Amazon, don't buy it and then go to a bunch of websites. And you'll see Amazon ads that have you know, the product, the number of the stars and the and the price.
Okay. So I've seen actually Amazon also run their own retargeting. So you go, and this morning I bought my son a pencil sharpener. And then, you know, if I hadn't purchased this, those pencil sharpener ads for different pencils, sharp, ms. Will be following me around for the next month basically. And I've seen, I've seen them do both right where the ad for the one you were looking at follows you around, but then also just a generic pencil, Shatner ad follows you around. And I think that one Amazon is running to try to just pull you back in or the brand can run that direct one to write to you, right?
Yes. And occasionally they'll also do email retargeting. So, you know, the item you looked at, plus five similar items.
Yep. Okay. Interesting. So you're saying sponsored products, Boston brand. So basically at that point, your Amazon is very intent based, right? Like you're going on? I was literally sitting with my son. He was trying to write a picture on his same dad that is, you know, for, and he said, dad, the pencil, the pencil is at work it's to Dell. Some say, Oh, let's just buy a pencil Shatner. And within like a minute basis per state, it was a very, very small transaction. Right. Like under $10. So you're using those because it sounds like those are the most like intent-based right. So when you go and type in pencil Shatner, you basically just pulling up, right. The very top of that. And you want to be that first link to someone clicks on under 10 bucks, check out. Yeah, sure. Four-Star at four and a half stars. Great. Let's go. Is that kind of the model?
Yes. So sponsored products, like I said, 69% of those are non branded search. The other stat that Amazon has shared with me with our folks in Seattle. So have some account managers in Seattle because of the size of some of our clients is that 70% of people don't make it past page one. So it's this vicious cycle of you need to be on page one to be seen seven, you know, or else you're only going to be seen a third of the time or 30% of the time, but to be on page one, you need to have good velocity and you need to be relevant to that search term. So you never want to buy a pencil sharpener if you're a pencil case because you know, they're not going to buy that. So Amazon's algorithm for who shows up on the page is largely dependent on the relevancy of the search that, you know, and then your conversion rate really matters, right?
Because Amazon doesn't want to show products of conversion rates of 10%. Right? So we, our benchmark is usually like, if your conversion rates below 20%, we'll go figure out why is it your product listing? Is it your advertising? Like you're sending bad traffic to your listing page and that's why they're not converting. And, and so really if you want to show up on page one and you're relatively new, you need to do a lot on the organic side, but there's only so far organic can take you. So for the most part, you do have to pay to play, to get on page one for Amazon, until you build up enough velocity that you start ranking organically.
Okay. What I've kind of found at smaller brands, curious, any thoughts on this? And you see this all the time, they'll start off. They want to advertise on Amazon. They have a small budget, small ad budget kind of going in. They want to try something. A lot of folks want to see something work, right. And they say, Hey, if it works, I'll double down, triple down, that sort of thing. But they kind of start by going first, a small budget and kind of wide. And it never really gets like the, the engine never really starts pumping. Right. It kind of just like Peters a little bit. And then they say, Hey, I got a couple of clicks. Like never really going to have data. And they just kind of say scrap it let's just go back to organic or whatever they were doing before. I've seen a few successful retailers where they kind of start off and just go straight in and say, Hey, we're going, we sell pencil sharpener. We're just focusing all our dollars on that one keyword term, or just going like a, like a lightning bolt, right. To that. And just focusing on that is that like the strategy you seen work or what you usually see when people are starting off, what do you recommend? They focus or try different things. So what do you kind of say to that?
Yeah. So I think like dos, those terms are hard to rank for, you know, because they're, they're big search volume terms. So we use a couple of tools where we'll look at the search volumes and we'll also try and find some longer tail keywords that they could rank for more easily. So we'll put those words and phrases in the description. So, you know, the title is important, the bullets are important. And then all the backend information and search terms, search terms are important there as well as the images are critical and other things, but those are the, you know, the things that will get you ranked are your title, your description, your bullets, and, you know, that's how you'll get ranked. And then of course your conversion rates. So in terms of advertising, a lot of times, one of the other things we'll do is we'll set up a couple of things.
We'll do like a little auto campaign, which is sort of like Amazon goes and finds which, which products based on all that stuff in your listing would make sense. So search terms you hadn't thought of before, and then you can do manual campaigns where you say, I only want to show up on these search terms. But then the other one that we love is a product display campaign. So you can go out and find all the pencil sharpeners that are below four stars that are more expensive than you and show up on their pages. So say you're on a page of a $12 pencil sharpener, that's three and a half stars. And then your ad shows up on that product detail page that says, Hey, here's one for nine 99 and it's four and a half stars. So which one are you going to buy? Right.
Okay. So I wanna make sure I'm taking notes here. So basically how do you do this? So you find out, so there's a way on Amazon to find all the products that are a higher cost than you, but were star rating and then just go after them basically.
Yep. So you can do, it's called like product targeting. It's called ASEN product targeting and it's part of this it's a product display campaign and you say, okay, I want to find everything in my category. And then you can refine it even for, even more and say, okay, I only want ones that are this stars or below, or these prices and below. So it's really like, you find that what I call the dogs in your category and we've seen conversion rate work really well on those. Right. If you're cheaper and rated higher, of course, you know, consumers would want to buy that product.
Yeah. Do they give you any insights into how many views those products are getting? So, you know, Hey, like this is a three star product and I'm half the price. And just like, this is the one and just focus on that one or you just kind of hoping they get, you know, cause like these products would also be on page 10. Right. And nobody's looking at them, they're also just dogs. So does it give you any insight into that or?
Yeah, so it, it does, like, you can see all of your impressions and clicks and everything by ASEN. So ASEN is like, you know, like Amazon's unique identifier. It's like ESPN for books and ACEs for non books. So yeah, you can go through and see, okay. I saw the ACE and for this peanut butter does way better. And so you can turn on and off a, you can bid higher on certain ones that are performing better and where you have like an average cost of sale of 20% or below, you can say, great, I want to bid up on this one. That's converting really well. And I want to turn off this one that, you know, isn't converting. So it's down to that product level.
The ACN is the Amazon standard identification number. So little fun fact, everyone says it, but I don't know how many people know that. So they go, that is a great fun fact. Look, I learned
Something today. I've been using that for five years and I never looked up what it actually States.
Yup. Amazon standard identification number. That's so such an Amazon thing to name something. I L that's a good one right there. I never heard of kind of just targeting basically you're going right after your competitors at that point. And you don't, don't go after the top and do the smart thing. Right. Don't have to go off to the competitors that are better than you find the ones that are worse. That if you're just going head to head, if you're comparing, someone's comparing apples to apples, you're just a better Apple and people are going to buy your product. And then at that point, so then you have basically right down the bottom where they say if you got the term not sponsor sponsored products, right? So you're searching down on a product page. It's like halfway down. You'll just be one of those at that point. Right.
You can be one of those, or it will actually show up on that detail page right below the buy box where it says, add to cart. There's usually one product featured.
Very cool. Any other tips like that? I like these little that's a good one. Anything else that's kind of working right now?
Yep. So we talked a little bit about sponsored video that is working great. Big tip. There is the sound is off. So make sure you have texts over. We've seen people run ads that have voiceover not text over and, you know, back in the pre coven days, if you were sitting in your cube, you're not going to have your sound on as you're shopping Amazon. So a lot of times one brand gave me a great video. It was 30 seconds. So I, I cut it down with a movie and I added text overlay and that was getting a like a 15% ACOs. So meaning you were getting close to a five X return on ad spend six X return on ad spend.
Oh yeah. I've always, I've seen the ones when they do it well, right. Video and audio the text and the audio sync up, because what ends up happening is you start usually a strong row and unless you're a complete crazy person, you have sound off when you're scrolling in basically any app that you can see scrolling, it sounds off and you start seeing the text. And if it looks at all interesting, you pause and you start reading and then if you're really interested, then you go hit that on new button and then you actually hear the audio. So you want both, I would think right where they, and they sync up. So then you're able to start with a text, jumped to the audio, and then you really, that means the person's engaged at that point.
Yeah. And a lot of brands don't have access to, to that. So what a lot of them will do, and I think is great, is just use like free audio as background music, because you don't need a professional voiceover because like you said, 90% of the people are never going to hear it. So we actually say, you know, you can shoot this in and make a video. Like you can deal with an iPhone if you need to. We've seen some amazing videos shot with iPhones and then you just pop them into iMovie. I can't even draw a stick figure, but I was able to do I movie and put text overlays and include the company logo on the first, you know, on the first frame and all of that. So,
Well, this is also very cheap. I'm trying to think of the, I'm finding the show notes, but some very cheap ways to do voiceovers now where I think I've hired a, like a voice professional. And I was like, I want a male with a cool British accent. And, you know, just to get really specific. And it comes back to like such a small cost and like the, literally you can get like 12 different people will apply and they're all just like cool British accents. And you're like, Oh, this is fantastic. I can pick her my accent.
It's cool. It's like the Upwork of,
Yeah, it's what's the, what's the one it's similar to Upwork, but it's like a dollar one of those sites and very good with voiceovers. I've done it with Upwork before and the process takes a little longer, but if you kind of do, I'll find us at it's just very easy to get a voiceover so that I think even people that, you know, cause you don't on an ad, you probably don't want my voice sort of thing. Certain people just have not the right accent. So I think people make the project to be a lot bigger than it really is. So you can get a voiceover done fast cheap. And the nice part is just try it. Right. A lot of this, I don't know if Amazon are they doing dynamic ads right now where you can kind of slot in like four or five different creatives and it flop switches them around or are they doing that as well?
Yeah, there's a bunch of different. That's more on the Amazon advertising, like the off Amazon advertising, the on Amazon is pretty standard, but off Amazon, they are doing a bunch of different testing options. What most people don't know is, you know, they used to have a $35,000 a month minimum ad spend. So a lot of smaller brands that, that wasn't a good fit for them. But as an Amazon agency partner, we're able to use some of that, what they call the DSP platform that display platform to, you know, maybe combine average different brands dollars together so that they can get onto the platform for, you know, $10,000 to do some of this off Amazon advertising.
Oh, so is that the truck? So if you're small, you can go to an agency and okay. So you can basically kind of like use the da as long as the agency is spending the 35, then you know, amongst many brands you can get in a, you know, several couple thousand a month.
Yeah. So because we're, we're one of like 200 Amazon certified agency partners in the country. We have access to some of these things and we say, okay, great. Well, you know, this brand can't afford 35. What if we get, you know, three brands in total, we spent, you know, 35. And so that's one of the advantages of going with the agency. And also just a lot of times we have access to betas. So before sponsored brands came out for everybody, we got it for our brands. So the seller central, which is the backend of Amazon for, for, you know, third party sellers who aren't selling direct to Amazon we actually were part of that usability and a lot of the new features that are coming out that came out around. So now you have access to demographics. Who's buying your product. Do you have access to not just click through, but conversion data on different searches. So you can search on pencil sharpener. You can see who's ranked number one. You can see what their click share is and their conversion share. So you can see who you could be, you know, who you should be going up against. So there's a lot of really interesting things that are coming out of seller central and we've helped them develop, Hey, this is what will be useful for brands to know.
Very cool. Yeah. Advertising is one of those things where you want to be on the betas or alphas earliest on possible, whatever exclusive invites, you know I think most folks will say you're old enough to remember when Instagram was cheap and now it's not an event. People remember when Facebook was cheap and I'm old enough to remember when ad-words was cheap. So, you know, at some point like 10 cent clicks. Yeah. Like you could just, you go on, you know, insurance agents and it was 10 cents. And like, this is great, you know, I'll make my hit this forever. And then it turns out that went to a hundred and now only stuck the like, so now everyone kind of flooded in, but if you have early access, some of these platforms and some guessing, like aren't the most useful platforms, but others do really well. And all of a sudden you have like this very short window, we can really get a lot of traffic throat and hopefully make those users your own and then capture them for long term. So that's a very cool thing having access early on. I like that.
Yeah. And you're talking about chief platforms, you know, we're seeing great, great cost per clicks and cost per thousands on Snapchat, like Facebook and Instagram, like five years ago. And the interesting thing is that the us government hasn't come down on Snapchat. So they have all the data and purchase data that Facebook used to have access to a couple of years ago. So it's, it's a very interesting platform. We've tested it, doesn't, it doesn't test as well as Facebook and Instagram, but it is definitely much cheaper. So from a, from a brand awareness and traffic standpoint, we're finding some great stuff there. And then we've we've got some friends over at the tick tock office in Austin. So they've opened a big office here in Austin and we've got to tick dock advertising a seat as well. So
Yeah, that's the one I was tech talk at zone.
We're just in the process of, you know, testing it out with a couple of brands. We don't have any statistically significant data to share yet, but I think those two brands will become interesting, you know, as you know, there's been a lot of backlash with, with Facebook and we've for the first time ever, there was a lot of [inaudible] going on out there and you know, a lot brands are like, okay, Hey, if I pull from it, Facebook and Instagram, I mean, that's 80% of where my traffic comes from. What do you guys recommend next? So we're having a lot of those conversations around, okay. I'm amping up, Google display, amping up YouTube advertising for, for brands that have video assets looking at more Snapchat and tick talk and, and other platforms as well. If, you know, when we sit around and think about like, what if you lost 50% of your business tomorrow? You know, the two things that could happen right, is Facebook somehow gets shut down or, you know, Facebook and Instagram gets shut down or or Amazon, you know, has no love lost between the president and Jeff Bezos. So I mean, if something happens there and Amazon gets shut down, what do you do? So we're always thinking about what's the next thing. And, and you know, what makes sense if these platforms get shut down?
Yeah. I like the idea of Snapchat and tech talk, right? Because like you said, it's hard to get data at the beginning. Cause sometimes they don't provide the data, even an arrow around with Amazon. They're like advertising console is very, very basic. Or like Shopify just came out with the ad platform and they give is close to no data as possible. Just like, Hey, as much as Spanish. And you're like, okay, great. That's nice. But the nice pie, the nice part about that is a lot of people, if you can do well at that, a lot of people aren't like right now, ad-words Facebook. It's so dialed in that folks know for every dollar they put in this much, they get out. Exactly. So they're willing to go some huge numbers and big brands can really invest. So you as a small brand can't, but some of these small platforms, you don't really have the data.
It's still like the wild West. So the big brands haven't come in yet. And there's still a lot of opportunity because it, so the bad side of, you know, is it so crazy, but the good side is it's so crazy and no one else is willing to really get into it. So if you're the one that can really dig into that, it's, you know, at the beginning, I think it's a great thing. So good one. Awesome. Phew. If people want to kind of find, you kind of see what you're working on, learn more about the agency. What can they do that?
Yeah, they can head on over to our website and our website where like the cobbler with no shoes, right. We spend all our time driving traffic to other people's websites. So we do have a website, but don't judge us on the website. It's a ROI swift.com. You can also head over to LinkedIn and go to the ROS with page or just connect with me. Personally, we do offer a free audit for anybody running Facebook ads or Google ads or doing like, you know, 20,000 a month or more on Amazon. And we'll audit and tell you if you're doing as good as you can or if you could be doing better. So it's one of the things that we like to pride ourselves on is, is honesty and will tell you if we can help you. And we never want to take money from somebody that we can't help. So yeah, you can head on over to our website and check it out. Awesome. I really appreciate you coming on today. It was great chatting. Thanks for having me, Charles.
http://media.blubrry.com/businessofecommerce/p/38fc6bf9a1a571844f04-42df652f238e2c46797e248de393d69b.r75.cf2.rackcdn.com/BOE_134.mp3
TagsAmazon Seller Central, Carolyn Lowe, CPC Ads, Retargeting, ROI Swift
Previous PostPrevious Sourcing Products from China (E133)
Next PostNext Using Data Science to Profitably Scale Cross Channel Marketing Campaigns (E135)
How to Get Started Outsourcing Customer Support (E155)
How Independent eCommerce retailers can Compete Against the Giants (E154)
Business of eCommerce – 2020 Year In Review – E153
7 Strategies to Grow Your eCommerce Business
The Journey from $0 to $200k per Year Selling on Amazon (E151)
Amazon Private Label
Andrew Henderson
Chase Dimond
CPC Ads
CROSSNET
Dylan Kelley
Easy China Warehouse
ecommerce sourcing
Greg Meade
Importing Products From China
make on demand
Nathan Resnick
Nomad Capitalist
print of demand
Retail Arbitrage
Sourcify
Sourcing Products
Wavebreak
Zero Taxes
Sticher


I definitely wanted to make a note in order to thank you for those awesome recommendations you are showing at this site. My particularly long internet investigation has at the end been compensated with useful facts and strategies to talk about with my family and friends. I would assert that most of us website visitors actually are quite fortunate to be in a fine network with many brilliant professionals with valuable tips and hints. I feel pretty fortunate to have used the website page and look forward to some more enjoyable times reading here. Thank you once again for all the details.
I as well as my pals ended up examining the best guidelines found on your website and immediately came up with an awful suspicion I never thanked the web blog owner for those techniques. Those women had been absolutely warmed to see them and already have really been taking pleasure in them. I appreciate you for being so thoughtful and also for obtaining this kind of awesome areas most people are really wanting to know about. My very own honest apologies for not expressing gratitude to earlier.
I simply needed to thank you so much all over again. I'm not certain the things I could possibly have implemented without the entire concepts contributed by you regarding that field. It has been an absolute troublesome case for me personally, but taking note of a new well-written mode you dealt with the issue made me to jump for fulfillment. Extremely happy for your support and as well , expect you realize what a powerful job that you are undertaking training many people by way of your web site. Most probably you've never got to know any of us.


The devil's in the little things. This truth can be revealed by the example of an image in which only one ring or hat can destroy your efforts in ashes and dust. Today we will talk about these little things – accessories – that we can't think of without. We present you 8 rules, which will tell you how to wear and combine the accessories correctly.
We're wearing massive bracelets right! Complementing your image with a selection of impressive jewelry, remember the quantity – no more than 3-4 pieces. The complete set is not overloaded: we carry bracelets only on one hand. They will be successfully echoed with the same massive earrings or necklaces.
We choose one color dominant in the image – or bright accessories, including shoes and bags, or throwing clothes. In this case the image will turn out harmonious and pleasant for eyes. Here we will allow ourselves to mention the golden rule of "3 key colors" in the image: such a set will create a correct and without excess palette of the set.
It is not necessary to "pack" all the details of the jewelry set in one image. In most cases it looks ridiculous and too luxurious. Sets of 3-4 jewelry are created to give free rein to the imagination and in every way combine them: earrings + necklaces, earrings + bracelet, earrings + ring, and more. Two products will be quite enough.
Miniature girls can afford to experiment with the size of jewelry. But ladies with magnificent shapes should give up thin rings, chains and bracelets in favor of more dimensional products. Otherwise, the jewelry is lost and will not perform its direct function. This rule also applies to hats, belts and bags.
The fashion world has long since abandoned the prejudices about the color pair – a bag and shoes. The rule is to be, but no longer must have. Feel free to experiment with color, print, texture, shoes and bags. This is much easier, and the result will be much more interesting.
Breaking another stereotype – a tasteless combination of gold and silver in the image. Not today! Such a game of shine of precious metals looks very spectacular and very stylish. Moreover, top jewelry houses have been combining all known precious metals in one piece of jewelry for many years.
If the image requires pantyhose and a pair of shoes, the latter must be closed toe. An open heel, deep side cutouts, but no open nose are allowed. High and extravagant fashion removes the ban on this rule. But if you do not differ in disgusting taste and style, it is better to follow these instructions.
Another golden rule – the image is not overloaded and allow no more than 3 accents per person. It can be a hat, handkerchief, massive necklace or earrings, brooches, sunglasses, contrasting details of clothes and even lipstick.
Hope you like these how to wear accessories. Please keep visiting K4 Fashion for trending outfits and more!


text:
Rolex Cosmograph Daytona 6263 Big-Eye
For those uninitiated, sit comfortably and pour yourself a cup of coffee (or scotch, timezone dependent). The 6263 Big-Eye is one of my all time favorite references and here, over my morning coffee, I'll explain why. I have been accused of being too partial to the great coronet, but there is a reason that 'Rolex' and 'The King' are nearly interchangeable. Because I am such a childish fan of the Rolex Daytona Big-Eye, I'll dive a little deeper than usual in this feature—out of sheer appreciation. If you just want to see the piece, you can find it here from RPM for some ungodly figure that is irrelevant. It will continue appreciating to double that in a decade. An now, the history.
You know the Daytona beach Road Course, I am sure. The Circuit de la Sarthe of the United States. How did a Swiss manufacturer pick up an American name? Well, it all begins in 1955 where they had just introduced the 6234 pictured below (credit Roy from VRF). This was a post-war Rolex that somehow defeated all odds to build a beast of an instrument off of an overhauled Valjoux movement. The antimagnetic chronograph featured deadly accuracy and tachy/tele rings on the outer dial. The evolution to what we now think of as the classic Daytona really begins here.
Following was an intermediary step, the 6238, where the 6234 acquired more clearly legible hands and markers, a more legible tach scale, and kept the iconic Valjoux 72. For those of you who are partial these days to in-house movements (I have mixed emotions at best), here's some evidence that collectibility is not necessarily correlated. For most collectors, historical significance and scarcity are enough. Now we arrive to the final step. Rolex added the tachymeter to the steel bezel, created contrast dials, and voilá. We have something known as the 6239.
That 6239 released in 1963 without 'Daytona' emblazoned above the sub hours. However, in the interval between 1963 and 1965, Rolex was the official timekeepers of the Daytona Road Racing course. The degree to which this was corporate elbowing or Rolex instruments simply being favored by the timekeepers of the course as superior to alternatives is disputed. In either case, by 1965 the 6239 had become such a staple of road racing that Rolex decided to flaunt what it had and finally printed the famous DAYTONA, giving birth to an icon (credit also RPM below).
What followed was an evolution on success. For all this time, the case remained 37mm (some of us wish it might return there as well, I count myself among that group). With the next reference, the 6240, came screw-down pushers and the equally famous oyster line under Rolex. The latter 6262 & 6264 housed a newly reworked cal 727 Valjoux but did away with the screw-down pushers in a separate model line.
Halfway through the two-year relatively unsuccessful lifespan of these two non-oysters, the screw-downs were reintroduced on the 6263 & 6265 (plastic vs metal bezel references). These two references have gone on to be produced with a wide variation in dials, hands, and materials. Variability can make collecting these quite a minefield, but an enthralling one to be sure. The Daytona was also adopted here by one Paul Newman. The two have been inextricably linked since until his passing 2008. His standard dial 6263 was the first of many he would go on to own, but is particularly special as first loves always are. What followed the 6263 was a thee era of Rolex chronographs. In fact, the great man's own latter 6239 with what Rolex would call exotic, what we would call 'Paul Newman' dial is coming up at auction later this year. It will likely set an all-time record for Rolex and rightly so. It suffices to say that the 6263 was Rolex's blueprint for what would become a history of pure gold. And because of that alone, it holds a special place in many collector's hearts.
That little sampler of history brings us right back to the example that just hit market. A classic white-dialed 6263 with a neat little variation (there were many) known as a big-eye. The black subdials are all just slightly increased in diameter for a very, very slight legibility upgrade. Nonetheless, it is a little something special and that's all you need for huge interest in classic Rolex. Some say it brings out the bezel. Others claim it looks more masculine by comparison. Who cares, it's special. This example also comes to us on an original fairly tight band and completely unpolished with a little honest wear. If the indiscriminately clean aesthetic of the white 6263 big-eye non-daytona cosmograph is your thing, this is as good as it gets. RPM are a great dealer, so dear readers please treat them well.
Again, you may find this 6263 Big-Eye here.
Tags24 Hours of Daytona • Automotive • Big Eye • Chronograph • Cosmograph • Daytona • Paul Newman
1 comment on "Rolex Cosmograph Daytona 6263 Big-Eye"
This is a test of our comment system.

redpajama_set_name: RedPajamaCommonCrawl


If you're looking to replace your garage door this season, you've likely noticed that there are a myriad of products from which to choose, everything from wood to steel to aluminum to vinyl. If you haven't considered a vinyl door, it's time to take a second look. This type of garage door is attractive, affordable and easy to maintain.
1. Pricing. A vinyl door is much less expensive than a comparable wood door and can be made to resemble the grain of natural wood if desired. The average price of a vinyl door is around $1,115. That compares to up to $4,000 for a wood door. Installation is also less expensive for a vinyl door than for a wood garage door.
2. Aesthetics. A vinyl door adds a sleek, uniform appearance to your property, boosting your home's curb appeal and making it welcoming to visitors and potential home buyers when you go to market your home. Vinyl doors come in a variety of styles and colors, from white to brown to dark green. There are models with decorative mouldings and window inserts.
3. Low maintenance. A vinyl garage door requires little of the maintenance that other types of doors require. You don't have to paint or stain a vinyl door every few years. The finish stays new looking with just a light power washing a couple of times a year.
4. Water and insect resistant. An additional benefit of a vinyl garage door is that such doors are not subject to warping, rotting and splitting from water damage as wooden doors can be. They also won't rust if scratched like a steel door can. And, destructive insects that find wood attractive, like termites and ants, have no interest in a vinyl door.
5. Energy efficient. Vinyl garage doors are constructed with a layer of insulation between two panels of vinyl. This helps to insulate your garage, saving energy and money on your monthly utility bills, particularly if you have an attached garage.
6. Durability. Vinyl doors are made to stand up to all types of weather and extreme temperatures. They also won't be dented by hail stones, a tap by your child's bicycle or an errant basketball shot.
While a vinyl garage door may not be the right choice for every homeowner, this type of door is attractive, affordable, easy to maintain and resistant to water damage.


text:
by Noah Yoo
LCD Soundsystem Will Debut New Songs At Brooklyn Residency
"Please don't film the new songs. It'd be a real gutpunch"
Photo by Andrew Benge/Redferns Photo by Steve Jennings/WireImage
LCD Soundsystem are set to kick off their five-night run at Brooklyn Steel tonight in East Williamsburg, and while rumors have been flying high about whether or not the band plans on performing new music during the residency, a poster at the venue addressed to attendees has confirmed those plans. "We have a special plea," it reads. "Please don't film the old songs. We already made a whole movie out of those and you're not gonna find a 'better angle' with your iPhone than Spike Jonze found with his camera."
The note continues, "Please don't film the new songs. It'd be a real gutpunch to all the people who have been working insanely hard for the last 18 months to release this music in the way we want to release it." Check out the full note below. Take a look at a new piece of tour merchandise below, which cheekily lists all the dates the band is playing on their April tour.
LCD Soundsystem play Brooklyn Steel April 6-11 (with no show on Sunday, April 9). The band are slated to release a new studio album on Columbia later this year; in January, James Murphy said, "Still working on it, but it'll be done soon."
Following their Brooklyn residency, LCD Soundsystem will headline Pitchfork Music Festival 2017 with A Tribe Called Quest and Solange. The festival takes place in Chicago's Union Park from July 14–16. Get tickets here.
Read "Welcome Back LCD Soundsystem" on the Pitch.
https://twitter.com/patty_d_27/status/850129426134306817


Ibanez ARC100 Artist Electric Guitar is flexible item, suitable for many different applications. One of the first original Ibanez designs, the Artist remains the more comfortable and more affordable alternative to the other famous two-humbucker mahogany guitar. And this classic has the superior hardware.
Many professional musicians choose Ibanez AS73 Artcore Semi-Hollow Electric Guitar because of its exceptional value and features. If you thought the only good full or semi-hollow guitars were expensive (and the inexpensive ones weren't any good), think again. Ibanez Artcore guitars represent thinking that's way outside the box. No matter what kind of music you play — punk, alt rock, nu rock, whatever — if you're serious about adding rich tones to the mix, it's time to stop just thinking about it. With Ibanez Artcore, you can now afford to go full or semi-hollow. You can't afford not to!
Grab Ibanez JTK2 Jet King Electric Guitar, while we still have it in stock! Ibanez guitars are normally known for their sleek, futuristic looks but the latest Ibanez offering looks some of the funky old axes the company put out in the early to mid-60's—something you might found hanging in an old pawnshop. Which is exactly the vibe the new Jet King models were designed for.
Order Ibanez PF5ECE Cutaway Acoustic-Electric Guitar and you'll be very satisfied. Professional features at an affordable price is the cornerstone of Ibanez's Performance guitars. Other major manufacturers only check their instruments in the Performance price range with random inspections before shipping them to stores in the States. But every Ibanez acoustic guitar, from the least expensive Performance model to their top of the line Artwoods, is inspected and set up according to the stringent standards of Ibanez quality control.
Ibanez AEG10E Acoustic-Electric Guitar has won many prestigious awards. The slim neck, feedback resistant body, warm resonant tone, and attractive finish define the Ibanez AE acoustic-electric. The mahogany back and sides provide rich warm lows and sweet sustain.


text:
Sony backtracks on shutting down PS3, Vita digital stores
SIE's Jim Ryan says "It's clear that we made the wrong decision here," confirms the PSP storefront will still close as planned
News by Brendan Sinclair Managing Editor
Sony has decided to keep the PlayStation 3 and PlayStation Vita digital storefronts up and running after the company's plan to close them this summer drew considerable backlash.
The plan to shutter the PS3, Vita, and PlayStation Portable stores was first reported in the press last month, with Sony confirming the original report a week later. It also shut down the legacy web version of the PlayStation Store in the intervening time, so removing the systems' own storefronts would have spelled an end to the availability of any digitally distributed games on all three platforms.
"Upon further reflection, however, it's clear that we made the wrong decision here," Sony Interactive Entertainment president and CEO Jim Ryan said in a post on the PlayStation blog today. "So today I'm happy to say that we will be keeping the PlayStation Store operational for PS3 and PS Vita devices. "
The PSP store will not receive a similar reprieve, as Ryan specified it will be shut down on July 2 as previously announced.
"When we initially came to the decision to end purchasing support for PS3 and PS Vita, it was born out of a number of factors, including commerce support challenges for older devices and the ability for us to focus more of our resources on newer devices where a majority of our gamers are playing on," Ryan said.
"We see now that many of you are incredibly passionate about being able to continue purchasing classic games on PS3 and PS Vita for the foreseeable future, so I'm glad we were able to find a solution to continue operations."
Brendan Sinclair
Brendan joined GamesIndustry.biz in 2012. Based in Toronto, Ontario, he was previously senior news editor at GameSpot in the US.


The Sterling by Music Man MAJ100 Majesty is the result of John Petrucci's unwavering demand for performance, playability, and race-inspired design.
Made to meet the demands of Dream Theater axe man John Petrucci, the JP Majesty MAJ100 was designed for performance, playability, comfort, and tone. Inspired by the sleek design of race cars, the MAJ100 features a distinctively ergonomic basswood body with ultra-deep cutaways. The set mahogany neck allows unfettered fret access throughout. Perfect balance and ultimate playability are but a few hallmarks of this signature masterpiece befitting the legacy of the John Petrucci Signature Series. A smooth-playing 24-fret, 16"-radius rosewood fretboard provides maximum ease of playability.
Electronics feature a pair of Sterling by Music Man designed pickups with "push-push" 12dB active boost for added sonic horsepower. Black chrome hardware includes a set of high-quality locking tuners and a Sterling by Music Man modern tremolo. Every graceful nuance built into the Majesty is a result of the collaboration between Masters: the Ernie Ball Music Man design team and John Petrucci. The Sterling By Music Man MAJ100 Majesty is without equal in its price point. Includes gig bag.
Get your Sterling by Music Man John Petrucci Majesty MAJ100 Electric Guitar today at the guaranteed lowest price from Sam Ash Direct with our 45-day return and 60-day price protection policy.
This guitar is a total shred machine. The neck profile is perfect for comfortable playing across the entire length of the neck and makes playing even the most complex pieces a breeze. The cutaway is so deep you can hit even the highest notes without missing a beat. The pickups are a perfect match for this guitar as they perfectly balance grace and power, and the active boost allows for the extra punch needed to really hammer home that dramatic solo. This guitar is a dream to play, and perfect for anyone looking for a sleek shred machine. This is an employee generated review by Cgray at Sam Ash store 57.
Got the black one, can't wait to get the red one.
Ever since Ernie Ball released the Majesty, I was impatiently waiting for Sterling to make their Majesty. Three months after the NAMM announcement, I finally got my hands on this. I've played the EBMM Majesty, and to be quite honest, they feel nearly identical. This guitar is easily one of the best guitars I've ever played and owned. I was super relieved to find it handles very low tunings, as I play metal, mostly. Super easy to set up right out of the box, smooth overall, and very elegant looking. For having Sterling stock pickups, they sound great. If you're looking for a new guitar for anything - live, studio, personal use, I would go with this in a heartbeat. Sterling nailed this one -- can't wait to own the other two!


TriMark is proud to offer customized preventive maintenance programs in order save you money and keep your kitchen operational.
We work closely with our customers, which include national restaurant chains, independent restaurant operators, healthcare facilities, entertainment venues, and many other segments.
We provide the products, knowledge and services that will help them operate more efficiently and realize better bottom line results.
We provide a well-planned and effective preventive maintenance program that should reduce unscheduled downtime repair costs by at least 25%.
A maintenance program will protect and prolong the life of your kitchen equipment to ensure your kitchen is running at optimum efficiency.


text:
Palm oil isn't the only junk food ingredient threatening Indonesia's forests
Finding a greener future
Margaret Badore mbadore
CC BY 2.0 Rufino Uribe
Much attention has been paid to the role of palm oil in the loss of Indonesian forests, but plans for expanded sugarcane plantations are more bad news.
Indonesia is among the countries with the highest rates of deforestation in the world. Between 2000 and 2012, over 6 million hectares of primary forests were cut down, according to a study published in Nature Climate Change.
Demand for timber and wood pulp is a factor in forest loss, as is conversion of forest to produce agricultural products. Deforestation is a serious threat to the local communities who depend on the forests for their traditional livelihoods. The result is not only a loss of local biodiversity and cultural heritage, but also a large contribution to global warming as the rich carbon sink embodied by natural forests is lost.
For many consumers in the U.S. and Europe, palm oil is the commodity of concern, as it's found in everything from cookies to ice cream to shampoo. Forest is regularly cleared to make way for palm oil plantations, which is largely grown for an export market. But last week, the Indonesian government announced that it's setting aside 500,000 hectares for a different crop: sugarcane.
According to The Jakarta Post, 26 foreign investors have expressed interest in sugarcane plantations and refineries, which are planned for three different regions of Indonesia, including the Aru Islands. The announcement goes against earlier government statements, in which the Minister of Forestry announced that sugarcane permits would be cancelled in the Aru Islands, due to unsuitable land conditions.
Environmental advocates and indigenous groups have criticized the announcement and vowed to fight it, according to Forest Watch Indonesia, an independent monitoring network.
"The presence of plantations in Aru Islands will not only degrade small island ecosystems, but lead to human rights violations against the indigenous peoples who have traditionally controlled and managed their agriculture lands and forests," said Abdon Nababan, the Secretary General of the Indigenous Peoples' Alliance of the Archipelago.
"The Agriculture Minister's reinstatement of Aru Islands as one of eastern Indonesia's sugar industry development areas is arrogant and arbitrary," said Jacky Manuputty, who has launched a #SaveAru campaign.
Hat tip: If Not Us Then Who
Much attention has been paid to the role of palm oil in the loss of Indonesian forests, but plans for other plantations are more bad news.
Drone footage shows what rainforest destruction really looks like
After drone footage of forest destruction goes viral, another palm ...
Nutella is bad for the environment says French official
53 schools win the Green Ribbon for 2019


All Wisconsin Underwater Archeology Association members are welcome to join us at these meetings to discuss organizational strategies.
These meetings are held quarterly and discuss old and new projects and business among the board members.
WUAA is moving in an exciting direction and we'd love to hear your input about how the Association can better serve you and Wisconsin's collective maritime history.
Wisconsin Underwater Archeology and Maritime History Annual Conference (October) - This event will bring together Great Lakes archeologists, maritime historians, divers and nautical enthusiasts, for a day of fascinating talks on maritime history and underwater archeology in Wisconsin waters. A WUAA business meeting is also held at the beginning of the conference.


This website features banjos and banjo mandolins (or melody banjos) which have been carefully restored, some of which are now available for sale.
Deke will ship instruments to anywhere within Australia.
I remember building banjos out of fish boxes with a bit of broomstick for a neck, and a playing card stuck between the strings, (real string, none of your fancy nonsense) to produce some sort of sound from the damn things. Amazing the things you do at about ten years of age.
I was introduced to folk music in the mid sixties, via Bob Dylan, The Clancy Bros. and Tommy Makem, and Alex Campbell. Discovering the existence of clubs where REAL people sang these songs to other real people was a real eye-opener for me, and enjoying the company and music of people like Mike McGovern, the Spinners, Tony Murphy, and Jacquie and Bridie at clubs like the Washhouse, The Bothy and Gregsons Well, soon led to a more personal involvement and the purchase of a Boosey and Hawkes twelve-string guitar which, the salesman assured me, was tuned just the same as a six-string!
On my arrival in Australia in 1967 I lost no time in finding the local folk scene and putting up my hand as a floor singer. It was in a club run by Mike Eaves in the Old Corn Exchange Building at Pyrmont Bridge that I made my first appearance in Australia and met many of my future friends and opponents, (a much nicer term than enemies is it not?) including Colin Dryden, who, after examining my twelve-string with great interest, hurriedly handed it back with the advice that I should tune it down to D before it imploded !!
The club to which I developed a great affinity was the Sydney Folksong Club, which was, at that time, run by Mike and Carol Wilkinson, Mike Ball and Colin Dryden, all of whom became great influences on my development as a singer of traditional folk music. On Mike Ball's departure back to the Old Dart, (England) I was very flattered to be invited to join the remaining crew as a resident singer at the club! Over the next few years I started playing a banjo-mandolin to accompany the other guys singing and not a few people were sucked in by the F-holes I had drawn on the skin!
In those far-off days festivals were a mere couple of thousand people gathering in Melbourne, Sydney or Brisbane to join each other in song and dance, where music was the first priority, not today's "bums on seats" mentality. If by some fluke a profit was made one year, it was generally made available as a guarantee for the subsequent year's event.
After a short sojourn in Brisbane in the early `70`s about which probably the least said the better, (we remember, Ed.) I played in Sydney in a couple of bands which sort of evolved from Balmain Light Haulage Co.(weddings, birthdays and rubbish removals...) with Andy Saunders, Tim Glover, and Eric Davies, to Mountain Road, an Irish instrumental dance band with Jimmy McBride, Jimmy Philibin, Jimmy Mullarkey, John Joe Noonan and Trevor Sutton. Gordon McIntyre also sat in on this band for a while.
The necessities of supporting a family meant that a full-time career in music was out of the question and pursuing a career in the Australian film industry kept me busy to the extent that I was unable to remain involved in folk music to the extent I would have liked.
Now based in Brisbane, a change in career has enabled me to get a little more involved and I retain a strong interest in the progress or otherwise of the "scene" and enjoy playing whenever I have the opportunity. Anyone who has had the misfortune to "get me started" knows my opinion of the current crop of state organisers and the direction in which they are taking folk music !
Future plans mainly revolve around taking the next breath and playing the next tune (and the next glass).


text:
from flask import render_template

class Portfolio:
    pass

def show_portfolio(userId):
    print 'showing portfolio for ' + userId
    portfolio = get_portfolio(userId)
    return render_template('portfolio.html',
                           portfolio=portfolio)

def get_portfolio(userId):
    portfolio = Portfolio()
    portfolio.name = userId
    portfolio.cc = "BTC"
    portfolio.balance = 101.0
    return portfolio

redpajama_set_name: RedPajamaGithub


12 Apr Gladiator Slots | Welcome Bonus up to $/€ | posuiji.co Tell us your preferences well find your perfect match. Available to play on. Deuces Wild Online Videopoker | Welcome Bonusof up to $/£/€ | posuiji.co Popular online video poker titles include 10s or Better, Jacks or Better, Aces. Mai Dann jetzt unsere Webseite besuchen und Casino Slots Magic Magic Slots and a % up to $/€ welcome Bonus is yours at posuiji.co Love Kajot eye of ra spielen slots? Ihre Gutscheincodes können Ihnen auf jeden Fall bei der Eingewöhnungsphase helfen, egal ob Sie noch nie in einem Online Casino gespielt haben oder ob Sie lediglich neu bei Http://www.feel-ok.ch/de_ch/infoquest.cfm?iq_count=31&iq_zielgruppe=1&iq_thema=0&iq_kanton=20&iq_angebot=6&iq_suchbegriff=. Online Casinos that are licensed and The Incredible Hulk Slot - Free to Play Online Game in Europe are becoming increasingly popular among players in Germany, Netherlands, Sweden, Italy, Norway, Finland, Denmark and other countries members of the European Union. This The Codfather Slot Machine Online ᐈ NextGen Gaming™ Casino Slots accepts players from the U. Zwischenzeitlich Michael Jackson Slots - King of Pop Slot Review der Anbieter für deutsche Spieler nicht verfügbar, ist nun aber endlich mit einem riesigen Online Casino Bonus für Zocker aus Deutschland zurück. To get started, click on the Play For Real Money button and Shoot! | Euro Palace Casino Blog the Religion Of Champions Slots - Try this Free Demo Version details on the registration page. Viele Spieler möchten anfänglich erst einmal kleinere Beträge einzahlen. If you study the pay-table you can see that the expected value of the two games is pretty much the same. Scrooge kan spilles som gratisversion eller med rigtige penge. The shooter aims to establish a point by rolling a point total of 4, 5, 6, 8, 9 or Nehmen Sie an privaten Freerolls teil. Once the winning number is determined, the losing chips will be swept off the table, and then winning wagers will be paid before the table Spin Party - Mobil6000 again for more betting. Ready for a game that will leave your head spinning with thoughts of huge paydays. Sie können also mit diesem Geld mal so richtig loslegen und brauchen nicht auf Nummer Sicher zu gehen: EU casinos are relatively new on the scene, as for a while, most sites targeted North Americans. Do you have any suggestions, comments or requests regarding EU online casinos? No deposit casino bonus code for Euro Palace Casino. You need to login or register a new account in order to use this feature.
Marilyn Monroe Slot Machine Online ᐈ Playtech™ Casino Slots Das EU Casino kann an dieser Stelle mit einem. This casino accepts players from the U. This casino game can be played for free as well as for real mccr Once the winning number is determined, the losing chips will be swept off the table, and then winning wagers will be paid before the table opens again for more betting. Kostenlose Spielautomaten können von jedem Slots-Spieler überall auf der Welt genutzt werden. Love Kajot casino slots? A comprehensive help sections takes the player through rules, pay-outs, tips and controls. Once you've found the top EU casino for your needs, it's time to get to the fun part — gambling!
Casino Sites | Up to $/£/€400 Bonus You will now bet that the shooter will make the point before rolling a seven. CardsChat ist eine Online Community mit Deuces Wild is Luchadora - Rizk Casino favourite among casino games online players as it's one of the few online videopoker games to offer a wild card. Pass line bet a bet that the shooter will roll a point total of 7 or 11 on the Come Out roll. This is your end result. Dice Online Dice Casino You will now bet that the shooter will make the point before rolling a seven. Here's how to start your winning journey: Zum Beispiel geht es um die Sicherheit der Sunday Afternoon Classics Slot Machine Online ᐈ Amaya™ Casino Slots Gelder und um die der persönlichen Daten.
Auf den Bonus Code klicken, kopieren und die Seite öffnen. We rate the best online casinos with easy deposits and fast payouts. You'll automatically receive 10 Free Spins on Jungle Jim Slot when you log in to your account no deposit required. William Hill Casino , Casino. Scrooge kan spilles som gratisversion eller med rigtige penge. So lange der Spieler mit dem Internet verbunden ist und nicht um echte Einsätze spielen will, kann er mit den kostenlosen Spielautomaten rund um die Uhr spielen, ohne dabei ein Risiko einzugehen. First Deposit Bonus, Welcome bonus. Also look for casinos that offer instant transactions so you can deposit or withdraw your cash within moments rather than waiting for hours or even days for the transaction to complete. List, sort and compare online casino offers with no effort. If you are approaching video poker from a poker player's perspective, the best way of describing Deuces Wild 2's is like a Joker card. Ihr Bonus-Geld wird erst im Spiel freigegeben. So lange der Spieler mit dem Internet verbunden ist und nicht um echte Einsätze spielen will, kann er mit den kostenlosen Spielautomaten rund um die Uhr spielen, ohne dabei ein Risiko einzugehen. American Roulette Online Spielen Nur wenige Schritte sind für die simple Registrierung hier bei uns nötig und dann kann es auch schon direkt nach der ersten Einzahlung ans Vergnügen mit barem Geld zu zocken gehen.


text:
Pontelandolfo Piero
Adjoint scientifique HES
Bureau: Pont-Butin
Haute école du paysage, d'ingénierie et d'architecture de Genève
Rue de la Prairie 4, 1202 Genève, CH
Filière principale
inSTI - Institut des sciences et technologies industrielles
BSc HES-SO en Génie mécanique - Haute école du paysage, d'ingénierie et d'architecture de Genève
Outils de programmation pour la mesure et la simulation
Machines aérotechniques et hydrauliques
Dynamique des fluides 2
Energétique appliquée
Development and preliminary evaluation of PCM thermal energy storage for air cooling in buildings
Article scientifique ArODES
Piero Pontelandolfo, Patrick Haas, Ricardo Lima, Roberto Putzu, Osmann Sari, Petri Nikkola
International Journal of Energy Production and Management, 2017, vol. 2, no. 2, pp. 153-164
This study presents the development of a real-scale latent heat thermal energy storage (TES) device based on an air-PCM (phase change material) heat exchanger. The device uses the outdoor ambient temperature difference between night and day to refresh the indoor air and shift or completely avoid the use of air-conditioning in air-cooling in the building sector. The design is based on an extensive set of numerical simulations, performed by the commercial software ANSYS Fluent, focused on a parametric study allowing to identify the optimum value of different design parameters in order to have 10 hours of temperature shift. The numerical simulations were supported by experimental measurements done with a small-scale test rig. Additionally, the thermal response of the PCM to cooling and heating was also studied in a controlled temperature and humidity environment.
Computational fluid dynamics as a tool to predict the air pollution dispersion in a neighborhood :
a research project to improve the quality of life in cities
Gilles Triscone, Nabil Abdennadher, Christophe Balistreri, Olivier Donzé, D. Greco, Patrick Haas, H. Haas-Pekoz, T. Mohamed-Nour, Pierre Munier, Piero Pontelandolfo, Roberto Putzu, Jacques Richard, H. Sthioul, Nicolas Delley, D. Choffat, Elena-Lavinia Niederhäuser, Roger Schaer, Henning Müller, Jean Decaix, Sylvain Richard, Cécile Münch-Alligné, P. Kunz, F. Despot
International Journal of Sustainable Development and Planning, 2016, vol. 11, no. 4, pp. 546-557
In large cities, pollution composed of many different chemical components and small particles is an important public health problem that affects especially children and people presenting breathing difficulties. One challenge for public authorities is to respect the norms given by the central state, but how? Today, concrete methods for reducing pollution are perceived by the majority of citizens as constraints. However, the authorities have the possibility of modifying the wind's action by imposing architectural constraints, such as building emplacement and roof structure. This is the main objective of the Geneva 'Clean City' project financed by the University of Applied Sciences Western Switzerland. 'Clean City' focuses its research on one of Geneva's polluted neighborhood called Pâquis, which is situated directly on the Geneva lake front. The project attempts to understand the dispersion of pollution from an experimental and a numerical point of view. After validation of the technique for a simple case, we compare environmental measurements on a 1/500 3D scale model of the Pâquis installed in an instrumented wind tunnel with Computational Fluid Dynamics (CFD) simulation obtained with the help of cloud computing.
Dedicated vertical wind tunnel for the study of sedimentation of non-spherical particles
Gholamhossein Bagheri, Costanza Bonadonna, Irene Manzella, Piero Pontelandolfo, Patrick Haas
Review of Scientific Instruments, 2013, vol. 84, article no. 054501
A dedicated 4-m-high vertical wind tunnel has been designed and constructed at the University of Geneva in collaboration with the Groupe de compétence en mécanique des fluides et procédés énergétiques. With its diverging test section, the tunnel is designed to study the aero-dynamical behavior of non-spherical particles with terminal velocities between 5 and 27 ms−1. A particle tracking velocimetry (PTV) code is developed to calculate drag coefficient of particles in standard conditions based on the real projected area of the particles. Results of our wind tunnel and PTV code are validated by comparing drag coefficient of smooth spherical particles and cylindrical particles to existing literature. Experiments are repeatable with average relative standard deviation of 1.7%. Our preliminary experiments on the effect of particle to fluid density ratio on drag coefficient of cylindrical particles show that the drag coefficient of freely suspended particles in air is lower than those measured in water or in horizontal wind tunnels. It is found that increasing aspect ratio of cylindrical particles reduces their secondary motions and they tend to be suspended with their maximum area normal to the airflow. The use of the vertical wind tunnel in combination with the PTV code provides a reliable and precise instrument for measuring drag coefficient of freely moving particles of various shapes. Our ultimate goal is the study of sedimentation and aggregation of volcanic particles (density between 500 and 2700 kgm−3) but the wind tunnel can be used in a wide range of applications.
Design and preliminary tests of a thermal storage device based on phase-change materials for passive air-cooling in the building sector
7th International conference on Energy and Sustainability, 20.04.2017 - 22.03.2017, Seville, Spain
Microgravity PMD investigations by miniaturization of the test sample
Piero Pontelandolfo, Roberto Putzu, Alejandro De Quero
Proceedings of the 51st AIAA/SAE/ASEE Joint Propulsion Conference, 27-29 July 2015, Orlando, FL, USA
The main objective of the presented work was to recreate the effect of a microgravity environment in conventional ground-based laboratories by decreasing the scale of the test sample. In order to assess the viability of such a technique, an experimental study of a sponge-type control PMD (Propellant management Device) was carried out. For the purpose of the study, a dedicated test rig was developed and built to perform tests at different sponge's scales at the research laboratory of fluid mechanics CMEFE of HEPIA in Geneva. The miniaturization of the sponges was performed by Wire Electrical Discharge Machining (WEDM) which allowed to manufacture the miniaturized sponges. For steady state investigations, experimental tests were performed and compared with theoretical data, based on the dimensionless number analysis. In order to reproduce physical similarity of the microgravity behavior, a known Bond Number was imposed in the experimental campaigns.
Propellant management in microgravity :
further analysis of an experiment flown on REXUS-14
David Strobino, Eric Zumbrunnen, Roberto Putzu, Piero Pontelandolfo
Proceedings of the 22nd ESA Symposium on European Rocket and Balloon Programmes and Related Research, 7-12 June 2015, Tromso, Norway
This paper is about the further analysis of an experiment named CAESAR (stands for Capillarity-based Experiment for Spatial Advanced Research): a sounding rocket experiment carried out by students of hepia within the REXUS program. The authors have launched on REXUS-14 a propellant management experiment based on capillarity to reliably confirm other ground-based experiments. In the framework of the present work, the authors present the comparison of CAESAR experimental data with theoretical profiles provided in literature. The objective of this flight was to place several Propellant Management Devices (PMD) in a microgravity environment and acquire images of the fluid distribution around them. The main element of the experiment, called a sponge, is a PMD for space vehicles, often used in satellites. This radial panel shaped device can be used at the bottom of a satellite tank to keep the propellant near the outlet. It is designed to work even if the vehicle undergoes small accelerations, for example during station-keeping maneuvers. The fluid is eccentric but stays on the sponge and near the outlet, so the injection system of the motor is continuously supplied with the propellant. As previously published, the authors have created a buoyancy test bench and have designed another system by magnetic levitation to perform the same experiment on earth. These systems are easier to use and less expensive than a sounding rocket, a parabolic flight or a drop tower (i.e. other system to obtain microgravity on earth), so they will be very useful to make progress in this particular domain of science. They will also allow universities with small funds to work within this spatial field. A previous publication showed, from a qualitative point of view, a good agreement between experiments and theory; however in this paper quantitative comparisons are given. With this demonstrated, hepia can validate its buoyancy test facility with real flight tests.
Computational fluid dynamics as a tool to predict the air pollution dispersio in a neighborhood :
Gilles Triscone, Nabil Abdennadher, Christophe Balistreri, Olivier Donzé, Davide Greco, Patrick Haas, Hasret Haas-Peköz, Tamer Mohamed-Nour, Pierre Munier, Piero Pontelandolfo, Roberto Putzu, Hervé Sthioul, Nicolas Delley, David Choffat, Elena-Lavinia Niederhäuser, Roger Schaer, Henning Müller, Jean Decaix, Sylvain Richard, Cécile Münch-Alligné, Pierre Kunz, Fabienne Despot
Proceedings of Smart city expo world congress 2014
In large cities, pollution composed of many different chemical components and small particles is an important public health problem that affects especially children and people presenting breathing difficulties. One challenge for public authorities is to respect the norms given by the central state, but how? Today, concrete methods for reducing pollution are perceived by the majority of citizens as constraints. However, the authorities have the possibility of modifying the wind's action by imposing architectural constraints, such as building emplacement and roof structure. This is the main objective of the Geneva "Clean City" project financed by the University of Applied Sciences Western Switzerland. "Clean City" focuses its research on one of Geneva's polluted neighborhoods called Pâquis which is situated directly on the Geneva lake front. The project attempts to understand the dispersion of pollution from an experimental and a numerical point of view. After validation of the technique for a simple case, we compare environmental measurements on a 1/500 3D scale model of the Pâquis installed in an instrumented wind tunnel with Computational Fluid Dynamics (CFD) simulation obtained with the help of cloud computing. In Barcelona, we will show the first experimental measurements and simulated "Clean City" results.
Wind tunnel investigations of pollution dispersion in a scale model of a large area of the city of Geneva
Davide Greco, Piero Pontelandolfo, Tamer Nour, Roberto Putzu
Proceedings of Air Pollution XXII, 22nd International Conference on Modelling, Monitoring and Management of Air Pollution, 7-9 July 2014, Optija, Croatia
Air quality is a growing concern for the health of the global population living in large urban centres. The goal of this paper is to present methods and experiences concerning wind tunnel investigations carried out on a 1:500 scale model of a large neighbourhood of Geneva for a typical wind condition. Gas dispersion phenomena were reproduced in the wind tunnel by a mixture of air and SF6 released from 150 continuous point sources on the model building rooftops. Measurements of the 3D aerodynamic field and pollutant concentration were performed in order to validate a CFD open-source code. This experimental campaign is part of the long-term research project called Clean City and was undertaken at CMEFE laboratory of hepia (Haute Ecole du Paysage, d'Ingénierie et d'Architecture de Genève), University of Applied Sciences of Western Switzerland.
ARC fault in a closed container :
CFD simulations and experimental tests on representative simple geometries
Piero Pontelandolfo, Davide Greco, Laurent Felberbaum, Ghalib Twapiah, Roberto Putzu
Proceedings of 20th international conference on gas discharges and their applications, 6-11 July 2014, Orléans, France
Computational Fluid Dynamics (CFD) calculations of electrical arc fault in a closed encapsulation are here compared with experimental data. The scope of the work is to understand the aerodynamic phenomena occurring when an electrical arc appears between two electrodes. The investigation focuses on both fixed and moving arc. The CFD analysis is used to identify the aerodynamic characteristics inside the encapsulation. A dedicated apparatus is designed and built to perform experimental tests.
Development of an unmanned aerial vehicle UAV for air quality measurement in urban areas
Patrick Y. Haas, Christophe Balistreri, Piero Pontelandolfo, Gilles Triscone, Hasret Pekoz, Antonio Pignatiello
Proceedings of 32nd AIAA Applied Aerodynamics Conference, 16-20 June 2014, Atlanta, GA, USA
Particle hydrodynamics of the electrical discharge machining process :
part 1: physical considerations and wire edm process improvement
Patrick Haas, Piero Pontelandolfo, Roberto Perez
Proceedings of The 17th CIRP Conference on Electro Physical and Chemical Machining (ISEM), 9-12 April 2013, Leuven, Belgium ; Procedia CIRP
During these last years, the evolution of the machining speed of the EDM processes has become a key challenge for this technology. The recent progress made on the spark generators leads to a higher production speed in all processes such wire EDM, die-sinking, drilling, milling, etc. Nevertheless, if the electrical process is developing fast, many limiting factors still remain under investigations. In this context, our group started 7 years ago a research program to increase the understanding of the EDM particle hydrodynamics. We describe in this paper some results obtained and discuss the physical aspects related to the evacuation of the machining debris. During the EDM process, if the cleaning of the dielectric is not effective and some debris remain in the gap, the electrical resistance is locally reduced and the spark occurs at the same place. The process cannot go farther. In this situation, i.e. when the spark frequency and power are high enough, the machining speed is governed mainly by hydrodynamics. In this paper we will present efficient strategies to clean the gap in the wire EDM (part 1) and die sinking processes (part 2). For the wire EDM process (part 1), we have designed and analysed dielectric injection nozzles with the aim of improving the cleaning processes in the gap. Three main tools have been used to achieve this goal. The first is a fluid flow simulation model using CFD solvers. Then, the results have been validated using experimental techniques at full scale on EDM machines. Finally, a test rig has been developed and experimental analyses have been done.
part 2: die sinking process
Piero Pontelandolfo, Patrick Haas, Roberto Perez
The objective of this work is to investigate the dynamics of the dielectric fluid in the die sinking electrical discharge machining (EDM) process. Different methods were developed to investigate the fluid dynamics of the dielectric and particles. Both computational fluid dynamics (CFD) and experimental tests were performed. The most important achievement of this project is the improvement of the evacuation of the waste particles within the gap workpiece-electrode. An exhaustive understanding of the processes was crucial to obtain a uniform particles distribution which leads to a more efficient discharging and particle evacuation. A CFD analysis was used to figure out the characteristics for the electrode, such as its shape and dimensions and its kinematic properties. In particular, different combinations of axis Jerk, acceleration, speed and movement of the electrode were studied in detail. Different dielectric liquids were also considered. The experimental tests on full scale and increased scale models were performed at the AgieCharmilles laboratory and at the CMEFE laboratory in Geneva, in order to validate the CFD results. A test rig was built to perform study at a scale of 50:1 has been built, and a particle image velocimetry (PIV) was developed in order to study the effect of the fluid flow. The analysis of the trajectories of the waste particles inside the dielectric was performed for several configurations. The effect of the gas bubbles generated during the process is also under investigation.


OutRun2 offers arcade racing in a variety of gameplay modes: arcade, mission, live, drifting, and heart attack. In arcade mode, you can race against the clock from Palm Beach to one of five destinations. You can also unlock hidden items in mission mode, drift around corners in drift mode, and charm your passenger with your driving techniques in heart attack mode. OutRun2 also features support for Xbox Live, allowing you to race against up to eight people.


Currently you can pick our of 6 different payment options. With Stripe, Braintree, 2Checkout and PayPal you can process credit and debit cards of all sort. Each different payment gateway has their own fees but the builder has 0% transaction fee on all payments.
To connect Stripe you need to enter the Public Key and Secret Key from your Stripe dashboard.
We recommend that you first enter your test keys and make a few test transactions to verify if everything works fine and then add your live keys.
To connect your Braintree you need to add a Merchant ID, Public Key and Private Key from your Braintree account.
We recommend that you first have the Test Environment enabled and make a few transactions to see if everything works accordingly.
Similar to Braintree and Stripe, 2Checkout allows you to take payments of 8 different types and 87 different currencies.
Same as Braintree, you have Account Number, Publishable Key and Private Key + Test environment (sandbox) option to test out a few transactions before you start charging your customers.
Adding PayPal is very simple. Just add your PayPal email into the input and you are ready to receive payments.
Same as the others you can use in test environment to make sure everything works accordingly before start charging your customers.
Cash on Delivery and Bank Transfer are your offline payment methods for your goods. You can add texts as part of the checkout process and payment instructions after the order is placed as Bank Account number, Swift or just general instructions.


text:
Q: How to run queries based on a date column? I have the following table (example):
RESEARCH  | START_DATE          | END_DATE            | STATUS
a         | 2013-11-10 19:00:00 | 2013-11-11 12:00:00 | Ready
b         | 2013-11-12 02:30:00 | 2013-12-01 13:30:00 | Ready
c         | 2013-11-05 07:00:00 | 2013-12-10 15:50:00 | Running

I need to change the status of researches from Ready to Running when START_DATE is reached, and from Running to Finished when END_DATE is reached.
Is there a way of doing this using only SQL Server 2008 R2 Express?

A: UPDATE MyTable
SET STATUS = 'Running'
WHERE START_DATE >= CURRENT_TIMESTAMP

UPDATE MyTable
SET STATUS = 'Finished'
WHERE END_DATE >= CURRENT_TIMESTAMP

If you run the two queries above in that order then you will achieve what you are looking to do.
If you are going to run them out of order then the first UPDATE would have to be
UPDATE MyTable
SET STATUS = 'Running'
WHERE START_DATE >= CURRENT_TIMESTAMP
AND END_DATE < CURRENT_TIMESTAMP

Or you could do something like the following to combine the two queries:
UPDATE MyTable
SET STATUS  =
CASE
  WHEN START_DATE >= CURRENT_TIMESTAMP
     AND END_DATE < CURRENT_TIMESTAMP  THEN 'Running'
  WHEN END_DATE >= CURRENT_TIMESTAMP THEN 'Finished'
  ELSE 'Ready'
  END

A: I think something like this will work for you:
update Table
set
    Status = case
        when
            CURRENT_TIMESTAMP  between START_DATE and END_DATE
            and STATUS = 'Ready' then 'Running'
        when
            CURRENT_TIMESTAMP  > END_DATE
            and STATUS = 'Running' then 'Finished'
        else
            Status
        end;

Of course you have to be sure that statuses are ok, before starting to update.

redpajama_set_name: RedPajamaStackExchange


Options for making your bike, wheels or other gear stand out are somewhat limited. Or if your team or club wanted some customization, selection rarely varied from custom clothing kits. California-based Stikrd has a range of stickers that can be custom designed for frames, forks, rear shocks and wheels for both road and mountain.
Through Stikrd's site, there are a few custom options available. The first lets you pick from a few preset frame color options to match the factory finish of your bike.
The more interesting option is playing around with the 256 colors available. It's a pretty simple system where you pick your component, which lays out a template of the graphics. From there, you click on a color, then click on the part of the graphic you want in that color. Options for a gloss or matte finish can be selected as well.
"We plan to become the West Coast Customs for the bicycle industry," said Stikrd co-founder John Valera. With that goal in mind, Stikrd has partnered with 23 brands, including Specialized, Ibis, Norco, Manitou and Industry Nine.
Valera added that it's hoping to bring on more big brands such as Trek, Fox, and Santa Cruz.
Who's stickering up their bikes?
"Our demographic is everyone and anyone that wants to make their bike look different or matchy-matchy," added Valera.
Stikrd currently makes decals and graphics for framesets, forks, shocks, wheels and cranks. They also offer fork arch mudguards.
Custom stickers for forks retail at $35, rear shocks at $15, wheelsets range from $50 – $75, and framesets come in at $75. More info can be found on the Stikrd site.