I am fairly new to Klaviyo and was hoping to get some help with Klaviyo data that is captured in the tables. Is there a way to capture the click-to-action (CTA) data in one of the tables as a column? The idea is to track how many users clicked on the links/URLs in an email campaign. Also, is there a table that contains the actual email text (I know that it is stored within a bunch of HTML tags) to determine how many characters/words an email is?
If these data elements don’t already exist, is it possible to access those through an API?
Building off of @k.mcevoy, you can certainly utilize Klaviyo’s Metric API to export click data to your own external database. You can learn more about exporting metrics from Klaviyo for use externally from the following documents we offer:
@jenny13857, to elaborate further on this discussion, the screenshot provided by Gautham illustrates a report of the Clicked Email metric within their Klaviyo account broken down by URL. You can use these reports in a number of ways depending on your business and marketing goals. For example, sending an email which contains a promotion with a button directing customers to the specific promotion’s page; you can see how many users have actually clicked on this specific button in your email to see how engaging your recipients and content are.
Thanks so much for contributing to the Klaviyo Community! If I’m understanding your end goal correctly you can use our segment builder to create a group of profiles who clicked a specific URL within an email:
As for determining the size of an email prior to send, there is no native tool within Klaviyo but you can use this free online tool: http://bytesizematters.com/
Thank you for the prompt response. I was hoping to accomplish that using the tables in the database, so I can use our reporting environment to build dashboards off of that. Would essentially want to recreate something like this plus more. Is that possible with the current setup? Or is there a way to get those additional data elements (in an automated way) into our database?
As for the email text, would be nice to automate that as well, but it’s not a high priority.
Building off of @k.mcevoy, you can certainly utilize Klaviyo’s Metric API to export click data to your own external database. You can learn more about exporting metrics from Klaviyo for use externally from the following documents we offer:
@jenny13857, to elaborate further on this discussion, the screenshot provided by Gautham illustrates a report of the Clicked Email metric within their Klaviyo account broken down by URL. You can use these reports in a number of ways depending on your business and marketing goals. For example, sending an email which contains a promotion with a button directing customers to the specific promotion’s page; you can see how many users have actually clicked on this specific button in your email to see how engaging your recipients and content are.
Building off of @k.mcevoy, you can certainly utilize Klaviyo’s Metric API to export click data to your own external database. You can learn more about exporting metrics from Klaviyo for use externally from the following documents we offer:
@jenny13857, to elaborate further on this discussion, the screenshot provided by Gautham illustrates a report of the Clicked Email metric within their Klaviyo account broken down by URL. You can use these reports in a number of ways depending on your business and marketing goals. For example, sending an email which contains a promotion with a button directing customers to the specific promotion’s page; you can see how many users have actually clicked on this specific button in your email to see how engaging your recipients and content are.
Hope this helps!
-David
Hi, I’ve been through those links and where I”m getting stuck is in terms of Exporting data using “by” instead of “where”. https://apidocs.klaviyo.com/reference/metrics#metric-export I’d like to export the data by campaign name, but I don't now what value to put in the &by= parameter in order to do this. Do you have a reference so that I know what parameter names to use depending on how I want to segment the data?
By clicking “Accept All Cookies,” you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.
Privacy Preference Center
Your Privacy
Strictly Necessary Cookies
Performance Cookies
Functional Cookies
Targeting Cookies
Site Analytics
Your Privacy
When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.
Privacy Notice
Strictly Necessary Cookies
Always Active
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
Performance Cookies
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
Functional Cookies
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
Targeting Cookies
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Site Analytics
These cookies record your visit to our website, and are used to track your visit including information such as: web page interactions (clicks, hovers, focus, mouse movements, browsing, zooms and other interactions), referring web page/source through which you accessed the Sites, heatmaps and scrolls, screen resolution, ISP, and statistics associated with the interaction between device or browser and the Sites. If you are accessing our Services with a European IP address, you have been asked to consent to the use of these cookies (you are free to deny your consent).