Just scaled a Shopify store to $54k month. Looking for partners to create more stores!!!

Hello guys and girls,
SEMrush

Little info about myself.

I am an entrepreneur based in Istanbul, Turkey. I ve been doing Shopify and Facebook marketing for over 5 years. In my first month as a dropshipper i scaled a store that sells charcoal paste to $30k a month. Cashed little over $200k net profit after 14 months.

Over the past year i ve developed a new technique with Shopify stores and Facebook marketing. Its fast and brings consistent day after day results.

The store i created little over a month ago with this technique just hit $54k revenue today.

I am looking to create 10 more stores with this technique, I need partners for each of them since Paypal and Shopify Payments (the best payment gateway in my opinion) is not available in my country.

What i require from candidates,

1. My new partner must be from/located in one of these countries – USA, CANADA, UK, AUSTRALIA.
2. They must have a registered business in one of these countries as well.
3. Must have an aged Facebook account.
4. Must have $300-$500 ad budget available for initial Facebook marketing.

Basically not looking for any payment or anything, but you must have ad budget available for initial testing phase. When we become profitable, we ll be paying marketing cost with our profit anyway. But first phase $300-$500 needs to be available.

My new partners will only be responsible for managing cash flows since revenue will go to your bank account from Shopify Payments. You need to manage payments going to Facebook Marketing, paying suppliers, paying future virtual assistants and also paying my cut which is 50/50.

I will manage everything else with my team.

My system is very sharp and quick, if we agree to be partners, store will be ready for marketing in 2 days and we ll be profitable in 7-14 days.

First 10 suitable partners that contacts me gets to work with me. Hope to kill it with you guys!!!

 

postgresql – How would I improve my “algorithm” for figuring out my average spending on food per month?

I have a database table keeping track of every grocery delivery. It’s stored as timestamps and sums (EUR).

Currently, I do this:

SELECT (SUM("amount in EUR") / 3) 
FROM personal."food purchases" 
WHERE "purchase time" >= now() - INTERVAL '3 months';

Now, let’s say that the current day is 1st of September 2020. This “algo” will count together all the deliveries from exactly three months back from the current moment, which I guess means from the first day of June, and then simply slash this price into 3 to symbolize “three months”.

Sometimes, depending on the day, this will give a reasonable value. Other times, and I cannot fully describe/understand why, this gives either a too high or too low value. I suspect that the reason for this is that my food purchases/deliveries don’t always happen on the exact same day, and vary quite a bit in price as well. Thus, the resulting sum, even though I do an interval of three months and then slash with three, and thus “should” give the average food cost “recently”, is oftentimes misleading.

I can’t tell for sure, but I think that it sometimes includes one purchase “too many”, and sometimes “one too few”. It might even be worse than that.

Can you help me improve my formula to be more “fair”? I want to know the average amount I pay for food each month, and I’m not convinced that I’m getting that value with my current query.

I think I need to drop the part which goes three months back from the current time, and instead somehow calculates the… last three… months… um… Frankly, I don’t know what I need to do. I just don’t think that the current method is correct.

I’d appreciate if your suggestion/solution stays as close as possible to my original query. I want to understand what is happening. I actually suspect that this is a very common issue and probably built into PG and all other database softwares.

If Biden is elected will we all have the freedom and utopia that the CHOP residents experienced over the last month ?

I’m sorry Zod did the right-wing dog whistling bait an angry bitter and misinformed white male like you with horror stories of CHAZ that didn’t happen, gonna pander to MyNorthwest and KIRO Radio which are both owned by Bonneville International which is wholly owned by Deseret Management Corporation which is wholly owned by the Mormon church some more.

Lick them boots.

“Just look at democrat run cities. Thugs murdering thugs, leads in covid infections and deaths, crumbling infrastructure.”

Spoken like an out of touch hick in a trailer park

I will provide real and genuine WEBSITE TRAFFIC for 1 month for your website for $1

I will provide real and genuine WEBSITE TRAFFIC for 1 month for your website

I will provide real and genuine WEBSITE TRAFFIC for 1 month for your website for 1$

Are you looking for WEBSITE TRAFFIC?

  • We know that web traffic is the amount of data sent and received by visitors to a website.
  • To increase your sale, you must need organic traffic.
  • No generated traffic by software or bots.
  • All traffic from various types of social media and other platforms.

So, it is not an easy task to generate traffic but I will do it as a digital marketer. 

Thanking You.

.

Community of the Month #39 – Tie Breaker | Forum Promotion

Hi guys,

We ended up with a three way tie in our Community of the Month #39, so I figured I’d just make a quick public poll and provide everyone with 48 hours to place your votes.

Anyways, here are our three contestants:

Same rules apply:

  • You must have made at least 15 posts on FP within the past three months to vote in CoTM.
  • You may only vote for one of the sites listed below (which were submitted in the first half of this month).
  • You may not vote for a site that you submitted to CoTM.
  • You may not vote for a site you are an administrator on.
  • You may not ask others to vote for a site you own, or are an administrator on.
  • You may not create duplicate accounts, or use others’ accounts, to vote for a site.
  • Any other tactic to gain additional votes may result in the votes being discounted, and/or further action.

