Community Discussion
how can I get 'site' breackdown
Hey
I'm using the premade report (campaign summary report) and I don't get the site dimension. how can I retrieve it?
Thx
Posted by [email protected] 8 months ago
Get Site when campaign_hour_breakdown Dimension
I am using the campaign_hour_breakdown dimension (from the reports/campaign-summary endpoint) which is great because it gives me the hourly breakdown for every Campaign. However, the Site is not included in the results. Site is allowed as a filter for the campaign_hour_breakdown dimension, but for this I would need to make a request for each Site to get its hourly breakdown, and this in our case it can be thousands.
I know there's a site_breakdown dimension but data is not aggregated at an hourly level but daily.
Posted by Esteban 12 months ago
Granular Data Request
We were going through the API documents and it looks like the most granular data we can request is the "by_hour_of_day" dimension from the campaign summary dimensions endpoint.
Two questions related to this:
- Is this the most granular data we can request? We would love to be able to access our costs and clicks at a finer time grain.
- Is this the only way to get data at a finer grain than "by-day" for a "by-campaign-by-site" analysis? What we mean is that if we want to do a site-by-site analysis for a campaign running on 500 sites, we would have to ping the "by_hour_by_day" endpoint 500 times for a single campaign. Is there another way to get hourly (or even more granular) data at the "by-campaign-by-site" level?
Posted by Alex Bank about 2 years ago
how can I can get bid and bid modifier as well
How to get additional fields in site level summary report?
Hi Admin.
I am trying to get site level summary report.
I want to know how can I can get bid and bid modifier as well?
This is the request URL :
"https://backstage.taboola.com/backstage/api/1.0/" . env('TABOOLA_API_ACCOUNT_ID') . "/reports/campaign-summary/dimensions/site_breakdown"
Could you please help me with how to get these additional fields in the summary report?
Thanks.
Posted by Nithu Shan about 2 years ago
How to get campaign details in campaign level summary reports?
Hi, Admin
I am trying to get campaign level summary report.
I want to know if I can get campaign status, daily_cap, CPC as well?
This is the request URL :
"https://backstage.taboola.com/backstage/api/1.0/" . env('TABOOLA_API_ACCOUNT_ID') . "/reports/campaign-summary/dimensions/campaign_breakdown"
Could you please help me with how to get additional fields in the summary report?
Thanks.
Legendary Phoenix
Posted by Legendary Phoenix about 2 years ago
How to extract revenues by publisher with Python Script (split by platform)
Hello all,
I have this script to extract my campaign data splited by plateform (see bellow).
But now, I want to know how to extract the revenues earn by my publisher.
Do you knwo how I can do that ?
___________________________
My Script :
client_id =XXXXXXXXXXX
client_secret = XXXXXXXXXXXXX
start_date = "2021-06-08"
end_date = "2021-06-08"
account_id = "XXXXXXXX"
dimension = "content_provider_breakdown"
folder_path = r"/Users//Documents/"
url = "https://backstage.taboola.com/backstage/oauth/token"
payload = f"client_id={client_id}&client_secret={client_secret}&grant_type=client_credentials"
headers = {"Content-Type": "application/x-www-form-urlencoded"}
response = requests.request("POST", url, data=payload, headers=headers)
data = response.json()
access_token = data["access_token"]
url = f"https://backstage.taboola.com/backstage/api/1.0/{account_id}/reports/campaign-summary/dimensions/{dimension}"
url = f"https://backstage.taboola.com/backstage/api/1.0/{account_id}"
querystring = {"start_date":start_date,"end_date":end_date,"platform":"DESK"}
bearer = f"Bearer {access_token}"
headers = {"Authorization": bearer}
response = requests.request("GET", url, headers=headers, params=querystring)
data = response.json()
_____________________________
Posted by Charles M. over 2 years ago
cpc calculation
How can we calculate thru the api the cost per click by publisher and time of the day? we need an estimate for live traffic and the real cost for updated data
Where can I find more information on how this works
Posted by Mansour Bennouna over 2 years ago
Calculating the Publisher spend for the last 24 hours
Hi,
For our requirements, in each account I need the last 24 hours' spend per Publisher.
With the Java SDK, I can easily get the spend per site in daily chunks using the **SITE_BREAKDOWN** dimension, however this doesn't support anything finer-grained, for instance if I want to know the spend from midday yesterday until midday today.
It doesn't look possible through the Java SDK.
I've also looked at calling the Backstage API directly, but even then it looks like I can only perform what I need one site per call using **campaign_hour_breakdown** with a site filter...
```
https://backstage.taboola.com/backstage/api/1.0/<account>/reports/campaign-summary/dimensions/campaign_hour_breakdown?start_date=2021-02-08&end_date=2021-02-09&site=<site name>
```
Our app can then aggregate the values in the response to calculate our spend on a site for the last 24 hours.
Given that we are using thousands of Publishers, this could take some time!
I'd love to know if there another more performant way of doing this?
Cheers,
Colin
Posted by Colin MacLean over 2 years ago
Publisher Url
Hi,
I'd like to know if there's a way to get the Publisher's URL via the API.
Posted by MΓ©lanie Macias almost 3 years ago
Campaign Summary Report By Site and Country
Hi,
It would be amazing to see the performance by site and by the country for a given campaign at the same time. Is there any option available for that?
If no, are you planning to add that anytime soon?
Thanks,
David
Posted by David Wilson about 3 years ago