Get download history for an email address

Look up all whitepaper downloads by a specific email to understand engagement patterns or verify prior access before follow-up. Use this before investor/artist meetings to understand engagement history, or in analytics to identify repeat downloaders. Returns all download events ordered chronologically (most recent first).

Usage

get_downloads_by_email(email, cn = NULL)

Arguments

email

Character string. Email address to look up. Validated using is_valid_email() before query.

cn

DBI connection object or NULL. Database connection from artcore::dbc("artsite"). If NULL (default), creates and closes connection automatically.

Value

Data frame with all download records for the email containing fields: id, email, user_type, user_id, ip_address, user_agent, downloaded_at. Ordered by downloaded_at descending (most recent first). Returns empty data frame if no downloads found.

See also

Other whitepaper: get_recent_downloads(), get_whitepaper_stats(), has_downloaded_whitepaper(), log_whitepaper_download(), whitepaper

Examples

if (FALSE) { # \dontrun{
# Check download history before investor meeting
downloads <- get_downloads_by_email("partner@vc.com")
if (nrow(downloads) > 0) {
  message("Downloaded on: ", downloads$downloaded_at[1])
}
} # }