The fields you listed initially, "MEMBER_RATING, OPTIN_TIME, OPTIN_IP CONFIRM_TIME, CONFIRM_IP LATITUDE, LONGITUDE, GMTOFF, DSTOFF TIMEZONE, CC REGION, CLEAN_TIME, CLEAN_CAMPAIGN_TITLE, CLEAN_CAMPAIGN_ID" those come from Mailchimp. MEMBER_RATING, for example, is calculated by Mailchimp. See their documentation here http://kb.mailchimp.com/article/how-do-you-determine-the-ratings-for-my-member-activity
Reading their documentation, I don't see any way you can affect that field. The other fields are similar. You can't set "CONFIRM_IP_LATITUDE", for example. They take the IP address of the computer which was used to click the confirmation link, and do a GeoIP lookup on the IP to determine the longitude and latitude.
I've looked through their documentation and I can't see any information to the contrary. Please share the information you have if it indicates you should be able to set these values. Thank you.
Posted 7 years ago on Friday January 11, 2013 | Permalink