Ejemplo n.º 1
0
    def get_ads_insight(self, account_id, from_time, to_time):
        """sample_response:: <api.Cursor> [
            <AdsInsights> {
                "ad_name": "Ad name here",
                "adset_name": "Sample name",
                "campaign_id": "123456789",
                "campaign_name": "Campaign Test name",
                "cost_per_unique_click": "0.727143",
                "cpc": "0.727143",
                "ctr": "1.62037",
                "date_start": "2019-12-10",
                "date_stop": "2019-12-10",
                "spend": "5.09",
                "clicks": "7",
                "unique_clicks": "7"
            },
        ]"""
        params = self.build_params(from_time, to_time)
        the_ad_account = AdAccount(account_id)
        try:
            async_job = the_ad_account.get_insights_async(fields=self.fields,
                                                          params=params)
            status = async_job.remote_read()
            while status['async_percent_completion'] < 100:
                time.sleep(1)
                status = async_job.remote_read()
            result = async_job.get_result()

            insight_data_list = []
            for item_ad_insight in result._queue:
                temp_dict = {}
                for _key in self.fields:
                    try:
                        temp_dict.update({
                            _key:
                            item_ad_insight.__getitem__(_key),
                        })
                    except KeyError:
                        temp_dict.update({
                            _key: '',
                        })
                if temp_dict:
                    insight_data_list.append(temp_dict)
            for k in self.required_merged_field_list:
                self.final_data.update(
                    {k: self.add_value_by_key(k, insight_data_list)})
            if len(insight_data_list) > 0:
                remaining_fields_set = set(self.fields) ^ set(
                    self.required_merged_field_list)
                for f in remaining_fields_set:
                    # remaining fields has same value of all items of the list. That's why only first item is considered
                    self.final_data.update(
                        {f: insight_data_list[0].get(f, '')})
        except FacebookRequestError:
            pass
            # print(er)
        return self.final_data
Ejemplo n.º 2
0
#Wait till all the data is pulled
def wait_for_async_job(async_job):
    async_job.api_get()
    while async_job[
            AdReportRun.Field.async_status] != 'Job Completed' or async_job[
                AdReportRun.Field.async_percent_completion] < 100:
        time.sleep(1)
        async_job.api_get()


# Iterate through the adaccounts
for account in adAccounts:
    # Create an addaccount object from the adaccount id to make it possible to get insights
    tempaccount = AdAccount(account[AdAccount.Field.id])
    # Grab insight info for all ads in the adaccount
    ads = tempaccount.get_insights_async(fields=params.get('fields'),
                                         params=params)
    wait_for_async_job(ads)
    x = ads.get_result()
    #campaigns = tempaccount.get_campaigns(fields=[Campaign.Field.name,Campaign.Field])
    # Iterate through all accounts in the business account
    for ad in x:
        # Set default values in case the insight info is empty
        date_of_report = todaydate
        account_id = ""
        account_name = ""
        action_values = ""
        actions = ""
        actions_link_click = ""
        actions_post_reaction = ""
        actions_post = ""
        actions_onsite_conversion_post_save = ""