Hi all,
I could not find a way to display "Street" field for each constituent in Analytics. I can only see City, PostCode, Country, GeoArea, and State. Has anyone successfully done this before? Please advise.
Best,
Tom Nguyen
Hi , I am also interested in this. Analytics provided me with a much faster way to pull all the info I need for our weekly donation letter mail merge, but I also need the street address field.
Look up how to add a Custom Category in Analytics. You only get 10 of them.
You will have to figure out the SQL query that gets you the data you seek. You should generally use secured Views instead of tables. And finally, you have to use an aggregation, e.g. MAX, so that the result set only has one row (per constituent in your case).
After you attempt to add a Custom Category, If Analytics fails to refresh the next time it should, that means you didn’t write the query correctly to only get one row.
If you use where primary_ind = 'Y' address you should get one per constituent (?)Actually bi.VT_CUSTOMER has primary street address built in