Let $M$ be a pure motive over a field $k$. Roughly speaking, the L-function of $M$ is the product over all primes $p$ of $$L_p(M,s)=\det(I-Fr_p|_{M_\ell^I} N(p)^{-s})^{-1}$$ where $Fr_p$ is a Frobenius element and $M_\ell^I$ is the $\ell$-adic realization of $M$ stable under inertia $I_p$. On the other hand, the zeta function of $M$ is the infinite series $$Z(M,t)=\sum_{n=0}^\infty[Sym^nM]t^n$$ taking values in the ring of pure motives over $k$.
Is there a precise relation between the L-function and zeta function? Both seem to generalize the Hasse-Weil zeta function in different ways, but it is tempting (if nonsensical) to ask for an euler product for the series and vice versa. [EDIT: I believe this 'product' should in fact be the $\det(\dots)^{-1}$ factor, and then the global L-function defined as a product over almost all $p$]
Indeed, Dhillon and Minac (1991) define a 'motivic Artin L-function' as $L(M,\rho,t)=Z((V\otimes M)^G,t)$ where $\rho$ is a representation of a finite group $G$ in a $\mathbb Q$ vector space $V$, but it is not obvious whether $L(M,\rho,t)$ and $L(M,s)$ are directly related in any way.