Send Email to Customers Question

[philip937]

On the send email to customers page, on the drop down you get various options to send bulk emails.

I would like to contact customers that have never comeplted a purchace but not ALL of them. just ones in say the past week.

Is there a way to change what ever query pulls the customers that havent made a purchase to limit them by this sort of period of time? perhaps a good one would be 'customers that havent made a purchase last week', so 7 days from 14 days ago?

Many Thanks,

Phil

[philip937]

I think I have a query that should deal with the dates bit, will this work?

WHERE Date BETWEEN (NOW() - INTERVAL 14 DAY) AND (NOW() - INTERVAL 7 DAY)

[philip937]

I think I have a query that should deal with the dates bit, will this work?

WHERE Date BETWEEN (NOW() - INTERVAL 14 DAY) AND (NOW() - INTERVAL 7 DAY)

So I think I should be able to use this:
SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM TABLE_CUSTOMERS c LEFT JOIN TABLE_ORDERS o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL

and i need hep merging the two above?? anyone?

[philip937]

im assuming i need to join the customers_info table so I have a date (customers_info_date_account_created) to reference but unsure how to do this|?

[Limitless]

You could utilize the mailbeez addon for this and/or the 'recover cart' plugin.

Might be easier than rolling your own.

[philip937]

You could utilize the mailbeez addon for this and/or the 'recover cart' plugin.

Might be easier than rolling your own.

installing a whoe mod rather compared to adding one query to a built in feature?

my preference is using the send mail page hence why I am trying to establish the correct sql syntax to pull the desired customer info.

[Limitless]

The mod has many more marketing features than 'just' what you are trying to do.

Perhaps download the mod and look through it for help with your queries?

[philip937]

The mod has many more marketing features than 'just' what you are trying to do.

Perhaps download the mod and look through it for help with your queries?

I am aware of its functionality as ive looked at it before. however I am not interested in these features. I simply want to send an email to a specified group of customers based on a query I insert into query builder. cheers anyway, i just need some help with the table joins

[Limitless]

Select
  customers.customers_firstname,
  customers.customers_lastname,
  customers.customers_email_address,
  orders.customers_name,
  orders.date_purchased

From
  customers Inner Join
  orders On orders.customers_id = customers.customers_id
  where date_purchased <= DATE(DATE_SUB(NOW(),INTERVAL 7 DAY))

[philip937]

Select
  customers.customers_firstname,
  customers.customers_lastname,
  customers.customers_email_address,
  orders.customers_name,
  orders.date_purchased

From
  customers Inner Join
  orders On orders.customers_id = customers.customers_id
  where date_purchased <= DATE(DATE_SUB(NOW(),INTERVAL 7 DAY))

The query I need wants to select customers that haven't made a purchase and group by date based on when they signed up. Basically the two elements I posted earlier in this thread need to be combined with another join statement?