Regards,
Cam

Community of the Month #40 – Submissions | Forum Promotion


Contest Information

Community of the Month is a monthly contest where members can vote on whose website or forum most deserves recognition. This contest merges two contests which we have previously held into a single contest, bringing a new take on this classic staple of Forum Promotion.

Typically, forums/sites are submitted from the 1st to the 15th, and voted on between the 16th and the 31st.

Submission Rules

  • You must have 15 posts on Forum Promotion to submit a site.
  • For a site to be accepted, its owner (or an administrator) must be a member of the Forum Promotion community.
  • You are allowed to submit as many sites or forums you want per month, so long as you are said owner or administrator of the site or forum.
  • All sites submitted must follow FP’s acceptable content policy.
  • We reserve the right to accept or decline any site submitted to CoTM.
  • When a site wins CoTM, it cannot be submitted again for another two months.

Contest Prizes

  • Advertisements: The winning site will be featured on the Community Billboard for one month.
  • Sticky: Your Promotion Directory topic will be stickied for one month.
  • Recognition: A medal will be displayed on each post you make on FP for one month.
  • Free Service: You will receive one free service of your choice on FP.

Submit Your Forum, Blog, or Website

We are currently accepting submissions until 11:59 PM EST on the 15th of July 2020. To submit your community to this contest, please post the following form as a reply to this topic.

Split date range (timestamp) into equal parts by Month- SQL Server

Experts,
Have a question regarding splitting a date range into equal parts by months including the time part

example – fromdate – 06/29/2020 09:00:00 and todate – 06/29/2021 09:00:00

Want to split this date range into twelve equal parts like below

06/29/2020 09:00:00 - 06/30/2020 12:59:59
07/01/2020 00:00:00 - 07/31/2020 12:59:59
.........
.......
06/01/2021 00:00:00 - 06/29/2021 09:00:00

I cant write recursive CTE as this is a sql synapse module I am running against..

With below query I am able to split the date part, but time part is not coming properly as above.. Please help me as this is a blocking my development

declare @FromTs DATETIME
declare @ToTs DATETIME
SET @FromTs = GetDate()
SET @ToTs = DATEADD(month, 12, @FromTs)

;WITH n(n) AS 
(
    SELECT ROW_NUMBER() OVER (ORDER BY (object_id))-1 FROM sys.all_columns
),
d(qi,qrt,qtt,n,f,t,md,bp,ep,rn) AS  
(
    SELECT 
    ,n.n, @FromTs, @ToTs, 
    DATEDIFF(MONTH, @FromTs, @ToTs),
    DATEADD(MONTH, n.n, DATEADD(DAY, 1-DAY( @FromTs),  @FromTs)),
    DATEADD(DAY, -1, DATEADD(MONTH, 1, DATEADD(MONTH, n.n, 
    DATEADD(DAY, 1-DAY( @FromTs),  @FromTs))))
    FROM n INNER JOIN <datetbl> AS d 
    ON @ToTs >= DATEADD(MONTH, n.n-1, @FromTs)
)
SELECT qi,qrt,qtt,
new_from_date = CASE n WHEN 0  THEN f ELSE bp END,
new_to_date   = CASE n WHEN md THEN t ELSE ep END,rn
FROM d WHERE md >= n

Split date range (timestamp) into equal parts by Month- SQL Server Synapse

Experts,
Have a question regarding splitting a date range into equal parts by months including the time part

example – fromdate – 06/29/2020 09:00:00 and todate – 06/29/2021 09:00:00

Want to split this date range into twelve equal parts like below

06/29/2020 09:00:00 - 06/30/2020 12:59:59
07/01/2020 00:00:00 - 07/31/2020 12:59:59
.........
.......
06/01/2021 00:00:00 - 06/29/2021 09:00:00

I cant write recursive CTE as this is a sql synapse module I am running against..

With below query I am able to split the date part, but time part is not coming properly as above.. Please help me as this is a blocking my development

declare @FromTs DATETIME
declare @ToTs DATETIME
SET @FromTs = GetDate()
SET @ToTs = DATEADD(month, 12, @FromTs)

;WITH n(n) AS 
(
    SELECT ROW_NUMBER() OVER (ORDER BY (object_id))-1 FROM sys.all_columns
),
d(qi,qrt,qtt,n,f,t,md,bp,ep,rn) AS  
(
    SELECT 
    ,n.n, @FromTs, @ToTs, 
    DATEDIFF(MONTH, @FromTs, @ToTs),
    DATEADD(MONTH, n.n, DATEADD(DAY, 1-DAY( @FromTs),  @FromTs)),
    DATEADD(DAY, -1, DATEADD(MONTH, 1, DATEADD(MONTH, n.n, 
    DATEADD(DAY, 1-DAY( @FromTs),  @FromTs))))
    FROM n INNER JOIN <datetbl> AS d 
    ON @ToTs >= DATEADD(MONTH, n.n-1, @FromTs)
)
SELECT qi,qrt,qtt,
new_from_date = CASE n WHEN 0  THEN f ELSE bp END,
new_to_date   = CASE n WHEN md THEN t ELSE ep END,rn
FROM d WHERE md >= n