report_automation_part_3.py

service_url = 'https://api.semrush.com/analytics/v1/'
def backlink_url_build():
    params = {
        "?type": "backlinks",
        'key': api_key,
        'target': "clientsite.com",
        'target_type': 'root_domain',
        'display_limit': '30000',
        'display_sort': 'first_seen_desc'
        }
    data = urllib.parse.urlencode(params, doseq=True)
    main_call = urllib.parse.urljoin(service_url, data)
    main_call = main_call.replace(r'%3F', r'?')
    return main_call
bl_call = backlink_url_build()
bl_data_set = API_Call(url=bl_call)
df_bl = pd.DataFrame(bl_data_set)
time_bar = []
for time_change in df_bl['first_seen']:
    new_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(int(time_change)))
    time_bar.append(new_time)
df_bl['first_seen'] = time_bar
new_bl = df_bl[df_bl['first_seen'].str.contains(time_check)]
new_bl['page_score'] = new_bl['page_score'].astype(int)
new_bl = new_bl[new_bl['page_score'] > 20]