Miches
September 16, 2020, 1:14pm
1
Hello,
I have the following problem - I added data to a SiteId via Google Analytics importer and after the import was completed, I also deleted it from the GAI. Now I’ve found that some not correct data and I have to do a re-import. Now the page is no longer listed for re-import in the GAI. How or what do I have to do?
Greetings Mitch
Miches
September 25, 2020, 8:58am
2
Is an Re-Re-Import possible?
Hi @Miches sorry for the late reply, this isn’t directly possible, but can be done with some SQL. Did you map any extra custom dimensions?
Miches
October 2, 2020, 9:00am
4
Hi @diosmosis ,
thanks for reply
No, i don´t use other dimensions
Hi @Miches ,
Can you execute the following SQL (after replacing the appropriate values):
insert into {TABLES_PREFIX}option (option_name, option_value) values ('GoogleAnalyticsImporter.importStatus_{IDSITE}', '{"status":"finished","idSite":{IDSITE},"ga":{"property":"{GA_PROPERTY_ID}","account":"{GA_ACCOUNT_ID}","view":"{GA_VIEW_ID}"},"last_date_imported":null,"main_import_progress":null,"import_start_time":1601424000,"import_end_time":1601510400,"last_job_start_time":1601424000,"last_day_archived":null,"import_range_start":"2020-02-01","import_range_end":"2020-04-01","extra_custom_dimensions":[],"days_finished_since_rate_limit":0,"reimport_ranges":[]}');
Replace:
{TABLES_PREFIX} with the prefix you specified during installation
{IDSITE} with the site ID of the site in question
{GA_PROPERTY_ID} with the Google Analytics Property ID
{GA_ACCOUNT_ID} with the Google Analytics Account ID
{GA_VIEW_ID} with the Google Analytics View ID
This should add the entry back to the admin page.
Miches
October 5, 2020, 2:11pm
6
@diosmosis
Wohooo - Thank U, it works