{"id":257,"date":"2024-09-23T10:36:20","date_gmt":"2024-09-23T10:36:20","guid":{"rendered":"https:\/\/www.martech-magic.com\/?p=257"},"modified":"2024-09-23T10:39:21","modified_gmt":"2024-09-23T10:39:21","slug":"what-the-hell-is-in-my-fields","status":"publish","type":"post","link":"https:\/\/www.martech-magic.com\/index.php\/2024\/09\/23\/what-the-hell-is-in-my-fields\/","title":{"rendered":"What the hell is in my fields?"},"content":{"rendered":"\n

I worked in Silverpop (later known under different names like “IBM <\/em>Campaign Automation (Watson)” and “Acoustic Campaign”) for a while, and there was a feature named “Field Value Report”. Similar to querying people in the database, you could also do queries on all values in a field. Pretty nice.<\/p>\n\n\n\n

In Marketo there is no such feature, but in “People Performance Reports” you find something that gives you a similar result. (People Performance Report is the most underrated Marketo report type anyway.)<\/p>\n\n\n\n

How does it work and what can you expect?<\/p>\n\n\n\n

Go to “Analytics” and “People Performance”. First thing I recommend doing always is to “save as”. Report Actions –> Save As –> Save to Group –> Select a Folder (or probably create one upfront, if you like this kind of report. “Field Values” would be a decent name for this folder), and choose “By Country” as the name. Then under “Group By” select “Country” from the database. As you can see you can choose any database field here, so you can create similar reports on “Industry”, “Job Title”, “Language”…<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

For this particular report we always set “Person Created At” to “All Time”, as we don’t want to filter here. We want to see the whole database drama!

Leave “Smart List” empty and here’s what you get:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

And this report instantly has a ToDo for you – which always happens if you start reporting on anything! – because you see two different values for the United States. Yikes, not nice, as these two <\/strong>values obviously try to represent one <\/strong>country. So you might think about normalization.<\/p>\n\n\n\n

And as a side note: Here’s my current example database if you scroll down further down in this report:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


Pretty ugly, isn’t it? The question is now how deep you want to dive down into this rabbit hole. What’s the cost\/effort of eliminating that empty space in ” Nigeria” relative to the gains? But either way: If your segmentation filter says “Country equals Nigeria”, the person with the blank in the Country name won’t be on the list.<\/p>\n\n\n\n

That’s it. Make a few clones and try different fields to group by. “Registration Source Type” e.g. is a good one!<\/p>\n","protected":false},"excerpt":{"rendered":"

Field Value Report is not a Marketo feature – but there’s a sweet workaround.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,8],"tags":[],"class_list":["post-257","post","type-post","status-publish","format-standard","hentry","category-analytics","category-tipps-tricks","entry"],"_links":{"self":[{"href":"https:\/\/www.martech-magic.com\/index.php\/wp-json\/wp\/v2\/posts\/257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.martech-magic.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.martech-magic.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.martech-magic.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.martech-magic.com\/index.php\/wp-json\/wp\/v2\/comments?post=257"}],"version-history":[{"count":4,"href":"https:\/\/www.martech-magic.com\/index.php\/wp-json\/wp\/v2\/posts\/257\/revisions"}],"predecessor-version":[{"id":264,"href":"https:\/\/www.martech-magic.com\/index.php\/wp-json\/wp\/v2\/posts\/257\/revisions\/264"}],"wp:attachment":[{"href":"https:\/\/www.martech-magic.com\/index.php\/wp-json\/wp\/v2\/media?parent=257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.martech-magic.com\/index.php\/wp-json\/wp\/v2\/categories?post=257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.martech-magic.com\/index.php\/wp-json\/wp\/v2\/tags?post=257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}