database/pivot table/ data management
Budget: $10 – $30 USD
I have an excel file with a row that each row contain an output like this:
{appsflyer:{is_universal_link:null,media_source:unityads_int,iscache:true,af_lang:en-ca,af_os:14.8,game_id:500110630,orig_cost:17.0,af_ua:Mozilla/5.0 (iPhone; CPU iPhone OS 14_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148,campaign_id:61969244c7aa2fc25c9ec5cb,campaign:campaignname,engmnt_source:null,af_siteid:dKW1VZ4DJGQO,adgroup_id:null,af_cost_value:17.000,af_channel:unity,af_ad:Hyper Gold Video Banner,adset:null,advertising_id:64443335C-DED7-41AF-88ED-A7D0289A335E,esp_name:null,is_incentivized:false,adset_id:null,redirect_response_data:null,af_sub1:null,af_status:Non-organic,af_cpi:null,install_time:2021-12-20 15:53:443.266,af_sub3:null,af_cost_currency:USD,retargeting_conversion_type:none,af_sub4:null,af_sub5:null,af_sub2:null,af_ad_id:61a605cb841037e264bc20d81,is_first_launch:true,adgroup:null,cost_cents_USD:1700,is_retargeting:false,af_c_id:61969244c7aa2fc25c9ec5cb,af_ip:72.2222..205.151,af_click_lookback:7d,idfa:67856E5C-DED7-41AF-88ED-A7D0289A335E,af_ad_orientation:
I would need some support for someone to help me move this data to a readable form
something like a dynamic pivot table that I can add any field i need.
it can be for only 5-6 fields from this output.
let me know if you can build something like this that i can pure in more data going forward and manipulate it in any way i want..
{appsflyer:{is_universal_link:null,media_source:unityads_int,iscache:true,af_lang:en-ca,af_os:14.8,game_id:500110630,orig_cost:17.0,af_ua:Mozilla/5.0 (iPhone; CPU iPhone OS 14_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148,campaign_id:61969244c7aa2fc25c9ec5cb,campaign:campaignname,engmnt_source:null,af_siteid:dKW1VZ4DJGQO,adgroup_id:null,af_cost_value:17.000,af_channel:unity,af_ad:Hyper Gold Video Banner,adset:null,advertising_id:64443335C-DED7-41AF-88ED-A7D0289A335E,esp_name:null,is_incentivized:false,adset_id:null,redirect_response_data:null,af_sub1:null,af_status:Non-organic,af_cpi:null,install_time:2021-12-20 15:53:443.266,af_sub3:null,af_cost_currency:USD,retargeting_conversion_type:none,af_sub4:null,af_sub5:null,af_sub2:null,af_ad_id:61a605cb841037e264bc20d81,is_first_launch:true,adgroup:null,cost_cents_USD:1700,is_retargeting:false,af_c_id:61969244c7aa2fc25c9ec5cb,af_ip:72.2222..205.151,af_click_lookback:7d,idfa:67856E5C-DED7-41AF-88ED-A7D0289A335E,af_ad_orientation:
I would need some support for someone to help me move this data to a readable form
something like a dynamic pivot table that I can add any field i need.
it can be for only 5-6 fields from this output.
let me know if you can build something like this that i can pure in more data going forward and manipulate it in any way i want..